Skip to content

Starter

A formGoogle Sheets

Add a row in Google Sheets when a form is submitted

When a form is submitted, add a row in Google Sheets.

Use this templateBrowse the library

Start the 14-day trial, then find it under Templates → Library. It installs into the client you choose, switched off, with its checklist.

Steps
1
Client fills in
2
Accounts
1
Starts
A form is submitted, within seconds

Uses

Every step, in order

When it happens in the first app, the step runs in the second, with the client’s own account.

A form is submitted
Someone sends one of the client’s forms.
Add a row
Add a row at the bottom of a sheet, one value per column, left to right.
  1. Starts whenA form is sent
  2. App stepAdd a row

What each client fills in

Google Sheets: Spreadsheet ID
For example from the URL: docs.google.com/spreadsheets/d/<this>/edit
Google Sheets: Sheet (tab)
For example Sheet1

The accounts it needs

Each is the client’s own, stored encrypted and never copied between clients. Until one is added the client’s checklist shows it, and nothing runs.

  • Google Sheets

    In your own Google Cloud project: enable the Google Sheets API, then IAM & Admin → Service accounts → Create → Keys → Add key → JSON, and paste the file here. Then share each client sheet with the service account’s email (…@….iam.gserviceaccount.com) as an Editor. The account is yours; no Google review is needed.

After you install it

It lands switched off. The client’s checklist holds exactly this:

  1. Pick the client’s form that starts it
  2. Connect the client’s Google Sheets, for “Add a row”
  3. Fill in Google Sheets: Spreadsheet ID (For example from the URL: docs.google.com/spreadsheets/d/<this>/edit)
  4. Fill in Google Sheets: Sheet (tab) (For example Sheet1)
  5. Check the order of Google Sheets’s values, column by column against the client’s columns

Related templates

Thrum is cooking.

Get early access and you’ll be among the first in. Early members get a launch perk.

Get early accessSee pricing