Automate Jotform Submissions to Google Sheets

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

{
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "8ec873d2-615b-4f5d-8dbd-fd8707a35e64",
      "name": "get all submissions",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -272,
        -32
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "ad59d4c5-e709-49a9-93a5-ca8dd023f0ac",
      "name": "When clicking \u2018Execute workflow\u2019",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -528,
        -32
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "ab335e18-901d-4733-8c61-595f05ede02c",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        288,
        -32
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "9d4c6804-440a-4a6c-aabd-f51bbd071751",
      "name": "No Operation, do nothing",
      "type": "n8n-nodes-base.noOp",
      "position": [
        832,
        -288
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e409f00f-02b1-4a87-8553-13909cc8da23",
      "name": "Append row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        976,
        16
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "e2b900db-b9eb-45e8-9e59-a8e258d03c59",
      "name": "Code",
      "type": "n8n-nodes-base.code",
      "position": [
        -64,
        -32
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "51639a36-6d3f-4437-a6fd-c16f96b5c255",
      "name": "Wait",
      "type": "n8n-nodes-base.wait",
      "position": [
        640,
        0
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "d4b9f5d5-625f-4635-ad96-b1e78d4a9569",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -352,
        -112
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e7149bdd-2981-4de6-840a-71fec52e8b2a",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -96,
        -112
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "311426d1-5c9e-43ab-8f6a-7dd5c849309f",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        928,
        -64
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fc1f4b5b-a491-41cc-bfd8-d9aeafad891c",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        224,
        -352
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "8e6ab364-5d2c-4e99-b9f1-af26815e3c03",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        544,
        -64
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "connections": {
    "Code": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait": {
      "main": [
        [
          {
            "node": "Append row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [
          {
            "node": "No Operation, do nothing",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Wait",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append row in sheet": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "get all submissions": {
      "main": [
        [
          {
            "node": "Code",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking \u2018Execute workflow\u2019": {
      "main": [
        [
          {
            "node": "get all submissions",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

About this workflow

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. Connecting to an API Parsing the response Looping through results Sending processed data to another app Manual…

Source: https://n8n.io/workflows/7263/ — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.