{ "edges": [ { "to": "dfbb3db9-6ecf-4029-814e-661d54f6739e", "from": "425c99b0-448d-4be0-8c39-c5439a254bdc", "toPort": "0", "fromPort": "0" }, { "to": "425c99b0-448d-4be0-8c39-c5439a254bdc", "from": "be721f70-0848-4b24-8a80-79478416ead9", "toPort": "0", "fromPort": "0" }, { "to": "0b442536-87b5-49a0-9ad8-c5a9efb99747", "from": "bbcd72e5-e891-483e-a652-4b112e666d3e", "toPort": "0", "fromPort": "0" }, { "to": "daec3abd-41ad-4484-bbb6-7becc4c6a2fc", "from": "3949e608-5a90-4ad5-9a72-b78ae20ac06a", "toPort": "0", "fromPort": "0" }, { "to": "daec3abd-41ad-4484-bbb6-7becc4c6a2fc", "from": "78dca46a-cca9-4570-9db6-3f08d3b3bbdc", "toPort": "0", "fromPort": "0" }, { "to": "be721f70-0848-4b24-8a80-79478416ead9", "from": "62d4caad-7579-4aeb-8844-c0d2088f85f5", "toPort": "0", "fromPort": "0" }, { "to": "bbcd72e5-e891-483e-a652-4b112e666d3e", "from": "6e614e05-f17f-4824-8d3c-25223e31185d", "toPort": "0", "fromPort": "0" }, { "to": "6e614e05-f17f-4824-8d3c-25223e31185d", "from": "dfbb3db9-6ecf-4029-814e-661d54f6739e", "toPort": "0", "fromPort": "0" }, { "to": "3949e608-5a90-4ad5-9a72-b78ae20ac06a", "from": "0b442536-87b5-49a0-9ad8-c5a9efb99747", "toPort": "0", "fromPort": "0" }, { "to": "0fd324b7-b255-4573-9a32-9fc3b09b4bc5", "from": "0b442536-87b5-49a0-9ad8-c5a9efb99747", "toPort": "0", "fromPort": "0" }, { "to": "78dca46a-cca9-4570-9db6-3f08d3b3bbdc", "from": "daec3abd-41ad-4484-bbb6-7becc4c6a2fc", "toPort": "0", "fromPort": "1" }, { "to": "62d4caad-7579-4aeb-8844-c0d2088f85f5", "from": "ae4fedc4-6818-4fc5-9dec-6d58e2e7f6ad", "toPort": "0", "fromPort": "0" }, { "to": "bbcd72e5-e891-483e-a652-4b112e666d3e", "from": "32ecd7ff-c51c-45bb-82fe-767fae4764f5", "toPort": "0", "fromPort": "ai_languageModel" } ], "nodes": [ { "id": "32ecd7ff-c51c-45bb-82fe-767fae4764f5", "name": "Google Gemini Chat Model", "type": "llm", "params": { "options": {}, "provider": "google" }, "position": [ 7808, 240 ] }, { "id": "daec3abd-41ad-4484-bbb6-7becc4c6a2fc", "name": "Loop Over Items", "type": "passthrough", "params": { "mode": "noOp", "options": {} }, "position": [ 8640, 176 ] }, { "id": "0fd324b7-b255-4573-9a32-9fc3b09b4bc5", "name": "Create a post", "type": "integration", "params": { "text": "={{ $('Format Response').item.json.linkedin_teaser }}", "postAs": "organization", "service": "linkedin", "operation": "read", "additionalFields": {}, "shareMediaCategory": "ARTICLE" }, "position": [ 8448, -32 ] }, { "id": "425c99b0-448d-4be0-8c39-c5439a254bdc", "name": "If", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 3, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "747c30c8-465d-4ea1-b666-a44e66d3acf1", "operator": { "type": "number", "operation": "lt" }, "leftValue": "={{ $json.LastProcessedID }}", "rightValue": "={{ $('Fetch Blog').item.json.id }}" } ] } }, "position": [ 7200, 80 ] }, { "id": "6e614e05-f17f-4824-8d3c-25223e31185d", "name": "data cleanse", "type": "code", "params": { "jsCode": "// Change this line to point specifically to your WordPress node name\nconst raw = $node[\"Fetch Blog\"].json; \n\n// 1. Strip HTML tags from the content\nconst cleanContent = raw.content.rendered.replace(/<[^>]*>?/gm, '').trim();\n\n// 2. Clean HTML entities from the title\nconst cleanTitle = raw.title.rendered.replace(/’/g, \"'\").replace(/–/g, \"-\");\n\n// 3. Extract the Image URL safely\nconst imageUrl = raw._embedded?.['wp:featuredmedia']?.[0]?.source_url || \"\";\n\nreturn {\n id: raw.id,\n title: cleanTitle,\n content: cleanContent,\n link: raw.link,\n image_url: imageUrl\n};" }, "position": [ 7616, 64 ] }, { "id": "be721f70-0848-4b24-8a80-79478416ead9", "name": "Last ID", "type": "integration", "params": { "options": {}, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": 350289368, "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEETS_DOCUMENT_ID/edit#gid=350289368", "cachedResultName": "Sheet2" }, "documentId": { "__rl": true, "mode": "list", "value": "YOUR_GOOGLE_SHEETS_DOCUMENT_ID", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEETS_DOCUMENT_ID/edit?usp=drivesdk", "cachedResultName": "Newsletter pipeline" } }, "position": [ 7024, 80 ] }, { "id": "dfbb3db9-6ecf-4029-814e-661d54f6739e", "name": "Update Last ID", "type": "integration", "params": { "columns": { "value": { "row_number": "={{ $json.row_number }}", "LastProcessedID": "={{ $('Fetch Blog').item.json.id }}" }, "schema": [ { "id": "LastProcessedID", "type": "string", "display": true, "required": false, "displayName": "LastProcessedID", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "row_number", "type": "number", "display": true, "removed": false, "readOnly": true, "required": false, "displayName": "row_number", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [ "row_number" ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "update", "sheetName": { "__rl": true, "mode": "list", "value": 350289368, "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEETS_DOCUMENT_ID/edit#gid=350289368", "cachedResultName": "Sheet2" }, "documentId": { "__rl": true, "mode": "list", "value": "YOUR_GOOGLE_SHEETS_DOCUMENT_ID", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEETS_DOCUMENT_ID/edit?usp=drivesdk", "cachedResultName": "Newsletter pipeline" } }, "position": [ 7424, 64 ] }, { "id": "0b442536-87b5-49a0-9ad8-c5a9efb99747", "name": "Format Response", "type": "code", "params": { "jsCode": "let rawAI = $input.item.json.output || $input.item.json.text || \"\";\n\ntry {\n const cleanJSON = rawAI.replace(/```json/g, '').replace(/```/g, '').trim();\n const parsed = JSON.parse(cleanJSON);\n\n // CRITICAL: This must match the name \"data cleanse\" exactly as seen in your Step 2\n const sourceData = $node[\"data cleanse\"].json;\n\n return {\n subject_line: parsed.subject_line,\n newsletter_body: parsed.newsletter_body,\n linkedin_teaser: parsed.linkedin_teaser,\n image_url: sourceData.image_url || \"\",\n link: sourceData.link || \"\"\n };\n} catch (error) {\n return {\n error: \"Parsing failed\",\n ai_raw: rawData\n };\n}" }, "position": [ 8160, 64 ] }, { "id": "3949e608-5a90-4ad5-9a72-b78ae20ac06a", "name": "Email List", "type": "integration", "params": { "options": {}, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEETS_DOCUMENT_ID/edit#gid=0", "cachedResultName": "Sheet1" }, "documentId": { "__rl": true, "mode": "list", "value": "YOUR_GOOGLE_SHEETS_DOCUMENT_ID", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEETS_DOCUMENT_ID/edit?usp=drivesdk", "cachedResultName": "Recepient Listt" } }, "position": [ 8448, 176 ] }, { "id": "78dca46a-cca9-4570-9db6-3f08d3b3bbdc", "name": "Send Email", "type": "integration", "params": { "sendTo": "={{ $json['email list'] }}", "message": "=\n\n\n \n

\n Insights on {{ $('Format Response').item.json.subject_line }}\n

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

\n $\"Header\"$ \n

\n{{ $('Format Response').item.json.subject_line }}\n

\n \n

\n {{ $('Format Response').item.json.newsletter_body }}\n

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

\n \n Read the Full Article\n \n

\n\n", "options": { "appendAttribution": false }, "service": "gmail", "subject": "=Daily Newsletter : {{ $('Format Response').item.json.subject_line }}", "operation": "read" }, "position": [ 8864, 192 ] }, { "id": "ae4fedc4-6818-4fc5-9dec-6d58e2e7f6ad", "name": "Schedule Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ {} ] } }, "position": [ 6656, 80 ] }, { "id": "bbcd72e5-e891-483e-a652-4b112e666d3e", "name": "AI Agent2", "type": "llm", "params": { "prompt": "", "options": {}, "provider": "openai", "approximated": true }, "position": [ 7792, 64 ] }, { "id": "62d4caad-7579-4aeb-8844-c0d2088f85f5", "name": "HTTP Request", "type": "http", "params": { "url": "https://vaguefoundation.com/blog/wp-json/wp/v2/posts?_embed&per_page=1", "options": { "response": { "response": { "responseFormat": "json" } } } }, "position": [ 6848, 80 ] } ] }

Publish AI-written newsletters and LinkedIn posts from WordPress with Gemini, Google Sheets and Gmail