Why Isn't the 'New Row Added' Trigger for Google Sheets Workflow Working Anymore?

Help
1

This topic was automatically generated from Slack. You can find the original thread here.

We are using the New Row Added (Shared Drive, Instant) trigger for our workflow but whenever we add rows to the Google Sheet nothing happens. We figured out if edited the trigger, selected the last event and tested the workflow that it would actually trigger it and make it work. Unfortunately that doesn’t work for us anymore. We’re trying to figure out a way to just have a trigger that we manually use to start looking at the data without going through all those steps

2

Hi Robert, I suggest deleting your current trigger and recreating it.

Sources (the underlying component powering your trigger) receive updates from time to time. But unfortunately unlike actions, there’s not a button within the Pipedream UI to update their source code.

3

Hi Pierce. We’ve had to recreate it 3 times over the past week and we still have to test the workflow before it actually triggers. Any clue on a trigger that would actually run without having to do a test run for it to trigger?

4

Perhaps the logs for the trigger might lead to something. You can see them under the Sources area in the dashboard

5

There you can find your Google Sheets source, then open the Logs tab which will give you the logs of each execution.

6

We’ve noticed that Google Drive events seem to work better when the account that sets up the trigger is also the owner of the files.

Sharing the file with the account as editor/viewer/commenter doesn’t seem to work as reliably. :man-shrugging:

7

Ah yes there are ownership quirks with Google APIs. For instance, you can’t add images to Google Photos albums unless the album is created by the same Pipedream OAuth token

8

Thank you for the replies and information. I’ll try to create it under my own account and see if that helps

9

Posted thread to Discourse: Why Isn't the New Row Added Trigger for Our Workflow Activating When Rows are Added to our Google Sheet?

10

Has there been any movement on this? Is this just a problem with google?
I have a trigger listening to a shared drive for new files, this wasn’t a problem when it was on my drive. The shared drive and the My Drive are both owned by someone else and shared to me, when I put files from a separate google account into the shared drive share it doesn’t work, when i put files from the same separate google account into the My Drive it works.
Further weirdness is if the owner of the shared drive puts a file into it all the files that i’ve put will trigger.

11

On our side, we’ve just stopped using Shared Drives entirely… :man-shrugging:

Got tired of always having issues.