Azure Active Directory + Google Sheets

Create spreadsheet rows in Google Sheets for new users in Azure Active Directory

Keep track of new Azure Active Directory users easily with this workflow. Once set up, every time a new user is added in Azure Active Directory, details will be copied and a fresh row will be created in your Google Sheets spreadsheet. With effortless organization and simplicity, this workflow ensures you always have a timely record of new members in your directory.

Keep track of new Azure Active Directory users easily with this workflow. Once set up, every time a new user is added in Azure Active Directory, details will be copied and a fresh row will be created in your Google Sheets spreadsheet. With effortless organization and simplicity, this workflow ensures you always have a timely record of new members in your directory.

  1. When this happens...
    Azure Active DirectoryAzure Active Directory
    New User

    Triggers when a new user is created.

    TriggerScheduled
  2. automatically do this!
    Google SheetsGoogle Sheets
    Create Spreadsheet Row

    Create a new row in a specific spreadsheet.

    ActionWrite
Start free with email
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
  • Azure Active Directory triggers, actions, and search

    New User

    Triggers when a new user is created.

    Trigger
    Scheduled
    Try It
    • Display NameRequired

    • Description

    • Group TypeRequired

    • Mail EnabledRequired

    • Email NicknameRequired

    • Security EnabledRequired

    • Is Assignable To Role

    Action
    Write
    • GroupRequired

    Action
    Write
    • User Id or User Principal NameRequired

    Action
    Write
    • GroupRequired

    • UserRequired

    Action
    Write
    • Display NameRequired

    • Given Name

    • Surname

    • Email NicknameRequired

    • User Principal NameRequired

    • PasswordRequired

    • Force Password Change

    • Force MFA Password Change

    • Job Title

    • Department

    • Mobile Phone

    • Email

    • Street Address

    • City

    • State

    • Postal Code (Zip Code)

    • Country

    Action
    Write
    • User ID or User Principal NameRequired

    Action
    Write
    • GroupRequired

    • UserRequired

    Action
    Write
azure-active-directory logo
azure-active-directory logo

About Azure Active Directory

Azure Active Directory Service
Learn more

Related categories

  • Microsoft
  • Security & Identity Tools
google-sheets logo
google-sheets logo

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Learn more

Related categories

  • Google
  • Spreadsheets

Similar apps

Zapier Tables integrationsZapier Tables integrations

Zapier Tables

Databases, Spreadsheets, Zapier
Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets