What's my plan?
All Suites Growth, Professional, Enterprise, or Enterprise Plus
By connecting the Action builder to external systems, such as Google Sheets, admins can integrate Zendesk with external systems in automated workflows, improving collaboration and maintaining a seamless experience across multiple platforms.
Note: The steps associated with external systems in action flows are referred to collectively as external actions.
This article contains the following topics:
  • Connecting Google Sheets to action builder
  • Using Google Sheets actions in action flows

Connecting Google Sheets to action builder

Before you can include external actions in your action flows, you must connect the action builder to the external system.

When connecting to external systems for use in action flows, the following best practices are recommended:
  • All external actions performed by an action flow are attributed to the user who connected the external system. Therefore, it is a best practice to use a dedicated service account rather than personal credentials when connecting to each external system.
  • All integrations request access to necessary scopes. However, it's important that you review and validate the scopes before authorizing the connection to the external system.
  • When managing credentials for API key-based tools, such as OpenAI, it's best to store keys in a secure vault or credential manager.
To connect action builder to Google Sheets
  1. In Admin Center, click Apps and integrations in the sidebar, then select Actions > Action flows.
  2. Create or edit an action flow.
  3. Open the step sidebar.
  4. Under External actions, click Google Sheets.
  5. Click Connect.
  6. Follow Google's prompts to authenticate and complete the connection.

    You'll log into a Google Workspace or Gmail account, and admin approval might be required in managed environments.

    Note: All external actions performed by an action flow are attributed to the user who connected the external system. Therefore, it is a best practice to use a dedicated service account rather than personal credentials when connecting to each external system.

After you've connected to the system, you'll see an indicator that it's connected and details about the instance you're connected to, as well as the actions available for Google Sheets.

Using Google Sheets actions in action flows

Google Sheets action steps can be used to create spreadsheets and add data to a sheet created within the action flow, such as an AI-generated ticket summary, which can then be shared with other users.

The following Google Sheet actions are available:
  • Create spreadsheet
  • Create a new sheet
  • Append row

Creating a new Google spreadsheet

Use the Create spreadsheet action to create a spreadsheet.

This action has the following inputs and outputs:

  Variables
Inputs spreadsheet_title
Output spreadsheet_id, sheet_title,

Creating a new sheet in a Google spreadsheet

Use the Create sheet action to add a sheet to an existing spreadsheet. You have the option to specify column headings and an initial row of data.

This action has the following inputs and outputs:

  Variables
Inputs spreadsheet_id, sheet_title
Output spreadsheet_id, sheet_title

Appending a row to a Google spreadsheet

Use the Append row action to add a row to a sheet previously created by the action flow.

This action has the following inputs and outputs:

  Variables
Inputs spreadsheet_id, sheet_title, values
Output spreadsheet_id, sheet_title, values
Powered by Zendesk