betterform

Destinations / Google Sheets

Form answers, straight to Sheets.

Every answer becomes a row in your sheet. Native Sheets is on the way. Until then, a webhook and a few lines of Apps Script get you there.

Coming soon. Webhooks work today, on every plan.

Studio leads
submittednameemailmessage
Mar 2, 9:12Jonah Reyesjonah@rise.bakeryLogo and site for a bakery, opening in March. Happy to hop on a call this week.
Mar 1, 16:40Sam Okaforsam@okafor.studioLooking for an illustrator for a picture book.
Feb 28, 11:05Priya Nairpriya@nairandco.comCan you quote a brand refresh for spring?

Setup

Set it up today

Sheets can take a webhook through Apps Script. It takes about five minutes.

  1. 1
    In your sheet, open Extensions, then Apps Script.
  2. 2
    Replace the code with this and save:
    function doPost(e) {
      const { submittedAt, fields } = JSON.parse(e.postData.contents)
      SpreadsheetApp.getActiveSheet().appendRow([submittedAt, ...fields.map((f) => f.value)])
    }
  3. 3
    Click Deploy, then New deployment. Pick Web app, set access to Anyone, and copy the URL.
  4. 4
    Add a Webhook destination in betterform with that URL.

Set it once.
Forget it's there.

Retries if a post fails
A failed post is tried again after 30 seconds, then 5 minutes. You'll see every attempt in the inbox.
Spam stays out
Held submissions are never sent. Move one out of spam and it's delivered then.
One form, many places
Send the same form to Slack, Teams and email at once. Each teammate picks their own.

Get a taste of betterform.

Your first form takes a minute. 250 submissions a month, free.

Create your first form