Google Sheets AI features include Gemini in the sidebar for formula suggestions, data summaries, and chart generation. Paired with ChatGPT for formula writing and structure planning, you can produce a finished table, project plan, or checklist in a fraction of the time it takes to build manually. On aidowith.me, the Tables, Plans & Checklists route runs 10 steps in about 1 hour. You'll use Gemini's sidebar to summarize data and suggest charts, and ChatGPT to generate formulas for tasks that Gemini's sheet integration doesn't handle cleanly. Step 1 starts with a blank sheet and a real task. Step 10 ends with a finished deliverable you can share today. The route works for any professional who builds reports, tracks projects, or runs recurring checklists in Sheets. No prior formula knowledge is required at the start of step 1.
Last updated: April 2026
The Problem and the Fix
Without a route
- Writing VLOOKUP, ARRAYFORMULA, and conditional logic from scratch eats 2+ hours per sheet for non-developers.
- Gemini's Sheets sidebar is available but 60% of users never touch it because there's no guided starting point.
- Building a project plan or tracker in Sheets takes a full afternoon when the structure could be generated in 10 minutes with AI.
With aidowith.me
- The route on aidowith.me shows you how to use Gemini's sidebar and ChatGPT together so every formula and structure is generated, not typed from memory.
- 10 steps take you from blank sheet to finished deliverable in about 1 hour, with AI doing the heavy lifting on formulas and layout.
- The route covers tables, project plans, and checklists, the 3 most common professional Sheets use cases.
Who Builds This With AI
Marketers
Content, campaigns, and briefs done in hours instead of days.
Sales & BizDev
Prep calls, draft outreach, research prospects in minutes.
Managers & Leads
Reports, presentations, and team comms handled faster.
How It Works
Open Gemini in Sheets and describe your task
In Google Sheets, click the Gemini icon in the sidebar. Type a one-sentence description of the table or plan you need and let Gemini generate the initial structure.
Use ChatGPT to write complex formulas
For any formula Gemini's sidebar doesn't handle, paste your column headers and goal into ChatGPT and get a working formula in under 30 seconds.
Complete the 10-step route to a finished deliverable
Follow the route on aidowith.me through data validation, conditional formatting, and final review. By step 10, you have a sheet you can share today.
Build Your First AI-Powered Sheet in 10 Steps
Join aidowith.me and follow the Tables, Plans & Checklists route. Go from blank Sheets tab to finished deliverable in about 1 hour.
Start This Route →What You Walk Away With
Open Gemini in Sheets and describe your task
Use ChatGPT to write complex formulas
Complete the 10-step route to a finished deliverable
The route covers tables, project plans, and checklists, the 3 most common professional Sheets use cases.
"I built a 6-month project tracker in one hour. Took me a full day the last time I did it without AI."- Project manager, digital agency
Questions
Open Google Sheets, click the Gemini icon in the top-right sidebar, and describe what you need in plain text. Gemini will suggest a structure, formulas, or a data summary depending on your input. For complex formulas, paste your column headers into ChatGPT and ask for the formula. The Tables, Plans & Checklists route on aidowith.me shows you how to combine both tools across 10 steps in about 1 hour.
For common formulas like SUMIF, COUNTIF, and conditional logic, yes. Gemini's Sheets integration handles these in seconds. For advanced cross-sheet references, array operations, or custom logic, it occasionally needs a correction. The fastest workflow is to generate with Gemini, check the output, then use ChatGPT for anything that needs refinement. The route on aidowith.me builds this workflow into 10 practical steps.
Gemini in Google Sheets is available on Google Workspace plans, including Business Starter at $6 per user per month. It's not available on personal free Google accounts at the time this route was written. If you don't have a Workspace account, you can still complete the route using ChatGPT for formula generation and structure planning, which covers the same outcomes without the Gemini sidebar.