AI WORLD HQHow to Build a Simple Weekly Schedule in Google Sheets with Gemini
Describe your week and get a ready-to-use template with time blocks, color categories, and hours-totaling formulas
This guide was written by AI. It passed automated fact and quality checks; no human editor reviewed it.
Most weeks you can list your time blocks in your head — work, gym, family dinner, the Saturday coffee — yet you never actually write them down. That's the gap this guide fills. In about ten minutes, you'll describe your week in plain English and end up with a color-coded schedule in Google Sheets that adds up your hours for you. The result is something you'll actually open on Sunday evening, not a spreadsheet that dies in your downloads folder.
💡 Tip: tap a step’s number when you finish it — a green tick appears and your browser remembers how far you got.
- A Google account (free — the same one you use for Gmail).
- A computer or phone that can open Google Sheets: go to sheets.google.com in any browser, or install the free Google Sheets mobile app.
- Roughly 10 to 15 minutes, and a rough mental picture of what your week actually looks like.
- Some Gemini features inside Sheets are only available on paid Google plans — if you don't see the Gemini option, check Google's official pricing page for the latest plan details. A free workaround: draft the schedule at gemini.google.com first, then paste it into Sheets.
Open Google Sheets and start fresh
Open sheets.google.com in your browser, or launch the Google Sheets app, and sign in with your Google account. Click the "+" button or "Blank spreadsheet" to create a new, empty sheet. Name it by clicking "Untitled spreadsheet" at the top-left and typing something you'll recognize later — "My weekly schedule" works fine.
Menu wording changes often — just look for any option that creates a fresh, empty sheet.
on a phone, the "+" usually sits in the bottom-right corner; if you only see templates, tap "Blank" inside that section.
you see a grid of empty cells with column letters (A, B, C…) across the top and row numbers (1, 2, 3…) down the side.
Open the Gemini side panel
Look at the top-right corner of the Sheets window for a small sparkle ✨ icon or a button labeled something like "Help me" or "Ask Gemini." Click it. A side panel slides in from the right edge — this is your chat window, and you'll stay inside your spreadsheet the whole time.
If you don't see a sparkle, open the "Tools" menu (sometimes labeled "Extensions" on older versions) and look for anything mentioning Gemini or "Ask." On Workspace accounts, your admin may need to turn Gemini on — if the option is entirely missing, ask your IT admin or check Google's help pages.
Gemini's exact location in Sheets has moved over the years.
you can type a question into the side panel and an answer appears in the same panel within a few seconds.
Add color categories so your eyes can scan it fast
Highlight the column or row headers by clicking the letter at the top of the column (or the row number on the left), then pick a fill color from the toolbar. Look for a paint-can icon or a "Fill color" button. Then color each activity by type: one color for work, one for fitness, one for family, one for rest. Pick colors that mean something to you.
On a phone, the same tool lives inside the formatting menu, often marked with an "A" and color bars underneath it.
the fill-color icon sometimes looks like a tipped-over paint bucket.
you can glance at the sheet and instantly see which parts of your week are work, which are fitness, and which are family time — without reading a single word.
Add a formula that totals your hours
At the bottom of one day's column, click an empty cell and type a SUM formula. In Sheets, every formula starts with =. If you've put the duration of each activity in plain numbers (8 for an 8-hour workday, 1.5 for a 90-minute class), the formula adds them up for you.
Ask Gemini in the side panel, "How do I add up time blocks written as text in Sheets?" if you get stuck.
if your time blocks are written as text like "9–5", Sheets can't add them up — they'd need to be plain numbers in a separate "Hours" column.
the total cell shows a number that updates the moment you edit any of the time blocks above it — that's the formula doing its job.
Save once and forget about it
Look at the top-left of the screen for your file name. As long as you're signed in, Google Sheets saves your work automatically every few seconds — there's no "Save" button to click. If you see a small gray "Saving…" message or a checkmark next to the title, you're done.
you can refresh the page or close and reopen the file and find your schedule exactly as it was.
- Mistake: asking Gemini something too vague. "Make me a schedule" gives a generic template that won't fit your life. Always include your real hours, real activities, and how many days — the more specific you are, the better the output.
- Mistake: writing time blocks as text like "9–5". Sheets can't add text up, so your total stays at zero. Fix: put the duration as a plain number in a separate "Hours" column (8 for an 8-hour workday, 1.5 for a 90-minute class), or ask Gemini how to convert time strings to numbers.
- Mistake: assuming Gemini inserted your schedule when it only chatted. Some versions of Gemini in Sheets can only suggest, not insert. Fix: read the side panel carefully — if you see an "Insert" button, click it; otherwise copy the suggestions into the cells yourself.
Open a new Google Sheet, open the Gemini side panel, and paste this in: "I teach three morning classes Monday, Wednesday, and Friday from 8 to 11 a.m. I work part-time Tuesday and Thursday from 1 to 6 p.m. I have family dinner every weekday at 7 p.m. Build me a weekly schedule with time blocks, three color categories (teaching, work, family), and a SUM formula that totals hours per category." See what it gives you, change the colors to match your real life, and you've got a planner that took ten minutes to make and will save you hours of "wait, what day is it again?" by next Sunday.
❓ Quick questions
How long does this take?
About 6 minutes — the guide has 7 steps, and you can tick each one off as you go.
Which tool do I need?
This guide uses Google Gemini — but the approach works very similarly in other AI assistants.
Do I need to prepare anything?
- A Google account (free — the same one you use for Gmail).
- A computer or phone that can open Google Sheets: go to sheets.google.com in any browser, or install the free Google Sheets mobile app.
- Roughly 10 to 15 minutes, and a rough mental picture of what your week actually looks like.
- Some Gemini features inside Sheets are only available on paid Google plans — if you don't see the Gemini option, check Google's official pricing page for the latest plan details. A free workaround: draft the schedule at gemini.google.com first, then paste it into Sheets.
What mistakes should I avoid?
- Mistake: asking Gemini something too vague. "Make me a schedule" gives a generic template that won't fit your life. Always include your real hours, real activities, and how many days — the more specific you are, the better the output.
- Mistake: writing time blocks as text like "9–5". Sheets can't add text up, so your total stays at zero. Fix: put the duration as a plain number in a separate "Hours" column (8 for an 8-hour workday, 1.5 for a 90-minute class), or ask Gemini how to convert time strings to numbers.
- Mistake: assuming Gemini inserted your schedule when it only chatted. Some versions of Gemini in Sheets can only suggest, not insert. Fix: read the side panel carefully — if you see an "Insert" button, click it; otherwise copy the suggestions into the cells yourself.
Keep reading
✦ Generated by AI in AI World HQ's automated newsroom, written in plain language. Checked by automated fact and quality gates — no human editor reviewed this guide. Spot a mistake? Use the buttons above.
← Back to all stories