Azure Active Directory and Google Sheets integrations and automations

Do everything in one place

Customize your Azure Active Directory and Google Sheets integration with the following triggers and actions.

Triggers

When this happens…

Azure Active Directory
  • New deleted user
    New deleted User in Microsoft Entra ID
  • New group
    New group in Microsoft Entra ID
  • New/updated group
    New or updated group in Microsoft Entra ID
  • New/updated user
    New or updated User in Microsoft Entra ID
  • New user
    New User in Microsoft Entra ID

    • Any other trigger you can think up

Google Sheets
  • New row in sheet in My Drive
    New row in a sheet in Google Sheets
  • New row in sheet in My Drive Real-time
    New row in a sheet in Google Sheets
  • New row in sheet in Team Drive
    New row in a sheet in Google Sheets
  • New/updated row in sheet in Team Drive
    New/updated row in a sheet in Google Sheets
  • New/updated row in sheet in My Drive
    New/updated row in a sheet in Google Sheets
  • New/updated row in sheet in My Drive Real-time
    New/updated row in a sheet in Google Sheets

    • Any other trigger you can think up

Actions

Do this…

Azure Active Directory
  • Custom action
    Custom action in Microsoft Entra ID (Azure Active Directory) (Custom)
  • Add member to group
    Add member to group in Microsoft Entra ID
  • Add or remove user license
    Add or remove User license(s) in Microsoft Entra ID
  • Create group
    Create group in Microsoft Entra ID
  • Create user
    Create user in Microsoft Entra ID
  • Delete group
    Delete group in Microsoft Entra ID
  • Delete user
    Delete user in Microsoft Entra ID
  • Get group details by ID
    Get group by ID in Microsoft Entra ID
  • Get custom attributes of group by ID
    Get custom attributes of group by ID in Microsoft Entra ID (Azure Active Directory)
  • Search group members
    Search group members in Microsoft Entra ID
  • Search transitive group members
    Search transitive group members in Microsoft Entra ID
  • Get user details by ID
    Get user by ID in Microsoft Entra ID
  • Get custom attributes of user by ID
    Get custom attributes of user in by ID Microsoft Entra ID (Azure Active Directory)
  • Get user license
    Get User license by ID Microsoft Entra ID
  • Search users
    Search users in Microsoft Entra ID
  • Remove member from group
    Remove member from group in Microsoft Entra ID (Azure Active Directory)
  • Revoke sign-in session
    Revoke user sign-in session in Microsoft Entra ID
  • Update group
    Update group in Microsoft Entra ID
  • Update user
    Update user in Microsoft Entra ID

    • Any other action you can think up

Google Sheets
  • Custom action
    Custom action in Google Sheets (Custom)
  • Add rows in bulk Batch
    Add multiple rows in a sheet in Google Sheets
  • Add row
    Add a new row in a sheet in Google Sheets
  • Get rows Batch
    Get rows from sheet in Google Sheets
  • Search rows Batch
    Search rows in a sheet in Google Sheets
  • Update rows in bulk Batch
    Update multiple rows in a sheet in Google Sheets
  • Update row
    Update a row in a sheet in Google Sheets
  • Update row using row ID (old version)
    Update a row using row ID in a sheet in Google Sheets

    • Any other action you can think up

The wonders of Workato

Easily set up as many intelligent automations you need.
  • 1000s of ready-to-use templates
  • Accelerate work with intelligent automation
  • Do it yourself, faster
  • Build bots. Put them to work

Market leaders run on Workato

  • mgm
  • adobe
  • att
  • atlassian
  • slack

Let’s start automating

Schedule a Demo