Send Form and Survey Answers to Google Sheets

You can copy past answers out as a file, or have each new answer land in a spreadsheet row automatically. They are two separate methods.

Method 1: Export existing answers

1. Go to Sites > Forms > Submissions (or Surveys > Submissions).
2. Filter to the form or survey you need.
3. Click Export.
4. A download link is emailed to you. Open the CSV in Google Sheets with File > Import.

Method 2: Add each new answer automatically

Prepare a Google Sheet with a header row (for example Name, Email, Phone, Feedback), and connect your Google account in Vendi Today.

1. Open Automation > Workflows and create a new workflow.
2. Add the Form Submitted or Survey Submitted trigger and use its filter to pick the exact form or survey.
3. Click + Add Action, choose Google Sheets, then Create Spreadsheet Row.
4. Select your Google account, spreadsheet and worksheet.
5. Map each workflow value (contact name, email, phone, mapped fields) to a column.
6. Save, Publish the workflow, and submit a test entry.
7. Confirm a new row appears with values in the right columns.

Troubleshooting

• Nothing happens: Check that the workflow is published and the trigger filter names the right form.
• No row: Check the account, spreadsheet and worksheet in the action, and review execution history.
• Wrong columns: Re-check the mapping.
• Answer missing: Not every answer becomes a contact field; confirm the value is available to the workflow.

Good to know: Keep the header row in place and add new columns to the right so existing mappings do not shift.