January 22, 2026

Shopify + Google Sheets: product blogs published fast

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Your product catalog changes, but your content backlog doesn’t. You meant to blog for every SKU, yet the work turns into a grind: pulling product details, checking nutrition labels, writing “unique” copy, then trying to remember what you already published.

This is what ecommerce marketers end up doing late at night. Shopify store owners feel it when organic traffic stalls. And a content-focused agency gets crushed when a client adds 50 new products. Shopify blog automation fixes the repeat work and turns product data into publish-ready posts.

This workflow pulls your Shopify products, uses GPT-4o to read nutrition facts from images, generates SEO blog HTML, publishes to Shopify, then logs every outcome to Google Sheets so you don’t create duplicates. Here’s the moving parts, the results you can expect, and what you’ll need to run it.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Shopify + Google Sheets: product blogs published fast

Click to explore

flowchart LR

    subgraph sg0["When clicking ‘Test workflow’ Flow"]
        direction LR
        n0@{ icon: "mdi:play-circle", form: "rounded", label: "When clicking ‘Test workflow’", pos: "b", h: 48 }
        n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/shopify.svg' width='40' height='40' /></div><br/>Shopify"]
        n2@{ icon: "mdi:swap-vertical", form: "rounded", label: "Split Out", pos: "b", h: 48 }
        n3@{ icon: "mdi:robot", form: "rounded", label: "OpenAI", pos: "b", h: 48 }
        n4@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model", pos: "b", h: 48 }
        n5@{ icon: "mdi:swap-horizontal", form: "rounded", label: "If", pos: "b", h: 48 }
        n6@{ icon: "mdi:cog", form: "rounded", label: "No Operation, do nothing", pos: "b", h: 48 }
        n7@{ icon: "mdi:web", form: "rounded", label: "Create Blog id", pos: "b", h: 48 }
        n8@{ icon: "mdi:web", form: "rounded", label: "Create Articles", pos: "b", h: 48 }
        n9@{ icon: "mdi:database", form: "rounded", label: "Read Sheet", pos: "b", h: 48 }
        n10@{ icon: "mdi:database", form: "rounded", label: "Update Sheet", pos: "b", h: 48 }
        n11@{ icon: "mdi:memory", form: "rounded", label: "Simple Memory", pos: "b", h: 48 }
        n12@{ icon: "mdi:swap-vertical", form: "rounded", label: "Main Product info", pos: "b", h: 48 }
        n13@{ icon: "mdi:robot", form: "rounded", label: "AI Blog Poster", pos: "b", h: 48 }
        n5 --> n12
        n5 --> n6
        n3 --> n5
        n1 --> n2
        n2 --> n3
        n9 -.-> n13
        n10 -.-> n13
        n11 -.-> n13
        n7 -.-> n13
        n8 -.-> n13
        n12 --> n13
        n4 -.-> n13
        n0 --> n1
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n0 trigger
    class n3,n13 ai
    class n4 aiModel
    class n11 ai
    class n1,n5 decision
    class n9,n10 database
    class n7,n8 api
    classDef customIcon fill:none,stroke:none
    class n1 customIcon

The Problem: Product blogging doesn’t scale past a handful of SKUs

Product-led blogging sounds simple until you try to do it consistently. One new product means hunting down the title, description, key benefits, and the “real” details customers actually care about (like nutrition facts or ingredients). Then comes the hard part: writing something search engines will respect, formatting it for Shopify, and keeping a record so you don’t accidentally publish the same product twice. Multiply that by a growing catalog and it becomes a weekly fire drill. Honestly, it’s the kind of task that makes teams quietly give up on content.

The friction compounds. Here’s where it breaks down in real life:

Someone has to copy product info into a doc, and small inconsistencies creep in fast.
Nutrition labels live in images, which means manual reading and re-typing (and yes, mistakes).
Without a tracking log, duplicates happen and your blog becomes a messy archive instead of a strategy.
Publishing isn’t just “paste and go” because Shopify needs clean HTML, not a rough draft.

