Question 1

How do I message someone when a new sheet row is added?

Accepted Answer

Use the Google Sheets on new row trigger, which polls a sheet and fires for newly added rows. Connect it to a WhatsApp send text message node and map the recipient and body from the row columns.

Question 2

Can WhatsApp replies be logged into a Google Sheet?

Accepted Answer

Yes. Start with the WhatsApp receive message operation and connect a Google Sheets append rows node. Each inbound message becomes a new row with the sender, timestamp, and text.

Question 3

How do I send a WhatsApp message to a whole list in a sheet?

Accepted Answer

Use read sheet data to pull the rows, then iterate over them sending a WhatsApp message per contact. For business-initiated outreach use the send template message operation with an approved template.

Question 4

Can I update a sheet row based on a WhatsApp reply?

Accepted Answer

Yes. After the WhatsApp receive message trigger, use find and replace or read the sheet to locate the matching row, then use write sheet data to update the relevant cells.

Question 5

How do I avoid messaging the same person twice?

Accepted Answer

Keep a status column in the sheet and only message rows that are not yet marked done. After sending, write the row back with an updated status so the next run skips it.

Connect Google Sheets and WhatsApp

Google Sheets + WhatsApp automations

About each integration

Google Sheets integration

WhatsApp integration

Frequently asked questions

More integration pairings

Connect Google Sheets and WhatsApp in minutes