Project & Development
Shared Link and Drive Audit: Fix External Shares, Leaver Shares, and Public Forms, Then Set Rules
Intermediate | 4 whiteboard pages · Task board: 5 columns (4 parent tasks, 12 subtasks)
Intermediate: Method names appear, but the whiteboard explains the key points. Use the examples as a guide and fill it in, thinking it through for your own situation.
Audit shared links and shared drives to find files anyone with the link can open, shares still open to vendors or former staff, and forms showing responses, then fix them. Setting names differ by service, so match them to the labels in each admin console. You search five angles - link, external, leaver, public form, and personal account - then sort findings on an importance-urgency matrix and set owners and deadlines. Four pitfalls get cards with what happens, how to check, and how to prevent it - default links open to anyone, copies left behind, visible form results, and company files in free personal accounts. Not sure where to start? List each service and its admin from your contract list or card statements. You end with sharing rules by situation, a quarterly check routine, and a way to ask before adopting a service. The four whiteboard pages map shares, find risks, set the fix order, and set rules; the task board has 5 columns and 4 parent tasks with 3 subtasks each.
Once you have a free account, you can copy this template from the marketplace
Whiteboard preview
Read the whiteboard text as plain text
Shared Link and Drive Audit
How to use (4 pages): ① List services and sort shares into internal, external, public (sections①–⑤) → ② Search five angles, check pitfalls (sections⑥–⑨) → ③ Sort by importance and urgency, set owners and deadlines (sections⑩–⑪) → ④ Write sharing rules, a quarterly check, and how to ask (sections⑫–⑭)
1/4 Map where files are shared
① Audit goal and scope (start writing here)
- Goal of this audit e.g. Within this month, no customer data is open to people outside the company
- Scope to check e.g. Company cloud storage, shared drives, online spreadsheets, and forms. Personal PCs are out of scope this time
- Period and who runs it e.g. One pass in two weeks. IT staff plus one admin from each department
② Services in use and their admins (also write the service names)
| Main use | Admin | Sharing scope | How to check | |
|---|---|---|---|---|
| Cloud storage | e.g. Department file storage | e.g. IT staff | e.g. Internal and external | e.g. Review the sharing list in the admin console |
| Shared drive | e.g. Project files | e.g. Admin of each drive | e.g. Internal only | e.g. Review each drive's member list |
| Online spreadsheet | e.g. Customer list and quotes | e.g. Whoever created it | e.g. Internal, external, public | e.g. Review the sharing settings together with the creator |
| Forms | e.g. Applications and surveys | e.g. Marketing staff | e.g. Public | e.g. Review the form's settings screen |
③ Internal shares
- Shares only people with an organization account can open
- e.g. Department shared drives, internal manuals
- To check, ask whether everyone shared with is inside the organization
④ External shares
- Shared with outside people, named one by one
- e.g. A shared quote folder with a client
- To check, look at who, until when, and whether it is still needed
⑤ Public shares
- Anyone with the link can open or answer
- e.g. Company brochure, application form
- To check, confirm that only content fine to publish is there
2/4 Find the risky shares
⑥ Search for risky shares in each service from ② (five angles)
| How to find (admin console, ledger) | Number found | Standout items | |
|---|---|---|---|
| Link sharing | e.g. Filter the sharing list to anyone with the link | e.g. 28 files | e.g. Customer list spreadsheet |
| External sharing | e.g. List shares with outside people | e.g. 41 files | e.g. Folder of a vendor whose contract ended |
| Leavers' shares | e.g. Match the leavers list against the user list and owners | e.g. 3 people, 12 files | e.g. Proposal owned by a leaver |
| Public forms | e.g. In the form list, check result display and response sheet sharing | e.g. 6 forms | e.g. Application form with visible responses |
| Personal accounts | e.g. Ask the team and compare expense records with the ledger in ② | e.g. 2 people | e.g. Quote in free personal storage |
⑦ Pitfall: links open by default
- What happens: every new share becomes an anyone-with-the-link URL, and once forwarded, outsiders can open it
- How to check: in the admin console, look at the default scope for new shares (the item name differs by service)
- How to prevent: set the default to inside the organization and share with outsiders by naming them
- e.g. The default was anyone with the link → the admin from ② changed it to inside the organization only
⑧ Pitfall: copies stay after unsharing
- What happens: if the other person downloaded or copied the file, it stays with them after you remove access
- How to check: ask the people you shared with whether they copied or saved it
- How to prevent: decide before sending outside whether the file may leave, and ask for deletion when a contract ends
- e.g. A copy of the customer list given to a vendor → at contract end we asked for deletion and got a reply that it was done
⑨ Pitfall: form responses exposed
- What happens: showing results to respondents or sharing the response sheet lets people see other answers
- How to check: look at the result display on the form settings screen and the sharing of the sheet that collects responses
- How to prevent: turn off result display and open the response sheet to the owner only
- e.g. An application form showed totals → we turned result display off
3/4 Decide the fix order
⑩ Sort the shares found in ⑥–⑨ (importance-urgency matrix)
Vertical axis: Importance (impact if leaked) / Horizontal axis: Urgency (who can open it now)
- Plan it The content matters, but few people can open it now. e.g. A proposal still owned by a leaver whose account is stopped → move the owner to a department admin in week 1. If the leaver can still open it, go to Do now
- Do now The content matters and anyone can open it now. e.g. A customer list spreadsheet shared by link → restrict it to the organization today
- Skip Content that is fine to publish and not urgent. e.g. A company brochure → only record it in the ledger and look again at the next audit
- Delegate Many people can open it now, but the impact if leaked is small. Ask the owning department to fix it. e.g. An old client folder holding only published brochures → ask that department's admin to remove the sharing
⑪ What to fix, who, and by when (for each quadrant in ⑩)
| What to fix and how | Owner | Deadline | |
|---|---|---|---|
| Do now 1 | e.g. Restrict the customer list spreadsheet's link sharing to the organization | e.g. Sales admin | e.g. Today |
| Do now 2 | e.g. Turn off result display on the application form | e.g. Whoever created the form | e.g. Today |
| Plan it 1 | e.g. Move the files owned by 3 leavers with stopped accounts to a department admin | e.g. IT staff | e.g. Friday of week 1 |
| Delegate 1 | e.g. End the old shared folder with a client | e.g. Purchasing staff | e.g. Wednesday of week 2 |
4/4 Write and run the rules
⑫ Sharing rules decided from what you fixed in ⑪
| Allowed scope | Who approves | What happens at the end | |
|---|---|---|---|
| Internal sharing | e.g. Only people inside the organization. No link sharing | e.g. None needed (the creator decides) | e.g. Move ownership on transfer or departure |
| Sharing with clients | e.g. Name each person and default to view-only | e.g. Department admin | e.g. At contract end, remove access and ask for copies to be deleted |
| Public release | e.g. Only files approved for publication | e.g. PR staff and department admin | e.g. Set a display period and remove it after that |
| Collecting with forms | e.g. Response sheet for the owner only. Results not shown | e.g. Department admin | e.g. Close the form when collection ends |
⑬ Quarterly check (4 steps)
- Open the ledger Update the table in ② e.g. On the first Monday of the quarter, add new services and admins
- Search Count the five angles in ⑥ e.g. Compare with last time's numbers and look at the angles that grew
- Sort and fix Set the order with ⑩ and ⑪ and fix e.g. Fix the do-now items within the same week
- Review the rules Rewrite the rules in ⑫ e.g. If the same finding appears twice in a row, add one line to the rules
⑭ Pitfall: company files in free personal accounts (ask before using a new service)
- What happens The admin console cannot see them, and files stay with the individual after departure or transfer e.g. A quote was kept in free personal storage
- How to check On check day, ask the team whether they use any service not in the ledger from ② e.g. Spend 5 minutes at the start of check day asking about services not in the ledger
- How to prevent (how to ask) Before using it, send the service name, the files to store, and who it is shared with to the admin in ② e.g. Send 3 lines in chat and use it only after getting a reply
Task board contents
Not checked 16 items
Map your shares
On page 1, write the audit goal and scope, list the services and admins in a table, and sort shares into internal, external, and public. Once it is clear who checks which service, you can split the search on page 2. Press Ctrl+F (⌘F on Mac) and type "3/4" to jump to page 3.
List your services
Open your contract list or card statements and write each service in its row of section ②, with its main use. Leave a ? where you do not know the admin. Done when four rows have service names, in about 15 minutes.
Write goal, scope
In section ①, write the audit goal, the scope, and the period and who runs it. Also write what you will not look at this time (for example, files on personal PCs) so the scope does not grow midway.
Sort the shares
In sections ③–⑤, sort the kinds of sharing used by the services in ② into internal, external, and public. Done when each of the three frames has one example of your own.
Find risky shares
On page 2, search each of the five angles in the admin consoles or the ledger and write how many you found. Check the pitfalls too. This is the core of the audit, and the shares you count here are what you fix on page 3.
Check links, guests
In rows 1-2 of section ⑥, find anyone-with-the-link shares and shares with outsiders in each service's admin console sharing list or reports. Some plans lack these, so owners then check their own sharing settings. Write the number and standout items.
Check leavers, forms
In rows 3-5 of section ⑥, search by matching the leavers list against the user list, by checking form settings screens, and by asking the team. Write the numbers.
Check the pitfalls
On the notes of sections ⑦–⑨, write whether each pitfall is happening in your services, and rewrite the example notes with your own results.
Set the fix order
On page 3, sort the shares you found on an importance-urgency matrix and build a table of what to fix, who, and by when. If the urgent ones are done today, the rest can follow their deadlines.
Sort into 4 groups
In section ⑩, place the shares found in ⑥ into four groups - do now, plan it, delegate, and skip.
Build the fix table
In the table of section ⑪, write how to fix, the owner, and the deadline for each do-now, plan-it, and delegate share. Done when no owner cell is empty.
Fix the urgent ones
Fix the do-now rows of ⑪ in the admin console. Then move the card to Done on the task board and rewrite the numbers in ⑥.
Write rules, repeat
On page 4, write sharing rules by situation, then decide the quarterly check and how to ask before using a new service. With rules in place, you will find fewer shares at the next audit.
Write sharing rules
In the table of section ⑫, write the allowed scope, who approves, and what happens at the end for each situation, then show the team and get agreement.
Schedule the audit
Check the four steps in section ⑬ and put a check in the calendar for the first week of next quarter. Done once it is scheduled.
Share how to ask
Write how to ask in section ⑭ and tell the team to send it to the admin in ② before using a new service.