{ "edges": [ { "to": "885e1631-7112-45e7-aced-60e38a246501", "from": "5500d97e-16f7-4ff3-b6b0-0c40f777f93a", "toPort": "0", "fromPort": "0" }, { "to": "b4cc767d-8826-4e9a-b113-dfc5b3b61102", "from": "5500d97e-16f7-4ff3-b6b0-0c40f777f93a", "toPort": "0", "fromPort": "1" }, { "to": "773d85a2-a25c-4596-8f1c-a30389c14cf5", "from": "b4cc767d-8826-4e9a-b113-dfc5b3b61102", "toPort": "0", "fromPort": "0" }, { "to": "965db1e6-1721-41ba-90a4-cf86557cac7c", "from": "26be266b-211f-4281-9df0-9439c127187f", "toPort": "0", "fromPort": "ai_languageModel" }, { "to": "b918c267-c7bf-41e1-9396-eebd5c49fefb", "from": "e76c4c98-24d9-49bf-b3b5-c58b331c1804", "toPort": "0", "fromPort": "0" }, { "to": "965db1e6-1721-41ba-90a4-cf86557cac7c", "from": "29e9059b-c773-40ba-a36f-5fb93120065b", "toPort": "0", "fromPort": "0" }, { "to": "29e9059b-c773-40ba-a36f-5fb93120065b", "from": "773d85a2-a25c-4596-8f1c-a30389c14cf5", "toPort": "0", "fromPort": "0" }, { "to": "e76c4c98-24d9-49bf-b3b5-c58b331c1804", "from": "1dc49b96-e6c8-4c38-858b-4865238423ba", "toPort": "0", "fromPort": "0" }, { "to": "b4cc767d-8826-4e9a-b113-dfc5b3b61102", "from": "b918c267-c7bf-41e1-9396-eebd5c49fefb", "toPort": "0", "fromPort": "0" }, { "to": "5500d97e-16f7-4ff3-b6b0-0c40f777f93a", "from": "c906fbd0-bd7f-407c-8a31-93cfe43c0ff1", "toPort": "0", "fromPort": "0" }, { "to": "c906fbd0-bd7f-407c-8a31-93cfe43c0ff1", "from": "965db1e6-1721-41ba-90a4-cf86557cac7c", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "1dc49b96-e6c8-4c38-858b-4865238423ba", "name": "Schedule Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ {} ] } }, "position": [ -1264, -48 ] }, { "id": "b918c267-c7bf-41e1-9396-eebd5c49fefb", "name": "Google_news search", "type": "integration", "params": { "q": "AI", "service": "serpapi", "operation": "google_news", "__originalType": "n8n-nodes-serpapi.serpApi", "requestOptions": {}, "additionalFields": {} }, "position": [ -944, -48 ] }, { "id": "965db1e6-1721-41ba-90a4-cf86557cac7c", "name": "Prepare Content Review Email", "type": "llm", "params": { "text": "=Generate clean, modern HTML email content from the provided JSON data with these requirements:\n- Use table-based layout with inline CSS for email compatibility\n- Create card sections for each platform containing:\n • Title header (20px) \n- Structure using:\n • 600px max-width container\n • 20px padding between cards\n • Left-aligned text hierarchy\n • Arial/sans-serif font stack\n • Email-safe colors (#333 text, #555 secondary)\n\nInput data: {{ $('Extract Details').item.json.out.toJsonString() }}\n\nRemove ALL code blocks and comments. Output ONLY the raw HTML with:\n- Platform cards in JSON order\n- All data elements represented\n- Mobile-responsive tables\n- W3C-valid markup\n\n## Example HTML:\n\n \n \n \n \n \n

\n \n \n \n \n

\n \n \n \n \n \n \n \n \n \n \n \n

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
Source: AP News, Author: John Doe
\n \n Read more...\n \n

\n \n \n \n", "agent": "conversationalAgent", "prompt": "=Generate clean, modern HTML email content from the provided JSON data with these requirements:\n- Use table-based layout with inline CSS for email compatibility\n- Create card sections for each platform containing:\n • Title header (20px) \n- Structure using:\n • 600px max-width container\n • 20px padding between cards\n • Left-aligned text hierarchy\n • Arial/sans-serif font stack\n • Email-safe colors (#333 text, #555 secondary)\n\nInput data: {{ $('Extract Details').item.json.out.toJsonString() }}\n\nRemove ALL code blocks and comments. Output ONLY the raw HTML with:\n- Platform cards in JSON order\n- All data elements represented\n- Mobile-responsive tables\n- W3C-valid markup\n\n## Example HTML:\n\n \n \n \n \n \n

\n \n \n \n \n

\n \n \n \n \n \n \n \n \n \n \n \n

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
Source: AP News, Author: John Doe
\n \n Read more...\n \n

\n \n \n \n", "options": {}, "provider": "openai", "promptType": "define", "approximated": true }, "position": [ 48, -176 ] }, { "id": "e76c4c98-24d9-49bf-b3b5-c58b331c1804", "name": "Create Counter", "type": "integration", "params": { "base": { "__rl": true, "mode": "list", "value": "appWOGRfXfKYuXtdO", "cachedResultUrl": "https://airtable.com/appWOGRfXfKYuXtdO", "cachedResultName": "n8n Base" }, "table": { "__rl": true, "mode": "list", "value": "tblmhlqwgnmwZd6hj", "cachedResultUrl": "https://airtable.com/appWOGRfXfKYuXtdO/tblmhlqwgnmwZd6hj", "cachedResultName": "n8n_Counters" }, "columns": { "value": { "Counter": 0, "Workflow ID": "={{ $workflow.id }}" }, "schema": [ { "id": "Workflow ID", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "Workflow ID", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Counter", "type": "number", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "Counter", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "airtable", "operation": "create" }, "position": [ -1088, 256 ] }, { "id": "b4cc767d-8826-4e9a-b113-dfc5b3b61102", "name": "Get Counter", "type": "integration", "params": { "base": { "__rl": true, "mode": "list", "value": "appWOGRfXfKYuXtdO", "cachedResultUrl": "https://airtable.com/appWOGRfXfKYuXtdO", "cachedResultName": "n8n Base" }, "table": { "__rl": true, "mode": "list", "value": "tblmhlqwgnmwZd6hj", "cachedResultUrl": "https://airtable.com/appWOGRfXfKYuXtdO/tblmhlqwgnmwZd6hj", "cachedResultName": "n8n_Counters" }, "options": { "fields": [ "Counter" ] }, "service": "airtable", "operation": "search", "filterByFormula": "={Workflow ID} = '{{ $workflow.id }}'" }, "position": [ -656, 272 ] }, { "id": "29e9059b-c773-40ba-a36f-5fb93120065b", "name": "Update Counter", "type": "integration", "params": { "base": { "__rl": true, "mode": "list", "value": "appWOGRfXfKYuXtdO", "cachedResultUrl": "https://airtable.com/appWOGRfXfKYuXtdO", "cachedResultName": "n8n Base" }, "table": { "__rl": true, "mode": "list", "value": "tblmhlqwgnmwZd6hj", "cachedResultUrl": "https://airtable.com/appWOGRfXfKYuXtdO/tblmhlqwgnmwZd6hj", "cachedResultName": "n8n_Counters" }, "columns": { "value": { "Counter": "={{ $json.counter }}", "Workflow ID": "={{ $workflow.id }}" }, "schema": [ { "id": "id", "type": "string", "display": true, "removed": true, "readOnly": true, "required": false, "displayName": "id", "defaultMatch": true }, { "id": "Workflow ID", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "Workflow ID", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Counter", "type": "number", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "Counter", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [ "Workflow ID" ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "airtable", "operation": "update" }, "position": [ -208, 272 ] }, { "id": "5500d97e-16f7-4ff3-b6b0-0c40f777f93a", "name": "Approved?", "type": "if", "params": { "options": { "ignoreCase": true }, "conditions": { "options": { "version": 2, "leftValue": "", "caseSensitive": false, "typeValidation": "loose" }, "combinator": "and", "conditions": [ { "id": "eb6bdb7f-61ad-4821-b1b4-d72acf045af0", "operator": { "name": "filter.operator.equals", "type": "string", "operation": "equals" }, "leftValue": "={{ $json.data.approved }}", "rightValue": "true" } ] }, "looseTypeValidation": true }, "position": [ 608, -48 ] }, { "id": "26be266b-211f-4281-9df0-9439c127187f", "name": "gpt-4o-mini", "type": "llm", "params": { "model": "gpt-4o-mini", "options": { "responseFormat": "text" }, "provider": "openai" }, "position": [ 80, 16 ] }, { "id": "885e1631-7112-45e7-aced-60e38a246501", "name": "Delete Counter", "type": "integration", "params": { "id": "={{ $('Get Counter').item.json.id }}", "base": { "__rl": true, "mode": "list", "value": "appWOGRfXfKYuXtdO", "cachedResultUrl": "https://airtable.com/appWOGRfXfKYuXtdO", "cachedResultName": "n8n Base" }, "table": { "__rl": true, "mode": "list", "value": "tblmhlqwgnmwZd6hj", "cachedResultUrl": "https://airtable.com/appWOGRfXfKYuXtdO/tblmhlqwgnmwZd6hj", "cachedResultName": "n8n_Counters" }, "service": "airtable", "operation": "deleteRecord" }, "position": [ 848, 288 ] }, { "id": "773d85a2-a25c-4596-8f1c-a30389c14cf5", "name": "Extract Details", "type": "code", "params": { "jsCode": "const results = $('Google_news search').first().json.news_results || [];\nconsole.log(\"results: \" + results.length);\nconst out = [];\n\nconst batchSize = 10;\n\nconst url = \"http://localhost:5678/webhook-test/news?p=\";\n\nlet indNews = Number($input.first().json.Counter);\nconsole.log(\"indNews start: \" + indNews);\nconsole.log(\"indNews after: \" + Number(indNews + batchSize));\n\nlet ind = 0;\nfor (const res of results) {\n\n if (ind >= indNews && ind < (indNews + batchSize)) {\n const src = res.source || {};\n if (src && Object.keys(src).length === 0 && src.constructor === Object) {\n const stories = res.stories || {};\n const src1 = stories[0].source || {};\n out.push({\n json: {\n position: Number(res.position),\n title: res.title,\n source: src1.name || null,\n authors: (src1.authors || []).join(\", \"), \n link2: url + res.position,\n link1: src1.link,\n }\n }); \n } else {\n out.push({\n json: {\n position: Number(res.position),\n title: res.title,\n source: src.name || null,\n authors: (src.authors || []).join(\", \"), \n link2: url + Number(res.position),\n link1: res.link,\n }\n }); \n } \n } \n ind++;\n //else {\n // break;\n //}\n}\n\nconsole.log(\"ind end: \" + Number(indNews + batchSize));\n\n// optional: sort by parent position then story pos\nout.sort((a, b) =>\n (a.json.position ?? Infinity) - (b.json.position ?? Infinity)\n);\nreturn { out: out, counter: Number(indNews + batchSize) };\n" }, "position": [ -416, -176 ] }, { "id": "c906fbd0-bd7f-407c-8a31-93cfe43c0ff1", "name": "Gmail Approval News", "type": "integration", "params": { "sendTo": "={{ $env.EMAIL_ADDRESS_ME }} ", "message": "=Select the news article to repost:\n\n{{ $('Prepare Content Review Email').item.json.output }}", "options": { "limitWaitTime": { "values": { "resumeUnit": "minutes", "resumeAmount": 45 } } }, "service": "gmail", "subject": "=🔥FOR APPROVAL🔥Latest 10 Google News", "operation": "sendAndWait", "approvalOptions": { "values": { "approvalType": "double" } } }, "position": [ 384, -176 ] } ] }

Schedule AI-formatted Google News digests with Gmail approval workflow