Connect Jotform and Google Sheets

Jotform holds your submissions, but planning, reporting and sharing often happen in a spreadsheet. FlowMattic copies each Jotform response into Google Sheets from your WordPress site and does more with it: one row per ordered item, an AI check on claims, an approval column filled in by a reviewer, or a stop when an event is full. It suits schools, event organisers and service teams.

Try FlowMattic free See example workflows

7 triggers 19 actions 6 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in Jotform1 trigger

Do this in Google Sheets19 actions

1. TriggerNew Form Submission

2. ActionAdd New Row

When Jotform fires New Form Submission, FlowMattic runs Add New Row in Google Sheets with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

Jotform and Google Sheets workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

Write every Jotform submission to a Google Sheet

Each response becomes a row with the columns you pick, so the people who work from the sheet never need a Jotform login.

New Form SubmissionAdd New Row

Update the applicant's row when they submit a change form

A change request form asks for a reference number. Lookup Row Data finds that row and Update Row replaces the old details, so the sheet keeps one line per applicant.

New Form SubmissionLookup Row DataUpdate Row

Ready-made template

Check warranty claims with AI and record the result

An AI Agent compares the claim against your rules, such as purchase date and product, and the row records its approve or more-info decision for a person to confirm.

New Form SubmissionAI AgentAdd New Row

View the template

Close registrations when the sheet reaches capacity

Get Row Count checks how many people are registered. When the event is full, a Filter lets Email (SMTP) tell the organiser it is time to close the form.

New Form SubmissionGet Row CountFilterEmail (SMTP)

Give each ordered product its own row

Order forms with several products are split by an Iterator, so the sheet has one row per item and quantity, which makes packing lists and totals simple.

New Form SubmissionIteratorAdd New Row

Let a reviewer approve each application in the sheet

The application is written as a row, then Human in the Loop asks a reviewer to approve or decline, and the decision is written into the row's Status cell.

New Form SubmissionAdd New RowHuman in the LoopUpdate Cell Data

Set up: each submission as a row

By the end, every new Jotform submission on your chosen form adds a row to your Google Sheet.

Prepare the sheet
Create a spreadsheet with a header row that matches the answers you want, for example Submitted, Name, Email, Phone and Choice.
Connect both accounts
Add Jotform and Google Sheets under Connects in FlowMattic, using a Google account that can edit the spreadsheet.
Choose New Form Submission
Start a workflow with the Jotform New Form Submission trigger, pick the form and send a test submission.
Map Add New Row
Add Add New Row, choose the spreadsheet and tab, map each answer to its column, test the step and switch the workflow on.

From Jotform	To Google Sheets
Submission date	Submitted
Full name	Name
Email	Email
Phone number	Phone
Dropdown answer	Choice

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

Jotform has no actions here, so data flows from Jotform to Sheets. A sheet edit cannot change or create a Jotform submission.
Answer names depend on the questions in your form; the mapping shows a common contact form.
Get Row Count counts the rows in the sheet you point it at, so keep registrations on their own tab and allow for the header row.

Jotform

Integration page

Triggers (1)

New Form SubmissionTriggers when new form submission is received

Google Sheets

Integration page

Triggers (6)

New Spreadsheet RowTrigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
Update Cell DataTrigger when any cell is updated in the spreadsheet
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

Add New RowAdd a new row with mapped data
Update RowUpdate existing row in specific spreadsheet with mapped data
Delete RowDelete row by ID in specific spreadsheet
Clear Row DataClear data or row by ID in specific spreadsheet
Lookup Row DataSearch for data in specific spreadsheet
Get Cell DataGet data for particular cell in specific spreadsheet
Update Cell DataUpdate data for particular cell in specific spreadsheet
Get Row CountGet total number of rows in specific spreadsheet
Get Row DataGet rows data from the sheet based on specified range
Create Spreadsheet ColumnCreate a new column in specific spreadsheet
Create New SheetCreate a new sheet in specific spreadsheet
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
Copy SheetCopy a sheet to another or within the same spreadsheet
Get RowsRetrieve rows in JSON format for use with Iterator
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Why run this pair with FlowMattic

Jotform and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

Responses go where the work is

Teams that plan in spreadsheets get each submission as a row, ready to sort, filter, share and chart.

No limit on submissions

FlowMattic runs on your WordPress server with unlimited runs, so a busy enrolment period costs nothing extra to automate.

A sheet that can decide

Lookup, count and update actions let the workflow check what is already in the sheet before it writes, not only append rows.

Common questions

Can I send old Jotform submissions to the sheet?

FlowMattic's Jotform trigger handles new submissions. For older ones, export them from Jotform and paste or import them into the same sheet, then let the workflow add new rows from there.

Can different forms write to different tabs?

Yes. Create a workflow per form, each with its own Add New Row step pointing at a different tab or spreadsheet.

Can uploaded files go into the sheet?

File upload answers usually come through as links. Map the link into a column so anyone with access to the sheet can open the file from Jotform.

Can the sheet show a calculated field such as a total?

Yes. Map the form's calculated value to a column, or keep a formula column in the sheet that works on the values FlowMattic writes.

Did not find your answer? You can browse the help center or ask us directly.

Start automating Jotform and Google Sheets

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

Try FlowMattic free See pricing

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 23 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Jotform integration 1.0, Google Sheets integration 2.2.4.