Google Sheet Trigger when a column is updated and return full row

How To
,
1

Hi everyone,

I’m trying to set up an automation in Make CRM that triggers whenever a specific column in a Google Sheet is updated. Once the column is updated, I need the automation to return the entire row of data where the update occurred.

Here’s what I’m looking to achieve:

  1. Trigger Activation: The automation should only trigger when an update occurs in a particular column (e.g., Column C).
  2. Return Full Row: After the trigger, the automation should pull the entire row of data from the sheet.

Does anyone have experience setting up something similar in Make CRM? Any advice or examples on how to configure this would be really helpful!

Thanks in advance for your support!

2

I solve the problem of Google Sheet → Make by adding a Google App Script to the sheet that builds a payload and sends the webhook POST.

It’s a bit of code.

But ask ChatGPT and it will do a pretty good job of explaining how to set it up, what code to copy/paste.

It did for me :slight_smile: