Google Sheets Integration

Append Formkove submissions to a Google Sheet automatically. This is a Pro feature.

How It Works

Formkove connects to Google Sheets through a Google Apps Script that you deploy to your Google account. When a submission comes in, Formkove sends the data to your script’s URL, which writes it to your spreadsheet.

This approach keeps your data in your own Google account — no third-party access required.

Setup

1. Create the Apps Script Project

1. Go to script.google.com and click New project
2. Delete any placeholder code and paste the Formkove Apps Script template (available in the Formkove dashboard)
3. In your script, set the sheet name and range to match your target spreadsheet
4. Click Deploy → New deployment
5. Choose Web app as the deployment type
6. Set Execute as to Me and Who has access to Anyone
7. Click Deploy and copy the Web app URL (it looks like https://script.google.com/macros/s/.../exec)

2. Connect to Formkove

1. Open app.formkove.com and select your form
2. Go to Integrations → Google Sheets
3. Paste your Apps Script web app URL
4. Save

3. Test

Submit a test entry through your form. The submission should appear as a new row in your Google Sheet within a few seconds.

Troubleshooting

Problem	Fix
No data appears	Check the script’s execution logs in the Apps Script editor
Authorization error	Redeploy the script and ensure access is set to Anyone
Wrong columns	Update the range in your Apps Script project to match your sheet layout