Hi there, I have a workflow here that pulls a list of Google Sheets docid and sheetid and sends that to a loop. Problem here is that, i would pull 45 records but the loop only runs for 18 times. Batch is set to 1 and i can access the sheets.
Any idea whats wrong here?
Appreciate any advice you can give me!
Hey @souichirou hope all is well. Welcome to the community.
Could you please share the execution screenshot?
Could you make sure that the last execution didn’t result in executing one of the nodes, that produced no result?
It looks like Google Sheets node executed 18 times and Edit Fields executed 17 times, so it is very possible this is where execution stops. Does it read same of different sheets on each execution? I see in the workflow the sheet is referenced as {{ $json.sheetid }}, but I don’t know if this value is always the same of different on each iteration.
Test enabling “Always Output data” in the settings of the Google Sheets node and then running it again, would that be any different?
Looks like you got it right! I am assuming one of the ID is wrong or empty? How do i tell during execution that is this the case? Or should i go with Always output data as a default setting to turn on?
Ha, I knew it!
Well the way to go from here is going to be all about what you are ok with happening if getting no data from that node doesn’t affect the rest of the loop iteration - just leave it everything the way it is, otherwise - if you want to understand whats and whys - then revert back, look at the processed sheets and find the one that is … empty? 
Great catch!. Well, those are supposed to come from some Sales Tracker app. Definitely would have empty sheets i feel. For example, if that sales was onboarded but hadnt made any sales yet.
Maybe if this is the case, what you could do is - put an IF node after the Google Sheets node and check if {{ $json }} object is empty - and if so - loop back to the Loop Over Items, otherwise - proceed with the rest of the node in the iteration.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