The Solution: Turn Shopify products into publish-ready blog posts (and track everything)

This n8n workflow takes your existing Shopify product data and turns it into a structured SEO blog post you can publish automatically. It starts by pulling products from Shopify, then processes each product image to find useful details like nutrition facts (the workflow uses GPT-4o for image understanding, so you’re not stuck doing manual OCR work). If the product has enough valid nutrition info, the workflow builds a clean “content package” from the product title, description, and extracted data. From there, an AI agent generates a complete article in HTML, including headings, bullet points, and a nutrition table. Finally, the workflow publishes the post to Shopify using the Blog + Article API flow and logs the result in Google Sheets so you can retry failures and avoid duplicates later.

The workflow begins with a manual trigger (or a schedule if you prefer), then Shopify → AI analysis → content generation → Shopify publishing. Google Sheets sits alongside the whole process as the source of truth for what’s already done, what failed, and what needs a retry.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

Pulls product titles, descriptions, and images directly from Shopify.
Analyzes product images to extract nutrition details without manual typing.
Generates a full SEO blog post in structured HTML, including a nutrition table.
Publishes the blog article to Shopify and updates a Google Sheets tracking log.

Turn one product into one publishable post in about 10–20 minutes of hands-off processing.
Fewer “did we already post this?” moments because the sheet becomes your audit trail.
More consistent on-page structure across your catalog (headings, bullets, tables).
Cleaner execution for teams, since retries and errors are visible in one place.
Scalable catalog marketing that doesn’t require hiring extra writers per SKU.

Example: What This Looks Like

Say you want to publish blogs for 30 products this month. Manually, you might spend about 20 minutes collecting product details, another 15 minutes reading nutrition labels from images, and roughly 45 minutes writing and formatting per post. That’s about 2 hours per product, or roughly 60 hours total. With this workflow, you trigger the run once, let it process in the background, and only spot-check the outputs. Most teams end up spending a couple of hours total on review instead of several workdays of writing.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Shopify for product data and blog publishing
Google Sheets to track status and prevent duplicates
OpenAI API key (GPT-4o) (get it from your OpenAI dashboard)

Skill level: Intermediate. You’ll connect accounts, add API credentials, and confirm Shopify API permissions.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

You trigger a run. It starts from a Manual Trigger in n8n, which is ideal for testing. Many teams switch this to a Cron schedule once they trust the output cadence.

Shopify products are pulled and prepared. The workflow retrieves product details (title, description, images), then splits images so each one can be analyzed individually. This matters because nutrition panels are often only visible on one image.

AI extracts nutrition data and filters out weak matches. GPT-4o analyzes each image for nutrition facts. If there’s no usable info, the workflow skips that item so you don’t publish low-confidence posts that look made up.

Content is generated, published, and logged. An AI agent generates structured HTML, then HTTP requests create the Shopify blog record and publish the article. Google Sheets is read and updated so you can see what published, what failed, and what should not run again.

You can easily modify the tracking rules to match your own workflow, like “only publish products in a certain collection” or “retry failures after 24 hours” based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Manual Trigger

Start the workflow manually so you can verify the Shopify product and OCR steps before publishing blogs.

Add the Manual Start Trigger node as the workflow trigger.
Keep the default settings; no parameters are required for Manual Start Trigger.
Connect Manual Start Trigger to Retrieve Shopify Products.

Step 2: Connect Shopify Product Retrieval

Pull all Shopify products and split image records so each image can be analyzed for nutrition facts.

Open Retrieve Shopify Products and set Resource to product, Operation to getAll, and Return All to true.
Credential Required: Connect your shopifyAccessTokenApi credentials in Retrieve Shopify Products.
Open Expand Image Records and set Field to Split Out to images.
Confirm the execution flow: Manual Start Trigger → Retrieve Shopify Products → Expand Image Records.

Step 3: Set Up Nutrition OCR and Conditional Routing

Analyze each product image for nutrition facts, then route only valid results forward.

