Append each accepted submission as a new row in a spreadsheet you choose. Formspring uses Google's official Sheets API after you connect your Google account - no Apps Script URL and no third-party relay. Available on Forms, Surveys, and Funnels.
What you need
- A Google account that can edit the spreadsheet.
- Nothing to copy: you pick the spreadsheet and tab from a list inside Formspring. (If you prefer, you can still paste the spreadsheet link.)
Steps
- Open your form / survey / funnel → Webhooks → click the Google Sheets card.
- Click Connect Google account and approve the permissions. Formspring asks to add rows to your spreadsheets and, read-only, to list their names so you can choose one. It does not read the contents of your other files.
- Choose your spreadsheet from the searchable list (newest first; use Load more for older ones). Prefer a link? Choose Paste a link instead and paste the address (it must contain
/spreadsheets/d/...). - Confirm the tab. The first tab is selected for you; pick another from the list, and click Refresh tabs if you just added one.
- Configure the column mapping (see below). You can use Auto-map fields to seed it from your form fields, then drag rows to reorder.
- Click Send test row to verify the connection. The row appears at the bottom of your tab.
- Save the integration and toggle it active.
Reconnect to browse your spreadsheets
Integrations connected before the spreadsheet list existed keep working exactly as they do today. To choose a spreadsheet from the list, click Reconnect Google where you see "Reconnect Google to browse your spreadsheets" and approve the extra read-only permission. Until then, paste the spreadsheet link instead. If you decline the extra permission, rows are still added as before; you just won't see the list.
How rows are mapped
Each column in the spreadsheet is bound to one of three sources:
- Form field - pulls the submitted value for a given field by its stable
name. The field's value is rendered using the format you pick:raw- string / number / boolean as-isdate_iso- ISO 8601 (2026-05-16T14:32:00+00:00)date_human- readable (2026-05-16 14:32)comma- array values joined by,json- encoded as JSONfiles_urls- for file fields, joins all uploaded file URLs with,
- Reserved token - a stable per-submission value not tied to any field:
{created_at}- submission timestamp{submission_id}- Formspring's submission identifier{form_id}- your form / survey / funnel public id{form_name}- the parent's display name{ip},{user_agent},{referrer}- request context{status}-receivedfor normal submissions,spamfor filtered ones{project_id}- submission's project assignment
- Empty cell - placeholder so you can keep spacing without binding anything yet.
If a form field is renamed later, the mapping still works - only the columns that referenced the old name will produce empty cells until you remap them. The mapping assistant flags any unknown field names when you save.
The header row in your spreadsheet is separate from the mapping. Use Write headers to sheet to push the mapping's header labels as the sheet's first row, or Import headers from sheet to start the mapping from a header row you've already authored.
Backfill past submissions
Once a Google Sheets integration is active, you can replay historical submissions through it:
- Pick a window: last 7 days / 30 days / 90 days / all-time (capped at 5,000 rows).
- Click Queue backfill. It runs in the background so it doesn't slow down live submissions.
- Each row passes through the same mapping you configured for new submissions.
Backfills are billable against your monthly delivery counter, same as live deliveries.
Reconnect Google account
If Google rejects the saved connection (the most common reason is revoking Formspring access at myaccount.google.com/permissions), the integration pauses automatically:
- We email the team owner and any member with webhook write permission, once per disconnect.
- A red banner appears at the top of the integration page for everyone with access.
- Live submissions are saved as normal - nothing is lost - but they aren't pushed to the sheet until you reconnect.
- Click Reconnect Google account in the banner or on the integration page to restore the link. Your mapping stays as-is.
We also run a daily background check that surfaces dead connections in the morning instead of at 3 AM, so the email lands while you can act on it.
Tips
- Tab names are case-sensitive and must match exactly (including spaces). Use the tab dropdown to avoid typos.
- Buttons such as Send test row, Queue backfill, Refresh tabs and Auto-map fields confirm the result with a short message; errors from Google are shown the same way.
- If Google returns a permission error after reconnecting, confirm the Google account you authorized actually has edit access on the spreadsheet (not just view access).
- For row-level branching or formula columns, combine Sheets with Automations in Formspring, or use a generic webhook alongside.
Troubleshooting
See Google Sheets troubleshooting for the "row didn't appear" decision tree.
