Roadmap

Integrations

Integrations Feature Requests

Voters 2

  • Avatar
  • P

⚡️ by Upvoty

2

Detect changes in any row of a Google Sheets file

  • Live
Avatar
 Daniel Nakash

I have a table in Google Sheets that lists events. The table has many rows and it is usually the case that a row somwhere in the table is updated.
The current trigger only detects a new row, or changes to the last row of the table.
With Automate.io I could detect changes in any row.


Detect changes in any row of a Google Sheets file
  • 07-05-2022 -
A

Activity Newest / Oldest

D

Divya

Status changed to: Live

D

Divya

Hi There,

We already support this feature. Please use - Row is created or updated trigger and under "Select Column" choose any column. Using this setting, the Google Sheet will trigger for any update/create operation in the sheet.

Thanks,
Divya

Detect changes in any row of a Google Sheets file

Avatar

Daniel Nakash

Hi,

This is exactly what I did, and it didn't work.
It did catch updates to the last row, but not updates to any other row.

D

Divya

Hi Daniel,

I checked with our team and they informed me that while setting up the flow we show the test data from the last row, however, once you set the flow as active it will fetch the details for update for any row. However, please ensure that you choose Any Column under the Select Column field.

Please do give this a try and in case if you are still facing an issue then please reach out to our live support, they will help you with the flow.

Thanks,
Divya