Skip to main content

Celonis Product Documentation

Send Sheet update via Slack

Notifying specific people by hand when updates in a Google Sheet are made can be annoying. That's the reason we provide you with that automation solution which tracks the Sheet and sends a Slack message including the data from the Google Sheet automatically. Using this you can easily send the right people the new data aggregated and in the form you like. For example when a Sales Order was requested you can notify the respective employee. Resulting messages could look like that:

60358712.png

And with a few more clicks it could also look like that:

60358711.png

Follow the step-by-step guide below to implement this solution for your Celonis Action Flows use case.

Sample Action Flow

The image below shows a working Action Flow which:

  1. Watches a Google Sheet for new rows

  2. Sends a Slack message to a specific recipient including the new data of the google sheet

60358703.png
Configuring Action Flow

Below you will find the step-by-step guide for configuring each module of the above Action Flow.

1. Watch Google Sheet for Updates

Connection: connect to your Google Account where the Google Sheet to be used is saved or shared with

Spreadsheet: choose the Google Sheet you want to send updates via Slack

Sheet: choose the Sheet with the desired data

Table contains headers: choose yes if you added headers beyond the A-Z numbering, if you directly start with data choose No

Row with headers / First Table Row: this defines the number of columns you want to use. If your table has 5 columns adjust it to A1:F1.

Limit: define here the maximum number of results to be worked with during one execution cycle.

60358704.png

Configuration:

Action Flows Module: Google Sheets

Action: Watch Rows

60358706.png
2. Send Updates via Slack

Connection: connect to your Slack Account and give Celonis the permission to send messages

Enter a channel ID or name: Select from the list

Channel type: depending which channel you want to send a message in (private/public/direct message(IM channel))

User/Channel: choose the recipient(s) of the message

Text: Message including the information from the Google sheet you want to send in Slack. If your table includes headers and you configured the first module right you should be able to see the column names when using the items from the first module.

60358705.png

Configuration:

Action Flows Module: Slack

Action: Create a Message

60358707.png
(3. Send Updates with your User Account)

If you want to send the message from your user this is possible with the advanced settings.

Show advanced settings: tick the box

As User: 'Yes'

Resulting message:

60358711.png
60358708.png
Downloading Action Flow blueprints

To download blueprints for Action Flows, go to Marketplace. In the Marketplace page for your Action Flow, click the Download button to get the blueprint.

Blueprints can be imported into your Celonis Platform Team so that you can quickly make the required changes without needing to build the Action Flow from scratch.

Potential Alternatives

You could replace the Slack module with a messaging module of your choice e.g. Teams or Mail

You could replace the Google Sheet module with a table module of your choice e.g. Excel

Possible Use Cases
  • Notify Order Managers about new Sales Orders

  • Notify employee about PO/invoice mismatch

  • Notify clerk about invoice with cash discount approaching

  • Notify when duplicate invoice detected