Google Sheet row updates but Webhook doesn't trigger

Features
1

Webhook works but the issue is this…

I"m using Zapier to update a specific column on the sheet.

I have the Make extension installed and configured on the Sheet correctly. When the update is done, Make.com never triggers. BUT if I MANUALLY go in and make the update on the column the webhook does trigger…

I have tried many ways to get this done… The Sheets webhook works only if I manually update the column on the sheet but it won’t work if it’s done through Zapier.

Can someone help me?

2

Hello @Erick_Escolero and welcome to the Make Community!

I believe that extension and corresponding Make module only work when updates are made via non-automated means - not using API or anything else that uses the API, like Zap!3r.

If you want it to work such that Make is notified when a cell, column, row, or range is updated then you’ll need to create a Google Apps Script for that on the Google side.
On the Make side, you need a scenario that is triggered by a Webhook and the Google Apps Script can call that Webhook address.

If you search this community forum you should be able to find many examples.

2 Likes
3

For clarification, this is not a Make problem, but a limitation on the Google Sheets API itself.

A possible workaround is that you have an additional timestamp or flag column that you can poll for using a Search Rows trigger module, and process those that haven’t been processed yet.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew