Amanda Benks This workflow corresponds to n8n.io template #3695 — we link there as the canonical source.
This workflow follows the Gmail → Google Sheets 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 →
{
"id": "vldHu7W6Cn8Sr2lx",
"name": "[template] Balance Query Ad Account Meta Ads Facebook",
"tags": [
{
"id": "8qq9RCjmrYPp5OrN",
"name": "iloveflows.gumroad.com",
"createdAt": "2025-04-24T15:21:54.942Z",
"updatedAt": "2025-04-24T15:21:54.942Z"
}
],
"nodes": [
{
"id": "49243dc3-1a74-42a3-aba9-c5c7eb47ee14",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-680,
140
],
"parameters": {},
"typeVersion": 3
},
{
"id": "b5dc3e8c-39a7-400c-a771-6bdd2ff7a2d8",
"name": "Replace Me",
"type": "n8n-nodes-base.noOp",
"position": [
760,
400
],
"parameters": {},
"typeVersion": 1
},
{
"id": "118a9f13-4a19-443f-aa75-86e0a6c78419",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "8cbcab56-9076-43ab-93d9-ae4e7f482a22",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
280
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "65bd7b3a-11a2-482d-b921-5f67bb756991",
"name": "Meta Ads",
"type": "n8n-nodes-base.httpRequest",
"position": [
-420,
160
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "856b9016-7446-4c49-8d77-412e41af759b",
"name": "Google Sheets1",
"type": "n8n-nodes-base.googleSheets",
"position": [
180,
380
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "55836782-a099-47ab-9287-e20a19263f5c",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
180,
100
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "ecda28a6-b3e5-4df4-b4bd-4d37d55c398f",
"name": "Gmail",
"type": "n8n-nodes-base.gmail",
"disabled": true,
"position": [
460,
100
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "75cad775-4426-4ca0-9af6-c682f937f1ab",
"name": "Gmail1",
"type": "n8n-nodes-base.gmail",
"disabled": true,
"position": [
460,
380
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "a51ad7e9-6153-413c-82ee-ab78292b7a75",
"name": "Wait",
"type": "n8n-nodes-base.wait",
"position": [
900,
400
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "f23e8e16-e37a-4c62-a520-51695b6cb428",
"name": "Start by Period",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1240,
60
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "783919d6-9506-4503-b5df-0011833d4922",
"name": "Start by Click",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1240,
200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6a653c6d-4d95-417d-a45d-9c03b1b914db",
"name": "Mapping",
"type": "n8n-nodes-base.set",
"position": [
-1060,
180
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "81aaf607-5e0f-4cb1-93da-d3446d65db1a",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1100,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "50fe6a9c-757a-45a5-84ed-3e0ba3392573",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1280,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2c6f8109-7351-4839-8bf6-1557b698bc48",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-920,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "349b66d2-c49a-4480-a9fd-1fc766bafd0e",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-920,
300
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "bb34806d-60c9-4517-bd76-a8f9dde03b22",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-460,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fc10439c-4a76-4e49-ac14-dd6937f8b911",
"name": "Is it Prepaid?",
"type": "n8n-nodes-base.if",
"position": [
-240,
160
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "eee052e9-80a5-4b54-a454-f6763897977d",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-280,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "86a1730b-a255-4ccb-89c7-b81b95dd773b",
"name": "Base Value",
"type": "n8n-nodes-base.if",
"position": [
-40,
100
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "c36cd7b3-dfa5-45d8-bd2e-331a51a09001",
"name": "Base Value1",
"type": "n8n-nodes-base.if",
"position": [
-40,
380
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "bb7b17f8-37e8-4569-ac2b-ee5e2f1b58f7",
"name": "Evolution",
"type": "n8n-nodes-base.httpRequest",
"position": [
320,
100
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "2bbced2a-9f28-4ec6-8f17-469f31c5c9b5",
"name": "Evolution1",
"type": "n8n-nodes-base.httpRequest",
"position": [
320,
380
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "7dcc62eb-53c3-484f-aa61-8157b5a9898a",
"name": "Sticky Note10",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1280,
-340
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "44018bf2-0851-4b6b-a083-37fb1c6007c2",
"name": "Customer Base",
"type": "n8n-nodes-base.googleSheets",
"position": [
-880,
140
],
"parameters": {},
"typeVersion": 4.5
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "32f42218-f19a-47a5-be74-99a333aad0d4",
"connections": {
"Wait": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Gmail": {
"main": [
[
{
"node": "Replace Me",
"type": "main",
"index": 0
}
]
]
},
"Gmail1": {
"main": [
[
{
"node": "Replace Me",
"type": "main",
"index": 0
}
]
]
},
"Mapping": {
"main": [
[
{
"node": "Customer Base",
"type": "main",
"index": 0
}
]
]
},
"Meta Ads": {
"main": [
[
{
"node": "Is it Prepaid?",
"type": "main",
"index": 0
}
]
]
},
"Evolution": {
"main": [
[
{
"node": "Gmail",
"type": "main",
"index": 0
}
]
]
},
"Base Value": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
],
[]
]
},
"Evolution1": {
"main": [
[
{
"node": "Gmail1",
"type": "main",
"index": 0
}
]
]
},
"Replace Me": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Base Value1": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
],
[]
]
},
"Customer Base": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets": {
"main": [
[
{
"node": "Evolution",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets1": {
"main": [
[
{
"node": "Evolution1",
"type": "main",
"index": 0
}
]
]
},
"Is it Prepaid?": {
"main": [
[
{
"node": "Base Value",
"type": "main",
"index": 0
}
],
[
{
"node": "Base Value1",
"type": "main",
"index": 0
}
]
]
},
"Start by Click": {
"main": [
[
{
"node": "Mapping",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Meta Ads",
"type": "main",
"index": 0
}
]
]
},
"Start by Period": {
"main": [
[
{
"node": "Mapping",
"type": "main",
"index": 0
}
]
]
}
}
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
I created this workflow with care for marketing professionals and agencies who manage multiple Meta Ads (Facebook) accounts and want to track ad account balances automatically — no more logging in every day or risking campaigns stopping unexpectedly.
Source: https://n8n.io/workflows/3695/ — 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.
YOUR_ID 4. Uses gmail, googleDrive, googleSheets, httpRequest. Scheduled trigger; 53 nodes.
Gmail, Google Drive, Google Sheets +1
Looking for a way to track GitHub bounty issues automatically and get notified in real time? This GitHub Bounty Tracker workflow monitors repositories for issues labeled 💎 Bounty, logs them in Google
Google Sheets, HTTP Request, WhatsApp +1
This workflow automatically sends a beautifully designed HTML newsletter every Sunday at 8 AM, featuring products currently on sale from your Algolia-powered e-commerce store.
Google Sheets, HTTP Request, Gmail
This n8n template demonstrates how to build a Auto Lead Gen & Outreach System for Local Businesses specifically designed to help businesses that don’t have a website yet.
Google Sheets, HTTP Request, Google Drive +1
This n8n workflow automates scheduled checks for your target keywords’ positions in Google’s organic search results using SerpAPI. It logs new positions in Google Sheets, compares them to previous ran
HTTP Request, Google Sheets, Google Sheets Trigger +2