Skip to content
Make Logo
  • Sign in
    Make logo
    Make platform
    Sign in to Make
    Integromat logo
    Legacy (Integromat)
    Sign in to Legacy
    • Get started free
    Google Workspace Admin
    Google Sheets

    Count users per G Suite organizational unit

    About

    Share

    This template shows how you can set Make to list all your G Suite organizational units and count their number of users. Then, the result is saved in Google Sheets. The template uses this example spreadsheet.

    Apps Included

    Google Workspace Admin
    Google Workspace Admin
    Google Sheets
    Google Sheets
    Get this template
    Categories
    Spreadsheets
    Admin Tools
    Get this template

    Similar templates for inspiration

    Looking to get more out of your apps? With Make, you can visually integrate any app into any workflow to save time and resources - no coding required. Try any of these templates in just a few clicks.

    Gmail
    Google Sheets
    Save a Gmail email containing a specific phrase to Google Sheets as a new row

    Use this template to save a Gmail message containing a specific phrase to your Google Sheets spreadsheet as a new row.

    Try It ➔
    Google Sheets
    Gmail
    Send a Gmail email from a new Google Sheets row

    Use this template to send a Gmail message when a new row is added to your Google Sheets spreadsheet.

    To work with the template's default settings, your Google Sheets spreadsheet should contain these columns: Email address, Subject of the email and Content of the email.

    Try It ➔
    Facebook Lead Ads
    Google Sheets
    Add leads from Facebook Lead Ads to a Google Sheets spreadsheet

    Every time a new lead is collected from Facebook Lead Ads, Make will automatically add a new row with the lead's info to Google Sheets spreadsheet.

    Try It ➔
    Google Sheets
    Slack
    Share data added to a Google Sheet as Slack messages

    This automation grabs new rows of data from your Google Sheet and sends them as Slack messages.

    Try It ➔
    Google Sheets
    Telegram Bot
    Get Telegram messages for new Google Sheets rows

    Every time a new row is added to your Google Sheets spreadsheet, Make will automatically send a message in Telegram.

    Try It ➔
    Try It ➔
    Gmail
    Google Drive
    Google Sheets
    Save Gmail emails and attachments to Google Sheets and Google Drive

    Use this template to save a Gmail message to your Google Sheets spreadsheet as a new row and its attachments to Google Drive.

    Try It ➔
    Facebook Lead Ads
    Google Sheets
    Save new Facebook Lead Ads leads into Google Sheets

    When you get a new response to a Facebook Lead Ads form, it will be logged as a new row in Google Sheets.

    Try It ➔
    Try It ➔

    Create your own workflow

    Create custom workflows by choosing triggers, actions, and searches. A trigger is an event that launches the workflow, an action is the event.

    All Modules (47)
    Google Sheets
    Add a Conditional Format Rule

    Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.

    Action
    Google Sheets
    Add a Row

    Appends a new row to the bottom of the table.

    Action
    Google Sheets
    Add a Sheet

    Adds a new sheet.

    Action
    Google Workspace Admin
    Assign a User to a Role

    Assigns a user to a specific role.

    Action
    Google Sheets
    Clear Values from a Range

    Clears a specified range of values from a spreadsheet.

    Action
    Google Sheets
    Clear a Cell

    Cleares a specific cell.

    Action
    Google Sheets
    Clear a Row

    Clears values from a specific row.

    Action
    Google Sheets
    Copy a Sheet

    Copies a sheet to another spreadsheet.

    Action
    Google Workspace Admin
    Create a Role

    Creates a new role.

    Action

    FAQ

    How do I get started with Make?
    What is a scenario?
    What is a module?
    What is mapping?

    Trusted by 500,000+ Makers