WA.cr

Send WhatsApp Flow answers to Google Sheets

Save every submitted WhatsApp Flow form straight into a spreadsheet row.

When someone submits a WhatsApp Flow form, an Auto Flow can write their answers into a spreadsheet — one row per submission, one column per question.

Steps

  1. Connect Google Sheets first — see Connect Google Sheets.
  2. Create a spreadsheet with a header row: one column name per question you ask, plus anything else you want, like the customer's phone.
  3. Open Auto Flows and create a flow.
  4. Set its trigger to WhatsApp Flow completed, and choose which form it should react to.
  5. Add a Google Sheets step set to Add a row, and pick your spreadsheet and tab.
  6. Press Load columns, then fill each box with the matching answer, like {{var.flow_email}}.
  7. Turn the flow on and submit the form yourself to check a row appears.

Naming the answers

Each answer is available as {{var.flow_}} followed by the field name from your form, in lower case with underscores instead of spaces.

  • A field named email becomes {{var.flow_email}}.
  • A field named Full Name becomes {{var.flow_full_name}}.
  • A multiple-choice answer is written as one cell, with the choices separated by commas.

You can mix these with anything else the flow knows, like {{contact.phone}}, so each row records who submitted it.

Before you start

  • The form has to be submitted through WhatsApp for a flow to react — a preview doesn't count.
  • Very long answers are shortened, and only the first thirty fields are carried over.
  • If you're unsure of a field's exact name, open the Flow's responses in WA.cr and check the labels there.

If it doesn't work

  • The flow doesn't start — check the trigger names the right form, and the flow is switched on.
  • Cells are empty — the field name doesn't match. Compare it against the responses list and fix the placeholder.
  • The row never appears — open the flow's run history: a failed Google Sheets step shows the reason.