Samir Saci This workflow corresponds to n8n.io template #4802 — we link there as the canonical source.
This workflow follows the Google Sheets → HTTP Request 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 →
{
"meta": {
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "f20cd1d4-671c-420c-a25d-1c9fe05b67d9",
"name": "When clicking \u2018Test workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1000,
-1030
],
"parameters": {},
"typeVersion": 1
},
{
"id": "edf80cc8-a4b3-42dd-96dc-c729d209aef9",
"name": "Extract Blog Posts",
"type": "n8n-nodes-base.ghost",
"position": [
-780,
-1030
],
"parameters": {
"limit": 1,
"options": {},
"operation": "getAll"
},
"credentials": {
"ghostContentApi": {
"name": "<your credential>"
}
},
"notesInFlow": true,
"typeVersion": 1
},
{
"id": "b2f0a448-5b73-499a-a78e-e69b75fc8f9d",
"name": "Extract Post Content",
"type": "n8n-nodes-base.set",
"position": [
-560,
-1030
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "00b337cd-1c61-4f19-8c51-b76f3a8dece1",
"name": "id",
"type": "string",
"value": "={{ $json.id }}"
},
{
"id": "8d38f4bc-bca6-4343-8c5e-5d9fd9cbe178",
"name": "title",
"type": "string",
"value": "={{ $json.title }}"
},
{
"id": "c34ddd76-0db6-4225-82fa-04d5542f9c7c",
"name": "featured_image",
"type": "string",
"value": "={{ $json.feature_image }}"
},
{
"id": "c0f9593c-0d5a-4659-9e25-91b098318bd6",
"name": "excerpt",
"type": "string",
"value": "={{ $json.excerpt }}"
},
{
"id": "0d11d3d5-49f8-473a-8602-b49769f88005",
"name": "content",
"type": "string",
"value": "={{ $json.html }}"
},
{
"id": "ec89a00d-9d76-4594-a8ce-98aa177e6737",
"name": "link",
"type": "string",
"value": "={{ $json.url }}"
}
]
}
},
"notesInFlow": true,
"typeVersion": 3.4
},
{
"id": "e80bde5d-28c0-4fa7-a7ff-bff0fcddbf94",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-360,
-800
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "1052cc12-c1cd-468f-9cf7-33f73ff43642",
"name": "Collect All Images",
"type": "n8n-nodes-base.code",
"position": [
500,
-1300
],
"parameters": {
"jsCode": "const results = [];\n\nfor (const item of items) {\n const articleUrl = item.json.link;\n const articleTitle = item.json.title;\n const articleId = item.json.id;\n const html = item.json.content;\n\n const imgRegex = /<img[^>]*src=\"([^\"]+)\"[^>]*alt=\"([^\"]*)\"?[^>]*>/g;\n let match;\n\n while ((match = imgRegex.exec(html)) !== null) {\n const imageUrl = match[1];\n const altText = match[2];\n\n results.push({\n json: {\n articleId: articleId,\n articleTitle: articleTitle,\n article_url: articleUrl,\n image_url: imageUrl,\n alt_text: altText\n }\n });\n }\n}\n\nreturn results;\n"
},
"typeVersion": 2
},
{
"id": "b2176289-ded3-471c-bc8a-225dacc33aeb",
"name": "Add Records",
"type": "n8n-nodes-base.googleSheets",
"position": [
720,
-1300
],
"parameters": {
"columns": {
"value": {
"alt_text": "={{ $json.alt_text }}",
"articleId": "={{ $json.articleId }}",
"image_url": "={{ $json.image_url }}",
"article_url": "={{ $json.article_url }}",
"articleTitle": "={{ $json.articleTitle }}"
},
"schema": [
{
"id": "articleId",
"type": "string",
"display": true,
"required": false,
"displayName": "articleId",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "articleTitle",
"type": "string",
"display": true,
"required": false,
"displayName": "articleTitle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "article_url",
"type": "string",
"display": true,
"required": false,
"displayName": "article_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "image_url",
"type": "string",
"display": true,
"required": false,
"displayName": "image_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "alt_text",
"type": "string",
"display": true,
"required": false,
"displayName": "alt_text",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 886110184,
"cachedResultUrl": "",
"cachedResultName": ""
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Nk_2xwvK0ipSjnSbP50AQFc92IlHWaOkSK57-vt_3GY",
"cachedResultUrl": "",
"cachedResultName": ""
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"notesInFlow": true,
"typeVersion": 4.6
},
{
"id": "cdb245eb-a3e3-45d1-bcce-f1d0ce65297c",
"name": "Collect Records by Id",
"type": "n8n-nodes-base.googleSheets",
"position": [
-140,
-760
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "={{ $json.id }}",
"lookupColumn": "articleId"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 886110184,
"cachedResultUrl": "",
"cachedResultName": ""
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Nk_2xwvK0ipSjnSbP50AQFc92IlHWaOkSK57-vt_3GY",
"cachedResultUrl": "",
"cachedResultName": ""
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"notesInFlow": true,
"typeVersion": 4.6
},
{
"id": "dbec4c36-c7e3-49ea-976d-cec6dee70f76",
"name": "Loop Over Items1",
"type": "n8n-nodes-base.splitInBatches",
"position": [
80,
-760
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "0254622b-3593-4ad8-820c-f6e27e31c53c",
"name": "Get Image",
"type": "n8n-nodes-base.httpRequest",
"position": [
300,
-780
],
"parameters": {
"url": "={{ $json.image_url }}",
"options": {
"response": {
"response": {
"responseFormat": "file"
}
}
}
},
"typeVersion": 4.2
},
{
"id": "bb2a182b-82ae-4263-b3ab-9a7e30a5b97c",
"name": "Extract Image Info",
"type": "n8n-nodes-base.code",
"position": [
520,
-780
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "const base64 = $binary[\"data\"].data;\nconst fileName = $binary[\"data\"].fileName || 'unknown.png';\nconst extension = fileName.split('.').pop().toLowerCase();\nconst fileSizeKB = $binary[\"data\"].fileSize || 'unknown.png';\nconst size_ok = fileSizeKB <= 500 ? true : false;\n\nreturn {\n json: {\n file_name: fileName,\n file_size_kb: fileSizeKB,\n format: extension,\n filename_seo: /[a-z0-9-]{3,}/.test(fileName) ? true : false,\n size_ok: size_ok\n }\n};\n"
},
"typeVersion": 2
},
{
"id": "871e3d19-87c7-4dd6-a481-d83fc652478b",
"name": "Results Images",
"type": "n8n-nodes-base.googleSheets",
"position": [
740,
-680
],
"parameters": {
"columns": {
"value": {
"format": "={{ $json.format }}",
"size_ok": "={{ $json.size_ok }}",
"image_url": "={{ $('Get Image').item.json.image_url }}",
"file_size_kb": "={{ $json.file_size_kb }}",
"filename_seo": "={{ $json.filename_seo }}"
},
"schema": [
{
"id": "articleId",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "articleId",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "articleTitle",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "articleTitle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "article_url",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "article_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "image_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "image_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "alt_text",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "alt_text",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "file_size_kb",
"type": "string",
"display": true,
"required": false,
"displayName": "file_size_kb",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "format",
"type": "string",
"display": true,
"required": false,
"displayName": "format",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "filename_seo",
"type": "string",
"display": true,
"required": false,
"displayName": "filename_seo",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "size_ok",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "size_ok",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"image_url"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 886110184,
"cachedResultUrl": "",
"cachedResultName": ""
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Nk_2xwvK0ipSjnSbP50AQFc92IlHWaOkSK57-vt_3GY",
"cachedResultUrl": "",
"cachedResultName": ""
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"notesInFlow": true,
"typeVersion": 4.6
},
{
"id": "ad236989-0707-40ca-885c-c5d5550d7954",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-820,
-1380
],
"parameters": {
"color": 7,
"width": 400,
"height": 520,
"content": "### 2. Extract Blog Posts Content\nThe Ghost node extracts all the posts of your blog with content and metadata. In the second node, we extract description, URL, content and features image url.\n\n#### How to setup?\n- **Ghost Account API**:\n 1. Add your Ghost Blog Account Credentials\n 2. Select the number of Blog Posts you want to collect\n [Learn more about the Ghost Node](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.ghost)\n\n"
},
"typeVersion": 1
},
{
"id": "8d296af6-9e32-4669-bacc-decab229847a",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1040,
-1380
],
"parameters": {
"color": 7,
"width": 200,
"height": 520,
"content": "### 1. Workflow Trigger\nThis workflow uses simple trigger.\n\n#### How to setup?\n*Nothing to do.*\n"
},
"typeVersion": 1
},
{
"id": "092719b3-65d7-40b8-af99-36cd3f41ea55",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-400,
-1380
],
"parameters": {
"color": 7,
"width": 1360,
"height": 280,
"content": "### 3. First Loop to Collect Images\nWe loop through all the articles extracted by the Ghost Node. For each article, this section will collect all the images of the article with their **image_url** and **alt_text**. The results will be recorded in a **Google Sheet**.\n\n#### How to setup?\n- **Record Long Break in the Google Sheet Node**:\n 1. Add your Google Sheet API credentials to access the Google Sheet file\n 2. Select the file using the list, an URL or an ID\n 3. Select the sheet in which you want to record the images information\n 4. Map the fields: **article_id**, **article_Title**, **article_url**, **image_url**, **alt_text**, **file_size_kb**, **format**, **filename_seo**\n [Learn more about the Google Sheet Node](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.googlesheets)\n\n\n"
},
"typeVersion": 1
},
{
"id": "71a03b91-fa30-4ede-88f4-f307b5fd7889",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-400,
-1080
],
"parameters": {
"color": 7,
"width": 1360,
"height": 620,
"content": "### 4. Second Loop to Extract Image Information\nWe loop through all the images in the article, for each image we **download** the content using the **HTTP request** node to record **image_size** in kilobytes and **image_name** in a Google Sheet. If the image size is higher than **500 kb**, it is flagged as **not ok**.\n#### How to setup?\n- **Record Image File Name and Size**:\n 1. Add your Google Sheet API credentials to access the Google Sheet file\n 2. Select the file using the list, an URL or an ID\n 3. Select the sheet in which you want to record the images information\n [Learn more about the Google Sheet Node](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.googlesheets)\n\n\n"
},
"typeVersion": 1
}
],
"connections": {
"Get Image": {
"main": [
[
{
"node": "Extract Image Info",
"type": "main",
"index": 0
}
]
]
},
"Add Records": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Results Images": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
},
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Collect All Images",
"type": "main",
"index": 0
},
{
"node": "Collect Records by Id",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items1": {
"main": [
[],
[
{
"node": "Get Image",
"type": "main",
"index": 0
}
]
]
},
"Collect All Images": {
"main": [
[
{
"node": "Add Records",
"type": "main",
"index": 0
}
]
]
},
"Extract Blog Posts": {
"main": [
[
{
"node": "Extract Post Content",
"type": "main",
"index": 0
}
]
]
},
"Extract Image Info": {
"main": [
[
{
"node": "Results Images",
"type": "main",
"index": 0
}
]
]
},
"Extract Post Content": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Collect Records by Id": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Test workflow\u2019": {
"main": [
[
{
"node": "Extract Blog Posts",
"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.
ghostContentApigoogleSheetsOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
*Tags: Ghost CMS, SEO Audit, Image Optimisation, Alt Text, Google Sheets, Automation*
Source: https://n8n.io/workflows/4802/ — 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 template is ideal for solo store owners, eCommerce marketers, automation beginners, or anyone using Shopify and Gmail who wants to recover lost revenue without coding.
HTTP Request, Gmail, Twilio +3
PCN. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, itemLists. Event-driven trigger; 60 nodes.
Google Sheets, HTTP Request, @N Octo N/N8N Nodes Json Database +3
The workflow automates the process of gathering extensive keyword data for a "Main Keyword." It starts by reading initial parameters from a Google Sheets template, creates a new dedicated Google Sheet
Google Sheets, Google Drive, HTTP Request
🔥 March Sale – n8n Community Members Get ideoGener8r for Just $27! (Reg. $47) Use Coupon Code: (Valid until 3/31/2025 for n8n community members)
HTTP Request, Google Drive, Google Sheets
📄 Documentation: Notion Guide
Google Sheets, Google Drive, HTTP Request +2