Skip to main content

Ai blog generator for Shopify products using Google Gemini and Google Sheets

Workflow preview

Ai blog generator for Shopify products using Google Gemini and Google Sheets preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

Overview

This AI Blog Generator is an advanced n8n-powered automation workflow that leverages Google Gemini and Google Sheets to generate SEO-friendly blog articles for Shopify products. It automates the entire process — from fetching product data to creating structured HTML content — with zero manual effort.

💡 Key Advantages

Our AI Blog Generator offers five core advantages that make it the perfect solution for automated content creation:

  • 🔗 Shopify Product Sync — Automatically pulls product data (titles, descriptions, images, etc.) via Shopify API.
  • ✍️ SEO Blog Generation — Gemini generates blog titles, meta descriptions, and complete articles using product information.
  • 🗂️ Structured Content Output — Creates well-formatted HTML with headers and bullet points for seamless Shopify blog integration.
  • 📄 Google Sheets Integration — Tracks blog creation and prevents duplicate publishing using a centralized Google Sheet.
  • 📤 Shopify Blog API Integration — Publishes the generated blog to Shopify with a single API call.

⚙️ How It Works

The workflow follows a systematic 8-step process that ensures quality and efficiency:

Step-by-Step Process

  1. Manual Trigger – Start the workflow via a test trigger or scheduler.
  2. Fetch Products from Shopify – Retrieves all product details, including images and descriptions.
  3. Fix Input Format – Organizes and updates the input table using Code and Google Sheet nodes.
  4. Filter Duplicates – Ensures no previously used rows are processed again.
  5. Limit Control – Processes one row at a time and loops until all blogs are posted.
  6. Gemini AI Generation – Creates SEO-friendly blog content in HTML format from product data.
  7. HTML Structure Fix – Adjusts content for JSON compatibility by cleaning unsupported HTML tags.
  8. Article API Posting – Sends finalized blog content to Shopify for publishing or drafting.

🛠️ Setup Steps

Required Node Configuration

To implement this workflow, you'll need to configure the following n8n nodes:

  • Trigger Node: Start the workflow instantly.
  • Shopify Node: Fetch product details.
  • Google Sheet Node: Store input/output data and track blog creation status.
  • Code Node: Format data as required.
  • Filter Node: Remove used rows to avoid duplication.
  • Limit Node: Process one blog at a time.
  • Agent Node: Sends prompt to Gemini and returns parsed SEO-ready content.
  • HTTP Node: Posts content to Shopify via the API.

🔐 Credentials Required

Authentication Setup

Before running the workflow, ensure you have the following credentials configured:

  • Shopify Access Token – For fetching products and posting blogs
  • Gemini API Key – For AI-powered blog generation
  • Google Sheets OAuth – For logging and tracking workflow data

👤 Ideal For

Target Users

This automation workflow is specifically designed for:

  • Ecommerce teams automating blogs for hundreds of products
  • Shopify store owners boosting organic traffic effortlessly
  • Marketing teams building scalable, AI-driven content workflows

💬 Bonus Tip

Extensibility Features

The workflow is fully modular and highly customizable. You can easily extend it for:

  • Internal linking between related products
  • Multi-language translation for global markets
  • Social media sharing automation
  • Email marketing integration

All extensions can be implemented within the same n8n flow, making it a comprehensive content automation solution.