A row in Google Sheets for every submission
The spreadsheet is still where most teams count, filter and hand things on. Each submission appends a row, with the columns and headers you chose, to a spreadsheet Formstep creates in your Drive and touches nothing else in.
Updated
How it works
- Open the form’s Integrations, pick Google Sheets, and connect a Google account or pick one the workspace already connected. Name the spreadsheet, or keep the form’s name.
- Keep Export all form fields on, or turn it off to pick fields, rename headers and add metadata columns.
- Turn on Export existing submissions to bring past responses in, click Turn on Google Sheets, then Send test to add a row of placeholders.
The columns you need
By default, every question is a column, and Submitted at and Submitter come first. Add Submission status to tell a completed response from a Partial draft or an Updated one, PDF Link for the submission PDF, Channel to tell a share-link response from one that answered a request, and Request ID to find that request again. A repeating group maps as one column with every entry numbered, or member by member, each joined with “ · “.
When someone does not finish
On Pro and Business, a public-link response left unfinished for 12 hours, a day, three days or a week can be added as a row too, marked Partial, limited to drafts that answered at least the fields you name.
When delivery fails
Deliveries are queued and tried up to five times, with Google’s rate limits and outages retried on their own. A deleted spreadsheet is recreated, header row and all, and the row is appended. A renamed sheet tab stops appends with an error, because the tab name is fixed when the sheet is created; rename it back. After five failures in a row the integration pauses and the person who set it up gets an email.
The spreadsheet is a good end point for the job application and vendor onboarding templates. When one row per submission is too flat, Airtable gives you typed columns and Notion a page per submission.
