Automate JotForm Submissions to Google Sheets

This workflow is a simple example showing how to fetch submissions from JotForm using its API and then use that data in another service — in this case, Google Sheets.

It demonstrates the basics of:

• Connecting to an API

• Parsing the response

• Looping through results

• Sending processed data to another app

How It Works

1. Manual Trigger
   Starts the workflow manually.
   (Can be replaced with a schedule or webhook trigger for automation.)

2. HTTP Request – Get Submissions from JotForm
   Fetches all submissions for a specific form from the JotForm API.

3. Code Node – Parse API Response
   Converts the API’s JSON response into individual submission items.

4. Split In Batches – Loop Through Each Submission
   Processes submissions one at a time to avoid hitting API rate limits.

5. Wait Node
   Adds a short delay before sending data to the next API.

6. Google Sheets – Append Submission Data
   Sends the selected fields from each JotForm submission into a Google Sheet:

Adaptations

You can modify this workflow to:

Send JotForm results to CRM systems like HubSpot or Pipedrive

Trigger email or Slack notifications for each new submission

Store submissions in a database for reporting and analytics