Sync Jotform form submissions to a live Google Sheets spreadsheet

This template starts when someone submits a Jotform, maps the answers in JavaScript, and appends a Google Sheets row.

Connect Jotform and Google Sheets. Put the Jotform API key on the Jotform connection. Pick the form on the trigger and the worksheet on the add-row step.

Updated Sep 16, 2026Est. run: 7sEst. cost: $0.0004

Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how CPU seconds work →

Workflow preview

What this template does

Writes each Jotform submission into Google Sheets
Starts when the form is submitted
Maps answers to columns in JavaScript
Keeps the Jotform API key on the Jotform connection

How it works

Trigger

Watch Jotform submissions

The scenario starts when someone submits the Jotform you connect.

Logic

Map the answers

JavaScript turns form fields into the column values your sheet expects.

Action

Add the Google Sheets row

Google Sheets appends those values as a new row in the worksheet you choose.

Setup guide

Connect Jotform

Add a Jotform connection and paste your Jotform API key there. Watch new submissions on the form that should land in the sheet.

Connect Google Sheets

Add a Google Sheets connection. Use a worksheet whose columns match the form fields you want to store.

Map columns and append

In JavaScript, return stable field names that match your columns, then add a single row. Submit a test entry and confirm the new row.

Requirements

A Jotform form Latenode can watch, with the Jotform API key on the Jotform connection

A Google Sheet Latenode can write

Agreement on which form fields become columns

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.

Contact support →

More templates

Browse all templates →

123FormBuilder to Insightly: Create leads from form submissions

Manually copying form responses into your CRM wastes time and risks errors. This integration captures each New Submission event from 123FormBuilder and uses it to Create a Lead in Insightly, mapping the respondent's name, email, and custom fields directly into a new lead record. Marketing managers and sales teams can eliminate data entry and get leads into Insightly instantly for follow-up. By connecting 123FormBuilder's form capture with Insightly's CRM, you keep your sales pipeline fed without manual work.

8s~$0.002

Send new ClickFunnels contacts to a Mailchimp audience

Manually exporting leads from ClickFunnels and importing them into Mailchimp is slow and error-prone. This automation uses the New Contact Identified trigger in ClickFunnels and the Add or Update Subscriber action in Mailchimp to capture every new form submission and add or update the contact in your chosen audience. Marketing automation managers and business owners who run ClickFunnels funnels can use this pair to keep their Mailchimp audience populated with fresh leads. ClickFunnels captures the contact's email and name, and Latenode passes that data directly to Mailchimp, so no manual CSV uploads or copy-paste are needed.