Jotform
Your Jotform form submissions: one column per question, or counts per day, per answer, per status.
The Jotform connector brings your form submissions into the sheet: individual submissions with one column per question, or aggregated counts (submissions per day, per answer given to a question, per status).
The connection does not use a Google login: you enter a Jotform API Key, created from My Account > API > Create New Key (jotform.com/myaccount/api). Read Only permission is enough: the connector only reads. The key is verified immediately and works for accounts on the global, EU and HIPAA data centers (the connector detects which one to use).
In the report you pick the form as the "property": that form's questions automatically appear among the dimensions ("Q: ..." entries), with the value already formatted by Jotform for composite fields (full name, address, date, matrices, multiple choices).
Available metrics
| Metric | Period | Aggregation | Note |
|---|---|---|---|
| Submissions | period | sum | Number of submissions in the period. |
| Unread Submissions | period | sum | How many submissions are still marked as new (unread) in Jotform. |
| Flagged Submissions | period | sum | How many submissions are flagged in Jotform. |
Available dimensions
| Dimension | Note |
|---|---|
| Date (Submitted) | Submission date as returned by the Jotform API (no timezone conversion). On its own it yields submissions per day. |
| Created At | Full submission date and time, API format "YYYY-MM-DD HH:MM:SS". |
| Updated At | Date and time of the last edit of the submission (empty if never edited). |
| Submission ID | Add it to get one row per individual submission. |
| Form ID | |
| Form Title | |
| Status | Submission status in Jotform (e.g. ACTIVE). |
| IP Address | Respondent IP recorded by Jotform. |
| Is Unread | "true"/"false": the submission is still marked as new (unread) in Jotform. |
| Is Flagged | "true"/"false": the submission is flagged in Jotform. |
| Q: <question> (one per form question) | One dimension per question of the selected form, named after the question text. The value is the one formatted by Jotform (e.g. full name, address, date, multiple answers comma separated). Fields without an answer (headings, buttons, page breaks, texts) do not appear. |
Known limits
- Daily API call quotaJotform limits API calls per day by plan (Starter 1,000, Bronze 10,000, Silver 50,000, Gold 100,000). A report uses 2 calls plus one per 1,000 submissions: with frequent scheduled reports or very large forms the Starter quota can be reached, and Jotform returns an error until the next day.
- Times without timezone (Jotform server time)created_at/updated_at come from the API without timezone and, according to Jotform support, are in their server time (US Eastern), not your account's: close to midnight a submission can fall on a different day than in Jotform's Submissions page. The connector does not convert, to stay consistent with the period filter that uses the same format.
- No visit or completion analyticsJotform's public API does not expose form analytics (views, conversion rate, drop-offs): only actual submissions are available. That is why the connector has a single category, "submissions".
- Max 50,000 submissions per reportThe connector downloads at most 50,000 submissions per single report (50 pages of 1,000): narrow the period for larger forms. Deleted forms do not appear in the list, disabled ones appear with the "(disabled)" suffix.
Execution notes
The report period filters submissions by submission date (created_at). Rows are aggregated by the dimensions you choose: with only "Date (Submitted)" you get submissions per day, adding "Submission ID" you get one row per submission with one column per selected question.
Dates and times are shown exactly as returned by the Jotform API, i.e. without timezone: according to Jotform support this is their server time (US Eastern), independent of the timezone set in your account. The connector does not convert anything, so the period filter and the dates in the sheet are consistent with each other, but they can differ by a few hours from what you see in Jotform's Submissions page (which uses your account timezone).
Jotform applies a daily API call quota per plan (Starter 1,000, Bronze 10,000, Silver 50,000, Gold 100,000 per day): each run uses 2 fixed calls (form details and questions) plus one per block of 1,000 submissions. Past the quota, Jotform returns an explicit error until the next day.