Projects using Google Sheets in BengaluruProjects using Google Sheets in Bengaluru
Projects
People
Cover image for Imagine knowing which buyer is
Imagine knowing which buyer is serious about purchasing the moment they submit your form. They get lost because nobody qualifies them fast enough. When a buyer fills a form, someone still has to open the responses, read everything, decide if the lead is serious, and then follow up. By the time that happens, the buyer is often already speaking with another agent. To solve this, I built a simple AI Buyer Qualification Workflow. Now the moment a buyer submits a Typeform: • The lead details are captured automatically • AI analyzes the responses and classifies the lead based on buying timeline • 🔥 Hot Lead — Buying immediately • 🟠 Warm Lead — Planning within 1–3 months • 🔵 Cold Lead — Planning within 4–6 months The system then: • Saves the lead and score into Google Sheets • Sends a priority email alert through Gmail with all the lead details This means agents instantly know which leads require immediate follow-up and which ones can be nurtured. No manual sorting. No delays. Just clear and prioritized leads ready for action. Feel free to explore this template and see how it works with real data: https://lnkd.in/gH8NfC5Y If you need a customized version for your workflow, feel free to contact me on naveenkumarraju000@gmail.com (mailto:naveenkumarraju000@gmail.com).
1
304
Cover image for Automated Employee Onboarding & Asset
Automated Employee Onboarding & Asset Setup Workflow The Automated Employee Onboarding & Asset Setup Workflow automates the entire new-hire intake process. By connecting intake forms, central database sheets, cloud storage folders, document generation engines, and automated email delivery, this workflow reduces manual onboarding time from hours to seconds while eliminating human error in documentation. Business Benefits Time Savings, Consistency & Compliance, Instant Resource Access, Seamless Candidate Experience, Target Industries & Business Use Cases HR & Recruitment Agencies, IT & Technology Startups, Healthcare & Enterprise Organizations, Remote & Distributed Teams Primary Nodes Involved Google Sheets: Acts as the central Master Roster database, recording structured employee attributes (Name, Role, Email, Start Date) for auditability Google Drive: Manages Folder Structures & Templates, automatically creating dedicated workspace folders for each employee and hosting master document templates. Google Docs: Serves as the Document Generator, holding formatted legal/welcome text with placeholder tags that are filled dynamically. Gmail: Provides Delivery & Distribution, converting the generated documentation into a PDF attachment and emailing the new hire. HTTP Request Node: Interacts directly with the Google Docs REST API to execute search-and-replace commands. Replaces template variables with the real data submitted via the intake form.
0
102
Cover image for E-Commerce Auto-Fulfilment System — From
E-Commerce Auto-Fulfilment System — From Order to Label Without Touching a Spreadsheet Built a fully automated order-to-fulfillment pipeline for a D2C brand selling across Shopify, Amazon, and their own store. THE PROBLEM: The operations team manually copied orders into spreadsheets, checked inventory against 3 separate sources, created shipping labels one by one, and updated tracking numbers by hand. 3 hours of daily grunt work. 8% error rate. Delayed shipments. Angry customers asking "where is my order?" THE SYSTEM I BUILT: → CAPTURE: Shopify order webhook fires instantly on every purchase. Amazon SP-API pulls orders every 15 minutes into the same pipeline. → VALIDATE: Auto-check inventory in Google Sheets. Flag low-stock SKUs for reorder. Route expedited orders to priority queue. → PROCESS: Generate shipping label PDF automatically via Shiprocket API. Create invoice in Zoho Books. Update inventory count across all channels in real-time. → SYNC: Push order status, tracking number, revenue data, and shipping cost to master Google Sheets dashboard for ops visibility. → NOTIFY: Customer receives automated email/SMS with tracking link within 5 minutes of order confirmation. → ALERT: Operations manager gets daily summary + instant alert on failed orders with retry logic and error context. THE RESULTS: • Manual processing time: 3 hours/day → fully autonomous • Order processing errors: 8% → 0.2% • "Where is my order?" support tickets: -60% • Scales to 10,000+ orders/month without adding staff TECH STACK: Make.com (http://Make.com) | Shopify | Amazon SP-API | Google Sheets | Shiprocket | Zoho Books | Twilio | PDF Generator WHY THIS WORKS: E-commerce margins are thin. Every minute of manual processing and every fulfillment error eats profit. This system runs 24/7 without breaks, mistakes, or overtime pay.
0
50