How Can I Get Google Sheets to Trigger When a Row is Updated?

Bugs
1

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

Google Sheets | Trigger : Google sheets does not trigger when a Row is updated - please help :slightly_smiling_face:

2

The workflow only catches updated rows when I initially add the Trigger step - but does not work when deployed or refreshed in editor

3

I tried both the Shared Drive and standard triggers - neither worked :confused:

4

It seems like the request is being pulled in from the logs

LOGS.png
LOGS.png3336×999 297 KB

5

But no events are displayed

empty source.png
empty source.png1604×1500 127 KB

6

Hello , maybe the change is not in your spreadsheet? Would you mind submitting a ticket for us with the reproduce steps

7

I submitted a ticket t he changes are 100% in the spreadsheet and as you see - being logged. For some reason the trigger is not catching the errors.

8

I just gave y’all access to edit the workflow

9

, I’m not surecwhat you mean by just submitted a ticket and gave the access, would you mind clarifying?

10

I think I found the issue - the Sheet has to be public :slightly_smiling_face:

11

or maybe you have not gave Pipedream enough permisson when connecting to Google Sheet account. You can try to remove Pipedream from your Google Account Permission page and try to reconnect again