Turn new Shopify products into SEO blogs with Perplexity, Gemini and Sheets

by MANISH KUMAR ✓ · 1,539 views · created 2025-12-29 · Content Creation, Multimodal AI

What this workflow does

This AI workflow has 17 nodes and runs on Shopify events. Along the way it connects Shopify, Google Gemini Chat Model and Google Sheets.

How it runs

Trigger: On Shopify events.

1. input set (Edit Fields (Set)): sets 7 fields: id, title, body_html…
2. input update (Google Sheets): append
3. web search (Perplexity): uses Perplexity
4. content generator (AI Agent): runs an AI agent, with model: Gemini; memory: Memory; output parser: Output Parser
5. HTML structuring (Code): runs custom JavaScript code
6. update content (Google Sheets): update
7. error handling (Switch): routes items into 2 branches
8. get product data (Google Sheets): uses Google Sheets
9. article creation (HTTP Request): calls an HTTP API (POST)
10. update blog post status (Google Sheets): update

Services it uses

ShopifyGoogle Gemini Chat ModelGoogle Sheets

Before you upgrade to n8n 3.0

Nodes used (13)

• Shopify Triggern8n-nodes-base.shopifyTrigger
• Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
• No Operation, do nothingn8n-nodes-base.noOp
• Edit Fields (Set)n8n-nodes-base.set
• Google Sheetsn8n-nodes-base.googleSheets
• Perplexityn8n-nodes-base.perplexity
• AI Agent@n8n/n8n-nodes-langchain.agent
• Simple Memory@n8n/n8n-nodes-langchain.memoryBufferWindow
• Auto-fixing Output Parser@n8n/n8n-nodes-langchain.outputParserAutofixing
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code
• Switchn8n-nodes-base.switch

From the author

Shopify Product-to-Blog Automation with Perplexity web search, Gemini AI Agent & Google Sheets Shopify Blog Automation (From Shopify product to SEO-optimized blog post — fully automated) This workflow is an advanced n8n-powered automation that transforms…

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