This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.
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.
beaconOAuth2ApigoogleSheetsOAuth2Api
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
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 →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
TrackCollect_deeper. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, itemLists. Event-driven trigger; 80 nodes.
This template is ideal for solo store owners, eCommerce marketers, automation beginners, or anyone using Shopify and Gmail who wants to recover lost revenue without coding.
PCN. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, itemLists. Event-driven trigger; 60 nodes.
Product Ad Machine. Uses googleDrive, googleSheets, httpRequest, @ffmpeg-micro/n8n-nodes-ffmpeg-micro. Event-driven trigger; 60 nodes.
Basic AI SEO KW Research n8n DataForSEO Gumroad 030125. Uses googleSheets, googleDrive, httpRequest. Event-driven trigger; 56 nodes.