January 22, 2026

Shopify + Google Sheets: blog posts published clean

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Your product catalog changes, inventory shifts, promos come and go. But your blog? It’s usually the thing that falls behind because creating posts means copy-pasting product details, chasing approvals, and trying not to publish the same idea twice.

This is the kind of mess Shopify store owners feel first. Marketing managers trying to grow organic traffic get stuck in the same loop. And agencies managing multiple stores? They live here. This Shopify blog automation turns product data into trackable drafts and published posts without the constant busywork.

Below, you’ll see exactly how the workflow runs in n8n, what outcomes to expect, and what you need to set it up so it stays clean as you scale.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Shopify + Google Sheets: blog posts published clean

Click to explore

flowchart LR

    subgraph sg0["Start Creation Flow"]
        direction LR
        n0@{ icon: "mdi:play-circle", form: "rounded", label: "Start Creation", 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/>Get All Product Details"]
        n2@{ icon: "mdi:database", form: "rounded", label: "Product Details to Sheet", pos: "b", h: 48 }
        n3["<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/code.svg' width='40' height='40' /></div><br/>Fix the input format"]
        n4@{ icon: "mdi:database", form: "rounded", label: "Update the sheet", pos: "b", h: 48 }
        n5@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Filter Duplicates", pos: "b", h: 48 }
        n6@{ icon: "mdi:robot", form: "rounded", label: "Magic Room", pos: "b", h: 48 }
        n7@{ icon: "mdi:brain", form: "rounded", label: "Gemini", pos: "b", h: 48 }
        n8@{ icon: "mdi:robot", form: "rounded", label: "Output Parser", pos: "b", h: 48 }
        n9@{ icon: "mdi:brain", form: "rounded", label: "Gemini1", pos: "b", h: 48 }
        n10@{ icon: "mdi:cog", form: "rounded", label: "Limit = 1", pos: "b", h: 48 }
        n11@{ icon: "mdi:database", form: "rounded", label: "Update Blog Content", pos: "b", h: 48 }
        n12["<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/code.svg' width='40' height='40' /></div><br/>Fix Content Format"]
        n13["<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/httprequest.dark.svg' width='40' height='40' /></div><br/>Blog Creation"]
        n14@{ icon: "mdi:database", form: "rounded", label: "Status Update", pos: "b", h: 48 }
        n15@{ icon: "mdi:cog", form: "rounded", label: "Nothing", pos: "b", h: 48 }
        n16@{ icon: "mdi:cog", form: "rounded", label: "Nothing1", pos: "b", h: 48 }
        n17@{ icon: "mdi:database", form: "rounded", label: "Update Input table", pos: "b", h: 48 }
        n7 -.-> n6
        n9 -.-> n8
        n10 --> n6
        n6 --> n17
        n6 --> n11
        n13 --> n14
        n8 -.-> n6
        n14 --> n16
        n0 --> n1
        n4 --> n5
        n5 --> n10
        n5 --> n15
        n12 --> n13
        n11 --> n12
        n3 --> n4
        n1 --> n2
        n2 --> n3
    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 n6,n8 ai
    class n7,n9 aiModel
    class n1,n5 decision
    class n2,n4,n11,n14,n17 database
    class n13 api
    class n3,n12 code
    classDef customIcon fill:none,stroke:none
    class n1,n3,n12,n13 customIcon

The Problem: Blog publishing gets messy at scale

Writing “just one more product post” sounds simple until you do it every week for a catalog of 50, 200, or 1,000 products. You pull titles and descriptions from Shopify, grab images, rewrite everything into a blog format, then try to keep it SEO-friendly and on-brand. Meanwhile, you still need a way to track what’s already been drafted or published. Miss that part and you’ll create duplicates, overwrite a draft, or publish something half-finished. Honestly, the mental load is the worst part.

The friction compounds. Here’s where it breaks down.

Copying product info into a doc or CMS takes about 20 minutes per post, and it’s easy to miss key specs or benefits.
Without a single tracking sheet, teams lose track of what’s “drafted,” “needs review,” or already published.
Duplicate prevention becomes a manual ritual, so it gets skipped when you’re busy.
Even when the writing is done, turning it into clean HTML for Shopify blog publishing is another tedious step.

The Solution: Generate Shopify blog drafts from product data (then publish)

This n8n workflow starts by pulling your Shopify product catalog, then logging those products into Google Sheets so you have a simple, visible queue. From there, it normalizes the product payload (so fields are consistent), checks the sheet to find unused entries, and processes one product at a time to keep the output predictable. Then Google Gemini generates an SEO-friendly blog draft in structured HTML based on the product’s details. Before anything is published, the workflow sanitizes the HTML so Shopify’s API accepts it cleanly. Finally, it posts the article to Shopify and updates your Google Sheet with the publish status, so you always know what happened.

The workflow begins when you manually launch it (or schedule it later). It pulls products from Shopify, runs a duplicate check in Google Sheets, and sends a single product’s data through Gemini for a draft. After a quick HTML cleanup, the post is published (or drafted) in Shopify and logged back to the sheet.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

It pulls Shopify product titles, descriptions, and media into a workable dataset.
It logs and manages a content queue in Google Sheets, including “used” status.
It generates SEO blog content via Gemini, formatted as structured HTML.
It posts the cleaned article to Shopify through an HTTP request and records the outcome.

Most teams get 4–6 draft posts created in about an hour of hands-off time.
You stop second-guessing what was already processed because the sheet becomes your source of truth.
Fewer duplicate posts, because unused rows are filtered before generation.
Cleaner reviews, since drafts follow a repeatable structure instead of ad hoc formatting.
More consistent publishing cadence, even when the team is slammed.

Example: What This Looks Like

Say you want to publish 10 product-based blog posts each week. Manually, if each post takes about 20 minutes to pull product info, 40 minutes to write, and 10 minutes to format and publish, that’s roughly 70 minutes per post (close to 12 hours weekly). With this workflow, you spend about 10 minutes setting the rules once and then hit run. Gemini drafts the posts, n8n logs everything in Google Sheets, and Shopify publishing happens automatically, so your weekly effort becomes review time instead of production time.

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 drafts and prevent duplicates
Google Gemini API key (get it from Google AI Studio)

Skill level: Intermediate. You’ll connect accounts, paste API credentials, and make small edits to prompts and field mappings.

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

How It Works

You launch the run. The workflow starts from a manual trigger, which is perfect for testing. Once you like the output, you can swap in a schedule so it runs daily or weekly.

Product data is pulled and organized. n8n fetches your Shopify catalog, logs products into Google Sheets, and normalizes fields so the AI prompt gets consistent inputs. Clean inputs matter more than people think.

Duplicates are blocked before they happen. An “unused entries” check routes only fresh rows into the generator, then a limit control processes one item at a time. That keeps drafts from colliding and makes troubleshooting much easier.

Gemini drafts, then Shopify receives. The agent node sends product context to Gemini, parses structured output, sanitizes the HTML for API compatibility, and posts the finished article via HTTP request. Google Sheets is updated again with the publish status so your team can review, spot errors, or re-run safely.

You can easily modify the prompt and the “publish vs draft” behavior based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Manual Trigger

This workflow starts manually so you can run it on demand while you validate your Shopify and Google Sheets setup.

Add the Manual Launch Trigger node as the trigger for the workflow.

Flowpast Branding as a visual reference note; it does not affect execution.

Step 2: Connect Shopify and Google Sheets Data Sources

Pull your Shopify product catalog and log it into Google Sheets. Multiple Google Sheets nodes are used for input, refined data, drafts, and status updates.

Configure Fetch Product Catalog with Resource set to product, Operation set to getAll, Return All enabled, and Authentication set to accessToken.
Credential Required: Connect your shopifyAccessTokenApi credentials.
Set up Log Products to Sheet with Operation set to appendOrUpdate, Document set to [YOUR_ID], and Sheet set to gid=0 (row_data).
Map columns in Log Products to Sheet using expressions: title to {{ $('Fetch Product Catalog').item.json.title }}, Images to {{ $('Fetch Product Catalog').item.json.images }}, handle to {{ $('Fetch Product Catalog').item.json.handle }}, product_id to {{ $('Fetch Product Catalog').item.json.id }}, and description to {{ $('Fetch Product Catalog').item.json.body_html }}.
Credential Required: Connect your googleSheetsOAuth2Api credentials.
Configure the remaining Google Sheets nodes (Write Refined Sheet, Mark Input Used, Append Blog Drafts, Update Publish Status) with the same Google Sheets document [YOUR_ID] and their respective sheet IDs (25757113 and 1548183235).
Credential Required: Connect your googleSheetsOAuth2Api credentials to all Google Sheets nodes.

Tip: Use a single Google Sheets OAuth credential across all five Google Sheets nodes to simplify maintenance and avoid token conflicts.

Step 3: Normalize Product Data and Filter Unused Entries

This stage converts raw Shopify data into structured fields, stores refined data, and selects one unused entry for drafting.

In Normalize Product Payload, keep the provided JavaScript to generate cleanDescription, normalize images, and build the refined payload.
Configure Write Refined Sheet with Operation set to appendOrUpdate and column mappings: title to {{ $json.title }}, handle to {{ $json.handle }}, Image_1 to {{ $json.imageSources[0] }}, Image_2 to {{ $json.imageSources[1] }}, Image_3 to {{ $json.imageSources[2] }}, Image_4 to {{ $json.imageSources[3] }}, blog_id to [YOUR_ID], product_id to {{ $json.product_id }}, blog_status to unused, and description to {{ $json.cleanDescription }}.
Set Check Unused Entries to allow items where blog_status equals unused or is empty using expressions {{ $json.blog_status }} with Right Value unused and .
Leave Limit to Single Item as-is to process only one product per run.
Route the false path of Check Unused Entries to No Action Path to safely exit if there are no unused entries.

⚠️ Common Pitfall: If Write Refined Sheet uses the wrong sheet ID, the Check Unused Entries condition will never match and no drafts will be generated.

Step 4: Set Up the AI Draft Composer

The AI pipeline generates structured blog drafts using Gemini and a strict output parser.

In AI Draft Composer, set Text to =Input fields provided: \n- Title: {{ $json.title }}\n- Description: {{ $json.description }} and leave Prompt Type as define with Has Output Parser enabled.
Connect Gemini Model Bridge as the AI language model for AI Draft Composer.
Credential Required: Connect your googlePalmApi credentials.
Attach Structured Output Parser to AI Draft Composer and keep Auto Fix enabled with the JSON schema example provided.
Credential Required: Credentials for parsers should be added to the parent model—ensure Gemini Parser Model has googlePalmApi credentials.
Connect Gemini Parser Model as the language model for Structured Output Parser.
Credential Required: Connect your googlePalmApi credentials.

Tip: Keep the JSON-only response requirement in AI Draft Composer unchanged to ensure the parser can reliably extract blog_title, content, and metadata.

Step 5: Configure Draft Logging and Publishing

After AI drafting, the workflow logs drafts, sanitizes HTML, publishes to Shopify, and updates status in Google Sheets.

AI Draft Composer outputs to both Mark Input Used and Append Blog Drafts in parallel.
In Mark Input Used, set product_id to {{ $('Limit to Single Item').item.json.product_id }} and blog_status to used.
Credential Required: Connect your googleSheetsOAuth2Api credentials.
In Append Blog Drafts, set content to {{ $json.output.content }}, excerpt to {{ $json.output.excerpt }}, blog_title to {{ $json.output.blog_title }}, page_title to {{ $json.output.page_title }}, product_id to {{ $('Limit to Single Item').item.json.product_id }}, URL _handle to {{ $('Limit to Single Item').item.json.handle }}, blog_status to generated, and meta_description to {{ $json.output.meta_description }}.
Credential Required: Connect your googleSheetsOAuth2Api credentials.
Keep Sanitize Blog HTML as-is to escape HTML for Shopify JSON compatibility.
Configure Publish Blog Article with URL set to https://[YOUR_SHOP].myshopify.com/admin/api/2025-07/blogs/[YOUR_ID]/articles.json, Method set to POST, and JSON Body set to ={ "article": { "title": "{{ $json.blog_title }}", "author": "[YOUR_NAME]", "tags": "Electronics", "body_html": "{{ $json.body_html }}", "published_at": "{{$now}}" } }.
Credential Required: Connect your shopifyAccessTokenApi credentials.
In Update Publish Status, set article_id to {{ $json.article.id }}, product_id to {{ $('Append Blog Drafts').item.json.product_id }}, and blog_status to posted.
Credential Required: Connect your googleSheetsOAuth2Api credentials.
Allow Update Publish Status to complete at No Action End for a clean termination path.

⚠️ Common Pitfall: If you forget to replace [YOUR_SHOP], [YOUR_ID], or [YOUR_NAME] in Publish Blog Article, Shopify will reject the request.

Step 6: Test and Activate Your Workflow

Run a manual test to verify the full end-to-end flow before enabling in production.

Click Execute Workflow to trigger Manual Launch Trigger and monitor each node’s output.
Confirm new rows appear in the sheets updated by Log Products to Sheet, Write Refined Sheet, Append Blog Drafts, and Update Publish Status.
Verify that Publish Blog Article returns an article.id and the Shopify blog post appears as expected.
If no unused items are found, confirm the workflow safely exits via No Action Path.
Once successful, save the workflow and activate it for scheduled or manual production runs.

🔒

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 private app/custom app access token scopes first (and confirm the blog/article endpoints are allowed).
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 45 minutes if your Shopify, Sheets, and Gemini access are ready.

Do I need coding skills to automate Shopify blog automation?

No coding is required for the basic setup. You’ll mostly map fields, connect credentials, and adjust the Gemini prompt to match your store.

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 Gemini API usage costs, which depend on your model and how long your articles are.

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 draft-only publishing?

Yes, but you’ll want to do it intentionally. Keep the same Shopify fetch and Google Sheets tracking, then adjust the “Publish Blog Article” HTTP request to create drafts (or route to a “needs review” path) instead of publishing immediately. Common customizations include changing the prompt structure, adding internal links between related products, and generating multi-language versions for specific collections.

Why is my Shopify connection failing in this workflow?

Usually it’s an access token scope issue or an expired token. Regenerate your Shopify access token, confirm it can read products and write blog articles, then update the credential in n8n. If it fails only sometimes, you may also be hitting Shopify API throttling, especially when you pull a large catalog and run drafts back-to-back.

How many posts can this Shopify blog automation automation handle?

A lot.

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

For AI-driven blog pipelines like this, n8n is usually the more comfortable fit because you can branch, loop one product at a time, and sanitize HTML before publishing without paying extra for “premium” logic steps. You also get the option to self-host, which matters when you’re generating lots of drafts across a big catalog. Zapier or Make can still work, but the moment you need structured parsing, conditional duplicate checks, and a publish-status feedback loop, the scenario tends to sprawl. If you want simple “new row in sheet → create draft” and nothing else, they may be faster to set up. If you’re unsure, Talk to an automation expert and get a straight recommendation.

Once this is running, your blog stops being a “someday” project. It becomes a system that quietly ships content while you focus on merchandising, offers, and growth.

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 Product Blog Publisher",
"versionId": "",
"meta": {
"instanceId": "12d1e99a96cdd2ad44c7612a493e82c88c35bcb615752abc24d30a5ee738f038",
"templateId": null,
"templateCredsSetupCompleted": null
},
"nodes": [
{
"id": "flowpast-topbar-8575",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 1320,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "83e6e157-fb98-4bad-a9e9-c043d6f7db16",
"name": "Manual Launch Trigger",
"type": "n8n-nodes-base.manualTrigger",
"position": [
0,
135
],
"parameters": [],
"typeVersion": 1
},
{
"id": "701f86cb-5169-4b09-9d74-2f1d7ac445af",
"name": "Fetch Product Catalog",
"type": "n8n-nodes-base.shopify",
"position": [
230,
120
],
"parameters": {
"resource": "product",
"operation": "getAll",
"returnAll": true,
"authentication": "accessToken",
"additionalFields": []
},
"credentials": {
"shopifyAccessTokenApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "db453c4b-34ac-4a59-91be-51fde818984f",
"name": "Log Products to Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
480,
150
],
"parameters": {
"columns": {
"value": {
"title": "={{ $('Fetch Product Catalog').item.json.title }}",
"Images": "={{ $('Fetch Product Catalog').item.json.images }}",
"handle": "={{ $('Fetch Product Catalog').item.json.handle }}",
"product_id": "={{ $('Fetch Product Catalog').item.json.id }}",
"description": "={{ $('Fetch Product Catalog').item.json.body_html }}"
},
"schema": [
{
"id": "product_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "product_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "description",
"type": "string",
"display": true,
"required": false,
"displayName": "description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "handle",
"type": "string",
"display": true,
"required": false,
"displayName": "handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Images",
"type": "string",
"display": true,
"required": false,
"displayName": "Images",
"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": "row_data"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "shopify_blog_n8n"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7
},
{
"id": "c9653b2e-3560-4986-8459-8632aecd557b",
"name": "Normalize Product Payload",
"type": "n8n-nodes-base.code",
"position": [
720,
125
],
"parameters": {
"jsCode": "// Function to process ALL input items (multiple products)\nconst allItems = $input.all();\nconst processedItems = [];\n\n// Function to process a single product\nfunction processProductData(inputData) {\n  try {\n    const result = {\n      product_id: null,\n      title: null,\n      handle: null,\n      description: '',        // keep original HTML\n      cleanDescription: '',   // plain text\n      imageSources: [],       // Always an array\n      totalImages: 0,\n      error: null\n    };\n\n    // Add fields as is\n    if (inputData.product_id !== undefined && inputData.product_id !== null) {\n      result.product_id = inputData.product_id;\n    }\n    if (inputData.title !== undefined && inputData.title !== null) {\n      result.title = inputData.title;\n    }\n    if (inputData.handle !== undefined && inputData.handle !== null) {\n      result.handle = inputData.handle;\n    }\n\n    // Process description\n    if (inputData.description) {\n      // 1. Keep original HTML (Shopify supports this)\n      result.description = inputData.description;\n\n      // 2. Generate plain text version\n      let cleanDescription = inputData.description\n        .replace(/<[^>]*>/g, '') // strip tags\n        .replace(/&/g, '&')\n        .replace(/</g, '<')\n        .replace(/>/g, '>')\n        .replace(/"/g, '\"')\n        .replace(/'/g, \"'\")\n        .replace(/ /g, ' ')\n        .replace(/\\n+/g, '\\n')\n        .replace(/[ \\t]+/g, ' ')\n        .replace(/\\n /g, '\\n')\n        .trim();\n\n      // escape for JSON safety\n      cleanDescription = cleanDescription\n        .replace(/\\\\/g, '\\\\\\\\')\n        .replace(/\"/g, '\\\\\"')\n        .replace(/\\n/g, '\\\\n');\n\n      result.cleanDescription = cleanDescription;\n    }\n\n    // Process images - ENSURE IT'S AN ARRAY\n    if (inputData.Images && Array.isArray(inputData.Images)) {\n      result.imageSources = inputData.Images\n        .filter(image => image && image.src && image.src.trim() !== '')\n        .map(image => image.src.trim())\n        .filter((src, index, array) => array.indexOf(src) === index);\n\n      result.totalImages = result.imageSources.length;\n    }\n    // Handle case where Images might be a string\n    else if (inputData.Images && typeof inputData.Images === 'string') {\n      try {\n        const parsedImages = JSON.parse(inputData.Images);\n        if (Array.isArray(parsedImages)) {\n          result.imageSources = parsedImages\n            .filter(image => image && image.src && image.src.trim() !== '')\n            .map(image => image.src.trim())\n            .filter((src, index, array) => array.indexOf(src) === index);\n\n          result.totalImages = result.imageSources.length;\n        }\n      } catch (parseError) {\n        console.log('Error parsing Images string:', parseError);\n        result.imageSources = [];\n        result.totalImages = 0;\n      }\n    }\n\n    return result;\n\n  } catch (error) {\n    return {\n      product_id: inputData.product_id || null,\n      title: inputData.title || null,\n      handle: inputData.handle || null,\n      description: '',\n      cleanDescription: '',\n      imageSources: [],\n      totalImages: 0,\n      error: error.message\n    };\n  }\n}\n\n// Process each item\nfor (let i = 0; i < allItems.length; i++) {\n  const processedItem = processProductData(allItems[i].json);\n  processedItems.push({ json: processedItem });\n}\n\n// Return all processed items\nreturn processedItems;\n"
},
"typeVersion": 2
},
{
"id": "da3c0cba-80d7-4ebb-a9fc-91d1dc900fcd",
"name": "Write Refined Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
680,
365
],
"parameters": {
"columns": {
"value": {
"title": "={{ $json.title }}",
"handle": "={{ $json.handle }}",
"Image_1": "={{ $json.imageSources[0] }}",
"Image_2": "={{ $json.imageSources[1] }}",
"Image_3": "={{ $json.imageSources[2] }}",
"Image_4": "={{ $json.imageSources[3] }}",
"blog_id": "[YOUR_ID]",
"product_id": "={{ $json.product_id }}",
"blog_status": "unused",
"description": "={{ $json.cleanDescription }}"
},
"schema": [
{
"id": "product_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "product_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "blog_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "blog_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "blog_status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "blog_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "description",
"type": "string",
"display": true,
"required": false,
"displayName": "description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "handle",
"type": "string",
"display": true,
"required": false,
"displayName": "handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image_1",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Image_1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image_2",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Image_2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image_3",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Image_3",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image_4",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Image_4",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"product_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 25757113,
"cachedResultUrl": "",
"cachedResultName": "refined_input"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "shopify_blog_n8n"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7
},
{
"id": "a9a6b7b7-2948-4827-ac71-6abd55da8b5a",
"name": "Check Unused Entries",
"type": "n8n-nodes-base.if",
"position": [
440,
385
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "or",
"conditions": [
{
"id": "9e037f0f-ed95-41e5-b229-80befb372ff7",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.blog_status }}",
"rightValue": "=unused"
},
{
"id": "55aa4e25-b574-4c48-97f8-80ff6b402724",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.blog_status }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "c7623b7a-0575-4ab9-b4cb-6647374aa87d",
"name": "Limit to Single Item",
"type": "n8n-nodes-base.limit",
"position": [
210,
365
],
"parameters": [],
"typeVersion": 1
},
{
"id": "3f421a55-3e62-44ff-8f75-822691bb0a03",
"name": "AI Draft Composer",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
0,
390
],
"parameters": {
"text": "=Input fields provided:  \n- Title: {{ $json.title }}\n- Description: {{ $json.description }}",
"options": {
"systemMessage": "=You are an expert content writer who creates concise, high-converting product blog posts for Shopify stores. \n\nYour output must follow this exact structure, using HTML tags for formatting, and adhering to ideal word/character counts for readability and engagement.\n\nWrite a blog post using the following structure:\n\n1. **Title** (within <h1> tags)  \n- Make it catchy and relevant to the product title, approximately 8\u201312 words and 50\u201370 characters.  \n\n2. **Introduction** (within <p> tags)  \n- Write 40\u201360 words (250\u2013350 characters) that hook the reader by highlighting a relatable problem, followed by a quick product benefit summary.\n\n3. **Key Features** (within <ul> and <li> tags)  \n- List the top 4\u20136 features in short, scannable bullet points totaling 50\u2013100 words (300\u2013600 characters).\n\n4. **Customer Reviews / Experience** (within <blockquote> or <div> tags)  \n- Include 2\u20133 short, authentic-sounding customer testimonials or experiences, total 80\u2013120 words (450\u2013700 characters).\n\n5. **Use Case Callout** (within <p> tags, optionally with <strong>)  \n- Briefly define who the product is ideal for, in 40\u201360 words (250\u2013350 characters).\n\n6. **Call to Action** (within <p> tags)  \n- Close with a clear invitation to buy or learn more, about 20\u201340 words (120\u2013250 characters).\n\nAdditionally, at the end of the output provide:  \n- An excerpt summary (max 160 characters) without tags  \n- A page title suitable for SEO (under 60 characters)  \n- A meta description (140\u2013160 characters) summarizing the blog content for search engines  \n\n---\n\nOutput the content with proper HTML markup and all requested fields exactly like this JSON:  \n\n{\n  \\\"blog_title\\\": \\\"[Your formatted <h1> title here without tags]\\\",\n  \\\"content\\\": \\\"[Full HTML content as a string with tags as per the structure above]\\\",\n  \\\"excerpt\\\": \\\"[SEO-friendly excerpt summary]\\\",\n  \\\"page_title\\\": \\\"[SEO page title]\\\",\n  \\\"meta_description\\\": \\\"[SEO meta description]\\\"  \n}\n\nWrite the response ONLY as this JSON object without any additional commentary or text.\n"
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2.2
},
{
"id": "a22f016d-fc40-4b8f-8d63-55c888175601",
"name": "Gemini Model Bridge",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
0,
235
],
"parameters": {
"options": []
},
"credentials": {
"googlePalmApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "4d2eacd5-3f48-4c63-898b-3246c7a118d3",
"name": "Structured Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
220,
245
],
"parameters": {
"autoFix": true,
"jsonSchemaExample": "{\n  \"blog_title\": \"blog_title\",\n  \"content\": \"content_html\",\n  \"excerpt\": \"excerpt\",\n  \"page_title\": \"page_title\",\n  \"meta_description\": \"meta_description\"\n}\n"
},
"typeVersion": 1.3
},
{
"id": "41194322-ba19-45b8-acb8-b5b9cb9dbebd",
"name": "Gemini Parser Model",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
440,
235
],
"parameters": {
"options": []
},
"credentials": {
"googlePalmApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "ebd6d255-ffef-457f-b568-39a1f3bb3641",
"name": "Mark Input Used",
"type": "n8n-nodes-base.googleSheets",
"position": [
100,
555
],
"parameters": {
"columns": {
"value": {
"product_id": "={{ $('Limit to Single Item').item.json.product_id }}",
"blog_status": "used"
},
"schema": [
{
"id": "product_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "product_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "blog_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "blog_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "blog_status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "blog_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "description",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "handle",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image_1",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Image_1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image_2",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Image_2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image_3",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Image_3",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image_4",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Image_4",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"product_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 25757113,
"cachedResultUrl": "",
"cachedResultName": "refined_input"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "shopify_blog_n8n"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7
},
{
"id": "a615f9c7-7adf-4b9c-8188-f26f4d5407e9",
"name": "Append Blog Drafts",
"type": "n8n-nodes-base.googleSheets",
"position": [
280,
605
],
"parameters": {
"columns": {
"value": {
"content": "={{ $json.output.content }}",
"excerpt": "={{ $json.output.excerpt }}",
"blog_title": "={{ $json.output.blog_title }}",
"page_title": "={{ $json.output.page_title }}",
"product_id": "={{ $('Limit to Single Item').item.json.product_id }}",
"URL _handle": "={{ $('Limit to Single Item').item.json.handle }}",
"blog_status": "generated",
"meta_description": "={{ $json.output.meta_description }}"
},
"schema": [
{
"id": "product_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "product_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "blog_title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "blog_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "content",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "content",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "excerpt",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "excerpt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "page_title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "page_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "meta_description",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "meta_description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL _handle",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "URL _handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "blog_status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "blog_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "article_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "article_id",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"product_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1548183235,
"cachedResultUrl": "",
"cachedResultName": "blog_post"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "shopify_blog_n8n"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7
},
{
"id": "c4f97660-c407-4b82-80e9-1fb3a5057bfe",
"name": "Sanitize Blog HTML",
"type": "n8n-nodes-base.code",
"position": [
530,
580
],
"parameters": {
"jsCode": "// Get input JSON\nlet input = $input.first().json;\n\n// Function to convert raw HTML into Shopify-safe JSON string\nfunction makeJsonSafe(html) {\n  return html\n    .replace(/\\\\/g, \"\\\\\\\\\")    // escape backslashes\n    .replace(/\"/g, '\\\\\"')      // escape quotes\n    .replace(/\\n/g, \"\\\\n\")     // escape line breaks\n    .replace(/\\r/g, \"\");       // remove carriage returns (Windows line breaks)\n}\n\n// Process body_html\nlet safeContent = makeJsonSafe(input.content);\n\n// Return all fields in correct JSON structure\nreturn {\n  json: {\n    blog_title: input.blog_title,\n    excerpt: input.excerpt,\n    page_title: input.page_title,\n    meta_description: input.meta_description,\n    \"URL _handle\": input[\"URL _handle\"],\n    blog_status: input.blog_status,\n    body_html: safeContent\n  }\n};\n"
},
"typeVersion": 2
},
{
"id": "29e2dedd-1eae-414e-a6b7-ea5824547e58",
"name": "Publish Blog Article",
"type": "n8n-nodes-base.httpRequest",
"position": [
780,
625
],
"parameters": {
"url": "https://[YOUR_SHOP].myshopify.com/admin/api/2025-07/blogs/[YOUR_ID]/articles.json",
"method": "POST",
"options": [],
"jsonBody": "={\n  \"article\": {\n    \"title\": \"{{ $json.blog_title }}\",\n    \"author\": \"[YOUR_NAME]\",\n    \"tags\": \"Electronics\",\n    \"body_html\": \"{{ $json.body_html }}\",\n    \"published_at\": \"{{$now}}\"\n  }\n}\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "shopifyAccessTokenApi"
},
"credentials": {
"shopifyAccessTokenApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.2
},
{
"id": "5cc50b49-1adb-4598-8fd4-9e9e2d710912",
"name": "Update Publish Status",
"type": "n8n-nodes-base.googleSheets",
"position": [
1010,
600
],
"parameters": {
"columns": {
"value": {
"article_id": "={{ $json.article.id }}",
"product_id": "={{ $('Append Blog Drafts').item.json.product_id }}",
"blog_status": "posted"
},
"schema": [
{
"id": "product_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "product_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "blog_title",
"type": "string",
"display": true,
"required": false,
"displayName": "blog_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "content",
"type": "string",
"display": true,
"required": false,
"displayName": "content",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "excerpt",
"type": "string",
"display": true,
"required": false,
"displayName": "excerpt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "page_title",
"type": "string",
"display": true,
"required": false,
"displayName": "page_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "meta_description",
"type": "string",
"display": true,
"required": false,
"displayName": "meta_description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL _handle",
"type": "string",
"display": true,
"required": false,
"displayName": "URL _handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "blog_status",
"type": "string",
"display": true,
"required": false,
"displayName": "blog_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "article_id",
"type": "string",
"display": true,
"required": false,
"displayName": "article_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"product_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1548183235,
"cachedResultUrl": "",
"cachedResultName": "blog_post"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "shopify_blog_n8n"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7
},
{
"id": "a976c2f9-2ad3-4d9c-8eaf-8d4be4887a16",
"name": "No Action Path",
"type": "n8n-nodes-base.noOp",
"position": [
460,
555
],
"parameters": [],
"typeVersion": 1
},
{
"id": "759af36b-3460-4a4e-8ca6-c3ee970babbd",
"name": "No Action End",
"type": "n8n-nodes-base.noOp",
"position": [
1220,
625
],
"parameters": [],
"typeVersion": 1
}
],
"pinData": [],
"connections": {
"Gemini Model Bridge": {
"ai_languageModel": [
[
{
"node": "AI Draft Composer",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Gemini Parser Model": {
"ai_languageModel": [
[
{
"node": "Structured Output Parser",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Limit to Single Item": {
"main": [
[
{
"node": "AI Draft Composer",
"type": "main",
"index": 0
}
]
]
},
"AI Draft Composer": {
"main": [
[
{
"node": "Mark Input Used",
"type": "main",
"index": 0
},
{
"node": "Append Blog Drafts",
"type": "main",
"index": 0
}
]
]
},
"Publish Blog Article": {
"main": [
[
{
"node": "Update Publish Status",
"type": "main",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "AI Draft Composer",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Update Publish Status": {
"main": [
[
{
"node": "No Action End",
"type": "main",
"index": 0
}
]
]
},
"Manual Launch Trigger": {
"main": [
[
{
"node": "Fetch Product Catalog",
"type": "main",
"index": 0
}
]
]
},
"Write Refined Sheet": {
"main": [
[
{
"node": "Check Unused Entries",
"type": "main",
"index": 0
}
]
]
},
"Check Unused Entries": {
"main": [
[
{
"node": "Limit to Single Item",
"type": "main",
"index": 0
}
],
[
{
"node": "No Action Path",
"type": "main",
"index": 0
}
]
]
},
"Sanitize Blog HTML": {
"main": [
[
{
"node": "Publish Blog Article",
"type": "main",
"index": 0
}
]
]
},
"Append Blog Drafts": {
"main": [
[
{
"node": "Sanitize Blog HTML",
"type": "main",
"index": 0
}
]
]
},
"Normalize Product Payload": {
"main": [
[
{
"node": "Write Refined Sheet",
"type": "main",
"index": 0
}
]
]
},
"Fetch Product Catalog": {
"main": [
[
{
"node": "Log Products to Sheet",
"type": "main",
"index": 0
}
]
]
},
"Log Products to Sheet": {
"main": [
[
{
"node": "Normalize Product Payload",
"type": "main",
"index": 0
}
]
]
}
}
}