What it does
Choose Google Sheets and sign in. Formkit makes a spreadsheet called after the form, with a Responses tab: Submitted, Name, Email, then a column for each question. Each new response is a new row, and a changed response updates its own row.
- Only the files Formkit makes, never the rest of your Drive
- A row the moment a response arrives
- Edits update the same row
Choose Google Sheets, by link, and Formkit gives you a formula to type into any cell. Google refreshes it about once an hour. For every few minutes, paste the Apps Script Formkit gives you and add a time-driven trigger.
The latest 3,000 complete responses, with a column for each question, each calculation's result and the payment. Uploaded files and voice recordings arrive as links. Exports have everything, however many there are.
Anyone with the link can read the responses. If it gets out, make a new link and the old one stops working at once.
How to start
- 1Open a form's Settings → Connections
- 2Choose Google Sheets and sign in, or choose Google Sheets, by link
- 3Make the spreadsheet, or paste the =IMPORTDATA formula into a cell
- 4Send a response and watch it arrive
Templates to start from
Every templateGoes well with
In the help centre
- 1 min readKeep a Google Sheet up to dateConnect Google for a sheet Formkit keeps up to date, or use a private link your sheet pulls from.
- 1 min readExport to CSV, Excel, JSON or PDFGetting the data out for a spreadsheet, a script or a printer.
- 1 min readCalculations and scoringAdd up answers into a total, a score or a price.
Questions
Can Formkit see the rest of my Google Drive?
No. When you sign in, Formkit asks only for the files it makes itself. The link way needs no Google sign-in at all.
How quickly do responses appear?
In a spreadsheet Formkit made, as each response arrives. With the formula, about once an hour; with the Apps Script, every few minutes.
Are partial responses included?
No. Only responses people sent reach the sheet. Partial ones stay in Formkit, where you can filter for them.
Is there a free way?
Export to CSV on any plan and open the file in Google Sheets. The live connections are part of Pro.
Try it on your next form.
Free to start, with unlimited forms, responses and members. See what each plan includes on the pricing page.