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
| submitted | name | message | |
|---|---|---|---|
| Mar 2, 9:12 | Jonah Reyes | jonah@rise.bakery | Logo and site for a bakery, opening in March. Happy to hop on a call this week. |
| Mar 1, 16:40 | Sam Okafor | sam@okafor.studio | Looking for an illustrator for a picture book. |
| Feb 28, 11:05 | Priya Nair | priya@nairandco.com | Can 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.
- 1In your sheet, open Extensions, then Apps Script.
- 2Replace 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)]) } - 3Click Deploy, then New deployment. Pick Web app, set access to Anyone, and copy the URL.
- 4Add 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.