Access audit of your Google Drive files — as a report by email

On a schedule the scenario checks access permissions on recently active files, flags the ones shared outside and emails you a report.

  • Checks access on active files
  • Flags files open to outsiders
  • The list with permissions into a sheet
  • A report by email on a schedule
Set it upScriptera

How it works

Automating Microsoft SQL and devino takes no code: a ready-made scenario does the routine for you.

  1. Starts when: Schedule Trigger
  2. Then: Create New Sheet
  3. Then: Get Recently Active Documents
  4. Check: Has Shared with External Users
  5. Check: For Each File
  6. Then: Flatten Rows
  7. Then: Rows to Items
  8. Then: Append to New Sheet
  9. Then: Send Email Report (Execute Once)
  10. Then: Permissions To Items
  11. Check: Filter Out Owner of Document
  12. Then: Normalise Fields
  13. Then: Aggregate

You can launch this Microsoft SQL + devino integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios