SHEET-TRIGGERED RECIPE

Website enquiry.

Instant row. Rows come from website form, google forms, typeform, jotform. A new row starts a two-way WhatsApp journey: send an approved welcome → wait for reply → notify the owner.

Start free trialGet your data into Sheets

7-day free trial · about 15 minutes to connect your number · Meta bills message charges to you directly (you add a card in Meta)

Category
New enquiries
Meta template category
Marketing
Send
Within 2 minutes of the row
Stops when
They reply, or the wait ends

SET UP

1. The sheet.

Only Phone is required, with the country code. The other columns personalise the message and help your team when the customer replies. Keep the column names in row 1 and don’t leave blank rows.

  • Name: used in the message or for your team
  • Phone: required, with country code (for example +61 412 000 184)
  • Enquiry: used in the message or for your team
  • Source: used in the message or for your team
  • Consent (recommended): record that the person agreed to WhatsApp messages, and when
Website enquiry · Sheet1
ABCDE
1NamePhoneEnquirySourceConsent
2Sarah+61 412 000 184Kitchen renovationWebsiteYes
3Tom+61 433 000 912Bathroom quoteFacebookYes
4Ana+64 21 000 457Deck repairGoogleYes

Row 1 holds the column names. The highlighted row is the newest: adding it starts the journey. Example data only.

DATA IN

2. How the rows get there.

Instant row. These tools can add a row for each new record. Pick yours for step-by-step setup.

Google FormsBuilt in: link responses to a sheet
→
TypeformBuilt in: Google Sheets integration
→
JotformBuilt in: Google Sheets integration
→
WPFormsWPForms Google Sheets addon (Pro licence or higher)
→
SquarespaceBuilt in: form storage to Google Drive
→
HubSpotHubSpot workflows: “Create Google Sheet row” (Professional or Enterprise)
→
Gmail and OutlookZapier: Gmail: New Email Matching Search (polling), then a parser step
→

See all data sources →

TEMPLATES

3. The messages.

Within 2 minutes of the rowMarketing
Hi {{1}}, thanks for your enquiry about {{2}}. When suits for a quick chat?

{{1}} = Sarah

{{2}} = Kitchen renovation

4 hours later, if no replyMarketing
Hi {{1}}, just checking you saw my message. Happy to answer here, or book a time that suits: {{2}}

Example wording. Submit your own version to Meta as a template; Meta confirms the category. Marketing templates need marketing consent and an opt-out.

BUILD

4. Build it in ConvoHut.

  1. 01

    Create the automation. In ConvoHut, open Automations, then Create Automation. Name it and tick the markets you message.

  2. 02

    Choose the trigger. Pick New Sheet Row. Choose the spreadsheet and tab, and map Phone (required) plus Name.

  3. 03

    Add the first message. Add a Send Message node with your approved template. Map each variable to a column.

  4. 04

    Wait for a reply. Add Wait for Reply. On Reply, add Notify Me so your team picks it up in the inbox.

  5. 05

    Handle no reply. On Timeout, add the follow-up template, then End Flow.

  6. 06

    Pass compliance and activate. ConvoHut checks consent rules and the opt-out for each market you picked. Then click Activate Now, and test with your own number first.

SHEET TRIGGERNew Sheet Row
SEND MESSAGEweb_enquiry_v1
WAIT FOR REPLYTimeout: 4h
On Reply
NOTIFY MENotify the team
On Timeout
SEND MESSAGEFollow-up template

GET IT RIGHT

5. Measure and avoid.

What to measure

  • Time to first reply
  • Share of enquiries that reply
  • Enquiries that book or buy

Mistakes to avoid

  • Waiting hours before the first message
  • Asking too many questions at once
  • No consent checkbox on the form

FAQ

Questions.

Do I need to change how my tools work?

No. Keep using your form, booking or accounting tool. You only need it to add a row to a Google Sheet for each new record, which most tools can do directly or through Zapier or Make.

What if a row has no phone number, or a bad one?

ConvoHut needs a phone number with the country code. Rows without one are skipped, so validate the phone field in your form or export.

Will editing an old row send another message?

A new row starts the journey. Turn on Fast Edit Detection if you want edits to phone, name or email to update the existing contact within seconds.

Is this marketing or utility?

For this recipe we suggest marketing. Meta decides the category when it reviews your template. Marketing needs marketing consent and an opt-out.

MORE

Related recipes.

Ad lead formWelcome within minutes → wait for reply → hand to salesOpen →Quote requestAsk for photos of the job → wait for reply → notify the estimatorOpen →Missed-call callbackApologise and ask how you can help → wait for reply → notify the teamOpen →

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.

Start free trialBook a demo
  • Meta Tech Provider
  • Hosted on AWS
  • Australian company
  • Your number stays yours
Front-desk team member with a headset helping a customer