Convert Shopify products into Blog content with DeepSeek and Sheets
Needs changesWhat this workflow does
This AI workflow has 13 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Shopify, Google Sheets, Gmail and OpenRouter Chat Model.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Shopify: get many (product)
- variables (Edit Fields (Set)): sets 5 fields: title, id, body_html…
- Product Data in Google Sheet (Google Sheets): append or update
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Wait: waits 1 seconds
- AI Agent: runs an AI agent, with model: OpenRouter Chat Model; memory: Simple Memory
- Gmail: uses Gmail
- Code: runs custom JavaScript code
- Google Sheets: append or update
- Create Blog As Draft (HTTP Request): calls an HTTP API (POST)
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI Agent (v1.9): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Agent (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (12)
- Shopify
n8n-nodes-base.shopify - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - AI Agent
@n8n/n8n-nodes-langchain.agent - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Code
n8n-nodes-base.code - Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - Gmail
n8n-nodes-base.gmail - Wait
n8n-nodes-base.wait - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Edit Fields (Set)
n8n-nodes-base.set
From the author
Overview Stop struggling with content creation for your e-commerce store. This workflow acts as your automated AI Content Marketer, instantly transforming your Shopify product details into high-quality, SEO-optimized blog posts. It handles everything from…