THE FUTURE MARKETACADEMY
Your classroomRoom 07 · Tech Lab
School of Data & Tech

Sheets Systems Lead: governance and team training

Step 8 of 8 in Tech Lab

Next in your path: 7.3.4 Analytics Lead: strategy, ethics and mentoring

What you'll be able to do
  • Map every important spreadsheet in a team workspace with a register: owner, location, sharing and risk.
  • Design permissions with roles, groups, shared drives and expiry dates, so people get only the access they need.
  • Plan for people leaving: ownership, transfers, triggers and regular access reviews.
  • Write naming standards for files, tabs, tables, named ranges and named functions, and check them with a formula.
  • Set backup and recovery rules with version history, named versions and a scheduled backup script.
  • Review someone else's sheet with a checklist and give feedback with assigned comments.
  • Plan and run a hands-on training session for your team.
  • Keep governance alive with a one-page standard, a few simple measures and a review calendar.

Before this course: Sheets Systems: connected tools and dashboards (course 7.2.3). You should already be able to design a Sheets system in layers, use tables, filter views and protected ranges, build dashboards with slicers, connect Data Studio and write a system map with health checks. In 7.2.3 you built one system for one team. In this course you lead the whole team workspace: who can see what, how things are named and saved, how work is checked and how people are trained.

A note on accounts: some features in this course (shared drives, access expiry dates, admin settings) work only with work or school accounts. Personal Google Accounts can still use the ideas with My Drive and careful sharing. Menu names can change over time. This course teaches spreadsheet skills; it is not legal advice.

Words in this course 52Open the Vocabulary Hall
01

The lead's job: map the team workspace

In simple words

Before you tidy a messy garage, you first look at everything in it and write a list: what it is, whose it is and whether it is safe. A sheets register is that list for your team's spreadsheets. You cannot look after things you do not know you have.

Key facts
  • Before this course: Sheets Systems (course 7.2.3). You built one well-documented system. A lead looks after many files and many people, so the first tool is a register: one row per important file.
  • A register usually records: file name, purpose, owner, where it lives (My Drive or a shared drive), general access, whether it holds personal data, connected tools (forms, scripts, reports) and the date of the last review.
  • Where a file lives matters. A file in someone's My Drive is owned by that person. In a shared drive, members share ownership of the files and folders, and if someone leaves the shared drive, the files they added stay. Shared drives are only available for work or school accounts.
  • General access has three settings: Restricted (only people given access can open the file), Anyone with the link (anyone on the internet who has the link can open it without signing in) and, for work or school accounts, your organization.
  • Start with the riskiest files: personal data, money, anything shared with Anyone with the link, and files nobody has reviewed.
  • Where this fits: Google Cloud offers an Associate Google Workspace Administrator certification for people who manage a Workspace environment (user accounts, Drive sharing permissions, data governance and security). Its page lists a 2-hour exam with 50 to 60 multiple choice and multiple select questions, in English and Japanese, and recommends 6 months of Super Admin experience. A team lead does not need it, but its topics show what your admin controls.
Example (register for a made-up tutoring centre, 8 files)
FileLocationGeneral accessPersonal dataLast review
OPS-Bookings-2026Shared driveRestrictedYes2026-10
FIN-Invoices-2026My DriveRestrictedYes2026-06
Tutor rota final v2My Drive (personal account)Anyone with the linkYesNever
MKT-Leads-2026Shared driveYour organizationYes2026-09
OPS-Rooms-2026Shared driveRestrictedNo2026-10
Copy of BudgetMy DriveAnyone with the linkNoNever
HR-Leave-2026Shared driveRestrictedYes2026-08
FIN-Prices-2026Shared driveRestrictedNo2026-10

What the register shows: 3 of 8 files live in My Drive, 2 are open to anyone with the link, 1 of those holds personal data (the tutor rota: fix it first), and 2 have never been reviewed.

Step by step
  1. Make a spreadsheet called Sheets Register with the columns from the example plus Purpose, Owner and Connected tools.
  2. List your team's important spreadsheets. Open each one and click Share to read its owner and general access.
  3. Mark which files hold personal data (names, phone numbers, emails, addresses, health or money details).
  4. Use COUNTIF to count files in My Drive, files with Anyone with the link and files never reviewed.
  5. Sort the register so files with personal data and link sharing come first.
  6. Pick the top three risks and write one action and one owner for each.
  7. Check: every important file has one row, and you can say which file is your biggest risk and why.
Watch on YouTube
Shared drives permissions and member accessJenta Tech · YouTube · youtube.com

Videos by other creators on YouTube, for reference. They are not made by or affiliated with The Future Market.

