Ai blog generator for Shopify products using Google Gemini and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 18 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Shopify, Google Sheets and Google Gemini Chat Model. It also calls p7wqck-r7.myshopify.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get All Product Details (Shopify): get many (product)
- Product Details to Sheet (Google Sheets): append or update
- Fix the input format (Code): runs custom JavaScript code
- Update the sheet (Google Sheets): append or update
- Filter Duplicates (If): checks a condition and branches into true / false
- Limit: keeps the first few items
- Magic Room (AI Agent): runs an AI agent, with model: Gemini; output parser: Output Parser
- Update Input table (Google Sheets): append or update
- Update Blog Content (Google Sheets): append
- Fix Content Format (Code): runs custom JavaScript code
…plus 2 more steps. See the full node list below.
Services it uses
HTTP calls to: p7wqck-r7.myshopify.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 (11)
- Manual Trigger
n8n-nodes-base.manualTrigger - Shopify
n8n-nodes-base.shopify - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Limit
n8n-nodes-base.limit - HTTP Request
n8n-nodes-base.httpRequest - No Operation, do nothing
n8n-nodes-base.noOp
From the author
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…