Google Sheets - Troubleshooting
When a submission doesn't land in your spreadsheet, work through this list in order.
1. Is the integration active?
Open your form / survey / funnel → Webhooks. The Google Sheets row has a status pill:
- active - should be delivering. Continue with step 2.
- paused - toggle it on or check whether the spreadsheet config is complete.
- reconnect - Google rejected the saved connection. Click the banner's Reconnect Google account link.
2. Did the submission itself succeed?
A submission has to pass Formspring's validation and spam scan before it goes to integrations. Open the submission in your Inbox:
- If the status is
spam, integrations are intentionally skipped. Spam classification can be tuned per form in Spam protection settings. - If you don't see the submission at all, the form might be paused, archived, or returning an error to the submitter - check the public form URL directly.
3. Check Deliveries on the integration
Each delivery has a status code and (for failures) an error code:
| Error code | What it means | Fix |
|---|---|---|
google_sheets_not_configured |
Spreadsheet URL or tab name is missing, or the integration still points at the retired Apps Script URL. | Reopen the integration, set the spreadsheet URL and tab name, save. |
google_sheets_auth_required |
Google revoked or invalidated the saved connection. | Click Reconnect Google account on the integration page. |
| HTTP 401 | Same as auth_required - the access token was rejected at delivery time. |
Reconnect. |
| HTTP 403 | The connected Google account doesn't have edit access on the spreadsheet, or the project's Sheets API is restricted. | Re-share the spreadsheet with the account you connected, or pick a different account. |
| HTTP 404 | The spreadsheet was deleted, or the tab name no longer matches a tab in the sheet. | Confirm the spreadsheet URL still works in your browser, then pick a tab from the dropdown again. |
| HTTP 429 | Google's API rate limit. Usually self-resolves within a minute. | Wait and click Replay on the delivery, or just submit the form again. |
4. Confirm the mapping isn't writing into empty cells
If rows do appear but the data looks wrong:
- Open the integration → mapping section.
- For each column, confirm the source (field vs token) and the field name.
- Use Send test row - it appends a single row using the current mapping. If the test row shows empty cells where you expect data, the mapping has a stale field reference.
5. Check the right account is connected
The "Google account connected" line at the top of the integration page shows whether OAuth is in good standing, but not which account is connected. To verify:
- Click Reconnect Google.
- On the Google account-chooser screen, confirm the email address. Cancel if it's wrong.
- Sign out of Google in your browser if necessary so the account chooser appears.
6. Still stuck?
Tell support which form / survey / funnel and which spreadsheet, plus a recent submission ID from your Inbox. Support has a cross-team admin view that shows token expiry, failure counts, and the auth-required flag, and can nudge a reconnect email back to your team if the original got missed.