In Nutrition OCR Analysis, set Resource to image, Operation to analyze, and Image URLs to {{ $json.src }}.
Keep the provided OCR prompt in Text to ensure only valid nutrition facts are extracted.
Credential Required: Connect your openAiApi credentials in Nutrition OCR Analysis.
In Nutrition Check, set the condition to check {{ $json.content }} notEquals null.
Route the true output of Nutrition Check to Core Product Details, and the false output to Skip Action.

Tip: If you see many products skipping, verify that images actually contain a readable nutrition facts table and that {{ $json.src }} is populated.

Step 4: Prepare Product Data and AI Blog Agent

Map core product fields and configure the AI agent that generates blogs and coordinates the tools.

In Core Product Details, set fields with expressions: title to {{ $('Retrieve Shopify Products').item.json.title }}, id to {{ $('Retrieve Shopify Products').item.json.id }}, and body_html to {{ $('Retrieve Shopify Products').item.json.body_html }}.
Keep Include Other Fields set to true in Core Product Details.
In AI Blog Publisher, keep the Text value that passes {{ $json.id }}, {{ $json.title }}, {{ $json.body_html }}, and {{ $json.content }} to the agent.
Connect Chat Model Engine as the language model for AI Blog Publisher. Credential Required: Connect your openAiApi credentials in Chat Model Engine.
Connect Session Memory Buffer as the memory for AI Blog Publisher and set Session Key to {{ $('Core Product Details').item.json.id }} and Context Window Length to 20.

⚠️ Common Pitfall: The AI tools and memory nodes are sub-nodes. Add credentials to the parent nodes like Chat Model Engine and not to Session Memory Buffer.

Step 5: Configure AI Tools for Tracking and Publishing

The AI agent calls Google Sheets and Shopify HTTP tools to check tracking status, generate blogs, publish articles, and record results.

Open Read Tracking Sheet and set Document ID to your sheet ID (replace [YOUR_ID]) and Sheet Name to gid=0.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Read Tracking Sheet.
Open Update Tracking Sheet, keep Operation as appendOrUpdate, and confirm matching column Product Id. Ensure the mapping uses the AI expressions like {{ $fromAI('Product_Id', ``, 'string') }}.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Update Tracking Sheet.
Open Generate Blog Record and set URL to https://smartworkflow.myshopify.com/admin/api/2024-01/blogs.json with Method set to POST and JSON Body set to {{ $fromAI('JSON', ``, 'json') }}.
Open Publish Blog Article and set URL to {{ $fromAI('URL', ``, 'string') }}, Method to POST, and JSON Body to {{ $fromAI('JSON', ``, 'json') }}.
Credential Required: Connect your shopifyAccessTokenApi credentials in both Generate Blog Record and Publish Blog Article.
Note that Read Tracking Sheet, Update Tracking Sheet, Generate Blog Record, and Publish Blog Article are AI tools attached to AI Blog Publisher, so credentials should be set on each tool node as configured.

Tip: In the tracking sheet, ensure the column names exactly match: Timestamp, Product Id, Proudct name, Blog title , Blog url, Blog Html, Retry, Error.

Step 6: Test and Activate Your Workflow

Run a manual execution to confirm products are read, nutrition facts are extracted, and blogs are generated and tracked.

Click Execute Workflow starting from Manual Start Trigger to test the flow end-to-end.
Verify that Nutrition OCR Analysis outputs valid JSON in content and that Nutrition Check routes true results to Core Product Details.
Confirm AI Blog Publisher calls Read Tracking Sheet, then Generate Blog Record and Publish Blog Article, and finally updates Update Tracking Sheet.
Check Shopify to ensure a blog and article are created, and verify the tracking sheet has a new row with Retry set to No.
When testing is successful, activate the workflow for production use.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

Shopify credentials can expire or need specific permissions. If things break, check your Shopify Admin app access scopes and token status first.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.

Frequently Asked Questions

How long does it take to set up this Shopify blog automation automation?

About an hour if your Shopify, OpenAI, and Google Sheets access is ready.

