NeetoForm offers integration with Google Sheets, which means that the data collected through your form submissions can be automatically stored on a Google Sheet. When someone submits a form, the data is instantly transferred to a designated Google Sheet in real-time.
How it works
A new row is created whenever someone submits your form, and the results automatically appear in a spreadsheet. You can move or delete columns as you like, and your form results will appear accordingly in Google Sheets.
To integrate Google sheets
Go to your Form dashboard, open your form, and click the Settings tab.
Scroll down to find Google Sheets integration and click on 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 can move your sheet to another folder and move or delete columns in the sheet without affecting the integration.
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.