NeetoForm integrates with Google Sheets so that the responses collected through your form are automatically copied to a Google Sheet. Whenever someone submits your form, a new row is instantly added to the sheet with their response. Your data continues to live in NeetoForm as well — a copy is simply added to the sheet, nothing is moved out of your form.
How it works
A new row is added to your connected Google Sheet every time someone submits the form, and the response appears automatically. NeetoForm creates and manages this sheet for you as part of the integration.
Integrate Google sheets
Go to your Form dashboard, open your form, and click the Settings tab.
Scroll down to Google Sheets and click Sign in with Google.
Once you're connected, a new spreadsheet will be created in your Google Drive's root folder, and a link to it will be visible in the Google Sheets integration row.
You're free to move this sheet to any folder in your Google Drive — the integration will keep working.
Note: You cannot export form data to an existing spreadsheet. NeetoForm only syncs to a spreadsheet that it creates as part of the integration.
Handling column changes and data syncing
To keep your Google Sheets integration reliable, NeetoForm attaches metadata to each column in the connected sheet. This metadata allows us to correctly populate submission details even if you rename columns or reorder columns in the connected Google Sheet.
However, the integration can break and data may get corrupted if you clear column values and then copy–paste values from other columns instead of properly reordering or deleting columns. In such cases, NeetoForm may no longer be able to correctly identify columns, and we won’t be able to populate the latest submission details in your Google Sheet.