Two or three times a week, the Google Sheets node fails to get the latest rows in a Google Sheet. I have a workflow, and track all executions there. However, the node does not always return all of the data (50 rows) in the sheet. Therefore, the workflow does not know a job has ALREADY been processed. Because the node doesn’t grab the last few rows, which were recently updated.
Is your Google sheet accessible to other people? Or do you ever filter/sort the sheet? If you do this will effect the results that are returned by the node