Notes from building automation for Indian businesses.
How we automate marketplace orders, track prices, run ads and use AI agents, with the traps we hit along the way. Written for founders, analysts and developers.
Automating Daily Marketplace Sales & Stock Reports Into Your Team's Own Google SheetsEvery morning someone types marketplace sales and stock into twenty workbooks. We automated it without replacing a single sheet — the six rules that made it safe.- A Marketplace Sales Dashboard in Google Sheets Using Only Formulas (No BI Tool, No Database)One dashboard per marketplace, in the folders the team already uses: a common order format, a hidden calculation tab, period pickers, and the formula gotchas.Data7 min read
- Moving a Small Business Website Off WordPress: Every Old URL Kept, Products Edited From a Google Sheet13 plugins, a disabled checkout and 87 real products became a fast site the owner edits from a Google Sheet — with all 130 old URLs still working.Cloud7 min read
- Amazon Moved Our Scheduled Jobs to Authenticator-App 2-Step Verification Overnight: What We ChangedHow authenticator codes work, how to handle them safely on a server, and the account-wide label throttle we hit the same week.Automation6 min read
- Sudden SSL Certificate Error on a Vercel Site With Hostinger DNS? Check 'Hosting CDN' FirstA live site showed an expired certificate with no code change. A Hostinger setting had re-enabled itself. How we found it, fixed it without breaking email, and prevent it.Cloud6 min read
- VITE_ Variables Are Public: Is Your Website's Admin Password Sitting in Its JavaScript?An admin password in a .env file is readable by every visitor. Why, how to check your own site in two minutes, and what to do instead.Cloud6 min read
- The Timezone Bug That Let a Locked Accounting Period Accept Entries (node-postgres DATE in IST)A locked period accepted entries — only on servers in India. How node-postgres turns a DATE into a Date at local midnight, and the rule we now follow.Data6 min read
- What Breaks When You Automate 250+ Marketplace Orders a Day: 6 Lessons From Our First Two WeeksOur Unicommerce order automation now dispatches 250+ orders on busy days across six marketplaces. Here's what broke at real volume — and how we fixed each one.Automation8 min read
- Building a Marketplace Price Tracker for Amazon, Flipkart, Myntra & Nykaa (What Actually Works in 2026)A twice-daily tracker that prices every running listing across five marketplaces and flags the ones selling below the brand's base price — the method, the traps, and the surprising result.Data9 min read
- Exam Photo & Signature Size 2026: IBPS, NEET, JEE Main & SSC (Verified From Official Notices)The real photo and signature limits for IBPS, NEET UG, JEE Main and SSC, checked against the official documents — plus a free tool that makes your files fit.Automation6 min read
- How Our Free AI Tools Run Without an API: Background & Watermark Removal in the BrowserReal AI models, no API bill, and your photo never leaves your device. How open-source models running in the browser power our background, passport photo and watermark tools.AI7 min read
- Automating Amazon Vendor Central Direct Fulfillment: Invoices, Labels, Handover & Ship ConfirmationThe daily Vendor Central DF routine — invoices, labels one by one, handover reports, mark as shipped, sheet rows — automated end to end. How it works and what to watch out for.Automation7 min read
- Automating Unicommerce Order Processing: Invoices, Labels & Manifests for Myntra, Ajio, Nykaa & FlipkartHours a day of invoice → label → manifest clicking in the Unicommerce panel, per marketplace. We automated the full loop on a schedule — here's the architecture and the channel quirks nobody documents.Automation9 min read
- Rent Receipts for HRA: What Your Employer Actually Checks (2026 Guide + Free Generator)Payroll teams reject HRA proofs for the same few reasons — missing landlord PAN, unsigned receipts, revenue-stamp confusion. Here's what a valid rent receipt needs, plus a free generator for all twelve months.Automation7 min read
- How to Calculate GST: Inclusive vs Exclusive, CGST/SGST vs IGST (With Examples)Taking 18% off a GST-inclusive price gives the wrong answer — and it shows up on invoices everywhere. The correct maths for adding and removing GST, CGST/SGST vs IGST, and today's slabs.Data7 min read
- Why Your AI Lead Scraper Keeps Messaging the Wrong People (And How to Fix It)We run our own AI-powered LinkedIn lead engine daily. When outreach stopped landing, the bug wasn't the outreach — it was the classifier letting vendors and freelancers through disguised as buyers. Here's every pattern we found and how we taught the AI to catch them.AI8 min read
- AI Agents vs Automation: What Indian SMBs Actually Need in 2026Every vendor is suddenly selling 'AI agents.' Most Indian SMBs asking us about them actually need something far simpler, cheaper, and more reliable — plain workflow automation. Here's how to tell which one your business actually needs.AI7 min read
- Festival Season Ads in India: What Creative Actually Converts (Real Campaign Data)We ran a full festival-season Meta ad campaign for a D2C gifting brand and tracked every ad variant to the end. The overall numbers were unremarkable — but one creative pattern quietly drove 82% of every purchase. Here's the breakdown, honestly.Marketing7 min read
- Google Merchant Center Suspended for Misrepresentation? The Same-Day Recovery PlaybookA Misrepresentation suspension kills your Shopping ads instantly — and Google won't tell you exactly what's wrong. We recovered a client's Merchant Center the same day it was suspended. Here's the exact checklist we used.Marketing8 min read
- Performance Max on a Small Budget: The Indian D2C Playbook (₹100–₹500/Day)Google says Performance Max needs big budgets. Reality: a well-fed PMax campaign at ₹100–₹500/day can profitably launch a small Indian D2C brand — if your feed, conversion tracking, and patience are set up right.Marketing9 min read
- GA4 + Meta Pixel for E-Commerce: Conversion Tracking That Actually FiresHalf the e-commerce sites we audit have analytics 'installed' that has never recorded a single event. Before you spend ₹1 on ads, here's how to wire GA4 and Meta Pixel properly — and prove it with one real test order.Data8 min read
- AI Social Media Autopilot: Auto-Generate & Post to LinkedIn + Instagram Daily with n8nWe built a workflow that writes a post, generates a branded image, and publishes to LinkedIn and Instagram every single day — with zero human time. Here's the architecture, the guardrails, and what it costs to run.AI8 min read
- AI Chatbot for Your Website: Lead Capture & 24/7 Support for Indian BusinessesMost visitors leave your website without ever filling a form. An AI chatbot trained on your business answers questions, qualifies leads, books appointments, and replies in Hindi or English — 24/7.AI8 min read
- Restaurant & Cloud Kitchen Automation in India: Orders, Inventory & WhatsApp OrderingJuggling Swiggy, Zomato, walk-ins, and phone orders manually? Here's how automation syncs every channel, controls inventory, and takes direct WhatsApp orders so you stop losing 25–30% commission on every plate.Automation8 min read
- Tally + AI: Automate Accounting, GST Reconciliation & Data Entry in IndiaTally runs the books for millions of Indian businesses — but the data entry is still manual. Learn how to connect Tally to AI so invoices, bank statements, and GST reconciliation happen on autopilot.Automation8 min read
- WhatsApp Abandoned Cart Recovery: Win Back D2C Sales on AutopilotAround 70% of online carts get abandoned. Email recovery sees 8–10% open rates; WhatsApp sees 90%+. Here's how D2C brands in India recover 15–25% of lost orders automatically.Marketing7 min read
- AEO & GEO: How to Get Your Business Cited by ChatGPT & Google AI OverviewsYour customers are asking ChatGPT, Perplexity, and Google AI Overviews for recommendations — and those answers don't show ten blue links. Here's the 2026 playbook to become the answer.Marketing9 min read
- How to Hire an Automation Agency in India (Without Wasting Your Budget)Not every automation consultant in India knows what they're doing. Here's a practical guide to finding the right agency, asking the right questions, and avoiding the most common hiring mistakes.Automation8 min read
- GST & Invoice Automation for Indian Businesses: Stop Filing ManuallyGST filing, invoice generation, GSTR reconciliation — these tasks eat up hours every month for Indian SMBs. Here's how to automate most of it.Automation7 min read
- 7 n8n Workflows Indian SMBs Are Using Right Nown8n is open-source, self-hostable, and cheaper than Zapier at any volume. Here are 7 real workflows our clients in India are running today — with the logic explained.Automation8 min read
- How Clinics in India Are Automating Appointments, Reminders & Follow-UpsMissed appointments, manual scheduling, and unanswered WhatsApp messages are costing Indian clinics real money. Here's how automation fixes all three.AI7 min read
- HR & Payroll Automation for Indian SMBs: From Onboarding to Salary SlipsManually generating salary slips, tracking attendance in spreadsheets, onboarding new hires over WhatsApp — there's a better way for Indian SMBs.Automation7 min read
- Real Estate Lead Automation: Never Miss a Client Inquiry AgainReal estate agents lose deals every day to slow follow-ups and missed WhatsApp messages. Here's how to automate your entire lead pipeline.AI7 min read
- CA Firm Automation: How Chartered Accountants Save 20 Hours a WeekFrom document collection to GST filing reminders, here's how CA firms in India are cutting admin work by 60% with smart automation.Automation6 min read
- LinkedIn B2B Lead Automation: How to Fill Your Pipeline on AutopilotMost B2B businesses send LinkedIn connection requests manually, one by one. Here's how to automate prospecting, outreach, and follow-up — without violating LinkedIn's terms.Automation7 min read
- n8n vs Zapier vs Make: Which Wins in 2026?Zapier is easy. Make is visual. n8n is open-source and self-hostable. We benchmark all three on price, scalability, AI integrations, and real client workflows — so you pick the right tool, not the trendiest one.Automation8 min read
- WhatsApp Business AI Automation: 24/7 Sales & Support on AutopilotWhatsApp is where your customers actually reply. Learn how to build AI-powered WhatsApp bots that qualify leads, book appointments, recover abandoned carts, and resolve 80% of support tickets — without a human touching the keyboard.AI9 min read
- Voice AI Agents for Outbound Sales: The New SDR Stack in 2026AI voice agents now make cold calls, qualify prospects, handle objections, and book demos — at 1/10th the cost of a human SDR. Here's how the new stack works, what it costs, and where it still falls short.AI8 min read
- DeepSeek vs ChatGPT vs Claude: Which LLM Should You Use for Business Automation?DeepSeek is dirt cheap. Claude reasons best. GPT-4o is the all-rounder. We compare cost, speed, accuracy, and tool-use across real automation workloads — so you stop overpaying for the wrong model.AI7 min read
- AI-Powered CRM Lead Generation: Scrape Google Maps, Enrich & Auto-Email ProspectsStop buying cold lists. Learn how to scrape qualified leads from Google Maps, enrich them with website, Instagram, ratings, email & mobile data, push to Google Sheets, and trigger personalised email sequences with automated follow-ups.AI9 min read
- How to Automate Your Data Warehouse with Python & SQLManual data loads are slow, error-prone, and unscalable. Learn how Python and SQL can fully automate your data warehouse — from ingestion to transformation to scheduled refreshes.Data7 min read
- What is ETL? A Beginner's Guide to Data PipelinesExtract, Transform, Load — the three steps that move your data from source to insights. We break down exactly how ETL works and why every data-driven business needs it.Data5 min read
- How an AI Receptionist Can Handle Your Business CallsImagine never missing a call, never double-booking, and never wasting staff time on routine enquiries. Here's how AI voice agents are transforming small business operations.AI7 min read
- Power BI vs Google Sheets: Which Dashboard Is Right for You?Both tools can visualise your data — but they serve very different purposes. We compare Power BI and Google Sheets dashboards so you can choose the right fit for your team.Data6 min read
- Why Your Business Needs a Marketing AI Agent in 2026AI marketing agents can generate content, optimise ad spend, and nurture leads around the clock. Here's what they are, how they work, and why early adopters are winning.AI8 min read
- Azure vs AWS: Choosing the Right Cloud for Your DataBoth Azure and AWS are world-class platforms — but the right choice depends on your data stack, team skills, and integration needs. Here's our honest comparison.Cloud9 min read
- SnapLogic 101: Enterprise Data Integration Made SimpleSnapLogic is one of the most powerful iPaaS platforms available — but it can seem complex. This guide breaks down what it is, when to use it, and what to expect.Cloud6 min read
- How to Automate Your Weekly Business ReportsStop wasting hours every week compiling reports manually. Here are the tools, techniques, and approaches we use to automate reporting for our clients.Automation5 min read
- Excel & VBA Macros for Small Business: Automate Repetitive Tasks in MinutesStill copying and pasting data between spreadsheets? Excel macros and VBA scripts can automate invoicing, data entry, inventory tracking, and reporting — saving your small business hours every week.Automation6 min read
- How to Extract Data from Emails Directly into Your Dashboard (Python & Java)Your inbox is full of invoices, order confirmations, and reports. Learn how to use Python or Java to automatically parse email data, extract key metrics, and push them straight into Power BI, Google Sheets, or any analytics dashboard.Data8 min read
- Build a Python Report Scheduler: Auto-Send Reports to Different Users Every DayStop manually emailing reports to your team. This guide shows you how to build a Python-based report scheduler that generates, personalises, and delivers business reports to different stakeholders on autopilot.Automation7 min read
- 10 Automation Ideas Every Small Business Should Implement in 2026From automated invoicing and appointment reminders to inventory alerts and customer follow-ups — here are 10 high-impact automation ideas that save small businesses time, money, and manual effort.Automation9 min read
- Google Sheets Automation: Apps Script Tricks to Eliminate Manual Data WorkGoogle Sheets is more powerful than you think. Learn how to use Apps Script, triggers, and API integrations to automate data imports, calculations, notifications, and report generation — no coding degree required.Data6 min read
- CRM Automation for Small Business: Capture, Nurture & Convert Leads AutomaticallyStop losing leads to manual follow-up. Learn how to automate your CRM pipeline with automated lead capture, email sequences, task assignments, and sales notifications — using tools like HubSpot, Zoho, or custom Python scripts.AI7 min read
- Free Online Tools Every Small Business Should BookmarkFrom PDF converters to date calculators — discover our collection of free browser-based tools built to save you time and boost productivity without any downloads or subscriptions.Automation5 min read
- Amazon PPC Advertising: The Complete Guide to Profitable Campaigns in 2026Master Amazon Sponsored Products, Sponsored Brands, and DSP advertising. Learn bid strategies, ACoS optimisation, and keyword targeting to maximise your Amazon seller ROI.Marketing10 min read
- B2C SEO Strategy: How to Rank Higher and Drive Organic SalesA comprehensive guide to B2C search engine optimisation — from on-page SEO and technical audits to content marketing and link building strategies that drive organic traffic and conversions.Marketing9 min read
- E-Commerce Marketing: Proven Strategies to Scale Your Online StoreFrom Google Shopping and retargeting ads to abandoned cart recovery and influencer marketing — proven e-commerce marketing strategies to scale your Shopify or WooCommerce store.Marketing8 min read
- Quick Commerce Marketing: How to Win in the 10-Minute Delivery EconomyBlinkit, Zepto, Swiggy Instamart — quick commerce is reshaping retail. Learn hyperlocal marketing, dark store strategies, and impulse purchase optimisation for the q-commerce era.Marketing8 min read
- Why Every Business Needs a High-Converting Landing Page in 2026Your website is your 24/7 salesperson. Learn why conversion-optimised landing pages are the highest-ROI marketing investment — and what separates pages that convert from pages that bounce.Marketing7 min read