Most people open Google Sheets, get stuck on a formula, and then ask AI something like "write a formula for sales." That is the spreadsheet version of asking for directions without saying where you are standing. You might get something useful, but you are making the model guess too much.
The Complete Excel Course with AI Integration
From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.
By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner
Buy nowGoogle Sheets is a particularly good place to use AI because the work is often collaborative, messy, and full of repeatable patterns. Gemini can help directly inside Google Sheets on supported accounts, and external tools such as ChatGPT or Claude can still write formulas, QUERY statements, data-cleaning logic, and Apps Script if you give them the right context.
This is a copy-paste prompt library for real Google Sheets work: formulas, cleanup, analysis, dashboards, collaboration workflows, and Apps Script automation. Replace the text in [brackets] with your real tab names, column headers, ranges, and output needs. If you work across Excel and Google Sheets, keep the 60 AI prompts for Excel open beside this one because several ideas transfer, but the best Google Sheets prompts use Google Sheets-native tools like QUERY, FILTER, ARRAYFORMULA, IMPORTRANGE, and Apps Script.
Quick Answer: Best AI Prompt for Google Sheets
The best AI prompt for Google Sheets is short and gives the AI four things: the tab name, the column headers, a few sample rows, and the exact output you want. Then end with "Ask me questions for a better response." That one sentence makes the AI ask about anything you left out instead of guessing. Gemini can sometimes act directly inside Google Sheets, while ChatGPT and Claude usually need you to paste the relevant sheet context first.
Google Sheets tab: [tab name]. Headers: [paste headers]. Sample rows: [paste three rows]. I want [formula/table/chart/script] in [cell/column/tab/file]. Ask me questions for a better response.
That single structure works for formulas, data cleaning, dashboards, analysis, and Apps Script drafts because it removes guesswork. If you only ask for "a formula," the AI must infer your columns, row layout, date format, blanks, and error handling. If you provide the spreadsheet shape, the answer is usually more accurate and easier to review.
Gemini vs ChatGPT vs Claude for Google Sheets
Use Gemini in Google Sheets when you want help inside the open file: summarising a spreadsheet, creating tables, generating formulas, building charts, or asking for spreadsheet actions that your account supports. Use ChatGPT or Claude when you want longer reasoning, alternate formulas, Apps Script drafts, cleanup plans, or a second opinion on logic. The tradeoff is simple: Gemini may have file context, while external AI tools need pasted context — the exception being OpenAI's ChatGPT for Google Sheets add-on, generally available since May 2026, which reads the open sheet from a sidebar.
For sensitive or shared work, keep the workflow review-first. Ask the AI to explain assumptions, show the formula or script before applying it, preserve raw data, and flag destructive actions such as deleting rows, overwriting formulas, or changing protected ranges.
What This Prompt Pack Covers
This guide is organised by search intent and real spreadsheet workflow. If you are stuck on a formula, start with the formula prompts. If your sheet is messy, start with data cleaning. If you need recurring work, jump to Apps Script. If you need a report, use the analysis, chart, dashboard, and executive-summary prompts. Each prompt is short enough for a beginner to copy, and its closing line gets the AI to ask for the details an analyst or operations teammate would add, so the answer is still reliable.
The Rule That Makes Google Sheets AI Prompts Work
Before the prompts, keep one rule in mind: tell the AI what your spreadsheet looks like before asking it to solve anything.
A weak prompt says, "Create a formula to find late tasks." A strong one is barely longer: "On tab Tasks, show Overdue in column E when the Due Date in column C is before today and the Status in column D isn't Done. Write it for E2 so it fills down. Ask me questions for a better response." Paste the header row and three sample rows under it if the AI can't see your sheet.
That last sentence is in every prompt below, because a short prompt always leaves gaps, such as whether your sheet uses commas or semicolons, or what a blank due date should mean. With it, the AI asks about the gaps before it writes the formula instead of guessing at them.
If you are using Gemini inside Google Sheets, it may already have some file context. Still, naming the tab, selected range, and desired output makes the response safer. If you are using ChatGPT or Claude outside the file, that context is not optional; it is the input.
Gemini in Google Sheets Starter Prompts (8)
Use these when you want Gemini to help from inside Google Sheets. Some features depend on account, region, file type, and Workspace settings, so phrase requests in a way that lets Gemini tell you what it can do on your current file.
1. Summarise the Whole Spreadsheet
Summarise each tab's purpose. Which three matter most for [business process/project/report], and what should I check before changing anything? Ask me questions for a better response.
This is a good first prompt when someone sends you a shared spreadsheet with too many tabs and not enough documentation.
2. Explain the Columns
Explain each column on tab [tab name] and flag any that are ambiguous, duplicated or risky for formulas. Ask me questions for a better response.
Use this before asking for formulas. Clean column understanding prevents bad logic from spreading through the file.
3. Create a Tracker Table
Create a Google Sheets tracker for [hiring/sales/projects/content] with status dropdowns, dates, owners and a calculated priority column. Ask me questions for a better response.
Gemini is useful for starting the structure. You should still review whether the status values match how your team actually works.
4. Focus on Selected Tabs Only
Use only tabs [tab names]. Describe their data, then suggest the safest calculation to find [issue/opportunity]. Ask me questions for a better response.
This reduces accidental cross-tab assumptions, especially in shared workbooks where old tabs linger forever.
5. Generate a Formula in Place
On tab [tab name], write a Google Sheets formula for [cell] that [desired result]. Explain it before I apply it. Ask me questions for a better response.
For formula-only help outside the file, the same prompt works in ChatGPT or Claude if you paste the headers and sample rows.
6. Turn Notes into a Table
Turn the notes in column A into a table with columns [field names]. Leave missing fields blank and flag them. Ask me questions for a better response.
This is useful for meeting notes, lead lists, content ideas, and messy intake data that arrived as paragraphs instead of rows.
7. Create a Chart or Insight
Which chart best shows [trend/comparison/distribution/progress] on tab [tab name]? Give me its data range, title and axis labels. Ask me questions for a better response.
Do not ask only for "a nice chart." Tell the AI what decision the chart should support.
8. Perform Multi-Step Spreadsheet Actions
Clean tab [tab name] for reporting: list the fixes in the safest order and pause before any destructive step. Ask me questions for a better response.
This prompt is deliberately review-first. It tells Gemini to plan before changing the sheet, which is the safer habit for shared files.
Formula Writing Prompts (12)
These prompts are for Google Sheets-native formulas. They work well with Gemini, ChatGPT, or Claude as long as you provide the tab name, range, and headers.
9. SUMIFS by Multiple Conditions
In [cell], write a Google Sheets formula summing tab [Sales] revenue for [region] and [product] from [start date] to [end date]. Ask me questions for a better response.
Ask for a follow-up version that references input cells instead of hardcoded criteria if you are building a dashboard.
10. XLOOKUP with a Fallback
Write a Google Sheets formula for [Orders!B2] that finds the customer name on tab [Customers] or shows 'Not Found'. Ask me questions for a better response.
Google Sheets supports modern lookup patterns, but the AI may also offer VLOOKUP or INDEX/MATCH. Ask it to explain which one is easiest to maintain in your file.
11. FILTER Matching Several Rules
Write a FILTER formula returning tab [Data] rows for team [team], dated after [date], excluding status [excluded status]. Ask me questions for a better response.
FILTER is often clearer than trying to create a helper column just to isolate rows.
12. UNIQUE and SORT List
List the unique [customer/product/category] names from tab [Responses] in one formula: sorted, no blanks, updating as rows arrive. Ask me questions for a better response.
This is one of the simplest ways to build dynamic dropdown sources and summary tables.
13. ARRAYFORMULA for an Entire Column
On tab [Tasks], write one ARRAYFORMULA for E2 showing 'Overdue' when past due and not Done, leaving blank rows blank. Ask me questions for a better response.
Ask the AI to include blank-row handling. Without it, formula columns can fill hundreds of empty rows with unwanted labels.
14. REGEXEXTRACT from Text
Write a Google Sheets formula extracting the invoice ID from column A text like '[INV-2026-0045 | ACME Ltd | Paid]'. Ask me questions for a better response.
Google Sheets regular-expression functions are extremely useful for messy imports, but the pattern needs sample data to be reliable.
15. REGEXREPLACE Cleanup
Write a formula that strips non-digits from the phone numbers in column A. Ask me questions for a better response, including whether I need leading zeros.
This prompt makes the AI handle the common trap: cleaned numbers may be identifiers, not values to calculate.
16. Working Days Between Dates
On Google Sheets tab [Projects], write a working-days formula for D2, then one that also skips holidays on tab [Holidays]. Ask me questions for a better response.
Always say whether the end date should count as a working day. Teams disagree on this more often than you would expect.
17. Date Buckets for Reporting
Write formulas labelling column A dates by month, quarter and financial year (starting [month]) so the labels sort correctly. Ask me questions for a better response.
The "sort correctly" requirement matters. Pretty month names can sort alphabetically unless you create a sortable key.
18. Weighted Average
Write a Google Sheets weighted-average formula (weights may not total 100) that skips blank scores and flags negative weights. Ask me questions for a better response.
This is better than asking only for a weighted average because it includes review logic.
19. Conditional Formatting Formula
Write a Google Sheets conditional formatting formula highlighting rows A2:H where column G is below [threshold] and H isn't 'Reviewed'. Ask me questions for a better response.
Conditional formatting prompts should always include the target range and the row where the rule starts.
20. Dynamic Dropdown Source
On tab [Lists], write a formula returning unique categories from tab [Raw], sorted and blank-free, as a dropdown source. Ask me questions for a better response.
Pair this with the Excel data validation guide if you also manage similar dropdowns in Excel.
Data Cleaning and Validation Prompts (10)
Google Sheets is often the place where form responses, CSV exports, copied web tables, and shared trackers collide. These prompts turn messy rows into cleaner, reviewable data.
21. Standardise Name Casing
Write a Google Sheets formula for column B that proper-cases and trims column A's names, flagging any under [number] characters. Ask me questions for a better response.
Good AI prompts combine cleanup and quality checks. The review flag catches suspicious results instead of silently polishing bad data.
22. Clean Phone Numbers
Clean column A's mixed-format phone numbers into column B with a Google Sheets formula. Should they be text or numbers? Ask me questions for a better response.
Phone numbers should usually be text because leading zeros and country codes matter.
23. Validate Email Addresses
Write a formula that labels column A's emails Valid or Review using a practical regex. Explain its limits. Ask me questions for a better response.
No spreadsheet regex can fully validate every email address. Ask for practical validation, not impossible certainty.
24. Split Full Names
Write formulas to split column A's full names into first, middle and last, leaving blanks for missing parts. Ask me questions for a better response.
Use this for operational cleanup, not legal identity handling. Names have real-world edge cases that formulas cannot fully solve.
25. Convert Text Dates and Text Numbers
Write Google Sheets formulas to convert the text dates and numbers in columns A and B without overwriting them. Ask me questions for a better response.
Keeping the original columns prevents accidental data loss when imports contain mixed formats.
26. Keep the Latest Record per ID
On a new tab, use formulas to list each ID's latest row from tab [Raw], by update date. Ask me questions for a better response.
Ask for a formula-based method first. Apps Script is useful, but formulas are easier for collaborators to inspect.
27. Check Required Fields
In column G, show Complete if A, C, D and F are filled, otherwise list the missing fields. Ask me questions for a better response.
This is a simple way to turn a shared intake sheet into a review queue.
28. Standardise Category Names
Standardise column C's messy categories, like [examples], with a formula and a reference table on tab [Category Map]. Ask me questions for a better response.
Reference tables are easier to maintain than giant nested IF formulas, especially when categories change.
29. Flag Outliers
Write a Google Sheets formula flagging outliers in column D ([metric]) using [standard deviation/IQR/percentage from average]. Which method suits this data? Ask me questions for a better response.
Prompting for the method first stops the AI from blindly applying a statistical rule that may not fit your business context.
30. Clean Messy CSV or Form Responses
Write a step-by-step checklist, with formulas, for cleaning my messy CSV import in Google Sheets without overwriting the raw data. Ask me questions for a better response.
If your messy files mostly live in Excel, my messy data cleaning guide covers the same thinking for that environment.
The Complete Excel Course with AI Integration
From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.
By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner
Buy nowApps Script Automation Prompts (10)
Apps Script is where Google Sheets starts behaving like a lightweight app. These prompts ask AI to generate scripts, but you should always test on a copied spreadsheet and review authorisation scopes before running anything on a real team file.
31. onEdit Timestamp
Write Apps Script for tab [tab name] that timestamps [timestamp column] whenever [watched column] is edited, ignoring the header row. Ask me questions for a better response.
Ask the AI to include the exact install steps: Extensions, Apps Script, paste code, save, and test.
32. Custom Menu
Write Apps Script that adds a custom menu, [menu name], when this Google Sheets file opens, with stub functions for [actions]. Ask me questions for a better response.
Custom menus make shared spreadsheet tools feel less fragile because users do not need to open the script editor.
33. Reminder Emails
Write Apps Script for tab [Tasks] that emails owners of tasks due within [number] days and not Done, without duplicate reminders. Ask me questions for a better response.
The duplicate-reminder rule is important. Without it, AI-generated scripts can spam your team during testing.
34. Export Sheet to PDF
Write Apps Script that exports tab [Report] to Drive folder [folder name] as a PDF named [report name] plus today's date. Ask me questions for a better response.
This is useful for weekly reports, invoices, certificates, and client-facing summaries.
35. Drive Backup Snapshot
Write Apps Script for a Create Backup menu item that copies this Google Sheets file, timestamped, to Drive folder [folder name]. Ask me questions for a better response.
Backups are boring until a shared file gets damaged. This is a practical automation for important trackers.
36. Calendar Event Creation
Write Apps Script that creates Google Calendar events from tab [Events] and writes each event ID back, skipping rows with IDs. Ask me questions for a better response.
Writing the event ID back to the sheet gives you a simple anti-duplicate system.
37. Form Response Processing
Write Apps Script that, on Google Forms submit, copies [fields] to tab [Reviewed], lowercasing emails, adding ticket IDs and sending confirmations. Ask me questions for a better response.
Use this when Google Forms is only the intake layer and the real workflow happens in a cleaner operational tab.
38. Duplicate Row Cleanup
Write Apps Script that lists duplicate rows from tab [Data], matched on [columns], in a new Duplicate Review tab. Delete nothing. Ask me questions for a better response.
For shared data, ask for a review tab first. Deleting rows automatically is rarely the safest first version.
39. Protected-Range Workflow
Write Apps Script that protects formula columns on tab [Dashboard], leaves [input ranges] editable and never locks out the owner. Ask me questions for a better response.
This is helpful when a spreadsheet becomes a team tool and accidental formula edits become expensive.
40. Weekly Report Generation
Write Apps Script that emails [recipients] a Drive-saved PDF of tab [Weekly Report] every Monday morning, with a dry-run mode. Ask me questions for a better response.
Ask for a dry-run mode whenever a script sends emails, writes files, or changes shared data.
Data Analysis Prompts (10)
These prompts are for turning rows into decisions. They work best when you give the AI column headers, sample rows, and the business question behind the analysis.
41. Trend Summary
Build weekly and monthly trend summaries of [metric] from tab [Data] with Google Sheets formulas. Ask me questions for a better response.
Ask for both weekly and monthly views because short-term noise can hide the real pattern.
42. Month-over-Month Growth
Write a Google Sheets formula or QUERY for month-over-month revenue growth by product, and highlight negative growth. Ask me questions for a better response, including missing months.
This prompt is stronger than asking for "growth formula" because it covers missing periods and review formatting.
43. Pivot Table Plan
Plan a Google Sheets pivot table that answers [question]: rows, columns, values, filters and any calculated fields, explaining each choice. Ask me questions for a better response.
Use this when the problem is exploratory. A pivot table is often better than a formula before you know what matters.
44. QUERY Summary
Write a Google Sheets QUERY on [range] totalling revenue by region and product for dates after [date], highest first. Ask me questions for a better response.
The QUERY function is one of the biggest reasons to ask for Google Sheets-specific help instead of generic spreadsheet help.
45. Cohort Retention
Build a Google Sheets cohort retention table by signup month and months since signup, using helper columns. Ask me questions for a better response.
This is advanced spreadsheet analysis, so ask for a step-by-step build rather than one giant formula.
46. Segment Comparison
Plan a fair comparison of customer segments in Google Sheets: formulas or pivot tables, charts, and checks for misleading conclusions. Ask me questions for a better response.
The "misleading conclusions" clause nudges the AI to think about sample size and context.
47. Top and Bottom Performers
Write Google Sheets formulas ranking the top 10 and bottom 10 [products/reps/campaigns] by [metric], excluding blanks and [excluded status] rows. Ask me questions for a better response.
This is useful for dashboards, performance reviews, and quick management summaries.
48. Correlation Check
In Google Sheets, check whether [metric 1] and [metric 2] move together: formula, scatter chart, and what correlation doesn't prove. Ask me questions for a better response.
Good analysis prompts ask for interpretation limits, not only the calculation.
49. Forecast Setup
Build a simple weekly sales forecast in Google Sheets with formulas and a chart. Ask me questions for a better response, including seasonality and one-off spikes.
For more structured forecasting in Excel, see the AI-assisted forecasting model guide.
50. Plain-English Executive Summary
Using this summary table: [paste table], write a plain-English executive summary with likely drivers, caveats and three follow-up questions. Ask me questions for a better response.
This works with Gemini, ChatGPT, or Claude. Paste only the summary data you are allowed to share.
Charts, Dashboards, and Collaboration Prompts (6)
Google Sheets is strongest when the sheet is shared, updated, and used by a team. These prompts focus on readability and collaboration, not just calculations.
51. Choose the Best Chart
Which Google Sheets chart best shows [trend/comparison/contribution/distribution] in columns [columns], and why? Which chart types would be misleading? Ask me questions for a better response.
The "misleading" part is the magic. It stops the AI from recommending a chart only because it looks polished.
52. Gemini Chart Prompt
Create a report-ready Google Sheets chart from [range] showing [message]. If you can't create it directly, give me manual steps. Ask me questions for a better response.
This wording works whether Gemini can act directly or needs to provide instructions for your current setup.
53. KPI Dashboard Layout
Design a one-screen Google Sheets dashboard for [team/process] from tab [Data]: KPI cards, charts, filters, helper tables and layout. Ask me questions for a better response.
Dashboard prompts should ask for layout and data flow, not only charts.
54. Sparklines for Quick Scanning
Write a SPARKLINE formula for column N showing each row's monthly trend from B:M. Ask me questions for a better response, including line colour and blank months.
Sparklines are excellent for dense Google Sheets reports where a full chart per row would be too much.
55. Collaborative Tracker Design
Design a Google Sheets tracker for [number] people managing [workflow]: status dropdowns, owners, protected ranges and a weekly review view. Ask me questions for a better response.
This is where Google Sheets often beats a local spreadsheet: everyone can work in the same lightweight operating surface.
56. Comments and Action Owner Workflow
Plan a shared Google Sheets workflow: owners, comments, statuses, due dates, open actions by owner. Suggest formulas, filters and conventions. Ask me questions for a better response.
Ask for conventions, not only formulas. Shared spreadsheets fail when the human workflow is vague.
Debugging and Review Prompts (4)
When something breaks, paste the exact formula, error, and a few sample rows. Debugging prompts without evidence become guesswork.
57. Formula Error Diagnosis
Why does [formula] return [error/wrong result] in Google Sheets? Sample rows: [paste]. Fix it, testing one row before filling down. Ask me questions for a better response.
For AI formula review habits that transfer back to Excel, see how to review AI-generated formulas before you trust them.
58. QUERY Parse Error
Fix this Google Sheets QUERY parse error: [formula]. Columns: [headers]. Explain the fixed syntax, including column letters vs Col1. Ask me questions for a better response.
QUERY errors often come from quotes, dates, labels, and mixed column notation. Ask the AI to explain the fixed syntax, not only paste a replacement.
59. IMPORTRANGE or Access Issue
My IMPORTRANGE formula isn't pulling data correctly: [formula]. Give me a safe diagnostic checklist. Ask me questions for a better response, including permissions and range references.
IMPORTRANGE issues are often permissions or range references, not formula intelligence.
60. Apps Script Authorisation or Timeout Debugging
Debug this Google Sheets Apps Script failing with [error/timeout]: [code]. Make it testable on a small range. Ask me questions for a better response, including authorisation scopes.
For scripts, always ask the AI to preserve your existing intent and change only the risky or broken parts.
How to Adapt These Prompts to Your Data
The prompts above are deliberately short, so you still need to fill in the context. Use this checklist before you send any serious Google Sheets prompt to Gemini, ChatGPT, or Claude.
- Name the tab — say whether the data is on
Raw,Responses,Dashboard, or another tab. - Give the range — include something like
A1:H500or say that new rows keep arriving at the bottom. - List the headers — column letters and header names are better than vague descriptions.
- Paste sample rows — three realistic rows usually beat a long explanation.
- State the output location — cell, column, new tab, pivot table, chart, or script output.
- Mention locale details — if your Google Sheets uses semicolons instead of commas in formulas, say so.
- State the tool — Gemini inside Google Sheets can sometimes act on the file; ChatGPT and Claude usually need pasted context.
- Keep the closing line — every prompt above ends with "Ask me questions for a better response." Answer the AI's questions in one reply before it writes anything.
- Add constraints — no Apps Script, no helper columns, formula-only, mobile-friendly, preserve raw data, or pause before deleting rows.
The safest pattern is: context first, task second, output format third, the AI's questions answered, review step last. That turns AI from a formula guesser into a practical spreadsheet assistant.
The Complete Excel Course with AI Integration
From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.
By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner
Buy nowFrequently Asked Questions
What are the best AI prompts for Google Sheets? The best prompts include the tab name, range, headers, sample rows, desired output, and the tool you are using. Gemini can work directly inside Google Sheets for many tasks, while ChatGPT and Claude usually need you to paste the relevant context.
Can Gemini write formulas in Google Sheets? Yes. Gemini in Google Sheets can help create formulas and perform spreadsheet actions when the feature is available on your account. Review formulas before relying on them, especially for financial, operational, or shared reporting work.
Can ChatGPT or Claude help with Google Sheets? Yes. ChatGPT and Claude can write Google Sheets formulas, QUERY statements, data-cleaning logic, and Apps Script code. Because they normally cannot see your live sheet, paste tab names, headers, sample rows, and the exact result you want.
Can AI write Apps Script for Google Sheets? Yes. AI tools can draft Apps Script automation such as custom menus, onEdit timestamps, PDF exports, email reminders, and weekly reports. Test scripts on a copied spreadsheet first, then review authorisation scopes before using them on real files.
How do I make Google Sheets AI prompts more accurate? Provide the exact tab name, data range, headers, sample rows, target cell or output tab, locale details such as comma or semicolon separators, and constraints such as no Apps Script, no helper columns, or preserve raw data. Then end the prompt with "Ask me questions for a better response." so the AI asks about anything you missed.
What should I paste into ChatGPT or Claude for Google Sheets help? Paste the tab name, range, headers, three to five sample rows, the formula or script you already tried, the exact error message, and the output you want. Remove private data before sharing spreadsheet content with an external AI tool.
When should I use Apps Script instead of a Google Sheets formula? Use formulas for calculations, lookups, filters, and visible spreadsheet logic. Use Apps Script when the task needs automation outside a cell, such as sending emails, exporting PDFs, creating Calendar events, protecting ranges, or running scheduled reports.
Are AI prompts safe for sensitive Google Sheets data? Treat sensitive spreadsheet data carefully. Use Gemini according to your account and organisation settings, and remove or anonymise private rows before pasting data into ChatGPT, Claude, or any external AI tool.
Related Tutorials
- The Complete Excel Guide 2026 — the hub page for all Excel tutorials.
- 60 AI Prompts for Excel That Actually Work — the Excel version of this prompt library.
- How to Use Gemini in Excel: Formulas, Setup and Free Options — useful if your spreadsheet work crosses Excel and Google Sheets.
- Excel vs Google Sheets: Main Differences and Which to Use — a practical comparison for teams choosing a spreadsheet tool.
- How to Use ChatGPT to Write Excel Formulas — the prompt structure also helps with Google Sheets formulas.
- How to Use Claude AI to Write Excel Formulas Instantly — useful for long-context formula explanations and debugging.
- The Complete AI Tools and AI Development Guide 2026 — the broader AI hub for tools, prompting, agents, and workflows.
Using this in a small business
- Gemini in Google Sheets for Small Businesses: 10 Practical Uses — ten practical Gemini in Sheets jobs for a small business.
- AI Quick Wins: 12 Things a Small Business Can Set Up This Week — twelve quick set-ups, several of them in a spreadsheet.
- AI Shift Scheduling vs a Rota Spreadsheet for Small Teams — when a rota spreadsheet is enough and when to switch.
- How to Build a Staff Training Matrix With AI — a staff training matrix built in a spreadsheet with AI help.
- How to Analyse Customer Feedback Surveys With AI — sorting survey responses into themes with AI.
- Can AI Help a Small Shop Set Prices and Promotions? — using a shop's sales data to set prices and promotions.
- How Bakeries Can Use AI to Predict Demand and Cut Unsold Stock — forecasting demand from a bakery's sales sheet.
- How to Forecast Covers and Cut Food Waste With AI — forecasting restaurant covers from booking and sales data.
- AI Food Insights Tool: Toast IQ, Square AI or a Spreadsheet? — Compare Toast IQ, Square AI and a spreadsheet with ChatGPT using the same four sales questions, with a scoring sheet and a way to check every answer.
- Catering Software for Small Business: Free Options and AI Extras — A free quote, order and invoice stack for a small caterer, then what a free AI assistant adds to each step and where it stops.
- How to Price Catering: A Cost-per-Person Sheet With AI — Build a catering cost-per-person sheet with AI: food, labour, equipment hire, overhead and margin, with a full 60-guest worked example and prompts to check it.
- AI Tools for Clothing Brands: From Sketch to Tech Pack to Listing — One overshirt taken from sketch photo to tech pack, supplier brief and product page, with the prompts, numbers and checks for each handover.
- AI Tools for a Grocery Store: Supplier Invoices and Shelf Prices — One week of supplier invoices in a one-shop grocery: read them with AI, check the totals, flag cost changes and set shelf prices that hold your margin.
- AI for a Car Rental Business: Enquiries, Availability and Damage Notes — Enquiry, availability and damage-note workflows for a small rental fleet: two source sheets, safe prompts, a photo shot list and where a person must decide.
- AI for a Jewellery Business: Anniversary and Repair Client Messages — Twelve templates for repair-ready and anniversary messages, plus the client segments, consent record and opt-out wording that keep them sendable.
- AI in Retail Commerce: Click-and-Collect for a Single Local Shop — Set up click-and-collect in the system you already use: a stock buffer rule with numbers, four order messages and a shelf-ordered pick list.
- Bakery Pre-Order Form for Christmas and Easter With AI — Form fields, slot caps, deposit wording and a reminder schedule, followed through a sample 120-order Christmas season with AI drafting the words.
- Bubble Tea Inventory: Forecast Tapioca, Milk and Cups by Weekday — A filled-in weekday sheet for a bubble tea shop: pearl batches, milk cartons and cup orders worked out from cups sold, with exam-week and weekend spikes.
- Car Detailing Price List Template: AI-Built Packages and Add-Ons — A filled-in car detailing price list built with AI: three packages, vehicle-size multipliers and an add-on menu, each priced from measured time and cost.
- Catering Menu Planning: Scale Recipes and Shopping Lists With AI — One 120-guest menu taken from recipe sheets to a supplier-ready produce order, with yield factors, pack-size rounding and the checks to run before ordering.
- Coffee Shop Inventory With AI: Ordering Milk, Beans and Pastries — Turn till data into par levels for milk, beans and pastries, keep a waste log, and have AI draft the supplier order for you to check and send.
- Customer Loyalty Programmes for Retail Stores: Can AI Design One? — A small shop's loyalty programme drafted with AI: points, stamps and tiers costed line by line, plus the five corrections the draft needed.
- Dog Grooming Price List Template: Breed, Coat and Size Tables With AI — A dog grooming price list template built from your hourly rate, timed grooms, size bands, a de-matting surcharge and add-ons, with AI doing the tables.
- How Much to Charge as an Event Planner: Flat Fee vs Percentage — Flat fee, percentage or hybrid: two worked quotes, a corporate launch and a private weekend, built from your own hourly cost with an AI fee model.
- Florist Inventory Management: Use AI to Track Stems and Waste — A stem-and-waste sheet for a one-shop florist: recipes turn bouquets sold into stems used, a waste log shows what to cut, and AI writes the formulas.
- Florist Wedding Quote Template: Price Stems, Labour and Hire With AI — A worked wedding quote in a sheet: stems, waste, labour hours, hire items and delivery, plus the ChatGPT prompts that build it.
- Free AI Workflow Automation: Three Shop Jobs That Fit the Free Tier — Enquiry logging, review requests and a daily sales summary on free Zapier and Make plans, with the task and credit sums worked out for each job.
- Google AppSheet for Nonprofits: Volunteer Rota App Without Code — A build-or-buy check for an AppSheet volunteer rota: the steps, the yearly cost for 42 volunteers, and the limits on reminders and outside users.
- Horse Feed Chart Template: Build Yard Feed Sheets With AI — How one livery yard turned messy owner messages into a master feed sheet, change log and whiteboard copy, with prompts and sample rows.
- Hotel Rate Shopping: A Weekly Competitor Rate Sheet Built With AI — A weekly competitor rate sheet for a small hotel: pick five rivals, fix the search, capture rates by hand, then let AI summarise and flag what moved.
- Hotel Staff Scheduling With AI: Front Desk, Housekeeping, Breakfast — A department-by-department rota method: occupancy sets the cover, hard rules limit the AI, and a checker sheet catches what its draft gets wrong.
- How Much to Charge for Dog Walking: Solo, Group and Holiday Rates — A worked rate card for solo walks, group walks and holiday cover, built from your cost per diary hour, travel time and cancellation losses.
- How to Use AI in a Bakery Business: Wholesale and Standing Orders — Wholesale bakery workflow: one standing-order sheet, a change form for cafés, AI that reads messy messages, and reminder texts that get answered.
- Martial Arts Summer Camp Ideas: Sign-Ups and Parent Emails With AI — A four-week camp plan for a martial arts school: 20-place pricing, daily timetable, safeguarding and pick-up rules, a sign-up page and six parent emails.
- Mobile Hairdressing Business: Diary, Travel Time and Rebooking With AI — Plan a mobile hairdresser's diary around drive time: patch days, same-street batching and rebooking texts, with two Tuesdays compared in minutes and income.
- Ice Cream Inventory: Forecast Tubs by Flavour, Weather and Weekday — Build a simple sheet that turns your sales log and the weather forecast into tubs per flavour, with a reorder rule and a spoilage check.
- Record Store Software: Catalogue Used Vinyl and Track Stock With AI — A one-row-per-copy sheet, a shared grading standard, AI-drafted listings and a pricing check you do yourself, worked through on a 40-record box.
- Vacation Rental Analytics: Occupancy and Rate Reports With AI — Export bookings, split stays across months, work out occupancy and nightly rate in a sheet, then have AI write the monthly summary.
- Wedding DJ Questionnaire: Must-Plays and Timeline Built With AI — Thirty questions for a wedding DJ form, then an AI prompt that turns the answers into a run sheet, flags clashes and drafts MC notes for the couple to approve.
- Game Store Inventory Management: Preorders and Trade-Ins With AI — Three ledgers for a games shop: a preorder deposit log, a singles pricing rule and a trade-in buy list, with AI drafting listings and customer replies.
- Hotel Shift Handover Notes With ChatGPT: From Desk Logs to a Daily Report — A one-line-per-event desk log, anonymising rules, two ChatGPT prompts and a worked Tuesday that shows what the AI gets wrong and how to catch it.
- Music Store Inventory Management: Used Gear and Trade-Ins With AI — One row per instrument, serials stored as text, a trade-in pricing sum and AI-drafted condition notes and listings, all in a spreadsheet a small shop can run.
- Personal Trainer Progress Reports: Monthly Client Summaries With AI — A worked month for one client: measurement table in, honest report out, with a three-step check so the AI never adds results you didn't record.
- How Can AI Help a Small Supermarket? Pricing, Stock and Posters — A one-store version of what the chains do: a weekly price check, a reorder list and offer posters, with the prompts, sums and checks to run each.
- Museums and AI: Turn Visitor Feedback Into Next Season's Plan — How a small museum can sort a season of visitor comments into themes with AI, check the tags, and turn the counts into five fixes for next season.
- Electrical Contractor AI: Setting Up Permit and Inspection Tracking — A spreadsheet tracker for permits, notifications and inspection dates, plus AI prompts that draft the chasers and flag jobs before they stall.
- Mileage Log for the Self-Employed: App, Spreadsheet or AI-Built Sheet? — The fields a mileage log needs, what apps cost against a free sheet, and one worked month of 98 trips logged three ways.
- Tool Tracking for Contractors: Paid App or a Sheet Built With AI? — A sheet with a QR check-out form costs nothing; paid apps start free or around $100 a month. See what each must record and the sum that decides it.
- AI for Architecture: Keep a Drawing Issue Register and Transmittal Log — One long-form register, AI that turns issue emails into checkable rows, formulas for current revisions and a ten-point check before anything is sent.
- Best AI for Cabinet Making: Supplier Orders, Lead Times and Chasers — How a small cabinet shop can use AI to chase board, hardware and door orders: a lead-time tracker, chaser prompts and acknowledgement checks.
- Electrical Permit Application: Track Permits and Inspection Dates With AI — A contractor's permit tracker: one job record for applications, a dated sheet for inspections, and AI for scope summaries, chase lists and correction notices.
- FF&E Schedule for Interior Designers: Build and Check It With AI — Build and check an interior design FF&E schedule with AI: the columns that matter, a totals audit, price checks against suppliers and a change log.
- Glide Mobile App Builder: A Snag List Photo App for a Building Firm — Which Glide to pick, how to build a sheet-backed snag list with camera photos and status filters, how to show clients only their plot, and the plan cost.
- Gritting Contracts: Price Winter Call-Outs and Plan Night Runs With AI — Work out what a night run costs, compare three ways to charge, write the trigger clause, order the route and keep a log that protects you.
- Gutter Cleaning Flyers: Three Leaflet Versions Written and Tested With AI — Three leaflet headlines, matched streets, a code per version and a two-week scorecard: find out which gutter cleaning flyer really brings calls.
- Gutter Cleaning Software: Reminders, Routes and Recurring Bookings With AI — A reminder, route and rebooking workflow for gutter cleaners: recurring jobs, reminder timing, patch days, AI-drafted replies and opt-outs.
- HVAC Callbacks: Log the Cause on Every Job and Spot the Pattern With AI — A callback log with ten cause codes, a worked quarter showing one repeat pattern, and a 20-minute weekly review for Jobber, Housecall Pro or a spreadsheet.
- HVAC Markup and Margin: A Worked Check on Past Jobs With AI — A worked audit of 50 HVAC jobs: markup versus margin formulas, a sheet you can check by hand, AI help with formulas, and a flag for jobs below target.
- Home Builder Selection Sheet: Track Allowances and Deadlines With AI — A builder-side spreadsheet that works out decision deadlines from the schedule, flags late selections and allowance overages, with AI-drafted reminders.
- Home Inspection Report Template: Build a Comment Library With AI — How to turn your best past comments into a reviewed library of plain-English defect comments, with prompts, review rules and standards checks.
- Hourly Rate for a Tradesman: Work Out Yours Without Guessing — A four-step method for a tradesman's hourly rate, with a worked plumber example, a crew version, a billable-hours log and an AI check of the maths.
- How to Price Pest Control Services With an AI-Built Rate Sheet — A rate sheet built from route minutes: cost per stop, home-size bands, initial versus recurring visits and travel zones, with the sums checked.
- How to Use Google AI Form Builder for a Builder's Site Visit Checklist — A walkthrough for a small building firm: draft a site visit checklist with Gemini in Google Forms, add sections and photo fields, and link a response sheet.
- Landscaping Estimate Template: Itemise Labour, Plants and Waste With AI — A worked front-garden estimate with labour, plant, materials and waste lines, a margin check, and four AI prompts that do the typing, not the pricing.
- Pool Service Report Template: AI Summaries and Chemistry Alerts — A field-by-field pool service report, green, amber and red bands you set yourself, and AI that writes the summary while a formula flags the readings.
- Price Carpet Cleaning Jobs: Build a Per-Room Calculator With AI — Build a carpet cleaning calculator from your own costs: per-room prices, a minimum charge, add-ons and a margin check, with the spreadsheet formulas.
- How to Price Pool Service With an AI-Built Pricing Sheet — A pool service pricing sheet built from volume, stop minutes, chemicals, driving and overhead, with a worked stop, seasonal margins and a margin check.
- Snow Plow Route Optimisation: Plan Pushes and Priority Sites With AI — Priority tiers, trigger depths and truck count for plough routes, with ChatGPT prompts and a map tool, checked against last storm's log.
- AI Real Estate Investment Analysis: Vet a Rental Deal Step by Step — A rental-deal checklist for small investors: rent comps, assumptions table, cash flow, a seller cap rate check and the AI maths errors to catch.
- AI Tools for Asset Management: Factsheet Commentary With Sign-Off — A month-end workflow for factsheet commentary: source-only drafting, a check on every figure, and a named approver who signs a log.
- AI for Insurance Brokerage: Reconcile Insurer Commission Statements — A routine for parsing insurer commission statements, matching them to a brokerage's policy ledger, listing exceptions and chasing insurers.
- Gemini for Accountants: Gmail, Sheets and AI() for Practice Tasks — Practice tasks for Gemini in Gmail and Sheets, and a tie-out step that checks every =AI() result against the source.
- AI Accounting for NDIS Providers: Categorising Income and Claims — How an NDIS provider can use AI to categorise bank-feed income, match payments to claims and spot unpaid ones, with privacy rules and an accountant's review.
- How Can AI Help Therapists With Superbills and Client Invoices? — Use AI for a therapy practice's billing: superbill and invoice templates, a monthly batch routine and checks, with no clinical content near the tool.
- Parents' Evening Booking System: Slots, Reminders and Clashes With AI — Slot maths, booking tool options, reminder wording and sibling clashes for a small school or tutoring centre, with AI doing the grid and the checking.
- Private School CRM: Do You Need One, or Will a Sheet and AI Do? — When a sheet with AI follow-ups is enough for school admissions enquiries, when HubSpot or a school-specific CRM earns its cost, and how to switch.
- Daycare Inspection Checklist: Prepare Your Records With AI — Build a daycare inspection checklist from your licensing rules, check staff and child records against it with AI, and keep a corrective-action log.
- Dental Equipment Maintenance Log: Service Dates and AI Reminders — A spreadsheet register for dental equipment with service dates, warranty flags and calendar reminders, plus AI that turns invoices and reports into rows.
- Dental Lab Case Tracking Template and AI Status Updates — A case-tracking sheet with stage definitions, due-date formulas and exception alerts, wired to send dentists status updates drafted with AI.
- AI for Healthcare Clinics: Referral Tracking and Chase Letters — A referral log, a 20-minute weekly overdue sweep and AI-drafted chase letters with no clinical detail, checked against the log.
- Independent Educational Consultant Software: An AI-Built Tracker — Build a student and deadline tracker in Google Sheets with AI help: tabs, working formulas, a weekly digest, parent update emails and consent.
- Medical Practice KPIs: A Monthly Dashboard Built With AI — Six medical practice KPIs with exact formulas, a worked month of numbers, a sheet layout and an AI prompt for the commentary the partners will read.
- Best AI Tool for Pricing Wholesale Goods: Chat Assistant or App? — Chat assistant plus a sheet, an inventory-system price list, or pricing software: the right pick depends mostly on how many SKUs you carry.
- AI Tools for Creating Digital Products: Printables and Templates Compared — Which AI tool suits which printable or spreadsheet template, what Etsy expects you to disclose, and the licence checks before you sell.
- AI for WooCommerce Stores: Descriptions and Support Replies — Draft descriptions in a controlled CSV batch and prepare support replies from verified order details.
- Dropshipping Profit Margin: A Spreadsheet AI Can Audit — One product, one spreadsheet: contribution margin per order after ads, fees, refunds and chargebacks, break-even ROAS and an AI audit of the formulas.
- Farmers Market Stock Planning: How Much to Pack Each Week With AI — Log each stall day, set weather factors from your own sales, and let AI build the sheet that tells you how much to load the van.
- How to Price Handmade Items: Materials, Hours and Fees With AI — A hand-poured candle priced from materials, a real hourly rate, overheads and marketplace fees, with the sheet and prompts to repeat it.
- Machine Shop Quote Template: AI Turns RFQ Emails Into Draft Quotes — Extract part, quantity, material and finish from RFQ emails, price from your rate card, and let an estimator approve every number.
- Manufacturing Cost Estimating: How AI Helps Price a New Product — One new steel product costed end to end with AI help: materials, labour minutes, overhead, scrap, tooling, margin and what moves the price.
- Practical AI for Business Owners: A First-Week Plan With Free Tools — A seven-day plan for owners starting with free AI tools: one task a day, copyable prompts, sample outputs and a clear keep-or-drop review on day seven.
- Using AI for Small Business Accounting: What to Hand It First — A sorted checklist: which bookkeeping jobs AI can take, which need your review, and which stay with you or your accountant.
- eBay Promoted Listings: Set Ad Rates With AI and a Margin Floor — Work out the highest ad rate each item can bear, set a margin floor, and test cost-per-sale rates by category with AI doing the arithmetic.
- Is Airtable Worth It for a Small Business? When a Spreadsheet Is Enough — A decision guide with cost thresholds: when a spreadsheet is enough, when Airtable's Team plan pays for itself, and what the AI credits add.
- AppSheet With Gemini: Build a Job-Tracking App by Describing It — Describe a job tracker to Gemini in AppSheet, edit the tables it proposes, clear the sample data and test it with staff.
