Beacon WhatsApp to Google Sheets Workflow

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 →

{
  "name": "H4K \u2014 Flow A: Ingest WA \u2192 Sheets",
  "nodes": [
    {
      "parameters": {
        "events": [
          "GroupMessageReceived"
        ]
      },
      "id": "node-01",
      "name": "Watch Source Group",
      "type": "@beacon/n8n-nodes-beacon.beaconTrigger",
      "typeVersion": 1,
      "position": [
        0,
        0
      ],
      "credentials": {
        "beaconOAuth2Api": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "conditions": {
          "options": {
            "caseSensitive": true
          },
          "conditions": [
            {
              "leftValue": "={{ $json.data.chatId }}",
              "rightValue": "120363187571838264@g.us",
              "operator": {
                "type": "string",
                "operation": "equals"
              }
            }
          ]
        }
      },
      "id": "node-02",
      "name": "Is Source Group?",
      "type": "n8n-nodes-base.if",
      "typeVersion": 2,
      "position": [
        220,
        0
      ]
    },
    {
      "parameters": {
        "conditions": {
          "options": {
            "caseSensitive": true
          },
          "conditions": [
            {
              "leftValue": "={{ $json.data.hasMedia }}",
              "rightValue": true,
              "operator": {
                "type": "boolean",
                "operation": "true"
              }
            }
          ]
        }
      },
      "id": "node-03",
      "name": "Has Media?",
      "type": "n8n-nodes-base.if",
      "typeVersion": 2,
      "position": [
        440,
        -100
      ]
    },
    {
      "parameters": {
        "resource": "message",
        "operation": "getMedia",
        "mediaId": "={{ $json.data.media.mediaId }}"
      },
      "id": "node-04",
      "name": "Get Media from Beacon",
      "type": "@beacon/n8n-nodes-beacon.beacon",
      "typeVersion": 1,
      "position": [
        660,
        -220
      ],
      "credentials": {
        "beaconOAuth2Api": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "method": "POST",
        "url": "https://api.cloudinary.com/v1_1/dpu4rviqw/auto/upload",
        "authentication": "none",
        "sendBody": true,
        "contentType": "multipart-form-data",
        "bodyParameters": {
          "parameters": [
            {
              "parameterType": "formBinaryData",
              "name": "file",
              "inputDataFieldName": "data"
            },
            {
              "name": "upload_preset",
              "value": "h4k_upload"
            },
            {
              "name": "tags",
              "value": "h4k_temp"
            },
            {
              "name": "folder",
              "value": "h4k"
            }
          ]
        },
        "options": {}
      },
      "id": "node-05",
      "name": "Upload to Cloudinary",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [
        880,
        -220
      ]
    },
    {
      "parameters": {
        "jsCode": "const msg = $('Has Media?').item.json.data;\nconst cl = $input.item.json;\nconst id = new Date(msg.timestamp).toISOString();\nreturn {\n  json: {\n    id,\n    content: msg.body || msg.caption || '',\n    media_url: cl.secure_url || '',\n    cloudinary_id: cl.public_id || '',\n    scheduled_at: '',\n    status: 'inbox',\n    target_groups: 'ALL',\n    sent_at: ''\n  }\n};"
      },
      "id": "node-06",
      "name": "Prepare Row \u2014 With Media",
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [
        1100,
        -220
      ]
    },
    {
      "parameters": {
        "operation": "append",
        "documentId": {
          "__rl": true,
          "value": "12WESjeS-G5yitJIPehxnjs3dvjBdHmb0R-vtvSu0W-8",
          "mode": "list",
          "cachedResultName": "H4K Scheduler"
        },
        "sheetName": {
          "__rl": true,
          "value": "posts",
          "mode": "name"
        },
        "columns": {
          "mappingMode": "autoMapInputData",
          "value": {},
          "schema": []
        },
        "options": {}
      },
      "id": "node-07",
      "name": "Add to Inbox \u2014 With Media",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.5,
      "position": [
        1320,
        -220
      ],
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "jsCode": "const d = $input.item.json.data;\nconst id = new Date(d.timestamp).toISOString();\nreturn {\n  json: {\n    id,\n    content: d.body || '',\n    media_url: '',\n    cloudinary_id: '',\n    scheduled_at: '',\n    status: 'inbox',\n    target_groups: 'ALL',\n    sent_at: ''\n  }\n};"
      },
      "id": "node-08",
      "name": "Prepare Row \u2014 Text Only",
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [
        660,
        60
      ]
    },
    {
      "parameters": {
        "operation": "append",
        "documentId": {
          "__rl": true,
          "value": "12WESjeS-G5yitJIPehxnjs3dvjBdHmb0R-vtvSu0W-8",
          "mode": "list",
          "cachedResultName": "H4K Scheduler"
        },
        "sheetName": {
          "__rl": true,
          "value": "posts",
          "mode": "name"
        },
        "columns": {
          "mappingMode": "autoMapInputData",
          "value": {},
          "schema": []
        },
        "options": {}
      },
      "id": "node-09",
      "name": "Add to Inbox \u2014 Text Only",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.5,
      "position": [
        880,
        60
      ],
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      }
    }
  ],
  "connections": {
    "Watch Source Group": {
      "main": [
        [
          {
            "node": "Is Source Group?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Is Source Group?": {
      "main": [
        [
          {
            "node": "Has Media?",
            "type": "main",
            "index": 0
          }
        ],
        []
      ]
    },
    "Has Media?": {
      "main": [
        [
          {
            "node": "Get Media from Beacon",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Prepare Row \u2014 Text Only",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Media from Beacon": {
      "main": [
        [
          {
            "node": "Upload to Cloudinary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Upload to Cloudinary": {
      "main": [
        [
          {
            "node": "Prepare Row \u2014 With Media",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Row \u2014 With Media": {
      "main": [
        [
          {
            "node": "Add to Inbox \u2014 With Media",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Row \u2014 Text Only": {
      "main": [
        [
          {
            "node": "Add to Inbox \u2014 Text Only",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "executionOrder": "v1"
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

• beaconOAuth2Api
• googleSheetsOAuth2Api

About this workflow

H4K — Flow A: Ingest WA → Sheets. Uses @beacon/n8n-nodes-beacon, httpRequest, googleSheets. Event-driven trigger; 9 nodes.

Source: https://github.com/hamal4kids/h4k-scheduler2.0/blob/42cdd7b197635e0550731193bae7cff01440c0b3/n8n-workflows/1-ingest.json — 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.