Name the columns
Include the column letters or headers your formula should read from.
Spreadsheet help in plain English
Generate a Google Sheets or Excel formula.
Describe the result you need, choose your spreadsheet app, and get a clean formula you can test in your workbook.
Google Sheets formula
=SUMIF(B2:B, "West", D2:D)Formulas should be reviewed against your actual sheet layout before using them.
Google Ads ready
Ad slot included for AdSense.
Add your AdSense client and slot IDs in ads.js. Every page can reuse the same clean ad loader.
Better prompts
Ask with the sheet shape in mind.
Describe the condition
Say which rows count, such as status equals paid or date is this month.
Give the expected result
Mention whether you want a total, lookup, filtered list, count, or label.
FAQ
Quick answers.
Is this connected to Gemini?
Yes. Run the secure local server and add your Gemini API key as an environment variable. The browser never receives the key.
Can it generate formulas for both apps?
Yes. Use the switch at the top of the form to tailor output for Google Sheets or Excel.
Where do Google Ads go?
Each page adds a simple ad slot and imports ads.js. The Google script is loaded once from that shared file.