Discover Folgo's new BigQuery feature

We are excited to introduce BigQuery integration, a new Folgo feature designed to help you get more value from your Google Drive Inventory Report.

This feature connects Google's Drive Inventory Report to Folgo, allowing Folgo Administrators to run specific queries on that report. These queries help retrieve useful data about users and folders, which can then be used directly in Folgo.

With this new capability, you can make better use of your Drive Inventory Report data, analyze it more flexibly, and prepare it for actions in Folgo.

Visit this page to learn more.

Use Cases

For many organizations, the Google Drive Inventory Report contains valuable information, but turning that data into something actionable can take time and effort. Folgo BigQuery integration helps simplify that process by making it easier to query the right data and bring it into Folgo where it becomes more useful for day-to-day operations.

  • Identify inactive folders/users fast.
  • Prepare cleanup actions by finding folders or users that match specific criteria.
  • Support offboarding by retrieving data linked to departing users and their folders.
  • Improve visibility by understanding how folders are distributed across your Drive environment.
  • Help decision-making with clearer insights into users, folders, and ownership.

Key benefits

Folgo’s BigQuery integration helps administrators turn Google Drive Inventory Report data into practical, usable insights that support everyday governance and operational work.

  • Get visibility across your entire Google Drive environment: One of the biggest advantages of this feature is scale. Instead of working with partial or isolated information, Folgo helps you access data from your whole Google Drive environment through your Drive Inventory Report. This creates a much broader view of users, folders, and structure across the organization, making it easier to identify issues, spot risks, and understand where action is needed.
  • Centralize data in one Google Sheet: The queried data is stored in a single Google Sheet, which makes it much easier to review, organize, and work with. Having everything centralized also reduces confusion and avoids switching between multiple data sources.

Once the data has been gathered and structured, it becomes much easier to use it directly in Folgo because Folgo works with the spreadsheet itself. Since the queried data is stored in Google Sheets, teams can use that spreadsheet as the starting point for actions in Folgo instead of leaving the data as a static report.

  • Turn inventory data into concrete actions: This feature becomes even more powerful when paired with Folgo’s action capabilities. Its value goes beyond identifying useful information by helping teams act on it directly. Once relevant users or folders have been identified through the query process, administrators can use Folgo to take action with features such as copying folders, transferring ownership, or granting access in bulk. Discover all the actions you can perform here.
  • Improve governance and control: Better visibility leads to better control. By giving administrators access to structured data about users and folders across the full Drive environment, this feature supports stronger governance practices. It becomes easier to review ownership, prepare access changes, monitor folder-related issues, and take action in a more consistent way. For organizations that need tighter control over their Google Drive environment, this is a clear operational advantage.

BigQuery integration expands the way Folgo works with your Google Drive data. It gives administrators a more flexible way to retrieve and use inventory report data, while keeping Folgo at the center of action. This makes it easier to go beyond visibility alone and start using your data in a more practical, operational way.

Get Started

To use this feature, your Google Drive Inventory Report must first be connected to Folgo. For full setup instructions and technical details, please visit our dedicated help center page. Once setup is complete, this page provides a step by step guide to help you get started.

Discover how Folgo BigQuery integration can help your team work faster and smarter, you can book a demo with our team to explore the feature with us.