Use Google Sheets with Workflow Builder

When you add Google Sheets steps to workflows you create in Workflow Builder, you can easily send data from your workflows into a spreadsheet, or pull data from Google Sheets into Slack.

Tip: Check out Create a new workflow in Slack for an overview of building workflows and how steps work.

 

Add a Google Sheets step to a workflow

Create or open a workflow in Workflow Builder, then search for or select the Google Sheets Add a spreadsheet row step from the step library. 

Note: If you don't see the option to add or request a Google Sheets step in Workflow Builder, find an owner or admin to ask for help.


Connect your Google account

When you add a Google Sheets step for the first time, you'll need to connect your Google account:

  1. Select the step you’d like to add.
  2. Click Connect.
  3. Select an account, then follow the prompts.
  4. Click Continue.
  5. Return to Workflow Builder to resume editing your step.


Decide which Google account people will use

Anyone who starts your workflow will need to connect with Google in order for your steps to work properly. By default, steps will use your account, but you can choose to have people use their own accounts instead.


Finish setting up your step

  1. Open the Spreadsheet dropdown menu to choose a spreadsheet. Open the Sheet dropdown menu to select a specific sheet.
  2. Follow the prompts to configure your step.
  3. Click Save.

Note: It’s not currently possible to adjust the timezone for your spreadsheet. Dates and times added to your spreadsheet will use the UTC+0 timezone.


Change your Google account

You can only connect one Google account to Slack at a time. If you need to access a spreadsheet that’s saved to a different Google account, you can change which one is connected.

  1. Open a workflow with a Google Sheets step.
  2. Add a new Sheets step, or select one you’ve already added.
  3. Next to your account information, click Change.
  4. Click Change Account, then select another account.
  5. Follow the prompts, then click Continue to return to Workflow Builder.

Note: Spreadsheets in workflow steps must be saved to a personal drive, not a shared drive

Who can use this feature?
  • All members (by default)
  • Available on paid plans