Skip to main content

Celonis Product Documentation

Add data received by a Webhook to Sheet

Sorting and saving data which is sent to you by hand can be annoying. That's the reason we provide you with that automation solution which offers an interface to receive data, manipulate it and saves that data in a structured way automatically. Working with Webhooks gets more and more important to get data from one System into another automatically as soon as it is sent. Speeding up this process by using an automation can save a lot of time and getting rid of manual human errors.

Sample Action Flow

The image below shows a working Action Flow which:

  1. Receives data which is sent to a Webhook.

  2. Manipulates the received data.

  3. Writes the data into a preconfigured Google Spread Sheet.

60359245.png
Configuring Action Flow

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

1. Receive Data from a Webhook
60359246.png

Configuration:

Action Flows Module: Webhooks

Action: Custom webhook

Webhook: Add a new Webhook and name it.

Optional: You have the possibility here to whitelist desired IP addresses to make sure no one else can send data to your hook. In addition you can define a data structure and all incoming data bundles which won't have that structure are ignored.

Determine data structure: You can either send data from the source which will be sending the data later to enable the Webhook to determine the structure or build it by hand.

To do it by hand you copy the address, put it in another window but don't press directly enter. Add data in the following structure to the URL:

?variable1=text&variable2=028366&Variable%20with%20spaces=12.12.2021

for this template we chose the following structure:

?Order%20Id=0176398276&Requested%20Delivery%20Date=22.12.2022&Customer=Amadeus

after pressing enter with the URL structured like that the Webhook should show the 'successfuly determined' confirmation and you should be able to find the defined variables as item after the webhook. In the example we would find Order Id, Requested Delivery Date and Customer.

Only applied when scheduling isn't immediately:

Advanced Setting - Maximum number of results: the default is 2, we chose 3 in this example. You should adapt it to the amount of line items you plan to send at the same time. The line items which are more than the limit won't be lost but queued.

Scheduling

The default of the scheduling is 'immediately' but can be adjusted in the published mode.

If you face any problems have, check Webhooks or try our Academy course on Webhooks!

60359254.png
60359249.png
60359250.png
60359251.png
2. Write received Data to a Sheet
60359247.png

Configuration:

Action Flows Module: Module

Action: Action

Connection: Add a Google connection

Mode: Select spreadsheet and sheet

Spreadsheet: choose the desired spreadsheet in which you want to write the data

Sheet:choose the desired sheet in which you want to write the data

Table contains headers: State if the Table in the sheet has headers to display the table proper in the module

You should now see the table structure in the module and be able to fill in the received data from the Webhook. You can even manipulate the data here using the built in functions like date formatting.

60359253.png
Download Action Flows Blueprint
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.

This blueprint 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 Google Sheets module with a Sheet module of your choice e.g. Microsoft 365 Excel

60359257.png
Possible Use Cases
  • Getting data from one system into another one automatically