When I added a row it to the sheet, it never again triggered
When I copy/pasted 10 rows, it fired again, but only for the last 3 of the 10 rows
Can you advise how to use Google Sheets triggers? This is my main use case.
Also, a suggestion: Add a trigger “Empty column”: It fetches n rows where a certain column is empty. Perfect to solve the new row identification problem. We can then check for empty fields that the flow enriches. Or if it updates existing, we can also set a specific column with e.g. an update-timestamp. Etc.
In any case, as it stands, the Google Spreadsheet trigger does not work.
The New Row trigger only work on rows whose numbers are new, for example if you have 10 rows pre-filled in your sheet before you created this flow and published it, any changes on them won’t be accounted for, but if you add 10 new rows under them, that will result in the flow triggering 10 times, with respect to your price plan’s sync time.
I hope this clears things out, if you are still facing issues, please elaborate more on your use case so we can further help, cheers
Hi @Abdul
Yes, I gathered that, but it still didn’t do it that way. I’ve copy pasted all the 10 last rows, and on the next run, it would fill out only parts of them.
Other than that I think currently the 1-minute schedule (that I have in my plan) is not reached, 1-minute flows are triggered anywhere between 2 - 10 or so minutes, rather than every minute.
These are all 1-minute period flows, and there was always something to do.
I assume servers are a bit overloaded currently?
Anyway, re-built the whole workflow to use time trigger + Find rows / Update rows and a loop, works much better (except from the missing 1-minute runs).
Did this Google Sheet trigger problem get resolved? I am using the “New Row Added (instant)” trigger. The only way I can get it to run the flow when I add a new row to my Sheet is by manually disconnecting and reconnecting the Google Sheets connection, which is less than ideal.
I have published this Flow and there is the lightning bolt icon indicating it’s a Real time flow.
I’ve also tried it with the ‘NEW OR UPDATED’ trigger and it still doesn’t work. I’m manually updating rows and the flow doesn’t run. When I swap out the trigger for a scheduled trigger, it works fine.
I am having the same issue with Google sheets trigger as well as Gmail and Google Forms. My flows were previously working 3-4 weeks ago but have not been triggering… as well I have been getting this message (see below) trying to test run. I tried new emails, disconnected, etc… no bueno.
Triggers are not firing on Google apps across the board. I just had another this morning that would not trigger. Updated credentials, etc… no change.
For this morning’s lack of trigger, I went in there to test the sample data and see if it is giving me that same red error box saying it cant pull sample data. Instead it actually pull the live data it was suppose to trigger on 10 minutes ago, Kinda laughable at this point. Is this a known issue AP team? Seems that others are having similar problems.
I took look at the google sheets, I republished the flow so it register new channel on google sheets, Is it possible to try to add row and see If it’s now working?