LESSON 01The lead's job: map the team workspace
LESSON 01 / ANIMATED LESSON / AI VOICE00:00 / 01:00
Read the video script
[Host] "Leading a team's spreadsheets starts with one question: what do we actually have?"
[Screen: Sheets Register with owner, location, access and personal data columns] "Make a register. One row per file: owner, where it lives, who can open it."
[Text on screen: My Drive = owned by one person. Shared drive = owned by the team.] "Where a file lives matters. In a shared drive, the files stay when a person leaves."
[Screen: rows with Anyone with the link and personal data highlighted] "Then fix the riskiest files first: personal data that anyone with the link can open."
Try it now

Build a register for at least five spreadsheets you or your team use. Count how many are in My Drive, how many use Anyone with the link and how many hold personal data. Write your top three risks with one action each.

ClaudeStuck? Copy a ready-made prompt for Claude

Copy this, open Claude, paste it, and Claude will walk you through the lesson step by step.

For a grown-up: Claude is for adults (18+). Copy this, paste it into Claude, and use the answer to explain the lesson to your child.

I'm learning "Sheets Systems Lead: governance and team training" on The Future Market. Lesson 1: "The lead's job: map the team workspace".

What the lesson teaches:
- Before this course: Sheets Systems (course 7.2.3). You built one well-documented system. A lead looks after many files and many people, so the first tool is a register: one row per important file.
- A register usually records: file name, purpose, owner, where it lives (My Drive or a shared drive), general access, whether it holds personal data, connected tools (forms, scripts, reports) and the date of the last review.
- Where a file lives matters. A file in someone's My Drive is owned by that person. In a shared drive, members share ownership of the files and folders, and if someone leaves the shared drive, the files they added stay. Shared drives are only available for work or school accounts.
- General access has three settings: Restricted (only people given access can open the file), Anyone with the link (anyone on the internet who has the link can open it without signing in) and, for work or school accounts, your organization.
- Start with the riskiest files: personal data, money, anything shared with Anyone with the link, and files nobody has reviewed.
- Where this fits: Google Cloud offers an Associate Google Workspace Administrator certification for people who manage a Workspace environment (user accounts, Drive sharing permissions, data governance and security). Its page lists a 2-hour exam with 50 to 60 multiple choice and multiple select questions, in English and Japanese, and recommends 6 months of Super Admin experience. A team lead does not need it, but its topics show what your admin controls.

The exercise I'm working on:
Build a register for at least five spreadsheets you or your team use. Count how many are in My Drive, how many use Anyone with the link and how many hold personal data. Write your top three risks with one action each.

I'm stuck. Please:
1. Explain the main idea in plain, simple words with one everyday example.
2. Walk me through the exercise one small step at a time. Ask me what I've done so far before giving the next step.
3. Don't just give me the final answer. Help me do it myself, and check my work when I share it.
I'm a parent helping my child (about 8 years old) with a lesson called "The lead's job: map the team workspace" from the course "Sheets Systems Lead: governance and team training".

Here's what the lesson says:
Before you tidy a messy garage, you first look at everything in it and write a list: what it is, whose it is and whether it is safe. A sheets register is that list for your team's spreadsheets. You cannot look after things you do not know you have.

The activity:
Build a register for at least five spreadsheets you or your team use. Count how many are in My Drive, how many use Anyone with the link and how many hold personal data. Write your top three risks with one action each.

Please explain this so an 8-year-old understands: short sentences, a fun everyday example, and no hard words.
Then give me 3 simple questions I can ask my child to check they understood, and a way to do the activity together, one tiny step at a time.
Open Claude
Sources
My notes
02

Design permissions

This lesson is part of full access: every course and every level for one payment.

03

Ownership, leavers and access reviews

This lesson is part of full access: every course and every level for one payment.

04

Naming standards

This lesson is part of full access: every course and every level for one payment.

05

Backup and recovery rules

This lesson is part of full access: every course and every level for one payment.

06

Review someone else's sheet

This lesson is part of full access: every course and every level for one payment.

07

Plan and run a training session

This lesson is part of full access: every course and every level for one payment.

08

Keep governance alive

This lesson is part of full access: every course and every level for one payment.

++

Final project

This lesson is part of full access: every course and every level for one payment.

??

Quiz

  1. What is a sheets register?

  2. What happens to files in a shared drive when a member leaves?

  3. What does "Anyone with the link" mean?

  4. Why share with Google Groups instead of single people?

  5. What can editors do by default that you may want to turn off?

  6. In a work or school account, what happens to the old owner after a transfer of ownership?

  7. Why must a team write down who created each Apps Script trigger?

  8. Why write dates as year-month-day in file names?

  9. What does =REGEXMATCH(A2, pattern) return?

  10. Who can see a file's version history?

  11. How long do files stay in the Drive Trash?

  12. Why is version history not enough as a backup?

  13. Which shortcut shows all formulas in Google Sheets?

  14. How do you give a review finding to the owner so they get an email?

  15. How do you know a training session worked?

EX

Final exam

This lesson is part of full access: every course and every level for one payment.

CE

Certificate

This lesson is part of full access: every course and every level for one payment.