ITOps

Automated Access Review with Google Workspace Admin, Jamf Pro and Drata

Automated Access Review with Google Workspace Admin, Jamf Pro and Drata

This use case automates access review across multiple platforms, generating a comprehensive report for compliance. It collects user data from Google, Slack, BitWarden, Jamf, HubSpot, and Notion, consolidates information in Google Sheets, and uploads to Drata for control assignment.

Automate Compliance


Explore canvas

This use case automates access review across multiple platforms, generating a comprehensive report for compliance. It collects user data from Google, Slack, BitWarden, Jamf, HubSpot, and Notion, consolidates information in Google Sheets, and uploads to Drata for control assignment.

Automate Compliance

Flow Automation Highlights

User Data Collection: Automated gathering of user information from Google, Slack, BitWarden, Jamf, HubSpot, and Notion replaces manual data retrieval from multiple platforms. This consolidation drastically reduces time spent on data collection and eliminates errors associated with manual entry.

Report Generation: Creation of a comprehensive access review report in Google Sheets is automated, replacing manual data compilation and formatting. This automation ensures consistency in reporting, reduces human error, and significantly decreases the time required to produce compliance reports.

Compliance Integration: Automated upload of the generated report to Drata and assignment to relevant controls streamlines the compliance process. This task replaces manual file uploads and control associations, reducing administrative burden and ensuring timely compliance updates.

Orchestration Toolbox

Google Admin Directory: Google Admin Directory is used to retrieve a list of active users in the organization. It provides essential information about user accounts, including their administrative status and two-factor authentication enrollment.

Slack: Slack is utilized to gather user information, particularly regarding user status (suspended or active) and administrative privileges. This data contributes to a comprehensive view of user access across platforms.

BitWarden: BitWarden provides data on user roles and two-factor authentication status within the password management system. This information is crucial for assessing the security posture of user accounts.

Jamf Pro: Jamf Pro supplies device information associated with users, including device models and serial numbers. This data helps in maintaining an inventory of company-issued devices and their association with user accounts.

HubSpot: HubSpot is queried to retrieve user membership and administrative status within the CRM system. This information is vital for understanding user access levels in customer relationship management tools.

Notion: Notion is used to verify user membership, contributing to the overall picture of user access across various collaboration and productivity tools.

Google Sheets: Google Sheets serves as the platform for compiling and formatting the collected data into a comprehensive access review report. It provides a structured and easily shareable format for the gathered information.

Google Drive: Google Drive is used to export the generated report, facilitating easy download and sharing of the access review document.

Drata: Drata is the final destination for the generated report, where it is uploaded and assigned to relevant compliance controls. This integration streamlines the process of maintaining up-to-date compliance documentation.

Why

Automate Compliance

?

Opportunity cost

Manual Data Collection Time

Inconsistent Access Control Practices

Delayed Compliance Reporting Process

Impact of automation

Streamlined Multi-Platform Data Collection

Enhanced Compliance Reporting Accuracy

Improved Security Risk Management

Let's talk!

Why

Automate Compliance

?

Opportunity cost

Manual Data Collection Time

Inconsistent Access Control Practices

Delayed Compliance Reporting Process

Impact of automation

Streamlined Multi-Platform Data Collection

Enhanced Compliance Reporting Accuracy

Improved Security Risk Management

Let's talk!