Google Sheets Integration
Automatically send form responses to a Google Sheets spreadsheet. Check each submission’s delivery status in Rowform if a row does not appear.
Setting Up Google Sheets
- Open your form in the Builder.
- Click the Integrate tab.
- Find Google Sheets and click Connect.
- Click Connect Google Account and approve access.
- Click Create Spreadsheet.
- Choose whether to sync previous responses or start fresh.
Once connected, Rowform attempts to send each new submission as a new row in your spreadsheet.
How It Works
- Each question in your form becomes a column header in the spreadsheet.
- Each successful delivery creates a new row with the respondent’s answers.
- Hidden fields (if configured) are appended as additional columns after the question columns, using the parameter name as the header.
- A dedicated spreadsheet is created in your Google Drive for each connected form.
- Delivery starts after the response is saved in Rowform; rows usually appear within seconds.
Checking Submission Delivery
Open Results → Submissions to see the Google Sheets status for each completed response. Click a submission to see its delivery details, error reason, and recorded, attempted, and completed times. Statuses refresh automatically while you view Results; Refresh delivery status checks again immediately.
| Status | Meaning |
|---|---|
| Delivered | Google Sheets confirmed that the response row was written. |
| Pending | The response is saved and delivery has not started. |
| Sending | A delivery attempt is in progress. |
| Failed | Delivery could not be completed. Open the submission for the reason, such as revoked Google access or a rejected request. |
| Unconfirmed | Rowform could not establish the outcome, or pending work has not completed after five minutes. Check the sheet before manually adding a row. |
| Not sent | Delivery was skipped, for example because Sheets was disconnected before the attempt started. |
| No delivery record | There is no recorded outcome. Older submissions may predate delivery tracking; this does not establish whether they reached the sheet. |
A submission’s success message means its response was saved in Rowform. Its Google Sheets delivery has a separate status. Delivery failures do not remove the saved response, and the respondent does not need to submit again.
Delivery tracking currently covers individual new-submission delivery attempts. It does not retry failed deliveries automatically or track the outcome of Sync Previous Responses. A later full sync does not replace the original attempt’s status. Reconnecting Google restores the connection for future submissions; it does not replay earlier failed attempts.
Syncing Previous Responses
If you connect Google Sheets to a form that already has responses:
- Click the Sync Previous Responses button to backfill all existing data into the spreadsheet.
- You can run a full sync again if needed. It rebuilds the response columns before writing the current data.
- Future responses sync automatically.
Managing the Connection
Last Full Sync
The integration panel shows when existing responses were last fully synced. New submissions continue to append automatically.
Disconnecting
To disconnect Google Sheets from your form:
- Go to the Integrate tab.
- Click Disconnect next to the Google Sheets integration.
- Existing data in the spreadsheet is preserved — only future syncing stops.
Bot Protection
Only verified submissions are synced to your spreadsheet. Spam and bot submissions are blocked by Cloudflare Turnstile before they reach Google Sheets, so your data stays clean.
Tips
- Use Google Sheets for live dashboards — create charts and pivot tables from your response data.
- Share the spreadsheet with your team to give everyone access to incoming responses.
- Combine with Google Sheets formulas or scripts for advanced data processing.
- If you need to restructure your form (add/remove/reorder questions), reconnect the spreadsheet to update column headers.