Hi HN,
I built Prompt2Sheets because I kept watching non-technical founders and operators lose evenings inside Google Sheets – fighting VLOOKUPs, pivot tables, dedupe formulas, and ad/lead exports that never line up. They didn’t want another BI tool; they just wanted their existing sheets to behave.
Prompt2Sheets lets you edit a Google Sheet by describing what you want in plain English. Under the hood it generates JavaScript, runs it in a sandbox, and syncs the result back to the original sheet. Typical prompts are:
– “Remove duplicate leads by email and keep the most recent row”
– “Add a Margin column after cost of goods sold = (price_fyi – cost of goods sold) / price_fyi”
– “Filter to only US + Canada with verified emails and add a summary row with total spend”
It’s aimed at people who live in Sheets (founders, operators, recruiters, marketers, ecommerce) but don’t want to learn complex formulas or maintain brittle scripts. The focus right now is: cleaning lead lists, transforming ad/export data, adding calculated columns, and building simple summaries directly in the sheet.
You can try it here: https://prompt2sheets.com
– No credit card required
– Uses Google OAuth; app is in beta but live
– Works best on small/medium sheets while I harden performance and edge cases
I’m particularly interested in feedback on:
– Where the natural-language interface feels useful vs. confusing
– Which operations you’d trust it with (and which you would never hand to an AI)
– Any cases where it silently does the “wrong” thing – those are the most valuable to fix
If you have a messy sheet you’re willing to share (leads, ads, inventory, reporting), I’m happy to personally help set up your first workflow and debug failures. Honest criticism is welcome – especially around UX, safety, and where this is obviously the wrong tool.
