Google Sheets > Watch Changes: Watch an area (a row/rows, a column/columns, a cell/cells)
reviewed
Michal Máša
Google Sheets > Watch Changes: Watch an area (a row/rows, a column/columns, a cell/cells)
Log In
Ilia Sablukov
marked this post as
reviewed
Mikalis
Darpan was right - we need that instant watch changes on certain rows / columns in integromat. . .basic functionality.
you should too!
Darpan Gogia
Who in the world will require that the entire sheet including sub sheet changes to trigger events with Watch Changes. Its a basic requirement to be able to configure watch changes triggers on Rows/ Columns etc.
Michal Máša
Dear Integromates,
Last month we released the universal "Google Sheets > Make an API Call" module, which may help you to achieve the functionality you have requested as it allows you to invoke any Google Sheets REST API endpoint - https://developers.google.com/sheets/api/reference/rest
The module's documentation is available here: https://support.integromat.com/hc/en-us/articles/360012792513#make-an-api-call
You can see what modules and templates are available for the Google Sheets app here: https://www.integromat.com/en/integrations/google-sheets
The app’s documentation is available here: https://www.integromat.com/en/kb/pkg/google-sheets/index.html
Please, check it out, test it and let us know if it works as expected.
Should you have any questions, please contact our support (https://www.integromat.com/en/ticket) or feel free to post a question to our Facebook Integromat Community group (https://www.facebook.com/groups/integromat/), where hundreds of specialists, users and fans are willing to help.
Happy Automating!
Thanks,
The Integromat Team
Hannes Rohregger
Michal Máša: I don't see how this helps us to watch changes without the Sheets plug in?
Konrad Schaefers
hi Michal Máša, answering your question from the other feature request (https://www.integromat.com/en/requests/requests-to-update-existing-apps/p/google-sheets-watch-changes-without-the-need-of-the-add-on).
I assume you are using the Google Drive API to watch changes of a file (https://developers.google.com/drive/api/v3/manage-changes)? Unfortunately as you said this does not contain the actual changes, but only that changes exist...
I have three ideas to workaround this:
- Using AppsScript Installable Triggers (https://developers.google.com/apps-script/guides/triggers/installable). Using this you would get a very detailed event:
https://developers.google.com/apps-script/guides/triggers/events#edit which one could filter.
Drawback to this is, that it must be implemented in AppsScript (which may require your users to write a custom appsscript function). But maybe all you need is a proper Blog post about this.
- Using the Script API. the above mentioned installable trigger may be possible to be programmatically created by Integromat using the Script API (https://developers.google.com/apps-script/api/reference/rest/v1/scripts/run)? Worth checking out.
- Last and maybe easiest to implement: Rather than using the "Watch Changes" Trigger, we use the "Perform a Function Trigger". When we only include the cells in the formula that we want to monitor changes for, the Integromat scenario should only be called when there are changes to those cells I suppose.
BIG drawback here is that you know that there is a change in the cell, and you know the new value, but you do not know the old values...?!
Looking forward to your thoughts on these ideas?
Cheers, Konrad
Michal Máša
Konrad Schaefers: Hello Konrad, Thank you very much for your contribution, I am passing it right on to our dev team to evaluate it. Best regards, Michal
Konrad Schaefers
Michal Máša: thanks. looking forward to hearing back on this topic