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": "FireReach \u2014 Always-On SDR Workflow",
"nodes": [
{
"parameters": {
"rule": {
"interval": [
{
"field": "hours",
"hoursInterval": 24
}
]
}
},
"id": "cron-trigger",
"name": "Daily Scan Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.1,
"position": [
200,
300
]
},
{
"parameters": {
"url": "https://news.google.com/rss/search?q=series+b+funding+tech+startup&hl=en-US&gl=US&ceid=US:en",
"options": {}
},
"id": "rss-node",
"name": "Google Alerts RSS",
"type": "n8n-nodes-base.rssFeedRead",
"typeVersion": 1,
"position": [
420,
300
]
},
{
"parameters": {
"jsCode": "// ICP Scoring Engine\n// Runs before firing the outreach API \u2014 only high-fit companies proceed.\nconst items = $input.all();\nconst scored = [];\n\nfor (const item of items) {\n const title = (item.json.title || '').toLowerCase();\n const content = (item.json.content || '').toLowerCase();\n const text = title + ' ' + content;\n\n let score = 0;\n const reasons = [];\n\n // Funding signal\n if (/series b/.test(text)) { score += 4; reasons.push('Series B funding'); }\n else if (/series [ac]/.test(text)) { score += 2; reasons.push('Funding round'); }\n\n // Hiring signal (proxy: job board mentions)\n if (/hiring|we.re growing|join our team/.test(text)) { score += 3; reasons.push('Active hiring'); }\n\n // Security angle\n if (/security|compliance|infra|soc 2|gdpr|devops/.test(text)) { score += 2; reasons.push('Security relevance'); }\n\n // Recent growth\n if (/expand|launch|acquire|partnership/.test(text)) { score += 1; reasons.push('Growth signal'); }\n\n const label = score >= 8 ? 'High Fit' : score >= 5 ? 'Good Fit' : 'Low Fit';\n\n scored.push({\n json: {\n ...item.json,\n icp_score: score,\n icp_label: label,\n icp_reasons: reasons,\n proceed: score >= 5\n }\n });\n}\n\nreturn scored;"
},
"id": "icp-scorer",
"name": "ICP Scoring Engine",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
640,
300
]
},
{
"parameters": {
"conditions": {
"boolean": [
{
"value1": "={{ $json.proceed }}",
"value2": true
}
]
}
},
"id": "icp-filter",
"name": "Filter: Score >= 5",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
860,
300
]
},
{
"parameters": {
"url": "={{ $env.FIREREACH_API_URL }}/run-outreach",
"authentication": "none",
"method": "POST",
"sendBody": true,
"contentType": "json",
"jsonBody": "={\n \"company_name\": \"{{ $json.title.split(' ')[0] }}\",\n \"company_domain\": \"example.com\",\n \"icp_description\": \"{{ $env.DEFAULT_ICP }}\",\n \"tone\": \"consultative\"\n}",
"options": {}
},
"id": "firereach-trigger",
"name": "Fire FireReach API",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
1080,
200
]
},
{
"parameters": {
"amount": 5,
"unit": "seconds"
},
"id": "wait-node",
"name": "Wait 5s",
"type": "n8n-nodes-base.wait",
"typeVersion": 1.1,
"position": [
1300,
200
]
},
{
"parameters": {
"url": "={{ $env.FIREREACH_API_URL }}/status/{{ $('Fire FireReach API').item.json.job_id }}",
"options": {}
},
"id": "poll-status",
"name": "Poll Job Status",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
1500,
200
]
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.job.status }}",
"operation": "equals",
"value2": "done"
}
]
}
},
"id": "done-check",
"name": "Job Done?",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
1700,
200
]
},
{
"parameters": {
"chatId": "={{ $env.TELEGRAM_CHAT_ID }}",
"text": "=\u2705 FireReach sent email!\nJob: {{ $('Fire FireReach API').item.json.job_id }}\nSignals: {{ $json.job.icp_label ?? 'N/A' }}",
"additionalFields": {}
},
"id": "telegram-notify",
"name": "Telegram Notification",
"type": "n8n-nodes-base.telegram",
"typeVersion": 1.2,
"position": [
1900,
140
]
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "={{ $env.SHEETS_DOC_ID }}",
"mode": "id"
},
"sheetName": "Outreach Log",
"columns": {
"mappingMode": "autoMapInputData",
"value": {}
},
"options": {}
},
"id": "sheets-log",
"name": "Log to Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.3,
"position": [
1900,
280
]
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "={{ $env.SHEETS_DOC_ID }}",
"mode": "id"
},
"sheetName": "Skipped",
"columns": {
"mappingMode": "autoMapInputData",
"value": {}
}
},
"id": "log-skipped",
"name": "Log Skipped (Low ICP)",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.3,
"position": [
1080,
420
]
}
],
"connections": {
"Daily Scan Trigger": {
"main": [
[
{
"node": "Google Alerts RSS",
"type": "main",
"index": 0
}
]
]
},
"Google Alerts RSS": {
"main": [
[
{
"node": "ICP Scoring Engine",
"type": "main",
"index": 0
}
]
]
},
"ICP Scoring Engine": {
"main": [
[
{
"node": "Filter: Score >= 5",
"type": "main",
"index": 0
}
]
]
},
"Filter: Score >= 5": {
"main": [
[
{
"node": "Fire FireReach API",
"type": "main",
"index": 0
}
],
[
{
"node": "Log Skipped (Low ICP)",
"type": "main",
"index": 0
}
]
]
},
"Fire FireReach API": {
"main": [
[
{
"node": "Wait 5s",
"type": "main",
"index": 0
}
]
]
},
"Wait 5s": {
"main": [
[
{
"node": "Poll Job Status",
"type": "main",
"index": 0
}
]
]
},
"Poll Job Status": {
"main": [
[
{
"node": "Job Done?",
"type": "main",
"index": 0
}
]
]
},
"Job Done?": {
"main": [
[
{
"node": "Telegram Notification",
"type": "main",
"index": 0
},
{
"node": "Log to Google Sheets",
"type": "main",
"index": 0
}
],
[
{
"node": "Wait 5s",
"type": "main",
"index": 0
}
]
]
}
},
"settings": {
"executionOrder": "v1"
},
"versionId": "firereach-v2"
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
FireReach — Always-On SDR Workflow. Uses rssFeedRead, httpRequest, telegram, googleSheets. Scheduled trigger; 11 nodes.
Source: https://github.com/Bhuvangoyal466/Fire-Reach/blob/475683fa36e781cd002dd1d8f7b63ae4879f48e5/n8n/workflow-export.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.
GNCA AI News Pipeline. Uses rssFeedRead, httpRequest, telegram, errorTrigger. Scheduled trigger; 29 nodes.
This workflow automates plant care reminders and records using Google Sheets, Telegram, and OpenWeather API.
Apollo Data Enrichment Using Company Id to automatically finds contacts for companies listed in your Google Sheet, enriches each person with emails and phone numbers via Apollo’s API, and writes verif
++Download the google sheet here++ and replace this with the googles sheet node: Google sheet , upload to google sheets and replace in the google sheets node. Scheduled trigger: Runs once a day at 8 A
YT AI News Playlist Creator/AI News Form Updater. Uses googleSheets, httpRequest, splitOut, stickyNote. Scheduled trigger; 23 nodes.