Start free

Jotform connector · Form reports

Read & reportRead-only source

Count Jotform submissions and answers without exporting by hand.

Bring Jotform forms, submissions and answers into your reports and AI assistants: submissions and unread counts per form, each submission’s status and flags, and every answer as its own row.

  • Count submissions per form per day
  • Tally how often each answer was chosen
  • Ask ChatGPT or Claude which submissions are still unread
JotformSheetsData StudioChatGPTClaude

Start free Explore the data

Updated November 2026

Jotform reportSample data
Form titleSubmissionsUnread submissions
New patient intake1,28412
Demo request3123
Clinic feedback960
Refreshes on your schedule in Google Sheets

Jotform reporting for one account

One Jotform account is the data source, with all forms or the one you pick. Submissions follow your report dates; times are US Eastern, as Jotform records them.

Forms

Read each form’s status, submissions, unread submissions, created date and last submission.

Submissions

See each submission’s form, time, status, unread and flagged state, and questions answered.

Answers

Get one row per question with the question, its field type and the answer as text.

Data location

Works with US, Europe and HIPAA accounts.

Report datasets and details

Reports you can build

3 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.

  • Forms
  • Submissions
  • Answers
What each dataset reports
  • Forms

    One row per Jotform form: title, status, total and unread submissions, when it was created, last changed and last submitted, and its share link. Times are US Eastern.

  • Submissions

    One row per submission received in the report dates: form, when it arrived, its status, whether it is unread or flagged and how many questions were answered. Times are US Eastern.

  • Answers

    One row per question of each submission received in the report dates, with the question, its field type and the answer as text. Times are US Eastern.

Metrics and dimensions

27 report fields across 3 datasets.

Search the available fields. Hover or tap a field to see what it means.

Send Jotform data anywhere

Google SheetsGoogle SheetsA sheet that refreshes every morning.
Data StudioData StudioCharts that read the same numbers.
BigQueryBigQueryA warehouse table for the same columns.
ClickHouseClickHousePush rows into ClickHouse over HTTPS with an API key.
AWS S3AWS S3Write report files to your S3 bucket with IAM access keys.
Amazon RedshiftAmazon RedshiftLoad rows into Redshift via the Data API with IAM keys.
FireboltFireboltPush rows into Firebolt over HTTPS with a Service Account.
PostgreSQLPostgreSQLWrite report rows into PostgreSQL with database credentials.
MySQLMySQLWrite report rows into MySQL with database credentials.
SnowflakeSnowflakePush rows into Snowflake over HTTPS with a PAT token.
Databricks SQLDatabricks SQLLoad rows into Databricks SQL with a Personal Access Token.
Cloudflare R2Cloudflare R2Write report files to your R2 bucket with access keys.
Excel / CSVExcel / CSVA Drive file you can open in Excel.
ClaudeClaudeAsk Claude about these numbers in a sentence.
ChatGPTChatGPTAsk ChatGPT about these numbers in a sentence.
APIAPIRead the same rows from your own tool.
Don't see yours? Use CSV or APIDownload the rows, or read them from your own tool.

Connect Jotform to ChatGPT or Claude for form questions

Use Datapipe’s MCP access as your Jotform reporting tool. Ask about submissions, answers and unread entries.

Example

How many intake forms came in each day last week, and how many are still unread?

Count last week’s submissions to the intake form by day, and list the ones still marked unread with their submission time.

Start with Jotform

What you need

A Jotform API key with Read Access from My Account, API, and your data location. Then pick a form from the list, or all of them.

What to know

Read-only. Jotform limits daily requests by plan. Up to 20,000 rows per report.

How it works

  1. Create your free account, then choose Jotform in Data sources.

  2. Paste your Jotform key, choose your data location and pick a form, or all of them.

  3. Choose forms, submissions or answers and a destination: a sheet, Data Studio, ChatGPT or Claude.

Works well with Jotform

Add both to the same project. Each keeps its own report, so you can check them side by side or ask ChatGPT or Claude a question that needs both.

Questions

Forms with submission counts, submissions with status and flags, and every answer as its own row.

Yes. Choose your data location when you add Jotform.

No. It only reads forms and submissions.

US Eastern time, as Jotform records them.

Free to start. Paid plans add more data sources and refresh faster.

Free and Starter refresh once a day. Pro refreshes every hour. Agency refreshes every 15 minutes on the first 50 data sources.

One for each Jotform account you add to a project. Adding the same account to another project counts again. Reports and destinations do not use extra data sources.

Put every submission to work.

Start free, add Jotform and bring submissions into the tools you already use.

Start free See setup requirements