n8n recipe · leads

Jotform → Google Sheets → Twilio

A Jotform submission is logged in Google Sheets and you get a text message (Twilio).

잡폼 신청이 오면 구글 시트에 적고 내 휴대폰으로 문자(트윌리오)를 보내요.

Steps

  1. When when a jotform is submitted — Jotform node
  2. Then add a row to google sheets — Google Sheets node
  3. Then text me with twilio — Twilio node

Fields to fill (7)

The file has every node wired up. These are the blanks only you can fill (your form, your sheet, your words).

NodeWhat to do
Jotformfill form (Choose from the list, or specify an ID using an expression)
Google Sheetsfill documentId (Document)
Google Sheetsfill sheetName (Sheet)
Google Sheetsfill columns (Columns)
Twiliofill from (The number from which to send the message)
Twiliofill to (The number to which to send the message)
Twiliofill message (The message to send)

Accounts to connect (3)

In n8n, pick or add a credential on each node — one of the types below.

Get the n8n file

Download jotform-to-sheets-and-sms.json

  1. Open a new, empty workflow in n8n.
  2. Open the workflow menu (⋯) and choose Import from File — or copy the JSON below and paste it onto the canvas (Ctrl/Cmd+V).
  3. Connect the accounts, fill the fields above, run one test, then turn the workflow on.
Or copy the JSON 
{
  "name": "A Jotform submission is logged in Google Sheets and you get a text message (Twilio)",
  "nodes": [
    {
      "id": "n1",
      "name": "Jotform Trigger",
      "type": "n8n-nodes-base.jotFormTrigger",
      "typeVersion": 1,
      "parameters": {
        "form": ""
      },
      "position": [
        240,
        300
      ],
      "notes": "step: when a jotform is submitted"
    },
    {
      "id": "n2",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.7,
      "parameters": {
        "resource": "sheet",
        "operation": "append",
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "columns": {
          "mappingMode": "autoMapInputData",
          "value": {},
          "matchingColumns": [],
          "schema": []
        }
      },
      "position": [
        460,
        300
      ],
      "notes": "step: add a row to google sheets"
    },
    {
      "id": "n3",
      "name": "Twilio",
      "type": "n8n-nodes-base.twilio",
      "typeVersion": 1,
      "parameters": {
        "resource": "sms",
        "operation": "send",
        "from": "",
        "to": "",
        "message": ""
      },
      "position": [
        680,
        300
      ],
      "notes": "step: text me with twilio"
    }
  ],
  "connections": {
    "Jotform Trigger": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets": {
      "main": [
        [
          {
            "node": "Twilio",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "executionOrder": "v1"
  },
  "active": false
}