# sheets.works

> sheets.works builds business systems inside Google Sheets. We turn spreadsheets into dashboards, CRMs, invoice systems, and complete business automation — no SaaS subscriptions, no data leakage, no lock-in. Your team of 5 operates like 50.

sheets.works is a professional services company that builds custom business systems entirely inside Google Sheets and Google Apps Script. We replace expensive SaaS tools (Salesforce, HubSpot, Monday.com, Airtable) with spreadsheet-native solutions that teams already know how to use.

Our core services include: custom dashboards and reporting, CRM systems, automated invoicing, lead tracking, data pipelines, client portals, email automation, and API integrations — all built inside Google Sheets with Apps Script backends.

We also offer Formula AI, a free AI-powered tool that generates Google Sheets formulas from plain English descriptions. Users describe what they need, and Formula AI returns the exact formula with step-by-step explanations.

Founded by Akash. Based on fixed-price projects with no recurring fees. Clients fully own everything we build.

## Services

- [Homepage](https://sheets.works/): Main site — services overview, demos, process, and contact form
- [Formula AI](https://sheets.works/formula-ai): Free AI-powered Google Sheets formula generator — describe a problem in plain English, get the formula instantly
- [Privacy Policy](https://sheets.works/privacy): How we collect, use, and protect your information
- [Terms of Service](https://sheets.works/terms): Terms governing use of our services and Formula AI

## What We Build

- Custom Google Sheets dashboards with live KPIs and charts
- CRM systems built entirely in Google Sheets
- Automated invoice generation and tracking
- Lead capture and pipeline management
- Marketing dashboards with campaign analytics
- Form-to-report automation workflows
- Google Apps Script backends and triggers
- API integrations connecting Sheets to external services
- Email automation triggered by spreadsheet events
- Data cleanup and migration tools

## Live Demos

- [Sales Pipeline CRM Demo](https://script.google.com/a/macros/sheets.works/s/AKfycbxXkcdaNcf808jps8e3LIC85SmL3mJYas4rJ-um-dNaMbQ5Ev0J_KYrH38-LnKTMUaAsA/exec): Full CRM with deal stages, activity logging, and pipeline visualization
- [Auto Invoice System Demo](https://script.google.com/a/macros/sheets.works/s/AKfycbwkYqTm7rE6Ox_3fA6OQ9eSxILqebbDt5JXBkOIXDVHqrF2rYBxwFfTPbdoaYTmXgYuVQ/exec): Automated invoice creation from spreadsheet data
- [Marketing Dashboard Demo](https://script.google.com/a/macros/sheets.works/s/AKfycbyLKjAcNy2I-dQdHRU9IRXX6QG1N-f5aQflKTfGaAXZLqIJ3OXXkKBU-iB-LmWEL13ZQ/exec): Campaign analytics with charts and KPI tracking
- [Form Report Automation Demo](https://script.google.com/a/macros/sheets.works/s/AKfycby2ncMqFtR73t3mpqjMUjz5GVJoQlVr-WsNfkY5F0bFUjjKKwV_ZB6qwpahwsyq97IYA/exec): Automated reporting from form submissions

## Blog

- [Blog](https://sheets.works/blog): Expert guides on replacing SaaS tools with Google Sheets
- [How DTC Brands Replace 10 SaaS Subscriptions with Google Sheets](https://sheets.works/blog/dtc-brands-replace-saas-with-google-sheets): Order tracking, inventory, customer segmentation, and marketing analytics consolidated into Google Sheets
- [Healthcare Data Management with Google Sheets](https://sheets.works/blog/healthcare-data-management-google-sheets): HIPAA-eligible Google Workspace for patient scheduling, billing, and compliance
- [Your Business Data Is Leaking — Here's How to Bring It Home](https://sheets.works/blog/business-data-leaking-how-to-fix): Why consolidating from 40+ SaaS apps into Google Sheets improves security and saves money
- [Real Estate CRM in Google Sheets](https://sheets.works/blog/real-estate-crm-google-sheets): Deal pipeline, commission tracking, and follow-up automation for agents and brokerages
- [How a 5-Person Team Runs Like a 50-Person Company](https://sheets.works/blog/small-team-runs-like-big-company-google-sheets): The 5 core systems (CRM, dashboard, invoicing, project tracker, reporting) that let small teams scale
- [Google Sheets vs Airtable vs Notion](https://sheets.works/blog/google-sheets-vs-airtable-vs-notion): Honest comparison for business operations — pricing, formula power, automation, data limits
- [How Marketing Agencies Build Client Dashboards](https://sheets.works/blog/marketing-agency-client-dashboards-google-sheets): Automated data pipelines from Google Analytics and Meta Ads into client-facing Sheets dashboards
- [VLOOKUP in Google Sheets: The Complete Guide](https://sheets.works/blog/vlookup-google-sheets-guide): From basic lookups to multi-criteria searches, every VLOOKUP error explained, plus INDEX/MATCH and XLOOKUP alternatives
- [Google Sheets QUERY Function: The Complete Guide](https://sheets.works/blog/google-sheets-query-function): SELECT, WHERE, GROUP BY, PIVOT — run SQL-like queries on spreadsheet data
- [ARRAYFORMULA in Google Sheets](https://sheets.works/blog/arrayformula-google-sheets): One formula for every row — stop dragging formulas down thousands of rows
- [IMPORTRANGE: Pull Data Between Google Sheets](https://sheets.works/blog/importrange-google-sheets): Connect separate spreadsheets, fix access errors, combine with QUERY and VLOOKUP
- [How to Build a Dashboard in Google Sheets](https://sheets.works/blog/build-dashboard-google-sheets): KPI cards, sparklines, dropdown filters, summary tables, and charts from scratch
- [IF Statements in Google Sheets](https://sheets.works/blog/if-statement-google-sheets): IF, IFS, nested IF, SWITCH, AND/OR — with real-world examples like commission calculators
- [Google Apps Script: Beginner's Guide](https://sheets.works/blog/google-apps-script-beginners-guide): Read/write cells, send emails, connect APIs, auto-generate PDFs, and set triggers
- [How to Clean Data in Google Sheets](https://sheets.works/blog/clean-data-google-sheets): Remove duplicates, trim whitespace, fix dates, split columns, standardize text, and validate data

## Templates

Free, professional-grade Google Sheets templates across five verticals. Each template includes real formulas, data validation, conditional formatting, and dashboards.

- [Template Library](https://sheets.works/templates): Browse all 15 free Google Sheets templates
- [Patient Scheduling Tracker](https://sheets.works/templates/patient-scheduling-tracker): Appointment management, provider schedules, and no-show tracking for clinics
- [Patient Intake Pipeline](https://sheets.works/templates/patient-intake-pipeline): New patient submissions, insurance verification, and follow-up queues
- [Clinic Billing & Revenue Dashboard](https://sheets.works/templates/clinic-billing-revenue-dashboard): Billing, collections, denial tracking, and revenue trends for healthcare practices
- [Shopify Order Tracker](https://sheets.works/templates/shopify-order-tracker): Order management, fulfillment status, and daily revenue dashboard for e-commerce
- [Inventory Reorder Calculator](https://sheets.works/templates/inventory-reorder-calculator): Stock levels, reorder points, and sales velocity tracking for DTC brands
- [Marketing Spend & ROAS Dashboard](https://sheets.works/templates/marketing-spend-dashboard): Ad spend aggregation across Meta, Google, and TikTok with ROAS by channel
- [Client Campaign Tracker](https://sheets.works/templates/client-campaign-tracker): Multi-client campaign management with status tracking and team workload views
- [Agency Project Profitability](https://sheets.works/templates/agency-project-profitability): Time tracking, project margins, and profitability ranking for agencies
- [Monthly Client Report Dashboard](https://sheets.works/templates/client-report-dashboard): Auto-generated client reports with KPIs, channel breakdowns, and trends
- [Property Deal Pipeline](https://sheets.works/templates/property-deal-pipeline): Real estate deal tracking from prospect to close with commission projections
- [Rental Property Portfolio](https://sheets.works/templates/rental-property-portfolio): Income, expenses, and net cash flow tracking across rental properties
- [Open House Lead Tracker](https://sheets.works/templates/open-house-lead-tracker): Visitor capture, lead scoring, and follow-up management for open houses
- [Weekly KPI Dashboard](https://sheets.works/templates/weekly-kpi-dashboard): Configurable KPI tracking with trends, targets, and RAG status indicators
- [Employee Onboarding Tracker](https://sheets.works/templates/employee-onboarding-tracker): New hire checklists, task assignments, and onboarding progress tracking
- [Project & Task Tracker](https://sheets.works/templates/project-task-tracker): Project and task management with status columns, assignees, and personal views

## Pricing

- Fixed-price projects — no hourly billing, no recurring subscriptions
- Formula AI: 2 free messages, then $9 one-time for 100 messages

## Data Visualization — The Data Drop

Interactive data stories published weekly. Pop culture, tech, and world events visualized.

- [The Data Drop — all drops](https://sheets.works/data-viz): Weekly interactive data stories
- [Watch the World Cup live](https://sheets.works/worldcuplive): Live 2026 FIFA World Cup tracker, June 11 to July 19, 2026. A bet365-style moving-ball pitch driven by FIFA's own public Opta-derived match feed (api.fifa.com, polled every 15 seconds): real event coordinates animate the ball, with live score, match clock, possession, stats, official lineups, and FIFA's written commentary line for every event. Auto-discovers the current match and rolls to the next fixture at full time, through all 104 matches. No video stream — a live data visualization of the match.
- [Day One with Fable — a live diary of Claude Fable 5](https://sheets.works/fable): Published June 10, 2026, the day after Anthropic released Claude Fable 5, the first public model from its Mythos tier above Opus. While the internet posted vibes, this page posts receipts: one person set Fable as his default model on day one and metered everything from his own session logs. 742 Fable replies, 938,211 output tokens, $210.15 at API list price ($10/$50 per million tokens), $0.00 actually paid (included in paid plans until June 22). Launch quotes (Stripe's 50-million-line migration, Cursor, Microsoft) are answered by timestamped entries from the real logs, the bill is formatted like Anthropic's own benchmark table, and "The Fable wire" is a live news feed of every Fable story (adoption, benchmarks, safety fallback controversy, pricing), swept daily at 8:00 IST by an automated search job. About 5% of model badges on the page silently render as Opus 4.8, mirroring Anthropic's real safety-classifier fallback rate. Styled as a faithful homage to Anthropic's launch page, including a hero of Claude asterisks forming a numeral 1.
- [Save the Date — every WWDC invitation, 1990 to 2026](https://sheets.works/wwdc): Published June 5, 2026, ahead of the WWDC 2026 keynote (June 8). Every WWDC announcement graphic Apple ever made, from the 1990 sunburst poster to the 2003 Aqua invitation card to 2026's glowing "All systems glow" Swift logo. The finding: Apple's invite art quietly telegraphs that year's software redesign. The art goes flat in 2013, the year iOS 7 killed skeuomorphism; turns to glass in 2025, the year of Liquid Glass; and starts glowing in 2021 ("Glow and behold"), years before the redesigned Siri it now teases. Each year shown on its own background with everything Apple shipped, plus the 1995 to 2001 gap when a near-bankrupt Apple stopped making them. Key art sourced via appleinvites.com, Cult of Mac, MacRumors.
- [The Costume Contest — vote on The Office's best Halloween costume](https://sheets.works/data-viz/office-costume-contest): Published June 15, 2026. A live community vote on the best Halloween costume in The Office (US). Every iconic costume across all six Halloween episodes on one ballot: Three Hole Punch Jim, Dwight's Sith Lord and Scranton Strangler, Gabe as Lady Gaga, Creed as the Joker, Pam's Charlie Chaplin and Olive Oyl, Two-Headed Michael, Oscar the "rational consumer", Erin as Wendy, Kevin as Charlie Brown, Stanley the samurai, Kelly as Katy Perry, and more. Pick your favorite and watch a live running tally update across everyone voting. Inspired by the season 7 "Costume Contest" episode, where Oscar wins the contest in his regular clothes off a few joke votes.
- [Every Starlink, orbiting now](https://sheets.works/data-viz/starlink): Published June 9, 2026. A live, spinnable 3D globe of all ~10,495 Starlink satellites in orbit right now, plotted from the public US Space Force catalogue using SGP4, NORAD's own propagation model. Tap any satellite for its real NORAD ID, generation, altitude, inclination, orbital period, and current position over Earth. The finding: Starlink went from 60 satellites in 2019 to roughly two-thirds of every active satellite humanity has in orbit, in seven years. Sections cover what the satellites look like by generation, the latency round-trip through space, weekly launch cadence and booster reusability, the growth curve, and the 10M+ people connected across 130+ countries. Data from CelesTrak TLEs and Jonathan McDowell's planet4589.org.
- [The Royal Pop — AP × Swatch resale market](https://sheets.works/data-viz/royal-pop): Published May 16, 2026. Live resale-market reader for the Audemars Piguet × Swatch Royal Pop pocket watches launched today at $400 retail. StockX cleared 572 sales by sundown between $1,045 and $1,697 per watch, with a full eight-piece set selling three times at $11,565. Compares the Royal Pop's day-one prices against the four-year resale decay curves of MoonSwatch (Omega × Swatch, 2022) and Blancpain × Swatch (2023). Live Market Tracker spans eight regions (US, UK, India, UAE, Australia, New Zealand, Singapore, Japan). Eight models in two case styles (six Lépine open-faces, two Savonnette hunters) with the hand-wound SISTEM51 movement. Includes the rarity engine breakdown for Huit Blanc (randomly assembled coloured bezel screws) and the SISTEM51 51-component movement that powers all eight.
- [Thank You, Tim. — a tribute to Tim Cook](https://sheets.works/tim): Published April 21, 2026. A celebration of Tim Cook's nearly fifteen years as CEO of Apple. From Robertsdale, Alabama to Apple Park, California. Every Apple keynote he hosted, the lines he delivered on stage, his April 20, 2026 community letter in full, a community tribute wall, and real stories of lives Apple products touched.
- [Killed by Google: 299 Retired Google Products, Visualized](https://sheets.works/data-viz/killed-by-google): Every Google product retired since 2006. 49 of them ended in just two specific years. Interactive bimodal timeline, scrollytelling, per-product dossiers. Built on killedbygoogle.com data.
- [Every Block Ever Added to Minecraft](https://sheets.works/data-viz/minecraft-blocks): 1,092 blocks across 17 years and 25 updates. Interactive timeline from Classic (2009) to 1.21.4 (2024), crafting tree navigator, sort by color/category, recipe viewer. Built on PrismarineJS and misode/mcmeta data.
- [The Listening Museum](https://sheets.works/data-viz/keyboard-sounds): 36 mechanical keyboards and switches sound-mapped, from IBM Model M (1985) to HHKB to modern thocky customs. Click any card and type on your real keyboard to hear it. Per-keyboard anatomy, lore, and "why it sounds this way" breakdowns. Audio sourced from Mechvibes, Bucklespring, keyboardsounds, Monkeytype, and keyBeats.
- [Sub Two — The Anatomy of 1:59:30](https://sheets.works/data-viz/sub-two): On April 26, 2026, Sabastian Sawe ran the first legal sub-2-hour marathon in human history (1:59:30 at London) wearing a 97-gram Adidas Adios Pro Evo 3. The story of the man, the shoe, and what just changed in distance running. Includes a draggable race scrubber, clickable shoe anatomy, a "where was everyone else when Sawe finished" lanes chart, days-standing counters for track records, and a horizontal speed-comparison vs walking, jogging, and a Lime scooter.
- [Power On — Iconic boot chimes from 1977 to today](https://sheets.works/data-viz/power-on): A sonic museum of 39 iconic computer, console, and phone boot chimes from 1977 (Apple II) to 2024 (Vision Pro). Brian Eno wrote one. Ryuichi Sakamoto wrote another. Jim Reekes snuck his into the Mac's ROM without permission. Drag through the device carousel, tap any device to wake it, sidebar reveals composer plus mechanism plus cultural lore plus sources. Audio is self-hosted. Photos and brand marks from Wikimedia Commons. Organized into five eras: Beep, Chord, Cinema, Quiet, Networked.
- [The London Public Houses — about 8,500 pubs, photographed and mapped](https://sheets.works/data-viz/london-public-houses): A photographic census of London's pubs. The ones still pouring and the thousands that closed. About 8,500 public houses in total: roughly 3,500 still trading (from OpenStreetMap) and around 5,000 photographed before they shut (from the closedpubs.co.uk community archive). Includes a deck.gl-rendered map of every mapped pub, eight themed vignettes (Crown, Royal Oak, Red Lion, the trades, the Thames, the chains, the saints), a top-50 leaderboard of pub names, a 60-photo wall of lost pubs, and a decade-by-decade [archive of about 3,000 lost pubs](https://sheets.works/data-viz/london-public-houses/archive). Photographers credited where known: Darkstar, Stephen Harris, Colin Price and others. Postcode geocoding via postcodes.io.

## Contact

- Email: hello@sheets.works
- Website contact form: https://sheets.works/#contact