Do I need coding skills to automate Shopify blog automation?

No. You will mostly connect accounts and paste in API credentials. The only “technical” part is confirming Shopify API permissions and testing a run.

Is n8n free to use for this Shopify blog automation workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API usage, which is usually a few cents per product depending on images and article length.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this Shopify blog automation workflow for non-nutrition products?

Yes, but you’ll want to swap the nutrition extraction step for a different “image-to-data” or “PDF-to-data” prompt. In n8n, that usually means editing the GPT-4o analysis node to extract specs, ingredients, sizing charts, or use-cases instead of macros, then updating the AI Blog Publisher prompt to reflect the new sections. Common customizations include skipping image analysis entirely, generating multiple post templates by product type, and only publishing items from a specific Shopify collection.

Why is my Shopify connection failing in this workflow?

Usually it’s an access token issue or missing scopes for reading products and writing blog articles. Regenerate the token in Shopify Admin, then update the credentials in n8n and re-test the “Retrieve Shopify Products” and publishing HTTP requests. If it fails only on publishing, double-check that the blog and article endpoints you’re calling match your store’s API version.

How many products can this Shopify blog automation automation handle?

A lot.

Is this Shopify blog automation automation better than using Zapier or Make?

For this workflow, n8n is usually the better fit because you’re doing branching logic (skip vs. generate), multi-step AI processing, and Shopify API calls that benefit from more control. Zapier and Make can do parts of it, but the moment you add image analysis, retries, and “don’t publish duplicates” rules, costs and complexity tend to climb. n8n also gives you the option to self-host, which matters when you’re generating content across a large catalog. If you only need a simple “new row in Sheets → create a draft post” flow, the simpler tools can be fine. Talk to an automation expert if you want help choosing.

