How to Get Jotform Submission Data Into Google Sheets (and When a Chart Tool Is Faster)

Option 1 — Native Google Sheets integration (recommended)

1. Open your form → Settings → Integrations → search Google Sheets.
2. Authenticate your Google account and choose to create a new sheet or use an existing one.
3. Map the form fields to columns and save. New submissions now append a row automatically; existing submissions can be imported on setup.

This is the best default: a live sheet, no exports, no third-party tool. The one gotcha is that payment fields often arrive as text (see the FAQ below) — clean them before you SUM.

Option 2 — One-time CSV export / import (snapshot)

1. In Jotform, go to Submissions → Export → Excel/CSV.
2. In Google Sheets, File → Import and upload the file (or open the Excel file directly).

Best when you just need a point-in-time snapshot — it won’t stay in sync, so you re-export whenever you want fresh numbers.

Option 3 — Zapier or Make (when you need to transform)

If you need to reshape data on the way — split a field, route to different sheets by product, or add rows to an existing multi-source tracker — a Jotform → Google SheetsZap (or a Make scenario) gives you that middle layer. It’s more setup and, on paid tiers, another subscription, so reach for it only when the native integration can’t do what you need.

Option 4 — Skip Sheets with a live connector

If the only reason you’re moving data into Sheets is to build charts, a reader that connects to the form directly removes that step. More on when that’s worth it below.

Once it’s in Sheets: getting a real revenue total

The most common surprise is that SUMon the payment column returns 0. That’s because Jotform stores the amount as text like $42.00. Add a helper column to clean it:

• =VALUE(REGEXREPLACE(A2,"[^0-9.]","")) strips the $ and commas, leaving a real number.
• Then =SUM(...)the cleaned column, and drop test / refunded rows so they don’t inflate the total.

For revenue by product or by month, build a pivot table on the cleaned data and, if you want a chart, select the pivot output and Insert → Chart. There’s a full walkthrough in turning Jotform submissions into a chart or dashboard.

When a chart tool is faster than Sheets

Google Sheets wins when you want custom formulas, a snapshot, or a sheet that other systems already read. A dedicated reader wins when the same money questions repeat. In Sheets, each reporting cycle you re-clean the payment column, drop test rows, and rebuild the pivot. A tool like TutuMarginconnects to your Jotform read-only and shows total revenue, average order value, top products, monthly trend, and new-vs-repeat customers the moment it reads your submissions — and you can ask it for any other cut in plain English.

Honest framing: if you report once and love spreadsheets, stay in Sheets. If you’re rebuilding the same revenue view every week or month, that recurring work is exactly what the tool removes — start free for ~10 questions, then $19/mo.

Related reading: how to see total revenue from your Jotform and Report Builder vs. a spreadsheet vs. a dedicated reader.