Find trending topics and quick answers here
Hi, how can we help?
Search FAQs and user guides, or start with a common task.
Search by task, feature, or problem - not just a single keyword.
How to automatically save form submissions to Google Sheets?
Question
Can I automatically save each form submission to Google Sheets?
Answer
Yes. Connect a form to Google Sheets and each new submission adds one row to the selected sheet automatically.
Connect a form to Google Sheets
Follow these steps:
-
Navigate to the Dashboard and hover over the desired form.
-
Click the Settings (gear) icon located at the top right corner of the form, select Manage form, then click Integrations under Connect.
-
On the Google Sheets card, click Connect.
-
Follow the on-screen prompts to grant PlatoForms access to your Google account.
-
Once successfully connected, you’ll see two fields on the panel:
-
Select a Google Sheets: Choose a spreadsheet that PlatoForms created earlier, or click Create a new Google Sheets. Spreadsheets created directly in Google Sheets are not listed. After selecting a spreadsheet, use Select a Sheet to choose the sheet that receives the rows.
-
Fields To Google Sheets: These are the submission fields that will be uploaded to your Google Sheets. Use the Change Fields option to select or deselect them as needed.
- Click Save to apply your settings.
New submissions will now be added to the selected sheet.
What gets added to the sheet?
- PlatoForms does not create a header row. Add your column titles to row 1; submission rows are added below the existing data.
- Each submission adds one row.
- Editing and resubmitting an entry adds another row instead of replacing the earlier one. Use the revision column to tell them apart.
- When you add fields to the form later, select them under Change Fields, save the integration and publish the form again.
For the full setup, see Integrate with Google Sheets.
Use an automation tool instead
Use Zapier or Make when you need to write to a spreadsheet you created yourself, map data differently or trigger other actions after submission.
These automation tools can also send submission data to other destinations, such as:
- CRMs
- Email marketing tools
- Databases
They can run multi-step workflows too, for example sending a notification, updating another app and then running a custom action after a submission.