Google Sheets and Jotform automations

Set up an automation: when new submission in Jotform, add new row to sheet in Google Sheets

Build it

50agents builds it as an automation, and asks before anything goes outside.

Google Sheets and Jotform in practice

Used for

Each Jotform submission fills a new row in Google Sheets.

Best template

“New Submission” in Jotform, then “Add New Row to Sheet” in Google Sheets. Jotform pushes each submission as it arrives, and “Add New Row to Sheet” writes it.

Watch out

If you rename Jotform fields or reorder sheet columns, recheck the header or column-letter mapping.

Google Sheets and Jotform templates

Pick one and Captain builds it with you.

  • When new submission in Jotform, add new row to sheet in Google Sheets

    Build this
  • When new submission in Jotform, row added or updated in Google Sheets

    Build this
  • When new submission in Jotform, format spreadsheet row in Google Sheets

    Build this

Google Sheets and Jotform triggers and actions

Every one of both apps. A trigger starts the work; actions are the steps.

Triggers

1
  • Row added or updatedRuns when row added or updated

Actions

23
  • Update spreadsheet rowUpdate columns in sheet row
  • List rows in sheetGet rows from a sheet tab as objects with row numbers. Supports an optional header row, offset/limit paging, and fetching from the last row.
  • Delete rowsDelete one or more rows from a specific sheet in a Google Spreadsheet using a row range or row numbers.
  • Add new row to sheetRuns as a step in Google Sheets.
  • Lookup spreadsheet rowsFind rows in a Google Sheet that match a column value or an advanced filter.

Questions about Google Sheets and Jotform

What can start a Google Sheets and Jotform automation?

“New submission”.

Which other apps work with both Google Sheets and Jotform?

Slack, Shopify, Stripe, Buffer and Swiftype. Each one has templates with Google Sheets and with Jotform, so a third app can join the same job.

All Google Sheets integrations · All Jotform integrations · Every app, A to Z

Connect Google Sheets and Jotform

Or pick another template above. Free to start.

Build it with Captain
Google Sheets and JotformBuild it