Run Queries With Folgo

What is Drive Inventory Query

This feature connects Google's Drive Inventory Report to Folgo by letting Folgo Administrators run specific queries on your Drive Inventory Report.

If you have not followed yet the setup to connect your Drive Inventory Report to Folgo, please follow the instructions detailed here.

These queries let you gather data on users and folders to then use Folgo on.

For more information on Google's Drive Inventory Report you can visit:

https://docs.cloud.google.com/storage/docs/insights/inventory-reports

Step 1: Open Folgo in Google Sheets

❗This feature is only available from a Google Sheets spreadsheet❗

Open Folgo from an empty Google Sheets spreadsheet. Go to Admin Tasks then Drive Inventory Report.

Step 2: Choose the query type

You end up with this UI:

Click on the dropdown to select another query:

The Snapshot end time is the date when the Drive Inventory Report was last updated. All information after this date will not be retrieved by the queries.

Choose the query type that matches the data you want to retrieve. Folgo currently supports the following query types:

Query type	Data retrieved
Files shared with anyone with the link	To identify content that is accessible through link sharing
Files owned by user (sorted by size)	To retrieve a user’s files and highlight the largest ones first. For this query, you need to enter the user’s email address.
Files shared with a user or domain	To identify content shared with a specific user or across a domain. For this query, you need to enter the target email address or domain.
Files larger than...	To retrieve files above a selected size threshold. Available thresholds include 50 MB, 100 MB, 1 GB, and 5 GB.
Total size by Shared Drive	To understand how storage is distributed across shared drives.

Step 3: Launch the query

Once you have selected your query, click Generate Drive Inventory report.

The job may take a few moments depending on the volume of data being retrieved. You do not need to stay on the page while it runs. You can close the tab, and Folgo will continue processing the request in the background. You will receive an email notification once the job is complete.

When the query is running, the status shows Ongoing. You can click Refresh to check for updates.

Once it is complete, Folgo shows the duration, the number of rows processed, and the number of folders and files retrieved.

Step 4: Review the query results

Once the query is complete, Folgo generates a spreadsheet with the retrieved data.

Depending on the query type, the results can include the following information:

Column / data	Description
Title	The name of the file or folder.
ID	The unique Google Drive ID of the item.
Document type	The type of content, such as Google Docs, Sheets, Slides, PDFs, folders, and more.
Owner email / Shared Drive ID	The owner’s email address for user-owned content, or the Shared Drive ID for content stored in a Shared Drive.
Editors	The users who have edit access to the item.
Commenters	The users who can comment on the item.
Viewers	The users who can view the item.
Creation date	The date the item was created.
Last update	The date the item was last modified.
File size	The size of the file, useful for identifying large content quickly.
Number of files	The total number of files.
Number of folders	The total number of folders.

This structured view makes it easier to sort, filter, and organize the data based on what you want to investigate.

(Optional) Step 5: Turn results into action

Once the query results are available in the spreadsheet, they become much more than a simple report. They provide a structured view of your Google Drive environment that can be used to identify risks, prioritize actions, and support day to day governance.

For example, you can use the results to:

identify files shared publicly and review whether their access should be restricted
spot large files or folders that may no longer be needed and prepare cleanup actions
detect inactive content that could be archived, moved, or deleted
review ownership before offboarding, account deletion, or internal handovers
check who has access to sensitive content by reviewing editors, commenters, and viewers
identify files shared with a specific user or domain for access reviews or security checks
understand how storage is distributed across Shared Drives, including the number of files and folders they contain

Once these issues have been identified, they can be resolved directly in Folgo in just a few clicks. Because the data is already available in a spreadsheet connected to Folgo, taking action is simple and efficient.

To see all the actions you can perform from this data in Folgo, visit this page.