Send submissions to Google Sheets

Log form submissions in Google Sheets

A new row for every real submission. No Zapier bill. Open a blank sheet, paste a short script, then add the web app URL to your form.

No Zapier

Free Google tools

About 5 minutes

Create a new sheet↗

Opens a blank Google Sheet

Open Apps Script↗

Set it up

Most people finish this in a couple of minutes.

Create a sheet

Open a blank spreadsheet and name it something like Form submissions. The first row is created for you on the first real submission.

Paste the script

Go to Extensions → Apps Script, replace the starter code with the script below, and save.

Deploy as a web app

Click Deploy → New deployment. Choose Web app.

Execute as: Me
Who has access: Anyone

Deploy and copy the URL. It looks like https://script.google.com/macros/s/.../exec.

Paste it on your form

In your Boosterpack Forms dashboard, add that URL as a webhook. Submit the form once and watch a row appear.

Changed the script? Create a new deployment so the URL uses the new version. Email still arrives if you keep a destination inbox on the form.

The script

Headers are created on the first submission. After that, each send appends a row.

Code.gs

Extensions → Apps Script

function doPost(e) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = JSON.parse(e.postData.contents);

  if (sheet.getLastRow() === 0) {
    var headers = ['Timestamp', 'Form ID'];
    var fieldNames = Object.keys(data.fields || {});
    headers = headers.concat(fieldNames);
    sheet.appendRow(headers);
  }

  var row = [
    data.submittedAt || new Date().toISOString(),
    data.formId || '',
  ];

  var headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];
  for (var i = 2; i < headers.length; i++) {
    var val = (data.fields && data.fields[headers[i]]) || '';
    row.push(val);
  }

  sheet.appendRow(row);

  return ContentService
    .createTextOutput(JSON.stringify({ ok: true }))
    .setMimeType(ContentService.MimeType.JSON);
}

For developers

You can skip this.

Apps Script cannot read our HMAC headers, so this path relies on the long, private web app URL. That is fine for most logs. If you need signed requests, put a small proxy in front.

Set webhook via API

curl -X PATCH "https://boosterpackforms.com/api/forms/<FORM_ID>" \
  -H "Authorization: Bearer $BPF_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{ "addWebhookUrl": "https://script.google.com/macros/s/.../exec" }'

Plans

Slack, Discord, and other destinations use webhooks, which are on Professional and Business. Email delivery works on every plan, including Free. You can keep email and add a destination later.