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": "broadcasting",
"nodes": [
{
"parameters": {},
"type": "n8n-nodes-base.manualTrigger",
"typeVersion": 1,
"position": [
-580,
-100
],
"id": "9daaa778-f3bc-4dfa-a1fa-ab8f10ab3709",
"name": "When clicking \u2018Execute workflow\u2019"
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "1zDl6cpaZg0kS_f8G5LCbI6m0RMRHWcJZ9839JHWw8FQ",
"mode": "list",
"cachedResultName": "Broadcast",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1zDl6cpaZg0kS_f8G5LCbI6m0RMRHWcJZ9839JHWw8FQ/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "data broadcast",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1zDl6cpaZg0kS_f8G5LCbI6m0RMRHWcJZ9839JHWw8FQ/edit#gid=0"
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.6,
"position": [
-240,
-100
],
"id": "106e5910-6fbe-4651-a5db-3043179307ce",
"name": "Get row(s) in sheet",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"method": "POST",
"url": "https://webhook.site/88f29ec4-69ad-4d37-8bdd-15747d244468",
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "apikey",
"value": "8KIOY5MsxZF6m71UJq1750242449537"
},
{
"name": "receiver",
"value": "={{ $json['no whatsapp'] }}"
},
{
"name": "mtype",
"value": "text"
},
{
"name": "text",
"value": "={{ $json['isi pesan'] }}"
},
{
"name": "readmessage",
"value": "yes"
},
{
"name": "id",
"value": "0B37DE10241D7DAE4CCE6F4F4CB74337"
},
{
"name": "duration",
"value": "3000"
}
]
},
"options": {
"redirect": {
"redirect": {}
}
}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
500,
-80
],
"id": "8c8a740a-8536-48c2-b61d-d7c7be2226c4",
"name": "HTTP Request"
},
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
80,
-100
],
"id": "62b23ca5-867b-44ac-a000-2e907030e1e9",
"name": "Loop Over Items"
},
{
"parameters": {
"amount": "={{[3, 4, 5, 6][Math.floor(Math.random() * 4)]}}\n"
},
"type": "n8n-nodes-base.wait",
"typeVersion": 1.1,
"position": [
900,
-80
],
"id": "50f6b11f-10ab-4117-b44d-b5bac21cec91",
"name": "Wait"
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"value": "1zDl6cpaZg0kS_f8G5LCbI6m0RMRHWcJZ9839JHWw8FQ",
"mode": "list",
"cachedResultName": "Broadcast",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1zDl6cpaZg0kS_f8G5LCbI6m0RMRHWcJZ9839JHWw8FQ/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "data broadcast",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1zDl6cpaZg0kS_f8G5LCbI6m0RMRHWcJZ9839JHWw8FQ/edit#gid=0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"status": "={{ $('HTTP Request').item.json.data }}",
"no whatsapp": "={{ $('Get row(s) in sheet').item.json['no whatsapp'] }}"
},
"matchingColumns": [
"no whatsapp"
],
"schema": [
{
"id": "nama",
"displayName": "nama",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "no whatsapp",
"displayName": "no whatsapp",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "isi pesan",
"displayName": "isi pesan",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "status",
"displayName": "status",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "row_number",
"displayName": "row_number",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"readOnly": true,
"removed": true
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.6,
"position": [
1300,
-80
],
"id": "ee75e08f-16df-4bec-8ee2-2f3ea6f89c94",
"name": "Update row in sheet",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"content": "### Kode Javascript Waktu Random number\n{{[3, 4, 5, 6][Math.floor(Math.random() * 4)]}}\n\nNumber bisa isi bebas\n",
"height": 220,
"width": 360
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
720,
-160
],
"id": "18dd565d-70ac-4cfb-8a62-e45d934ff883",
"name": "Sticky Note"
},
{
"parameters": {
"content": "### Sheet untuk mengisi Status\nambil drag n drop dari nodes sebelumnya\n",
"height": 220,
"width": 360
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
1100,
-160
],
"id": "55d16438-a8ab-4576-9266-82a635cc53a3",
"name": "Sticky Note1"
},
{
"parameters": {
"content": "### loop isi default",
"height": 220,
"width": 200
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
40,
-160
],
"id": "b037fae4-ed6d-48ac-91a9-ff2e2403007c",
"name": "Sticky Note2"
},
{
"parameters": {
"content": "### http request\nisi sesuai whatsapp gateway masing masing",
"height": 220,
"width": 360
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
320,
-160
],
"id": "666694e7-ab38-4de6-993e-8be3c2766c9f",
"name": "Sticky Note3"
},
{
"parameters": {
"content": "## Tutorial lengkap cara membuat bisa lihat di sini :\n### [TIKTOK](https://www.tiktok.com/@hardi.digitalsantuy/video/7524996791452847376?lang=en) \n### [YOUTUBE](https://www.youtube.com/watch?v=rdD-_x4_M98)",
"width": 440,
"color": 4
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-500,
-320
],
"id": "0e79f0fb-af4e-4dd9-bcc6-bb191f61e309",
"name": "Sticky Note4"
}
],
"connections": {
"When clicking \u2018Execute workflow\u2019": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "Update row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Update row in sheet": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "95ce0b7a-4b64-4f5d-9e9f-eafc68b2f3e4",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "p48gdyZkoYLqCNwW",
"tags": []
}
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.
googleSheetsOAuth2Api
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
broadcasting. Uses googleSheets, httpRequest. Event-driven trigger; 11 nodes.
Source: https://github.com/hardisastra/File-Projek-Json-n8n/blob/main/Broadcast_WhatsApp_AMAN_dari_BANNED.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.
Weather Bot - Main Handler. Uses telegramTrigger, googleSheets, telegram, httpRequest. Event-driven trigger; 65 nodes.
This n8n workflow automates the process of scraping Google Play Store reviews, analyzing app performance, and sending alerts for low-rated applications. It integrates with Bright Data for web scraping
⚠️ Heads up: this is satire. The "Hell Yeah!" workflow is a parody of "automate your whole life with AI agents" grindset content. The API endpoints are fictional and the function nodes are illustrativ
This workflow tracks a configurable crypto watchlist using the CoinGecko API, sends Telegram alerts when price, % change, or volume-spike conditions are met (with optional RSI filtering), optionally l
This n8n workflow provides automated monitoring of Public Key Infrastructure (PKI) components including CA certificates, Certificate Revocation Lists (CRLs), and associated web services. It extracts c