What it does
Sign in with Google and select Make the spreadsheet. Each response adds a row, kept up to date. Formkit can only open the files it makes, never the rest of your Drive.
Paste the =IMPORTDATA formula Formkit shows into any cell, and Google refreshes it about once an hour. For every few minutes, use the Apps Script Formkit gives you with a time-driven trigger. Anyone with the link can read the responses, so make a new one if it gets out.
Google Sheets leads the responses export bar. It opens the form's synced sheet, or takes you to Connections to set one up.
The Google sign-in opens in a new tab, which closes itself when it is done, and you stay signed in to Formkit.
Which plan includes it
- CSV, JSON and PDF export
- Google Sheets
- Excel export
How to start
- 1Open a form's Settings → Connections and choose Google Sheets
- 2Sign in with Google in the new tab
- 3Select Make the spreadsheet
- 4Send a response and find it as a new row
Templates to start from
Every templateGoes well with
In the help centre
Questions
Can Formkit see my other files?
No. It can only open the spreadsheets it makes.
Do partial responses go to the sheet?
No. Only responses people sent are added.
Is it on the free plan?
Google Sheets is part of Pro. CSV, JSON and PDF exports are on every plan.
Try it on your next form.
Free to start, with unlimited forms, responses and members. See what each plan includes on the pricing page.