Generate Shopify collection blog posts with Perplexity, Gemini and Google Sheets

by MANISH KUMAR ✓ · 275 views · created 2026-01-13 · Content Creation, Multimodal AI

What this workflow does

This AI workflow has 51 nodes and runs on Shopify events (plus 3 other triggers). Along the way it connects Shopify, Google Sheets, Google Gemini Chat Model and Google Gemini. It also calls shopify-staged-uploads.storage.googleapis.com and nl-astools.myshopify.com over HTTP.

How it runs

Trigger: On Shopify events (plus 3 other triggers).

1. data allocation (Edit Fields (Set)): sets 5 fields: id, title, handle…
2. collection API call (HTTP Request): calls an HTTP API (POST)
3. data allocation (Edit Fields (Set)): sets 2 fields: title, handle
4. get old collection (Google Sheets): uses Google Sheets
5. collection data storing (Google Sheets): append
6. devide items (Split Out): splits a list into separate items
7. article creation (HTTP Request): calls an HTTP API (POST)
8. data allocation (Edit Fields (Set)): sets 8 fields: id, title, handle…
9. 2 Sec delay (Wait): waits 2 seconds
10. batch size (Loop Over Items (Split in Batches)): loops over the items in batches

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

Services it uses

ShopifyGoogle SheetsGoogle Gemini Chat ModelGoogle Gemini

HTTP calls to: shopify-staged-uploads.storage.googleapis.com, nl-astools.myshopify.com

Before you upgrade to n8n 3.0

Nodes used (19)

• Shopify Triggern8n-nodes-base.shopifyTrigger
• Edit Fields (Set)n8n-nodes-base.set
• HTTP Requestn8n-nodes-base.httpRequest
• Manual Triggern8n-nodes-base.manualTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
• Perplexityn8n-nodes-base.perplexity
• AI Agent@n8n/n8n-nodes-langchain.agent
• Simple Memory@n8n/n8n-nodes-langchain.memoryBufferWindow
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Coden8n-nodes-base.code
• Waitn8n-nodes-base.wait
• Split Outn8n-nodes-base.splitOut
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Limitn8n-nodes-base.limit
• Auto-fixing Output Parser@n8n/n8n-nodes-langchain.outputParserAutofixing
• Google Gemini@n8n/n8n-nodes-langchain.googleGemini
• Ifn8n-nodes-base.if

From the author

Shopify Collections to AI Blog Automation Pipeline This Shopify AI automation is an advanced n8n-powered workflow that transforms Shopify product collections into SEO-optimized blog articles with images, while maintaining full visibility and control through…

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