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.
Click Integrations on the left-hand side.
Find Google Sheets on the Integrations and click on Sign in with Google.
A message will pop up asking you to connect to a Google account or choose the one you previously connected to NeetoForm. Choose an account or follow the prompts to sign in to Google.
You can choose an account if you are already connected.
Once you're connected, a new spreadsheet will be created in your Google account's default drive, 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.
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.