Once this is running, product blogging stops being a recurring project and becomes a background process. Your catalog grows, your content grows with it, and you get your time back for the work that actually moves revenue.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": "",
"name": "Automated Shopify Blog Builder",
"versionId": "",
"meta": {
"instanceId": "33d61a8b4040c25b7fc30ca6deece25b8f0e7ec4b5bdbe8bda14c8ee180f39f4",
"templateId": null,
"templateCredsSetupCompleted": null
},
"nodes": [
{
"id": "flowpast-topbar-4735",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
60,
75
],
"parameters": {
"color": 7,
"width": 1520,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "096ccd11-0ae4-4e3d-aeac-d180c09512ae",
"name": "Manual Start Trigger",
"type": "n8n-nodes-base.manualTrigger",
"position": [
970,
175
],
"parameters": [],
"typeVersion": 1
},
{
"id": "c95491ab-6e4e-4671-bfaf-b8a362d2ec01",
"name": "Retrieve Shopify Products",
"type": "n8n-nodes-base.shopify",
"position": [
685,
270
],
"parameters": {
"resource": "product",
"operation": "getAll",
"returnAll": true,
"authentication": "accessToken",
"additionalFields": []
},
"credentials": {
"shopifyAccessTokenApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "1620e19b-cd01-4798-858c-8f2fb3d58087",
"name": "Expand Image Records",
"type": "n8n-nodes-base.splitOut",
"position": [
545,
180
],
"parameters": {
"options": [],
"fieldToSplitOut": "images"
},
"typeVersion": 1
},
{
"id": "944ab8ba-6e41-4e04-b442-9468ff341ba0",
"name": "Nutrition OCR Analysis",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
270,
295
],
"parameters": {
"text": "=You are an expert OCR and nutrition facts extractor. You carefully extract only the exact nutritional data present in the image without fabricating or guessing. You can recognize nutritional facts tables, and you know how to distinguish between actual nutrition data and promotional or partial text. You return null if no clear nutrition facts table or readable nutritional information is present.\n\n\nYou will analyze an image containing a product's nutritional information. Extract all nutritional data exactly as shown in the image, including nutrient names, amounts, units, and daily values if present.\n\n- If the image clearly contains a nutritional facts table or full nutritional data, output it in clean JSON format, where each nutrient is a key and the value contains the amount, unit, and daily value if available.\n- If the image shows only partial, blurry, or promotional text like \"20% protein\" or any incomplete nutritional data, do NOT fabricate any values; instead, return null.\n- If there is no clear nutritional facts table or nutritional data visible in the image, return null.\n- Do not guess or invent any numbers.\n- Only include information that is confidently present and readable in the image.\n\nExample output when nutrition facts are present:\n\n{\n  \"Calories\": \"190\",\n  \"Total Fat\": {\n    \"amount\": \"8g\",\n    \"daily_value\": \"10%\"\n  },\n  \"Cholesterol\": {\n    \"amount\": \"0mg\",\n    \"daily_value\": \"0%\"\n  },\n  ...\n}\n\nExample output when no valid nutritional facts table or data is visible:\n\nnull\n",
"modelId": {
"__rl": true,
"mode": "list",
"value": "chatgpt-4o-latest",
"cachedResultName": "CHATGPT-4O-LATEST"
},
"options": {
"detail": "auto",
"maxTokens": 900
},
"resource": "image",
"imageUrls": "={{ $json.src }}",
"operation": "analyze"
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.8
},
{
"id": "de84b88d-e96e-4c3c-a9f9-71cfc413022e",
"name": "Nutrition Check",
"type": "n8n-nodes-base.if",
"position": [
120,
210
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "6aa4dfe1-d907-47e8-b97e-3a77bb30c1d0",
"operator": {
"type": "string",
"operation": "notEquals"
},
"leftValue": "={{ $json.content }}",
"rightValue": "null"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "9ef20e21-7ad8-409f-a13e-e1088ec4e4a3",
"name": "Skip Action",
"type": "n8n-nodes-base.noOp",
"position": [
60,
455
],
"parameters": [],
"typeVersion": 1
},
{
"id": "486be3b5-dc25-4c5a-bde7-daaeff56308e",
"name": "Core Product Details",
"type": "n8n-nodes-base.set",
"position": [
295,
450
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "93cb8cc0-cdcd-44da-8187-9df85b770293",
"name": "title",
"type": "string",
"value": "={{ $('Retrieve Shopify Products').item.json.title }}"
},
{
"id": "95990abc-b64d-4cb4-8d4e-88145395a3fc",
"name": "id",
"type": "number",
"value": "={{ $('Retrieve Shopify Products').item.json.id }}"
},
{
"id": "d833cfa1-9abf-4a9d-86ed-a713acbc1974",
"name": "body_html",
"type": "string",
"value": "={{ $('Retrieve Shopify Products').item.json.body_html }}"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "6d708bbb-9c9c-419a-883b-d7e48e89e82a",
"name": "AI Blog Publisher",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
480,
620
],
"parameters": {
"text": "=Product id : {{ $json.id }}\nProduct title : {{ $json.title }}    \n\nProduct Description html : {{ $json.body_html }}\n\nProduct Nutrition Facts : {{ $json.content }}\n\n",
"options": {
"systemMessage": "=You are an AI agent responsible for automating blog creation for Shopify products using Google Sheets as a tracking system.\n\n## Step-by-step Workflow:\n\n### 1. Read Google Sheet\nBefore doing anything, call the Read Sheet tool to check if a blog has already been created for the Product ID. The sheet contains columns:\n\n- Timestamp\n- Product Id\n- Product name\n- Blog title\n- Blog url\n- Blog Html\n- Retry\n- Error\n\nCall this tool first and look up the row with the same Product Id.\n\n### 2. Check Conditions:\n- If the Product Id exists and Retry = No, skip this item.\n- If Retry = Yes, retry blog creation from Step 3.\n- If the Product Id is not found, proceed to Step 3 to generate and post a new blog.\n\n---\n\n### 3. Generate Blog Content\nBased on the following provided in the user message:\n- Product ID\n- Product Title\n- Product Description HTML\n- Product Nutrition Facts \n\nGenerate:\n- SEO-Friendly Blog Title\n- Meta Description\n- Formatted Blog Content in clean, structured HTML:\n  - Introduction summary\n  - H2/H3 subheadings\n  - Bullet points (key benefits, nutrients)\n  - Nutrient callouts or tables (if available)\n  - Closing paragraph or CTA\n  - Add internal keywords (tags)\n\n---\n\n### 4. Create Blog (HTTP Tool Call)\nCall the Shopify API to create a blog:\n\njson\n{\n  \"tool_call\": {\n    \"tool\": \"http\",\n    \"name\": \"Create Blog\",\n    \"method\": \"POST\",\n    \"url\": \"https://smartworkflow.myshopify.com/admin/api/2024-01/blogs.json\",\n    \"body\": {\n      \"blog\": {\n        \"title\": \"[SEO Blog Title]\"\n      }\n    }\n  }\n}\nOnce the blog.id is returned, post the article to:\n\n\nhttps://smartworkflow.myshopify.com/admin/api/2024-01/blogs/{{blog.id}}/articles.json\njson\nCopy\nEdit\n{\n  \"tool_call\": {\n    \"tool\": \"http\",\n    \"name\": \"Create Article\",\n    \"method\": \"POST\",\n    \"url\": \"https://smartworkflow.myshopify.com/admin/api/2024-01/blogs/{{blog.id}}/articles.json\",\n    \"body\": {\n      \"article\": {\n        \"title\": \"[Same Blog Title]\",\n        \"body_html\": \"[Generated HTML content]\",\n        \"tags\": \"nutrition, wellness, product, shopify\",\n        \"published\": false\n      }\n    }\n  }\n}\n6. Update Google Sheet\nIf Blog is Posted Successfully\nCall Update Sheet tool and set:\n\n\n{\n  \"Timestamp\":{{ $now }} ,\n  \"Product Id\": \"{{ $json.id }}\",\n  \"Product name\": \"{{ $json.title }}\",\n  \"Blog title\": \"[SEO Blog Title]\",\n  \"Blog url\": \"[Generated URL from blog.id and article.id]\",\n  \"Blog Html\": \"[Generated HTML]\",\n  \"Retry\": \"No\",\n  \"Error\": \"\"\n}\nIf Blog or Article Fails\nLog the error in Error column and set Retry = Yes.\n\n\n{\n  \"Product Id\": \"{{ $json.id }}\",\n  \"Retry\": \"Yes\",\n  \"Error\": \"[Detailed error message]\"\n}\n\nNotes:\nAlways call Read Sheet first before blog generation.\n\nRetry logic is based strictly on the Retry column.\n\nAll tool call responses should be handled using proper try-catch/error-check patterns.\n\nEnsure HTML is clean and includes correct spacing, paragraphs, H2s, bullet lists, and optionally nutrient tables.\n"
},
"promptType": "define"
},
"typeVersion": 1.9
},
{
"id": "49448095-a73a-4fdb-9354-f3e442f100b4",
"name": "Session Memory Buffer",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
710,
485
],
"parameters": {
"sessionKey": "={{ $('Core Product Details').item.json.id }}",
"sessionIdType": "customKey",
"contextWindowLength": 20
},
"typeVersion": 1.3
},
{
"id": "390bd7e4-b7bc-4575-9fe4-36a81445c7d3",
"name": "Chat Model Engine",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
695,
750
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": []
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "60d74f7d-cc66-4af6-bb8d-686c3eb320cb",
"name": "Read Tracking Sheet",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
1240,
520
],
"parameters": {
"options": [],
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "blog_details"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Blog update sheet"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.5
},
{
"id": "75976a59-7017-4e2c-ab12-d2e3448b6566",
"name": "Update Tracking Sheet",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
1220,
700
],
"parameters": {
"columns": {
"value": {
"Error": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Error', ``, 'string') }}",
"Retry": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Retry', ``, 'string') }}",
"Blog url": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Blog_url', ``, 'string') }}",
"Blog Html": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Blog_Html', ``, 'string') }}",
"Timestamp": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Timestamp', ``, 'string') }}",
"Product Id": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Product_Id', ``, 'string') }}",
"Blog title ": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Blog_title_', ``, 'string') }}",
"Proudct name": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Proudct_name', ``, 'string') }}"
},
"schema": [
{
"id": "Timestamp",
"type": "string",
"display": true,
"required": false,
"displayName": "Timestamp",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Product Id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Product Id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Proudct name",
"type": "string",
"display": true,
"required": false,
"displayName": "Proudct name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Blog title ",
"type": "string",
"display": true,
"required": false,
"displayName": "Blog title ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Blog url",
"type": "string",
"display": true,
"required": false,
"displayName": "Blog url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Blog Html",
"type": "string",
"display": true,
"required": false,
"displayName": "Blog Html",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Retry",
"type": "string",
"display": true,
"required": false,
"displayName": "Retry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Error",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Error",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Product Id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "blog_details"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Blog update sheet"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.5
},
{
"id": "059199d7-0f80-40fc-9f45-ee4ef8d6475b",
"name": "Publish Blog Article",
"type": "n8n-nodes-base.httpRequestTool",
"position": [
1480,
760
],
"parameters": {
"url": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('URL', ``, 'string') }}",
"method": "POST",
"options": [],
"jsonBody": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('JSON', ``, 'json') }}",
"sendBody": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "shopifyAccessTokenApi"
},
"credentials": {
"shopifyAccessTokenApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.2
},
{
"id": "0cfadf47-06c7-4b00-b660-87241cc4bf4c",
"name": "Generate Blog Record",
"type": "n8n-nodes-base.httpRequestTool",
"position": [
1460,
640
],
"parameters": {
"url": "=https://smartworkflow.myshopify.com/admin/api/2024-01/blogs.json",
"method": "POST",
"options": [],
"jsonBody": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('JSON', ``, 'json') }}",
"sendBody": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "shopifyAccessTokenApi"
},
"credentials": {
"shopifyAccessTokenApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.2
}
],
"pinData": [],
"connections": {
"Nutrition Check": {
"main": [
[
{
"node": "Core Product Details",
"type": "main",
"index": 0
}
],
[
{
"node": "Skip Action",
"type": "main",
"index": 0
}
]
]
},
"Nutrition OCR Analysis": {
"main": [
[
{
"node": "Nutrition Check",
"type": "main",
"index": 0
}
]
]
},
"Retrieve Shopify Products": {
"main": [
[
{
"node": "Expand Image Records",
"type": "main",
"index": 0
}
]
]
},
"Expand Image Records": {
"main": [
[
{
"node": "Nutrition OCR Analysis",
"type": "main",
"index": 0
}
]
]
},
"Read Tracking Sheet": {
"ai_tool": [
[
{
"node": "AI Blog Publisher",
"type": "ai_tool",
"index": 0
}
]
]
},
"Update Tracking Sheet": {
"ai_tool": [
[
{
"node": "AI Blog Publisher",
"type": "ai_tool",
"index": 0
}
]
]
},
"Session Memory Buffer": {
"ai_memory": [
[
{
"node": "AI Blog Publisher",
"type": "ai_memory",
"index": 0
}
]
]
},
"Generate Blog Record": {
"ai_tool": [
[
{
"node": "AI Blog Publisher",
"type": "ai_tool",
"index": 0
}
]
]
},
"Publish Blog Article": {
"ai_tool": [
[
{
"node": "AI Blog Publisher",
"type": "ai_tool",
"index": 0
}
]
]
},
"Core Product Details": {
"main": [
[
{
"node": "AI Blog Publisher",
"type": "main",
"index": 0
}
]
]
},
"Chat Model Engine": {
"ai_languageModel": [
[
{
"node": "AI Blog Publisher",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Manual Start Trigger": {
"main": [
[
{
"node": "Retrieve Shopify Products",
"type": "main",
"index": 0
}
]
]
}
}
}