MANISH KUMAR
AI Engineer | Automation Architect | n8n Expert | API Integration I turn repetition into magic! Building workflows for: - Content creation (YouTube/social media) - Business ops (CRM/data pipelines) - Personal productivity (AI/smart home) - E-Commerce Automation solution Superpowers: API integrations • Debugging • Scalable solutions "Automation should adapt to humans" 📧 manipritraj@gmail.com
Templates by MANISH KUMAR
Generate Shopify product listings from images with Gemini AI and Airtable
Shopify Digital Product Automation (from just and image to complete Shopify product page.) This Shopify Digital Product Automation is an advanced n8n-powered workflow that leverages AI (Google Gemini), Airtable, and Shopify API to generate product details from images and automatically post them to Shopify. It fully automates the process — from uploading images to publishing Shopify products — with minimal manual effort. --- 💡 Key Advantages Our Shopify Digital Product Automation offers five core advantages: 🔗 Shopify Product Sync — Automatically posts product details including title, description, SEO fields, and matched category to Shopify. ✍️ AI-Powered Product Generation — Gemini analyzes uploaded images and generates engaging, SEO-friendly product titles, descriptions, and metadata. 🗂️ Structured Output — Outputs JSON-ready product data compatible with Shopify, ensuring smooth automation. 📄 Airtable Integration — Tracks uploaded images, analyzed data, and generated products to prevent duplication. 📤 End-to-End Automation — Handles the complete workflow from image upload to Shopify posting without manual intervention. --- ⚙️ How It Works The workflow follows a step-by-step automated process: Step-by-Step Process Upload Images – Add your digital artwork or poster images to Google Drive and record them in Airtable. Image Analysis – AI fetches new images and analyzes visual elements like characters, series, poster text, and style. Store Analysis Results – Updates analyzed data in Airtable and marks images as Used. Fetch Shopify Collections – Retrieves current collections from your Shopify store for category matching. Generate Product Details – Gemini generates product title, description, matched category, SEO page title, meta description, and URL handle. Save Generated Products – Stores generated product details in Airtable and marks them as generated. Post Products to Shopify – Automatically creates new products in Shopify using the API. Update Status – Marks products as posted in Airtable after successful posting. --- 🛠️ Setup Steps Required Node Configuration To implement this workflow, configure the following n8n nodes: Trigger Node – Start workflow manually or via scheduler. Airtable Node – Fetch raw images and store processed product details. Google Drive Node – Access image files. HTTP Request Node – Fetch Shopify collections. Code Node – Refine AI outputs and format product data. Split & Limit Nodes – Process images and products in batches. LangChain / Gemini Node – Generate product titles, descriptions, and SEO data. Shopify Node – Create products via Shopify API. Status Update Node – Update Airtable with processing and posting status. --- 🔐 Credentials Required Before running the workflow, ensure you have the following credentials configured: Shopify Access Token – For posting products and fetching collections. Gemini API Key – For AI-powered product generation. Airtable API Key – For storing and tracking workflow data. Google Drive OAuth – To access image files. --- 👤 Ideal For This automation workflow is designed for: Shopify store owners managing hundreds of digital products Ecommerce teams automating product listings Marketing teams needing scalable, AI-driven product content workflows --- 💬 Bonus Tip The workflow is fully modular and customizable. You can extend it to: Automatically assign prices or discounts Multi-language product description generation Social media promotion of new products Email campaign integration All extensions can be implemented within the same n8n flow, making it a complete digital product automation solution.
By MANISH KUMARAi blog generator for Shopify products using Google Gemini and Google Sheets
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 structured HTML content — with zero manual effort. 💡 Key Advantages Our AI Blog Generator offers five core advantages that make it the perfect solution for automated content creation: 🔗 Shopify Product Sync — Automatically pulls product data (titles, descriptions, images, etc.) via Shopify API. ✍️ SEO Blog Generation — Gemini generates blog titles, meta descriptions, and complete articles using product information. 🗂️ Structured Content Output — Creates well-formatted HTML with headers and bullet points for seamless Shopify blog integration. 📄 Google Sheets Integration — Tracks blog creation and prevents duplicate publishing using a centralized Google Sheet. 📤 Shopify Blog API Integration — Publishes the generated blog to Shopify with a single API call. ⚙️ How It Works The workflow follows a systematic 8-step process that ensures quality and efficiency: Step-by-Step Process Manual Trigger – Start the workflow via a test trigger or scheduler. Fetch Products from Shopify – Retrieves all product details, including images and descriptions. Fix Input Format – Organizes and updates the input table using Code and Google Sheet nodes. Filter Duplicates – Ensures no previously used rows are processed again. Limit Control – Processes one row at a time and loops until all blogs are posted. Gemini AI Generation – Creates SEO-friendly blog content in HTML format from product data. HTML Structure Fix – Adjusts content for JSON compatibility by cleaning unsupported HTML tags. Article API Posting – Sends finalized blog content to Shopify for publishing or drafting. 🛠️ Setup Steps Required Node Configuration To implement this workflow, you'll need to configure the following n8n nodes: Trigger Node: Start the workflow instantly. Shopify Node: Fetch product details. Google Sheet Node: Store input/output data and track blog creation status. Code Node: Format data as required. Filter Node: Remove used rows to avoid duplication. Limit Node: Process one blog at a time. Agent Node: Sends prompt to Gemini and returns parsed SEO-ready content. HTTP Node: Posts content to Shopify via the API. 🔐 Credentials Required Authentication Setup Before running the workflow, ensure you have the following credentials configured: Shopify Access Token – For fetching products and posting blogs Gemini API Key – For AI-powered blog generation Google Sheets OAuth – For logging and tracking workflow data 👤 Ideal For Target Users This automation workflow is specifically designed for: Ecommerce teams automating blogs for hundreds of products Shopify store owners boosting organic traffic effortlessly Marketing teams building scalable, AI-driven content workflows 💬 Bonus Tip Extensibility Features The workflow is fully modular and highly customizable. You can easily extend it for: Internal linking between related products Multi-language translation for global markets Social media sharing automation Email marketing integration All extensions can be implemented within the same n8n flow, making it a comprehensive content automation solution. ---
By MANISH KUMARTurn new Shopify products into SEO blogs with Perplexity, Gemini and Sheets
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 newly created Shopify products into professionally written, SEO-ready blog posts using AI. By combining Shopify Webhooks, Google Sheets, AI research, structured content generation, and automated HTML formatting, this workflow removes all manual work from product-based content marketing. --- 💡 Key Advantages This Shopify Product-to-Blog Automation delivers the following benefits: 🛍️ Shopify Product Sync Automatically captures new product data (title, description, vendor, type, images) the moment a product is created. 🧠 AI-Powered Research & Writing Uses AI to perform market analysis, identify customer intent, and generate structured, high-quality blog content. 📊 Google Sheets Tracking Maintains a clear audit trail of products, generated blogs, and publishing status to prevent duplication. 🧩 Structured Content Output Generates strict JSON-based blog sections (problem, solution, features, usage, comparison, CTA) for consistency and scalability. 📤 End-to-End Automation Handles everything — from product detection to blog publishing — with zero manual writing. --- ⚙️ How It Works Step-by-Step Process Shopify Trigger Listens for products/create events in Shopify. Product Data Extraction Normalizes product fields and selects the primary product image. Google Sheets Storage Stores raw product data and sets initial processing status. AI Market & SEO Research Analyzes product intent, audience, use cases, FAQs, and keyword opportunities. AI Blog Content Generation Creates structured, SEO-focused blog content using a LangChain AI agent. HTML Structuring Cleans, escapes, and formats content into Shopify-safe, responsive HTML. Shopify Blog Publishing Automatically posts the article to the Shopify Blog via Admin API. Status Update & Tracking Updates Google Sheets to reflect successful blog publication. --- 🛠️ Setup Steps Required Node Configuration To run this workflow, configure the following nodes: Shopify Trigger – Detect new product creation Set Node – Normalize Shopify product fields Google Sheets Nodes – Store and track workflow state AI Research Node – Market & SEO analysis LangChain / Gemini Agent – Blog content generation Code Node – HTML formatting and safety handling HTTP Request Node – Publish blog post to Shopify Error Handling Logic – Retry and fail-safe routing --- 🔐 Credentials Required Before enabling the workflow, configure these credentials: Shopify Admin API Access Token – For blog publishing Google Sheets OAuth – For data tracking Google Gemini API Key – For AI content generation Perplexity API Key – For research and SEO insights --- 👤 Ideal For This automation is ideal for: Shopify store owners using content marketing Ecommerce teams managing large product catalogs SEO teams scaling product-driven blog content Agencies offering automated Shopify SEO solutions --- 💬 Bonus Tip This workflow is fully modular and extensible. You can easily enhance it to: Auto-link blogs to products Generate multilingual blog posts Schedule delayed publishing Route content by product category Add internal linking or schema markup All extensions can be implemented within the same n8n workflow. --- ✅ Result Every new Shopify product automatically becomes: Research-backed SEO-optimized Professionally structured Automatically published No manual writing. No copy-paste. Fully automated. Keywords shopify ai shopify automation shopify marketing automation shopify blog automation shopify content automation ai blog generator shopify shopify seo automation ecommerce automation ai ecommerce automation shopify workflow automation shopify product to blog auto generate shopify blogs shopify ai content how to automate shopify
By MANISH KUMARDynamic Hubspot lead routing with GPT-4 and Airtable sales team distribution
AI Agent for Dynamic Lead Distribution (HubSpot + Airtable) 🧠 AI-Powered Lead Routing and Sales Team Distribution This intelligent n8n workflow automates end-to-end lead qualification and allocation by integrating HubSpot, Airtable, OpenAI, Gmail, and Slack. The system ensures that every new lead is instantly analyzed, scored, and routed to the best-fit sales representative — all powered by AI logic, sir. --- 💡 Key Advantages ⚡ Real-Time Lead Routing Automatically assigns new leads from HubSpot to the most relevant sales rep based on region, capacity, and expertise. 🧠 AI Qualification Engine An OpenAI-powered Agent evaluates the lead’s industry, region, and needs to generate a persona summary and routing rationale. 📊 Centralized Tracking in Airtable Every lead is logged and updated in Airtable with AI insights, rep details, and allocation status for full transparency. 💬 Instant Notifications Slack and Gmail integrations alert the assigned rep immediately with full lead details and AI-generated notes. 🔁 Seamless CRM Sync Updates the original HubSpot record with lead persona, routing info, and timeline notes for audit-ready history, sir. --- ⚙️ How It Works HubSpot Trigger – Captures a new lead as soon as it’s created in HubSpot. Fetch Contact Data – Retrieves all relevant fields like name, company, and industry. Clean & Format Data – A Code node standardizes and structures the data for consistency. Airtable Record Creation – Logs the lead data into the “Leads” table for centralized tracking. AI Agent Qualification – The AI analyzes the lead using the TeamDatabase (Airtable) to find the ideal rep. Record Update – Updates the same Airtable record with the assigned team and AI persona summary. Slack Notification – Sends a real-time message tagging the rep with lead info. Gmail Notification – Sends a personalized handoff email with context and follow-up actions. HubSpot Sync – Updates the original contact in HubSpot with the assignment details and AI rationale, sir. --- 🛠️ Setup Steps Trigger Node: HubSpot → Detect new leads. HubSpot Node: Retrieve complete lead details. Code Node: Clean and normalize data. Airtable Node: Log lead info in the “Leads” table. AI Agent Node: Process lead and match with sales team. Slack Node: Notify the designated representative. Gmail Node: Email the rep with details. HubSpot Node: Update CRM with AI summary and allocation status, sir. --- 🔐 Credentials Required HubSpot OAuth2 API – To fetch and update leads. Airtable Personal Access Token – To store and update lead data. OpenAI API – To power the AI qualification and matching logic. Slack OAuth2 – For sending team notifications. Gmail OAuth2 – For automatic email alerts to assigned reps, sir. --- 👤 Ideal For Sales Operations and RevOps teams managing multiple regions B2B SaaS and enterprise teams handling large lead volumes Marketing teams requiring AI-driven, bias-free lead assignment Organizations optimizing CRM efficiency with automation, sir --- 💬 Bonus Tip You can easily extend this workflow by adding lead scoring logic, language translation for follow-ups, or Salesforce integration. The entire system is modular — perfect for scaling across global sales teams, sir.
By MANISH KUMARAutomate Shopify product CSV from images using Gemini, GPT-4o, Google Drive & Sheets
Shopify AI Automation Image-to-Product CSV Bulk Upload Automation This Shopify AI automation is an advanced n8n-powered workflow that converts raw product images into a Shopify-ready product CSV. It uses AI image analysis, Google Drive, Google Sheets, and Shopify APIs to fully automate product onboarding — from images to structured ecommerce data. Built for scalable ecommerce automation, this workflow is especially effective for image-first catalogs such as jewelry, fashion, and accessories. --- 🚀 Features 🖼️ AI Image Analysis — Analyzes product images one by one for higher accuracy and lower risk 🧠 Automatic Category Detection — Identifies main product category (e.g. Jewelry), easily customizable for any niche ✍️ AI Product Content Generation — Creates product names, descriptions (HTML), tags, and attributes 📄 Google Sheets Orchestration — Structures data and outputs a clean Shopify-compatible CSV 🛍️ Shopify Asset Upload — Uploads images to Shopify and retrieves CDN URLs --- 🧩 Workflow Preparation Before running the workflow: Upload all product images to Google Drive Name images using the format: <SKU><ColorCode> Example: 12345GR Place all images inside a folder named:<Brand Name> Root folder name : pending Example : Google_Drive/pending/Manish Collection/All Images Each image represents one product variant. --- ⚙️ How It Works The workflow follows a 6-step automation pipeline designed for reliability and scalability. Notes : You may connect all these step to make it fully automatic or shecdule it according to your suitable time. --- 🔄 Step-by-Step Process Step 1: Fetch Images from Google Drive Scans the pending/<brand_name> folder Fetches all images Extracts SKU and color code Stores references in Google Sheets --- Step 2: AI Image Analysis (One-by-One) Images are analyzed individually Slower than batch processing, but far more reliable Reduces hallucinations and incorrect attributes Ideal for production-grade Shopify automation. --- Step 3: Main Category Identification AI determines the primary product category (example: Jewelry) Prompts can be modified for any ecommerce niche --- Step 4: Conditional Product Content Generation Based on category: Product titles are generated Descriptions are written in Shopify-ready HTML Tags and attributes are created This replaces repetitive work typically handled via Shopify Flow or manual data entry. --- Step 5: Shopify Image Upload Images are uploaded to Shopify assets Shopify returns CDN URLs URLs are mapped back to product data --- Step 6: Shopify CSV Generation All enriched data is compiled into a new Google Sheet Output matches Shopify’s product import CSV format File is ready for bulk upload --- 🛠️ n8n Nodes Used Trigger Node (Manual / Schedule) Google Drive Node Google Sheets Node AI Agent Node (Image Analysis + Content) Switch Node (Category-based logic) Code Node (Formatting & CSV structure) Shopify Node / HTTP Node --- 🔐 Credentials Required Before running the workflow, configure the following credentials in n8n: Shopify Access Token — For asset uploads and API calls AI Provider API Key — For image analysis and content generation Google Drive OAuth — To access product images Google Sheets OAuth — To store and export data --- 👤 Ideal For This workflow is ideal for: Shopify store owners handling bulk product uploads Ecommerce teams managing image-heavy catalogs Agencies building scalable Shopify automation systems Anyone exploring how to automate Shopify product onboarding --- 💬 Extensibility This workflow is modular and easy to extend. You can add: Multi-language product descriptions Pricing and margin automation Shopify marketing automation triggers Shopify Flow integrations after product import Marketplace exports (Google Shopping, Meta, Amazon) --- 🔑 Keywords shopify ai shopify flow shopify marketing automation shopify automation ecommerce automation how to automate shopify --- 📌 Notes No AI fine-tuning required No fragile prompt chaining Designed for accuracy over speed Safe for production ecommerce workflows --- 📞 Support If you’re looking to customize or extend this workflow, feel free to reach out or fork the project. Happy automating 🚀
By MANISH KUMAR