Google Get Rows Not Pulling Data

Status: Open · Asked by Dan Cook on · 0 views

Dan Cook — Question ·

I am trying to pull data from a google sheet and it works when I manually test it. But when I leave it to work automatically it fails to pull any data.
I have tried a few workarounds like copying the file and using that sheet or automatically getting the sheet ID, in case there are issues with that.
But nothing seems to be working.

A connected issue is my trigger (google driver new file in a folder) doesn't go every 10 minutes as expected. Sometimes it never triggers at all and other times it randomly does it after 20/30 minutes.

Any assistance here would be appreciated.

Dan Cook — Reply ·

I tested it again and it triggered twice and actually worked this time. I think the sheetID was the culprit as that was the most recent update I made in an attempt to get it working. The trigger though is intermittent and not working as intended or there is a long delay happening.

Arshil Ahmad — Reply ·

Hi @dan90,

Google Drive has a trigger interval of 10 minutes, which means Pabbly Connect checks for new files in your Google Drive folder every 10 minutes. If a new file is uploaded within the last 10 minutes, the workflow is triggered. Therefore, if no file is uploaded during a certain period, the workflow will not be triggered for that time.

Back to all forum threads · Log in to reply