Generate SEO/AEO-optimized Shopify blog articles with GPT-4 and Google Sheets
Ready for 3.0What 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).
- Set - Config (Edit Fields (Set)): sets or maps fields
- Sheets - Read Keywords (Google Sheets): uses Google Sheets
- Sheets - Read Links (Google Sheets): uses Google Sheets
- Sheets - Read Published (Google Sheets): uses Google Sheets
- Merge: merges the data from its input branches
- Code: runs custom JavaScript code
- Code: runs custom JavaScript code
- Merge: merges the data from its input branches
- Code: runs custom JavaScript code
- Code: runs custom JavaScript code
…plus 12 more steps. See the full node list below.
Services it uses
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)
- Manual Trigger
n8n-nodes-base.manualTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if
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,…