This workflow follows the HTTP Request → Notion 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": "Ingest Metrics",
"nodes": [
{
"parameters": {},
"id": "3b4af3f3-ab4d-46b8-bc2a-dfd03e0113aa",
"name": "Cron",
"type": "n8n-nodes-base.cron",
"typeVersion": 1,
"position": [
-304,
208
]
},
{
"parameters": {
"url": "https://mockapi.io/projects/ads-metrics",
"options": {}
},
"id": "fa1b535e-e6b0-4601-8c6e-92e692e9cbca",
"name": "HTTP Request Mock",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4,
"position": [
96,
96
]
},
{
"parameters": {
"url": "https://onebytecode.io/projects/google-ads",
"options": {}
},
"id": "7029a268-9d48-4898-973f-4774457d0589",
"name": "HTTP Request Real",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4,
"position": [
96,
304
]
},
{
"parameters": {
"mode": "combine",
"mergeByFields": {
"values": [
{}
]
},
"options": {}
},
"id": "6485c6d4-7c37-4cad-a7c0-accd1a73be30",
"name": "Merge Results",
"type": "n8n-nodes-base.merge",
"typeVersion": 2,
"position": [
304,
208
]
},
{
"parameters": {
"functionCode": "return items.map(item => {\n const d = item.json;\n return {\n json: {\n date: d.date || new Date().toISOString().split('T')[0],\n platform: d.platform || 'mock',\n account_id: d.account_id || 'acc1',\n campaign_id: d.campaign_id || 'camp1',\n campaign_name: d.campaign_name || 'Campaign X',\n spend: d.spend || 0,\n impressions: d.impressions || 0,\n clicks: d.clicks || 0,\n conversions: d.conversions || 0,\n cpl: d.clicks ? d.spend/d.clicks : null,\n roas: d.conversions ? (d.revenue||0)/d.spend : null\n }\n };\n});"
},
"id": "b4ad1cb6-f51d-4a73-8d5c-821a44b46125",
"name": "Function Normalize",
"type": "n8n-nodes-base.function",
"typeVersion": 1,
"position": [
496,
208
]
},
{
"parameters": {
"resource": "databasePage",
"databaseId": "YOUR_NOTION_DB_ID",
"options": {}
},
"id": "5456a639-dfe2-4f6b-b7fe-58283c129507",
"name": "Notion",
"type": "n8n-nodes-base.notion",
"typeVersion": 2,
"position": [
704,
96
],
"credentials": {
"notionApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"tableId": "campaign_metrics"
},
"type": "n8n-nodes-base.supabase",
"typeVersion": 1,
"position": [
704,
288
],
"id": "ea428e91-6513-461d-ba64-0ce40ff5294e",
"name": "Insert",
"credentials": {
"supabaseApi": {
"name": "<your credential>"
}
}
}
],
"connections": {
"Cron": {
"main": [
[
{
"node": "HTTP Request Mock",
"type": "main",
"index": 0
},
{
"node": "HTTP Request Real",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request Mock": {
"main": [
[
{
"node": "Merge Results",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request Real": {
"main": [
[
{
"node": "Merge Results",
"type": "main",
"index": 1
}
]
]
},
"Merge Results": {
"main": [
[
{
"node": "Function Normalize",
"type": "main",
"index": 0
}
]
]
},
"Function Normalize": {
"main": [
[
{
"node": "Notion",
"type": "main",
"index": 0
},
{
"node": "Insert",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "f0d75103-27bd-49f5-9b06-2e54976e165e",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "wV4CS298JOZbosrb",
"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.
notionApisupabaseApi
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Ingest Metrics. Uses httpRequest, notion, supabase. Scheduled trigger; 7 nodes.
Source: https://github.com/Paulinho19/ad-optimization-agent/blob/c4357bc957f05fd90c20e1c7506433e041b126fe/workflows/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.
This workflow solves a common problem with RSS feeds: they often only provide a short summary or snippet of the full article. This template automatically monitors a list of your favorite blog RSS feed
This workflow is a multi-system document synchronization pipeline built in n8n, designed to automatically sync and back up files between Microsoft SharePoint, Supabase/Postgres, and Google Drive.
This enables webhooks for nearly realtime updates (every 5 seconds) from Notion Databases.
Syncs assignments and completion states to and fro between Canvas LMS and a Notion database. Automatically triggers every 2 hours during the schoolday by default (meaning 7 times a day), but also supp
03 - Recordatorio 4h (CON VERIFICACIÓN) ✅. Uses supabase, httpRequest, twilio. Scheduled trigger; 17 nodes.