Kumar Shivam
I'm an automation specialist who helps startups, agencies, and growth teams save time and scale faster using n8n. I design smart, reliable workflows that connect tools like HubSpot, Slack, OpenAI, Claude, Pipedrive, Google Ads, and vector databases (Qdrant, Pinecone). Whether it's auto-assigning leads, generating AI-powered reports, triggering Slack alerts, or syncing APIs — I build automations that just work. Let’s turn your manual processes into automated systems that scale.
Templates by Kumar Shivam
AI-powered restaurant order chatbot with GPT-4o for POS integration
This workflow automates the restaurant POS (Point of Sale) data management process, facilitating seamless order handling, customer tracking, inventory management, and sales reporting. It retrieves order details, processes payment information, updates inventory, and generates real-time sales reports, all integrated into a centralized system that improves restaurant operations. The workflow integrates various systems, including a POS terminal to gather order data, payment gateways to process transactions, inventory management tools to update stock, and reporting tools like Google Sheets or an internal database for generating sales and performance reports. Who Needs Restaurant POS Automation? This POS automation workflow is ideal for restaurant owners, managers, and staff looking to streamline their operations: Restaurant Owners – Automate order processing, track sales, and monitor inventory to ensure smooth operations. Managers – Access real-time sales data and performance reports to make informed decisions. Staff – Reduce manual work, focusing on providing better customer service while the system handles orders and payments. Inventory Teams – Automatically update inventory levels based on orders and ingredient usage. If you need a reliable and automated POS solution to manage restaurant orders, payments, inventory, and reporting, this workflow minimizes human error, boosts efficiency, and saves valuable time. Why Use This Workflow? End-to-End Automation – Automates everything from order input to inventory updates and sales reporting. Seamless Integration – Connects POS, payment systems, inventory management, and reporting tools for smooth data flow.(if needed) Real-Time Data – Provides up-to-the-minute reports on sales, stock levels, and order statuses. Scalable & Efficient – Supports multiple locations, multiple users, and high order volumes. Step-by-Step: How This Workflow Manages POS Data Collect Orders – Retrieves order details from the POS system, including customer information, ordered items, and payment details. Update Inventory – Decreases inventory levels based on sold items, ensuring stock counts are always accurate. Generate Reports – Compiles sales, revenue, and inventory data into real-time reports and stores them in Google Sheets or an internal database. Track Customer Data – Keeps a log of customer details and order history for better service and marketing insights. Customization: Tailor to Your Needs Multiple POS Systems – Adapt the workflow to work with different POS systems or terminals based on your restaurant setup. Custom Reporting – Modify the reporting format or include specific sales metrics (e.g., daily totals, best-selling items, employee performance). Inventory Management – Adjust inventory updates to include alerts when stock reaches critical levels or needs reordering. Integration with Accounting Software – Connect with platforms like QuickBooks for automated financial tracking. 🔑 Prerequisites POS System Integration – Ensure the POS system can export order data in a compatible format. Payment Gateway API – Set up the necessary API keys for payment processing (e.g., Stripe, PayPal). Inventory Management Tools – Use inventory software or databases that can automatically update stock levels. Reporting Tools – Use Google Sheets or an internal database to store and generate sales and inventory reports. 🚀 Installation & Setup Configure Credentials Set up API credentials for payment gateways and inventory management tools. Import Workflow Import the workflow into your automation platform (e.g., n8n, Zapier). Link POS system, payment gateway, and inventory management systems. Test & Run Process a test order to ensure that data flows correctly through each step. Verify that inventory updates and reports are generated as expected. ⚠ Important Data Privacy – Ensure compliance with data protection regulations (e.g., GDPR, PCI DSS) when handling customer payment and order data. System Downtime – Monitor system performance to ensure that the workflow runs without disruptions during peak hours. Summary This restaurant POS automation workflow integrates order management, payment processing, inventory updates, and real-time reporting, enabling efficient restaurant operations. Whether you are running a single location or a chain of restaurants, this solution streamlines daily tasks, reduces errors, and provides valuable insights, saving time and improving customer satisfaction. 🚀
By Kumar ShivamAI blog generator for Shopify product listings: Using GPT-4o and Google Sheets
🧠 AI Blog Generator for Shopify Products using GPT-4o The AI Blog Generator is an advanced automation workflow powered by n8n, integrating GPT-4o and Google Sheets to generate SEO-rich blog articles for Shopify products. It automates the entire process — from pulling product data, analyzing images for nutritional information, to producing structured HTML content ready for publishing — with zero manual writing. --- 💡 Key Advantages 🔗 Shopify Product Sync Automatically pulls product data (title, description, images, etc.) via Shopify API. 🤖 AI-Powered Nutrition Extraction Uses GPT-4o to intelligently analyze product images and extract nutritional information. ✍️ SEO Blog Generation GPT-4o generates blog titles, meta descriptions, and complete articles using both product metadata and extracted nutritional info. 🗂️ Structured Content Output Produces well-formatted HTML with headers, bullet points, and nutrition tables for seamless Shopify blog integration. 📄 Google Sheets Integration Tracks blog creation, manages retries, and prevents duplicate publishing using a centralized Google Sheet. 📤 Shopify Blog API Integration Publishes the generated blog to Shopify using a two-step blog + article API call. --- ⚙️ How It Works Manual Trigger Initiate the process using a test trigger or a scheduler. Fetch Products from Shopify Retrieves all product details including descriptions and images. Extract Product Images Splits and processes each image individually. OCR + Nutrition AI GPT-4o reads nutrition facts from product images. Skips items without valid info. Check Existing Logs References a Google Sheet to avoid duplicates and determine retry status. AI Blog Generation Creates a blog with headings, bullet points, intro, and a nutrition table. Shopify Blog + Article Posting Uses the Shopify API to publish the blog and its content. Update Google Sheet Logs the blog URL, HTML content, errors, and status for future reference. --- 🛠️ Setup Steps Shopify Node: Connects to your Shopify store and fetches product data. Split Out Node: Divides product images for individual OCR processing. OpenAI Node: Uses GPT-4o to extract nutrition data from images. If Node: Filters for entries with valid nutrition information. Edit Fields Node: Formats the product data for AI processing. AI Agent Node: Generates SEO blog content. Google Sheets Nodes: Reads and updates blog creation status. HTTP Request Nodes: Posts the blog and article via Shopify’s API. --- 🔐 Credentials Required Shopify Access Token – For retrieving product data and posting blogs OpenAI API Key – For GPT-4o-based AI generation and image processing Google Sheets OAuth – For accessing the log sheet --- 👤 Ideal For Ecommerce teams looking to automate content for hundreds of products Shopify store owners aiming to boost organic traffic through blogging Marketing teams building scalable, AI-driven content workflows --- 💬 Bonus Tip The workflow is modular. You can easily extend it with internal linking, language translation, or even social media sharing — all within the same n8n flow.
By Kumar ShivamAI-powered MIS agent
The AI-powered MIS Agent is an intelligent, automated system built using n8n that streamlines email-based data collection and document organization for businesses. It classifies incoming emails, extracts and processes attachments or Drive links, and routes them to the correct destination folders in Google Drive. Additionally, it provides advanced file operations like cleaning, merging, joining, and transforming data. Advantages 📥 Automated Email and File Management Detects and processes emails containing attachments or Drive links, ensuring seamless classification and routing of business-critical files. 🧠 AI-Based Classification Uses LLMs (like GPT-4o Mini) to classify emails into categories such as Daily Sales, Customer Info, and Address based on their content. 📂 Smart File Routing and Upload Recognizes whether a file is a direct attachment or a Google Drive link, extracts the file ID if necessary, and uploads it to predefined folders. 📊 Powerful Data Operations Supports operations like append, join, group by, aggregation, and standardization of data directly from spreadsheets using Python and Pandas within the workflow. 🔁 Scheduled and Triggered Automation Supports scheduled runs and real-time email triggers, making it highly reliable and timely. 🔧 Fully Modular and Scalable Easily expandable with more logic, new folders, or different workflows. Clean architecture and annotations make maintenance simple. How It Works Email Trigger The system uses a Gmail trigger to monitor incoming emails with specific labels or attachments. Classification An LLM-based text classifier identifies the purpose of the email (e.g., sales data, address list, customer details). Conditional Logic Regex-based conditions check if the email contains Google Drive links or attachments. File Handling If it's a Drive link, it extracts the file ID and copies it to the correct folder. If it's an attachment, it uploads directly. Scheduled Data Management Periodically moves or logs files from predefined folders using a schedule trigger. Data Cleaning and Processing Performs data cleaning and transformation tasks like replacing missing values, standardizing formats, and joining datasets based on criteria provided by the user. Final Output Cleaned and processed files are saved in designated folders with their public links shared back through the system. Set Up Steps Configure Nodes: Gmail Trigger: Detects relevant incoming emails. Text Classifier: Uses OpenAI model to categorize email content. Regex Conditions: Determine whether a link or attachment is present. Google Drive Operations: Upload or copy files to categorized folders. Python Nodes: Handle data manipulation using Pandas. Google Sheets Nodes: Extract, clean, and write structured data. LLM-based Chat Models: Extract and apply cleaning configurations. Connect Nodes: Seamlessly connect Gmail inputs, classification, file processing, and data logic. Output links or processed files are uploaded back to Drive and ready to share. Credentials: Ensure OAuth credentials for Gmail, Google Drive, and OpenAI are correctly set. Ideal For Sales & CRM teams managing large volumes of email-based reports. Data teams needing structured pipelines from unstructured email inputs. Businesses looking to automate classification, storage, and transformation of routine data. Testing and Additional customization If you want to test this bot capability before purchasing the workflow. ask me on my mail kumar.shivam19oce@gmail.com I will share the chat url and the links of associated google drives to see the result once you are satisfied then we are good to go. I have just kept $1 for testing purposes because of paid open ai . -If there is any customization needed like charts and other request like adding databases feel free to let me know i can do it accordingly. This is the first version i will come with more advancements based on the request and responses. Use it and let me know on kumar.shivam19oce@gmail.com
By Kumar Shivam