SuPujaCreations
We engineer practical business automation systems using Google Sheets, Google Apps Script, REST APIs, Looker Dashboards, and custom web applications.
Helping organizations digitize CRM, leads, sales orders, manufacturing lines, client accounts, vendor procurement, service tickets, attendance, and executive reporting.
Google Sheets & Web Forms
Zero Manual Typing • Dynamic Dropdowns
“We do not just prepare MIS reports. We engineer and automate complete business processes.”
(Main sirf reports nahi banata; main manual business processes ko structured digital systems mein convert karta hoon.)
10+ Years of Turning Messy Operations into Automated Flow
SuPuja Creations is a specialized business automation and MIS solutions agency with over a decade of hands-on experience solving real shop-floor, corporate, and field problems.
Our core capability lies in mapping chaotic, uncoordinated operations into a disciplined step-by-step workflow (S00..S85), assigning responsible persons, defining Turnaround Times (TAT), and automating real-time bottleneck alerts.
Read Full Background & JourneyCore Competencies Snapshot
Enterprise Systems & Specialized Services
CRM & Lead Management System
Centralized lead capture from Meta Ads, Website, IndiaMART, and WhatsApp. Automatic round-robin salesperson assignment, follow-up scheduler, stage-by-stage pipeline tracking (New, Contacted, Proposal Sent, Won/Lost), and daily sales conversion MIS.
Sales & Order (S-Order) Management
End-to-end sales order processing system. Instant professional PDF quotation generator, order approval hierarchy, proforma invoicing, production dispatch link, dispatch DC/LR tracking, and automated payment reminder alerts on WhatsApp.
WhatsApp Marketing & Business API Automation
Direct high-response customer outreach and marketing on WhatsApp. Personalized Bulk Broadcast Messaging (promotional offers, product catalogs, festival discounts), Click-to-WhatsApp Ads (direct lead chats from Meta Ads into WhatsApp), and 24/7 Chatbot Funnel Automation (interactive quick-reply buttons, dynamic order status updates, automated payment links, and lead nurturing).
Meta Ads (Facebook & Instagram Marketing)
Targeted high-converting ad campaigns across Facebook & Instagram tailored for your exact business goals: Brand Awareness (maximum reach and visibility in your target market), Website Traffic & Store Visits (driving active buyer traffic), and Lead Generation (capturing high-intent customer inquiries for rapid sales growth). Includes custom audience retargeting, creative ad copy design, Meta Pixel & Conversions API integration, and real-time ROAS optimization.
Google Sheets & MIS Automation
Automated executive reporting, multi-sheet data consolidation, advanced formulas (QUERY, ARRAYFORMULA, XLOOKUP), data cleaning, duplicate removal, and dynamic master data architectures.
Production Management System (FMS & Shop Floor)
Digital manufacturing control from raw material to finished goods. Bill of Materials (BOM) explosion, material issue slips, machine workstation WIP tracking (Laser, CNC, Bending, Welding, Paint, Assembly), daily production logs, and rejection root-cause analysis.
Vendor & Purchase Management System
Streamlined vendor procurement architecture. Vendor rate comparison, automated Purchase Order (PO) dispatch, Goods Received Note (GRN) verification, material inspection checklist, vendor bill booking, and payment aging reports.
Client & Account Lifecycle Management
Complete 360-degree client management database. Track client order history, pending balances, recurring contracts, key contact persons, communication logs, automated ledger statements (SOA), and customer retention analytics.
Multi-Stage Business & Manufacturing Flow Control (FMS)
Eliminating shop-floor confusion with granular Planned vs. Actual tracking, defined Target TATs, and automated delay escalation matrices.
Requisition & Material Issue
BOM verification, raw material allocation, digital store issue slips, and stock reservation.
Machining & Fabrication
Laser cutting, CNC bending, rotor lathe turning, precision welding, and fixture alignment.
Vendor Job-Work & Heat Treat
Outward challan, external heat treatment, gear hardening, vendor SLA timer, and inward QC.
Assembly, Paint & Dispatch
Gearbox fitment, blade mounting, powder coating, final QC testing, and serial dispatch.
Manual Chaos vs. SuPuja Digital Flow
How structured Google Workspace, Apps Script, and FMS architecture systematically eliminates operational friction, stops revenue leakages, and enforces single-owner accountability:
Sales & Lead Pipeline
Leads scattered in personal WhatsApp chats, registers, and diaries. No auto-assignment; follow-ups missed and conversion rates untracked.
Centralized Multi-Channel CRM. Automatic round-robin salesperson assignment, follow-up scheduler, and daily conversion MIS.
Sales Orders & Balance Collection
Orders dispatched without verifying 70% balance payment. Manual PDF creation errors, payment delays, and bad-debt disputes.
10-Step S-Order Lifecycle. Dispatch strictly locked until 30% advance & 70% balance are verified, with automated WhatsApp reminders.
Shop-Floor & Production Flow
Owner must walk the factory floor or call supervisors to ask status. Bottlenecks and machine WIP delays discovered only after client complains.
Multi-Stage Manufacturing FMS. Real-time stage-by-stage Planned vs. Actual tracking with automated WhatsApp delay escalation alerts.
Purchase & Vendor Material Inward
Vendor rate comparison on loose papers, duplicate POs created, and rejected materials entered into inventory without inspection.
Standardized 1-Click PO Generator. Mandatory GRN quality checklist, duplicate prevention, and automated vendor payment aging reports.
Employee Attendance & Field Tracking
Proxy attendance, buddy punch-ins, manual Excel timesheets, and zero location verification for field sales and plant staff.
Smart GPS Geofenced Attendance. Device location radius check (Inside/Outside office) + mandatory camera selfie capture (Zero Proxy).
Executive Management Visibility
Reports prepared 2–3 days late with manual copy-paste formula errors. Owner lacks instant visibility into daily company bottlenecks.
Live Executive Looker Studio Dashboard. Real-time single-screen view of active orders, payments locked, and department scorecards.
Featured Automation Projects
GPS-Based Smart Attendance System
Engineered an interactive web-based attendance terminal featuring live GPS geofencing (distance calculation vs office coordinates), front camera photo capture with mirrored preview, strict 1-Check-in/1-Check-out per day logic, and direct Google Sheets live logging.
Automated Multi-Stage Manufacturing & Purchase FMS
Mapped and digitized a multi-stage manufacturing & procurement FMS covering raw material requisition, BOM breakdown, machine shop bays, vendor job-work, assembly, testing, paint shop, and final dispatch with automated Turnaround Time (TAT) and escalation alerts.
TrackOlap Attendance REST API Integration
Developed an automated Google Apps Script pipeline that executes scheduled GET requests to TrackOlap REST APIs, parses nested JSON responses with pagination, processes check-in/out timestamps, and synchronizes clean employee attendance records directly into master sheets.
Have a Process to Automate?
Whether you need complex Google Sheets automation, a custom web form, manufacturing FMS, or full MIS architecture — let's build something practical.
Instant Connect Options
Send a Project Inquiry
Select your required services and enter your project details. We will respond promptly.