Google Sheets Watch Changes only sends one cell edit — need full row data (Name + Phone)

How To
1

Hi everyone,

I’m working on a Google Sheets → Make integration using the Watch Changes module and custom Apps Script.

The automation works. Make receives the webhook but there’s a major problem:

When I enter data into two columns (Name in A, Phone in B), only the cell I edited last is included in the webhook payload.

  • If I enter the name first, Make only gets the name.

  • If I enter the phone number first, Make only gets the phone.

This means I’m not getting both values in the same webhook call, which breaks my downstream SMS automation (which requires both Name and Phone).

  • I’m using the onEdit(e) Apps Script trigger as instructed.

  • The webhook URL is correctly set.

  • I’ve added a check to wait until both A and B are filled before sending data, but due to Google’s cell-based edit trigger, it still fires twice and only sends the changed cell’s data

What I Need:

How do I send the entire row’s data (columns A & B) together in one webhook, only once both fields are filled?

Any clean workaround or alternative approach from Make’s side would be hugely helpful. I’m currently testing the platform and would love to upgrade if I can solve this issue.

Thanks in advance!

PS: I have used this Google Sheets - Apps Documentation documentation for guidance.

2 Likes
2

Heyy @Tanishq_B_Kiran Welcome to the community!

When using on edit in APPS SCRIPT sends data on every edit, you can add filter after webhook to check if both values from Col A and B are present or add 1 more condition in apps script to check if data available in All columns before sending data so it will only trigger when all of the columns from condition are with some data in it.

When working with multiple columns, To make sure it sends whole row data, change it to send data on edit in specific column as a trigger, like you can add a check box at the last or a status field and set on edit on that specific column to check if that check box was filled or not or has any specific status to send data or not.

I hope this helps!

Best,
@Prem_Patel