📊 Lesson 8.1: Templates, Add-ons & Gemini / AI in Sheets (Honest Free vs Paid)

Templates: A Running Start

A template is a pre-built spreadsheet someone already designed — the headers, the formulas, the formatting, the layout — waiting for you to drop your own numbers in. Think of it like a furnished apartment versus an empty one: the walls, the wiring, and the furniture are already there, so you can move in today instead of building from studs. For common jobs — a monthly budget, an invoice, a schedule, a project tracker — someone has almost certainly built a reasonable starting point already.

The template gallery

When you're on the Google Sheets home screen (at sheets.google.com), there's a Template gallery across the top — a row of ready-made sheets grouped into categories like Personal (budgets, schedules, to-do lists), Work (invoices, project timelines, expense reports), and more. Click one and Sheets makes you a fresh copy that's entirely yours to edit. You're never editing the original; you always get your own copy.

Using and customizing a template

The trick with any template is to treat it as a draft written by a stranger, not a finished product. Before you rely on it, do three things: read what each column is for, click into the summary cells to see what formulas are actually doing, and delete anything you don't need. A budget template might assume monthly income you don't have, or categories that don't match your life. Bend it to your reality — don't bend your reality to it.

Making your own template

Google's own templates are the polished ones, but the most useful template is often one you make. If you build a sheet you'll recreate again and again — a weekly report, a client invoice, a project kickoff tracker — the simplest durable approach is: build it once, clean it up (remove the sample data, keep the headers and formulas), and then use File → Make a copy every time you need a fresh one. Name the clean version something obvious like TEMPLATE — Weekly Report and keep it in its own folder so you don't accidentally type real data into the master.

Add-ons & the Marketplace (and the Permissions Caution)

An add-on is a small third-party program that plugs into Sheets to give it a new ability the built-in menus don't have — things like generating a document from your rows, connecting to an outside service, or bulk-cleaning data. You find and install them from the Google Workspace Marketplace, reached from Extensions → Add-ons → Get add-ons.

What add-ons do

Add-ons cover a wide range of jobs. Rather than endorse specific products (they come and go, and this course is independent), it's more useful to know the common categories so you can recognize what you're looking at:

The permissions caution — read before you click "Allow"

This is the part nobody slows down for, so we will. When you install an add-on, a Google screen lists the permissions it's requesting — the things it wants to be allowed to do, such as "See, edit, create, and delete your spreadsheets" or "Send email as you." Granting these is a real decision, not a formality.

⚠️ Important Note: An add-on can only do what you permit — so read the permission list and grant carefully. Be extra cautious with anything that wants access to all your files, your email, or your contacts when its job doesn't obviously need that. Prefer add-ons from developers you can identify, with many installs and reviews. You can always review and revoke what you've granted later at your Google Account's security settings (Third-party access). When in doubt, don't install.

Gemini & AI in Sheets — Honest and Hedged

Google has been adding AI features to Sheets under the Gemini brand — things like a "Help me organize" panel that can suggest a table structure, assistance writing or explaining a formula, and generating starter tables from a plain-language description. These are genuinely useful when they work. But here honesty matters more than hype, so let's be precise about the caveats.

⚠️ Important Note — availability changes constantly: Which AI features you can see depends on your plan, your region, your account type, and the date. They roll out gradually, get renamed, move between menus, and sometimes appear for some accounts before others. Some are free; many require a paid Google Workspace edition or a paid Gemini plan. This course will not quote exact prices or promise a specific feature is in your account — both go stale fast. Check Google's current pricing and feature pages for what's true for you today.

What these features try to do

• Organize / summarize: suggest how to structure messy data, or summarize a range in words.
• Formula help: draft a formula from a description ("sum sales where region is West"), or explain a formula you don't understand.
• Generate tables / starters: produce a starter table or sample layout from a prompt.

Notice these overlap with skills you already have. That's the honest framing: AI in Sheets is a faster first draft, not a replacement for understanding. You'll get the most from it precisely because you learned the fundamentals — you can tell when its answer is right.

The Free-vs-Paid Map

