Hey,
Has anyone tried to trigger the Google Sheets new row watch (or something else that would work the same way) with a webhook?
I have a sheet tab that I need to monitor constantly, but it’s rare they will change. As I don’t know when they will change, following the scheduled scenarios, I would check, every 2-3min. Which is expensive. I would love to trigger the Sheet checker from a call on Manychat (where the actions happens).
any one?
Thanks,
Andre
Hello @andremoura,
If you want to monitor the sheet for every change, that could get expensive as well.
If you still want to do it, look into creating an Apps Script that can detect changes then call a Make webhook along with the coordinates / range of the cell(s) that changed.
Others have done something similar if you just search something like “google apps script webhook”. Here is one example.
Hi @Donald_Mitchell
Nope. Instead of checking if there’s a new row, I would love to let Make know that I have a new row using a webhook. I don’t want to monitor it and then trigger the process, as offered by Make.
I want to start a new process when I need it. The same way I trigger a Trello card update from a call started from Manychat…
My use case here is: I need to send a GMail message when a new row is added, with data from this row.
I will check your link. Thanks.
Andre
Hi Andre,
As Donald said - you need an AppScript running on your google sheet to watch when new rows are added and call a Make Custom Webhook module. You can configure it from Extensions → App Scripts.
Ok, thanks, I think I understand now.
You want the functionality of Watch New Rows, but want to run ad-hoc / on demand instead of on a schedule.
If that’s the case, then assuming you’re on at least the Core paid plan, you can use a helper scenario.
Call your existing scenario Scenario 1 and it’s trigger is the Google Sheets Watch New Rows with a schedule set to On Demans.
Scenario 2 will start with a Webhook, followed by a Make Run a Scenario module.
When someone or something calls the Webhook, that will trigger Scenario 2, which will trigger Scenario 1.
Hope that makes sense, and hope it helps!
1 Like
I will try these things, @Donald_Mitchell and @Stoyan_Vatov (sorry, I was away…)
Thanks!
@Donald_Mitchell, your solution sent as your last reply here is more straightforward than the one here.
I don’t need to create the Google Script. I can trigger a Make custom webhook from manychat.
1 Like