Integrate with Google Sheets
On this page
Connect an online form to Google Sheets and each submission is added to a spreadsheet automatically. This article walks through the setup.
Integrate with Google Sheets
-
On the Dashboard, hover over the form, click the Settings (gear icon) at the top right, then click Manage Form.
-
In the left sidebar, click Integrations.
-
Find the Google Sheets card and 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 from the dropdown list, or click Create a new Google Sheets to generate a new one. Spreadsheets you created yourself in Google Sheets are not listed: only spreadsheets created by PlatoForms can be connected.
If you create a new Google sheet, its name will match your online form’s title in PlatoForms. Once a spreadsheet is selected, you’ll see a field called Select a Sheet where you can choose a particular sheet within it to store all the data submitted through the form.
-
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.
With these steps completed, all new form submissions will be automatically saved into your designated Google Sheet.
How the sheet is filled
- PlatoForms does not write a header row. Type your own column titles in row 1; new rows are added below the last row of data.
- Each submission adds one row. When a submission is edited and submitted again, a new row is added and the earlier row is not changed; the revision column tells them apart.
- Fields added to the form later are not ticked in Change Fields. Tick them and click Save, then publish the form again, for their values to be sent.