Popular Workflow: Google Sheet > Slack

So you want to take data from a Google Sheet and send it to slack? Maybe you’ve got a quick pacing view, or

This guide helps you quickly create a workflow that:

Pulls data from Google Sheets
Posts the downloaded contents in a message to Slack

This is not meant to be an exhaustive guide, you can customize your workflow by adding new tasks - like sending your ChatGPT generated response to somewhere other than slack like Email or Google Drive - that’s the fun part!

Workflows is designed to be mix-and-match to meet your needs, you can explore all the available templates in the Template Library, or in the Explore Existing Templates area of our documentation.

Download Data from Google Sheet

Use the Google Sheets: Download Sheet to Workflows template.

Make sure you’ve shared your sheet with your client’s Google Service Account - thats what will be accessing your Google Sheet in the workflow

Use the How-To: Find Your Alli Client's Google Service Account documentation if you’re unsure how to find it.

Is your sheet in a shared drive? Make sure you share the Drive or Folder with that email as well - think about if it were you, you would need access to both if you were accessing that sheet as well!

Only want to capture a small portion of your google sheet? Use the Cell Range field, to fetch data from in the sheet formatted as `A1:B10`. If left blank the entire contents of the tab will be fetched.

Slack - Send Message

Use the Slack - Send Message or Slack - Send Message With File template.

You can choose to embed the file that Google Sheets created (for example pacing_insights.csv) into your message directly

Embed the output in your message like this:

CODE

Here's the output! {{text:pacing_insights.csv}}

Or if you’d rather keep your message static, and upload the contents of the file directly into slack, you can use the Slack - Send Message With File template!

Tip: Add the Alli - Workflows bot to your channel

Either: /invite @Alli - Workflows
Or: Channel Settings → Integrations → Add Apps → Alli - Workflows