GOOGLE FORMS TO GOOGLE SHEETS
Google Forms to Google Sheets, then WhatsApp.
How to add a Google Sheets row for each new Google Forms record, so ConvoHut can start a WhatsApp journey from it. Google Forms can do this built in.
7-day free trial · about 15 minutes to connect your number · Meta bills message charges to you directly (you add a card in Meta)
Illustrative example. Names and details are made up.
FORMS
The options.
Built in: link responses to a sheet
- Open your form, then the Responses tab.
- Choose “Link to Sheets” (or More → Select destination for responses).
- Create a new spreadsheet or pick an existing one.
- Add a phone question and a clear WhatsApp consent checkbox.
Make, webhooks and more
- Apps Script onFormSubmit, if you need to tidy data first
- Unlinking the form stops new rows.
- Validate the phone field so numbers include the country code.
THE SHEET
The columns to send.
Send one row per record, with the column names in row 1. Phone is the only required column and must include the country code.
- Name
- Phone
- Enquiry
- WhatsApp consent
- Consent: that the person agreed to WhatsApp messages
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Name | Phone | Enquiry | WhatsApp consent |
| 2 | Sarah | +61 412 000 184 | Kitchen renovation | Yes |
| 3 | Tom | +61 433 000 912 | Bathroom quote | Yes |
| 4 | Ana | +64 21 000 457 | Deck repair | Yes |
Row 1 holds the column names. The highlighted row is the newest: adding it starts the journey. Example data only.
BUILD
Then, in ConvoHut.
- 01
Open Automations, then Create Automation, and choose New Sheet Row as the trigger.
- 02
Pick the spreadsheet and tab, and map Phone and Name.
- 03
Add your approved template, a wait for reply, and a notify step.
- 04
Pass the compliance review for your markets, then Activate Now. Test with your own number first.
RECIPES
Recipes that work with Google Forms.
Checked against Google Forms’s, Zapier’s and Google’s documentation in September 2026. Features, plan requirements and trigger names change; check the current documentation when you set it up. ConvoHut isn’t affiliated with Google Forms.
LIVE NOW · 7-DAY FREE TRIAL
More sales from every conversation.
WhatsApp marketing, sales and support from your own number. 7-day free trial, free onboarding and Meta verification help.
- Meta Tech Provider
- Hosted on AWS
- Australian company
- Your number stays yours
