DoiT AdminPulse for Workspace
This comprehensive checklist, housed in Google Sheets™ and maintained by Dustin Christlieb, is tailored for Super Admins seeking a security review of Google Workspace™ and Cloud Identity environments. Drawing inspiration from the renowned GAM, this application harnesses the power of the Admin SDK to collect asset data seamlessly and integrate it into a Google Sheet. Currently, it focuses on read-only functionality, ensuring no modifications to API settings.
Delve into the appscript code on our GitHub repository for insights into its architecture and future developments as a Google Sheets™ Editor add-on.
Key features
Comprehensive Security Settings
Access a detailed checklist of settings with direct links to Google's Admin Console for easy configuration.
User Audit
Track user activities including last sign-in date, status, 2SV enrollment, and admin privileges.
Domain & DNS Audit
Ensure your domain conforms to best practices by auditing MX, SPF, DKIM, and DMARC records.
Google Group™ Settings Audit
Review Google Group™ memberships for both internal and external accounts.
Google Groups™ Membership Audit
Review Google Group™ memberships for both internal and external accounts.
Mobile Device Audit
Monitor mobile devices connected to your Google Workspace™ for security compliance.
License Audit
Track licenses to optimize usage and reduce costs.
Shared Drive Settings Audit
Review settings for Shared Drives to ensure data security.
OAuth Token Audit
Review OAuth tokens for third-party app access to your Google Workspace™.
App Passwords Audit
Review user configured app passwords for less secure apps.
Organizational Unit Audit
Review organizational units for effective organization management.
Get Help
Reach out for personalized assistance with the DoiT AdminPulse for Workspace.
How to use the tool
Install from Marketplace.
Install the DoiT AdminPulse for Workspace Google Sheets™ editor add on from the Google Workspace Marketplace
Locate in extensions menu
Open a new Google Sheets document and find the DoiT AdminPulse for Workspace in the extensions menu
Activate Application
Start with Activate Application to trigger the OAuth flow and connect the DoiT AdminPulse for Workspace to your Super Admin account
Run Setup or Refresh Sheet
Run Setup or Refresh Sheet to populate the security checklist information to your Google Sheet with the newest information. A warning modal will appear confriming that any existing data will be deleted from the sheet before proceeding. A second modal will appepar when the Setup Sheet function is comepleted
Run all scripts
Run all scripts to get API level reports on the enviorment. A modal will appear asking for confrimation before proceeding
Complete the Security Checklist
With the API inventory completed, dive into the extensive check list of security controls. The API inventory will be helpful in answering if the organization is following best practices
Analyze API Reports
Review the inventory reports of users, group members, group settings, Mobile devices, license assginments, shared drives, OAuth tokens, and App Passwords
Get Help
Click Get Support to send an email to the DoiT Google Workspace team for assistance
