llms.txt
Compare with other sites' llms.txt files →# 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 every Tuesday. Pop culture, tech, and world events visualized.
- [The Data Drop — all drops](https://sheets.works/data-viz): Interactive data stories, one every Tuesday
- [All 199 passports](https://sheets.works/data-viz/passports): Data Drop No.110. Every ordinary passport, photographed the same way. Colour, size, twenty years of rank, who lets whom in, and what it costs. Start with yours.
- [Long Story Short](https://sheets.works/long-story-short): A daily word game. Rephrase a twelve-word sentence in exactly five words, using only words from the sentence, Wordle-scored in blue and orange. Five tries, one puzzle a day, shareable result grid.
- [Wordle today](https://sheets.works/wordle): Unofficial daily Wordle hints, then Long Story Short on the same page. Not affiliated with the New York Times.
- [Connections today](https://sheets.works/connections): Unofficial daily NYT Connections hints, then Long Story Short on the same page. Not affiliated with the New York Times.
- [Wordle Connections today](https://sheets.works/wordle/connections): Unofficial daily Wordle and Connections hints on one page, then Long Story Short. Not affiliated with the New York Times.
- [Dear Stranger — what 87 million postcards between strangers know](https://sheets.works/data-viz/dear-stranger): Data Drop No.091. The story of Postcrossing, the website where you mail a postcard to a stranger and a different stranger mails one back, told as a stack of hand-drawn postcards you flip over. Opens with Helen, 101, in a senior living community ("it's like a little vacation"). A scroll-driven crowd of drawn postcards piles up year by year from 2005 to today (one drawn card = 100,000 real ones, from Postcrossing's own records), pausing for real members: Helen, Andrea (who mailed cards through depression), Noa (housebound with ME/CFS). Covers the loop's one rule (the stranger who writes to you is never the one you wrote to), the war closing mail routes into Russia (112,727 members, sends down 54%), Taiwan as the per-capita capital, the December literacy charity with Deutsche Post, and 422,616 postcards in transit at time of drawing. Every quote sourced; drawn in the spirit of Dear Data; not affiliated with Postcrossing.
- [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.
- [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.
- [The Lives of Great Hotels](https://sheets.works/accor): We rebuilt all 210 Accor luxury hotels by hand, and found the strange story hiding inside each building.
- [The Self-Hosted Index](https://sheets.works/data-viz/self-hosted): 2,050 open-source apps you can run yourself, and the paid service each one replaces.
- [The Houseplant Atlas](https://sheets.works/plant-atlas): Every houseplant was a wild plant first. A field guide to 114 of them, each sculpted in clay, each pot from its homeland: where it comes from, how to keep it alive, and what it's worth.
- [Player One](https://sheets.works/data-viz/player-one): Fifty years of video game heroes, one per game, from Pong to GTA VI. Each with a true story and its real theme to play. Every one of them, for a while, was you.
- [Semicolon](https://sheets.works/data-viz/semicolon): A printer drew it in 1496. Now it holds together our language, our code, and the whole digital world; the most important little mark you never think about.
- [No one introduced us](https://sheets.works/data-viz/no-one-introduced-us): Jake was in Ohio. Maria was in Lisbon. No friend on Earth could have introduced them. An app did. The strangers we were never supposed to meet.
- [What we can't get out](https://sheets.wo
