Node not recognizing data in Google Sheet Cell

I have a node that is supposed to pull data from Google Sheets.

When it views the Google Sheet, it outputs that the cells are empty.

It worked for the prior 9 rows, and now it has decided not to work correctly.

What could be causing this?

Welcome to the community @jasonmbd

It looks like the Google Sheets node isn’t reading the new rows because it might be set to look at a specific area of the sheet that doesn’t include them, or the “Yes” trigger isn’t working for those rows. Check the node settings to make sure it covers all the rows you want, and double check that the “Yes” is typed correctly in the new rows. You can also look at the sheet to see if the data looks different or has any hidden empty spaces. This is just my observation on what may be the cause.

Hi there, does this still happen? like consistently? like if you trigger it right now does it still happen again?

might be it just needs more time for the node to fetch it correctly, in case the data has just been change before you take the screenshot

I played wtih it and got it to work but was not able to figure it out.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.