Google Sheets
Formspark does not connect to Google Sheets directly. The recommended path is to use Zapier or Make as a bridge. For developers, a Google Apps Script webhook is also an option.
Via Zapier
- Set up the Formspark Zapier integration.
- In your Zap, select
New Submissionas the trigger. - Add
Google Sheetsas the action and chooseCreate Spreadsheet Row. - Map your form fields to the matching spreadsheet columns.
Via Make
- Set up the Formspark Make integration.
- In your scenario, select
Formspark→New Submissionas the trigger. - Add a
Google Sheets→Add a Rowmodule. - Map your form fields to the matching spreadsheet columns.
The free tier of both Zapier and Make is sufficient for typical low-volume contact forms.
Via webhook (Google Apps Script)
If you'd rather skip a third-party automation tool, you can deploy a Google Apps Script as a web app and use its URL as your form's webhook.
- Open your spreadsheet and go to
Extensions→Apps Script. - Write a
doPost(e)function that appendse.postData.contentsto the active sheet. - Deploy the script as a web app with access set to
Anyone. - Paste the deployment URL into your form's
Webhook URLfield.
Check this page to learn more about webhooks.