Uptil now I was using make.com only for my personal POCs. But today I formally purchased a plan to move my official automation from N8N to Make.com. But here again I have hit a roadblock. I need help.
My objective is to make an HTTP call every time a new row is added. But, in my case, the rows can get added in any order, basically if I have 100 rows, I could get a row added at 60th position later. And I could not find, a common google sheet trigger of “Add or Update Row”.
So, I tried creating two separate scenarios - one for “Watch a new row” and another for “Watch for changes”.
- The new row if added later works fine, as scenario has still not read that row.
- But if my row is added above, it was ignored by “Watch for new rows” trigger. So, I am trying “watch changes” google sheet trigger. For this, I have added the make extension in google sheet selecting first column range. I selected column range, as I did not want multiple triggers for same row.
Now, the trigger keeps waiting forever, even if I manually type the data in column A or copy paste it from another sheet.
Welcome to the Make community!
This is because the module is an INSTANT (Webhook) trigger, and not a POLLING trigger.
There are two main types of triggers, Polling (scheduled), and Instant (webhooks). Polling triggers can only run on a schedule. Instant triggers can be run as soon as data is received by the webhook.
Polling means Make checks external service for changes (pull changes to Make).
Webhook (instant) triggers means external service calls Make when there are new changes (push changes to Make).
To trigger the scenario, you’ll need to send data to it, while the scenario is switched ON, or in “waiting” mode like your screenshot.
To find out more on the different types of Trigger modules, see refer to Types of Modules and Webhooks sections of the Make help center.
See if your app has an “Instant” or “Webhook” trigger in Make. If not, check if the third-party service has a feature that can send out a webhooks when content is created/updated - and then you can point it to a “Custom Webhook” trigger in your scenario.
samliew – request private consultation
Join the Make Fans Discord server to chat with other makers!
3 Likes
I do agree it is an INSTANT trigger and that’s why I was expecting some events, but I am unclear how to send data, as you mentioned above? Do I need to write Google App script? My thoughts are if App script is needed, why will I need Make’s automation or extension in google sheets?
My team has been trying a lot of things with Google App script. But there again we dont see any way to get the event when a new row is added in between existing data. We have ended up comparing the unique column value manually to identify if any row is added, but this may not be a scalable solution.
Has no one across make community implemented a Watch changes Instant trigger. Why no one is able to guide if we have to POST any HTTP payload to this webhook or should I assume make.come is not a good fit when dealing with Instant triggers? I am loosing hope in No-code Low code now.