People get confused about what actually costs money in Google's world, so here's an honest map. The headline: the core of Google Sheets — and everything in this course — is free with a personal Google account. The paid tiers add capacity, admin control, and some AI. Numbers and exact inclusions change, so this is the shape, not a price list — always check Google's current page for the specifics.

Using AI Well: Assistant, Not Oracle

The right mental model for AI in Sheets is a fast, tireless intern: great for first drafts and boring work, but everything it produces gets checked before it ships. You are the senior person who signs off. Here's how to work that way.

Good jobs to hand an AI assistant

• Explain a formula you inherited and don't understand — then confirm the explanation against what you know.
• Draft a first version of a formula from a plain-language description, to save typing.
• Suggest a structure for messy data, or brainstorm categories for a column.
• Generate sample data for practice (never mistake sample data for real data).

Always verify — a quick checklist

Whenever an AI writes a formula or produces a number, run it through this before you trust it:

• Read the formula — do the ranges point at the right cells? Are the criteria correct?
• Spot-check the result — compute one case by hand or with a tiny manual sample and compare.
• Try an edge case — an empty cell, a zero, a duplicate. Does it still behave?
• Ask "why" — if you can't explain why the answer is right, you're not done verifying.

⚠️ Important Note: Never paste an AI-generated formula into a sheet other people rely on without checking it first. "The AI wrote it" is not an answer when a report is wrong — your name is on the sheet. Verify, then ship.

🎯 Project: Template + Add-on + AI Try-out

Time to explore all three shortcuts hands-on — and, crucially, to label as you go what was free and what would need a paid plan. You'll come away with a real feel for the ecosystem and a small "shortcuts log" you can reuse.

Shortcuts Log

Item                     | What it did                | Free / Paid / Blocked | Verified?
------------------------ | -------------------------- | --------------------- | ---------
Template: Monthly Budget | Prebuilt budget sheet      | Free                  | n/a
Add-on: (name)           | (its job)                  | Free / needs paid     | permissions read
AI: formula assist       | Drafted a SUMIFS for me    | May need paid plan    | YES - checked by hand

Note: prices and availability change - I checked Google's current page on (date).

Best Practices for Templates, Add-ons & AI

✅ Do's

• Reverse-engineer templates. Click through their formulas to learn how pros structure a sheet.
• Read every permission screen. Grant the least access an add-on needs to do its job, and no more.
• Verify AI output every time. Treat it as a first draft you sign off on, not a final answer.
• Check Google's current page for what's free versus paid before assuming.

❌ Don'ts

• Don't fight a template. If you're battling it, a blank sheet plus your skills is faster.
• Don't install add-ons you don't recognize or that want access far beyond their purpose.
• Don't paste AI formulas into shared sheets unchecked. Your name is on the numbers.
• Don't pay to finish this course. Everything here works on the free tier.

📓 Learning Journal

📝 Lesson Summary

🎉 What You've Accomplished

You explored three real shortcuts and — more importantly — learned to use each one with judgment: a template as a draft to bend, an add-on only after reading its permissions, and AI only after verifying its output. You also built an honest mental map of what's free and what costs money, so you'll never be confused into paying for something you don't need. That discernment is exactly what separates a confident spreadsheet user from someone at the mercy of the tools.

❓ Common Questions at This Stage

🔭 Looking Ahead

In the next lesson — Lesson 8.2: Performance, Common Errors & Best Practices — we make your sheets fast and correct. You'll learn why sheets get slow and how to speed them up, decode every error message Sheets can throw at you, and lock in a best-practices checklist that keeps your work reliable as it grows. It's the polish that makes everything you build trustworthy.

✅ Before the Next Lesson

• Finish your Shortcuts Log with each item honestly labeled free, paid, or blocked
• Revoke any add-on access you tried but don't plan to keep
• Write your Learning Journal entry for this lesson

📚 Additional Resources

• Use Google Sheets templates (Google Support)
• Google Sheets Help Center — add-ons & more
• Google Workspace — editions & current pricing
• Google Sheets function list (Google Support)