Shared Link and Drive Audit: Fix External Shares, Leaver Shares, and Public Forms, Then Set Rules

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.

0 Likes 0 Copies Author: WeProcess
shared link audit shared drive security external sharing access review cloud storage
Sign up free and use this template

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)

  1. Open the ledger Update the table in ② e.g. On the first Monday of the quarter, add new services and admins
  2. Search Count the five angles in ⑥ e.g. Compare with last time's numbers and look at the angles that grew
  3. Sort and fix Set the order with ⑩ and ⑪ and fix e.g. Fix the do-now items within the same week
  4. 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.

Searching 0 items

Fixing 0 items

Added to rules 0 items

Done 0 items

← Back to templates

Preview mode Shared Link and Drive Audit: Fix External Shares, Leaver Shares, and Public Forms, Then Set Rules

Whiteboard preview

① Audit goal and scope (start writing... ② Services in use and their admins (a... ③ Internal shares ④ External shares ⑤ Public shares ⑥ Search for risky shares in each ser... ⑦ Pitfall: links open by default ⑧ Pitfall: copies stay after unsharing ⑨ Pitfall: form responses exposed ⑩ Sort the shares found in ⑥–⑨ (impor... Plan it Do now Skip Delegate ⑪ What to fix, who, and by when (for ... ⑫ Sharing rules decided from what you... ⑬ Quarterly check (4 steps) ⑭ Pitfall: company files in free pers... Shared Link and D... How to use (4 pag... Goal and files to... Rules and how to ... Risky shares and ... How to fix and pr... 1/4 Map where files a... Ctrl+F / ⌘F : 2/4... → 2/4 2/4 Find the risky sh... ↙ 3/4 Goal of this audite.g. Within this month, no customer data is open to people outside the company Scope to checke.g. Company cloud storage, shared drives, online spreadsheets, and forms. Personal PCs are out of scope this time Period and who runs ite.g. One pass in two weeks. IT staff plus one admin from each department 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 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 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 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 How to find (admi... 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 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 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 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 → 4/4 4/4 Write and run the... Vertical axis: Im... 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 The content matters and anyone can open it now. e.g. A customer list spreadsheet shared by link → restrict it to the organization today 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 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 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 Allowed scope Who approves What happens at t... 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 f... e.g. Response sheet for the owner only. Results not shown e.g. Department admin e.g. Close the form when collection ends Open the ledgerUpdate the table in ②e.g. On the first Monday of the quarter, add new services and admins SearchCount the five angles in ⑥e.g. Compare with last time's numbers and look at the angles that grew Sort and fixSet the order with ⑩ and ⑪ and fixe.g. Fix the do-now items within the same week Review the rulesRewrite the rules in ⑫e.g. If the same finding appears twice in a row, add one line to the rules What happensThe admin console cannot see them, and files stay with the individual after departure or transfere.g. A quote was kept in free personal storage How to checkOn 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 → 2/4 Find the risky sh... ↙ 3/4 Decide the fix order → 4/4 Write and run the...
100%

Drag to move, scroll to zoom