Templates / Generate SEO/AEO-optimized Shopify blog articles with GPT-4 and Google Sheets

Generate SEO/AEO-optimized Shopify blog articles with GPT-4 and Google Sheets

Ready for 3.0

by Geoffroy ✓ · 1,154 views · created 2025-09-30 · Content Creation, Multimodal AI

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 24 nodes and runs on a schedule (cron 0 9 * * 2,5) (plus 1 other trigger). Along the way it connects Google Sheets. It also calls api.openai.com over HTTP.

How it runs

Trigger: On a schedule (cron 0 9 * * 2,5) (plus 1 other trigger).

  1. Set - Config (Edit Fields (Set)): sets or maps fields
  2. Sheets - Read Keywords (Google Sheets): uses Google Sheets
  3. Sheets - Read Links (Google Sheets): uses Google Sheets
  4. Sheets - Read Published (Google Sheets): uses Google Sheets
  5. Merge: merges the data from its input branches
  6. Code: runs custom JavaScript code
  7. Code: runs custom JavaScript code
  8. Merge: merges the data from its input branches
  9. Code: runs custom JavaScript code
  10. Code: runs custom JavaScript code

…plus 12 more steps. See the full node list below.

Services it uses

Google Sheets

HTTP calls to: api.openai.com

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (8)

From the author

This n8n template demonstrates how to automatically generate and publish SEO/AEO-optimized Shopify blog articles from a list of keywords using AI for content creation, image generation, and metadata optimization. Who’s it for Shopify marketers, content teams,…

Excerpt from Geoffroy's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.