Google Sheets and Jotform automations
Set up an automation: when new submission in Jotform, add new row to sheet in Google Sheets
Build it50agents 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
No triggers match.
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.
- Copy sheet to spreadsheetCopy a sheet to another file
- Add multiple rowsAdd one or more rows to a specific sheet in a Google Spreadsheet. Provide data column-by-column or paste a JSON array for bulk inserts. If the sheet has no headers, they will be auto-created from your JSON keys.
- Create subsheetAdd a new subsheet to a spreadsheet and optionally set its position and add column headers in the first row.
- Create sheet columnInsert a new column into the specified Google Sheets sheet at the given index (or append to the end) and optionally set its header.
- Get rows from rangeRetrieve rows from sheet range
- Create a spreadsheetCreate a new spreadsheet.
- Find subsheetSearches a sheet in a spreadsheet by name and returns the sheet name, column titles, and number of rows.
- Get row detailsRetrieve values and metadata for a specific row in a spreadsheet sheet.
- Clear spreadsheet rowClears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.
- Create spreadsheet from templateCreate sheet from template
- List spreadsheetsFetch all spreadsheets
- List spreadsheet tabsLists all tabs (sheets) in a spreadsheet and returns the total count.
- Batch update cell valuesUpdate multiple cells at once
- Format spreadsheet rowFormat row font and background
- Add conditional formatting ruleApply conditional formatting to cells in a Google Sheets spreadsheet based on their values
- Update sheet nameRenames an existing sheet (tab) within a Google Spreadsheet to a new name you specify.
- Update multiple rowsUpdate values in one or more rows of a Google Sheet.
- Permanently delete spreadsheetPermanently delete a spreadsheet from Google Drive, including files on shared drives.
No actions match.
Triggers
1- New submissionUpdate New Submission trigger sample to return latest submission or a single-line no-data message.
No triggers match.
Actions
8- Get submission dataRetrieve answers from a specific form submission.
- Get user informationGet user account details.
- Get form submissionsRetrieve submissions from a selected form; supports filters, paging, and field selection.
- Create formCreate a new form to collect responses.
- List formsList Jotform forms with ID, title, status, last submission date, and link. Supports status, date range, pagination.
- Create submissionCreate a Jotform submission from provided responses and return the submission ID and URL.
- List form questionsLists all questions from a Jotform form using its form ID.
- Add questionAdds a new question to a form.
No actions match.
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