WeblineIndia This workflow corresponds to n8n.io template #9617 — 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": "unl2pTzZ5wjLa1LJ",
"name": "n8n IPA Size Tracker Workflow",
"tags": [],
"nodes": [
{
"id": "b359d5db-f75a-4ff6-8563-7760134859a0",
"name": "Daily size check",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1696,
16
],
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "0 0 0 * * *"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "836eb96f-716e-4b0e-a864-608e9d7b4776",
"name": "App Configuration",
"type": "n8n-nodes-base.set",
"position": [
-1488,
16
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "1b05cba9-c860-47d7-8776-4dfb01da6650",
"name": "app_name",
"type": "string",
"value": "APP_NAME"
},
{
"id": "e5ee79ad-87be-4f59-82a4-39f8ef9c73a0",
"name": "version",
"type": "string",
"value": "1.0.0"
},
{
"id": "cc1481ec-2fe3-4c52-af36-706a7cf8a039",
"name": "build_number",
"type": "string",
"value": "1"
},
{
"id": "16a60a31-e728-4f65-8aa6-405cf5751942",
"name": "ipa_url",
"type": "string",
"value": "ENTER_IPA_FILE_DOWNLOAD_URL"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "aee76d66-e1d7-4ed2-9a39-f6ff25a61557",
"name": "Download IPA File",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1280,
16
],
"parameters": {
"url": "={{ $json.ipa_url }}",
"options": {
"response": {
"response": {
"responseFormat": "file"
}
}
}
},
"typeVersion": 4.2
},
{
"id": "8381ba6f-b167-4e87-b83a-2534a7e921b7",
"name": "Calculate Sizes",
"type": "n8n-nodes-base.code",
"position": [
-1072,
16
],
"parameters": {
"jsCode": "// Get input data from previous nodes\nconst items = $input.all();\nconst results = [];\n\n// Process each item\nfor (const item of items) {\n // Get file size from binary data\n const fileSize = item.binary?.data?.fileSize || 0;\n \n // Calculate different size units\n const fileSizeKB = Math.round(fileSize / 1024);\n const fileSizeMB = Math.round(fileSize / (1024 * 1024) * 100) / 100;\n \n // Get current date/time\n const now = new Date();\n const currentDate = now.toISOString().split('T')[0]; // YYYY-MM-DD format\n \n // Build result object\n const result = {\n // Keep original data\n app_name: item.json.app_name,\n version: item.json.version,\n build_number: item.json.build_number,\n ipa_url: item.json.ipa_url,\n \n // Add new calculated data\n date: currentDate,\n timestamp: now.toISOString(),\n file_size_bytes: fileSize,\n file_size_kb: fileSizeKB,\n file_size_mb: fileSizeMB\n };\n \n // Add to results array\n results.push(result);\n \n // Log for debugging (check browser console)\n console.log(`\ud83d\udcca ${item.json.app_name}: ${fileSizeMB} MB`);\n}\n\n// Return results to next node\nreturn results;"
},
"typeVersion": 2
},
{
"id": "500042b4-327c-4a2c-9c6c-2b75405a6d76",
"name": "Append row in sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
-864,
16
],
"parameters": {
"columns": {
"value": {},
"schema": [],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "ENTER_SHEET_NAME"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "ENTER_SHEET_ID"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "0c53dfec-5e21-4faa-8d0b-5864736d744d",
"name": "Analyze Size Trends",
"type": "n8n-nodes-base.code",
"position": [
-656,
16
],
"parameters": {
"jsCode": "// Simple trend analysis using thresholds\nconst items = $input.all();\nconst results = [];\n\nfor (const item of items) {\n const currentSize = item.json.file_size_mb;\n \n // Define size thresholds (you can customize these)\n const SMALL_APP = 50; // MB\n const MEDIUM_APP = 150; // MB\n const LARGE_APP = 300; // MB\n \n // Determine size category\n let sizeCategory = 'UNKNOWN';\n let trendStatus = 'NEW_TRACKING'; // First time tracking\n let alertLevel = 'INFO';\n \n if (currentSize < SMALL_APP) {\n sizeCategory = 'SMALL';\n } else if (currentSize < MEDIUM_APP) {\n sizeCategory = 'MEDIUM';\n } else if (currentSize < LARGE_APP) {\n sizeCategory = 'LARGE';\n } else {\n sizeCategory = 'VERY_LARGE';\n alertLevel = 'WARNING'; // Large apps always get warnings\n }\n \n // Check if size is unusually large (basic threshold check)\n if (currentSize > 500) {\n trendStatus = 'SIZE_ALERT_LARGE';\n alertLevel = 'CRITICAL';\n } else if (currentSize > 300) {\n trendStatus = 'SIZE_WARNING';\n alertLevel = 'WARNING';\n } else {\n trendStatus = 'SIZE_NORMAL';\n }\n \n const result = {\n ...item.json,\n size_category: sizeCategory,\n trend_status: trendStatus,\n alert_level: alertLevel,\n analysis_timestamp: new Date().toISOString(),\n analysis_note: `App size is ${sizeCategory.toLowerCase()} (${currentSize} MB)`\n };\n \n results.push(result);\n \n console.log(`\ud83d\udcca Analysis: ${item.json.app_name} = ${currentSize}MB (${sizeCategory})`);\n}\n\nreturn results;"
},
"typeVersion": 2
},
{
"id": "d22847f2-81e5-43a9-bfd4-2777f26d05ca",
"name": "Check for Alerts",
"type": "n8n-nodes-base.if",
"position": [
-448,
16
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "bd7ec616-cf77-4fb6-ac2b-92907fe77526",
"operator": {
"type": "string",
"operation": "notEquals"
},
"leftValue": "={{ $json.trend_status }}",
"rightValue": "STABLE"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "0aca8e1a-519f-4582-81eb-92adbca785b2",
"name": "Send Alert Email",
"type": "n8n-nodes-base.gmail",
"position": [
-240,
-128
],
"parameters": {
"sendTo": "user@example.com",
"message": "=\ud83d\udea8 IPA Size Alert App: {{ $json['App Name'] }} Current Size: {{ $json['Size(Bytes)'] }} MB Previous Size: {{ $json['Size(Bytes)'] }} MB Trend: {{ $json.trend_status }} Time: {{ new Date().toLocaleString() }} This is an automated alert from your IPA Size Tracker.",
"options": {},
"subject": "=IPA Size Alert: {{ $json['App Name'] }} - {{ $json.trend_status }}"
},
"credentials": {
"gmailOAuth2": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "d6fc5d0b-2044-49df-8c37-e95095ac3d8f",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1552,
-112
],
"parameters": {
"width": 224,
"height": 80,
"content": "** Central place to define which apps to monitor and their IPA download links **"
},
"typeVersion": 1
},
{
"id": "8f55147e-3cec-460c-819f-40bf4a979f13",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1328,
176
],
"parameters": {
"width": 224,
"height": 80,
"content": "**Fetches the IPA from the configured URL and makes it ready for size calculation**"
},
"typeVersion": 1
},
{
"id": "3ea7e537-1fa4-49d6-af5b-0f374581f684",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-928,
-96
],
"parameters": {
"width": 256,
"height": 80,
"content": "**Saves the app size data with timestamp into Google Sheets for historical tracking**\n\n"
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "5210e3a2-cf62-41b9-a30e-23d961dd9e71",
"connections": {
"Calculate Sizes": {
"main": [
[
{
"node": "Append row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Check for Alerts": {
"main": [
[
{
"node": "Send Alert Email",
"type": "main",
"index": 0
}
]
]
},
"Daily size check": {
"main": [
[
{
"node": "App Configuration",
"type": "main",
"index": 0
}
]
]
},
"App Configuration": {
"main": [
[
{
"node": "Download IPA File",
"type": "main",
"index": 0
}
]
]
},
"Download IPA File": {
"main": [
[
{
"node": "Calculate Sizes",
"type": "main",
"index": 0
}
]
]
},
"Analyze Size Trends": {
"main": [
[
{
"node": "Check for Alerts",
"type": "main",
"index": 0
}
]
]
},
"Append row in sheet": {
"main": [
[
{
"node": "Analyze Size Trends",
"type": "main",
"index": 0
}
]
]
}
}
}
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.
gmailOAuth2googleSheetsOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This workflow runs on a daily schedule and monitors IPA file sizes from configured URLs. It stores historical size data in Google Sheets, compares current vs. previous builds and sends email alerts only when significant size changes occur (default: ±10%). A DRY_RUN toggle allows…
Source: https://n8n.io/workflows/9617/ — 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
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 eve
HTTP Request, Google Sheets, Gmail