Integrating IXON Cloud with other applications via Zapier

How can you use webhooks to change the state of other applications you already use?

You may, for example, want to report or log machine alarm occurrences by creating a chat message for your service team or log the alarms in Google Sheets for reporting. In this blog, we will show you how you can use IXON Cloud’s webhooks to trigger custom actions in other applications you use.

Sending machine data from IXON Cloud to Google applications via Zapier

In the below step by step example, you’ll learn how to integrate IXON Cloud with Google Sheets and Google Chat via Zapier. We use Zapier to set up our integrations with these applications. Google Sheets doesn’t support webhooks and requires you to make automated changes via their API, and Google Chat requires the webhook data to have a specific format – different from the IXON Cloud format.

Zapier is a web API translation service that has integrations for a lot of popular apps like Google Sheets. You can also create a new webhook in Zapier and format the data so it meets the required format for apps like Google Chat.

IXON Cloud webhooks feature - integrate via Zapier with 3rd-party applications

Step-by-step guide on how to integrate the use of webhooks

In the example below we describe how to:

  1. Create a Zapier webhook as a trigger and set up a connection with the IXON Cloud, so that the webhook is triggered when a machine alarm goes off
  2. Create an action (example 1): create new rows in Google Sheets to log the alarm information
  3. Create an action (example 2): create a Google Chat message to inform your service team about the alarm information.

The ‘Zaps’ we are going to create consist of two parts; a Trigger App and an Action App. The Trigger App receives webhooks from IXON Cloud in Zapier. Next, the Action App makes a change in our target application.

Requirements to integrate IXON Cloud with Google applications

To follow this tutorial you need:

  • an IXON Cloud account and a device (e.g. IXrouter) with Cloud Notify activated to trigger alarms.
  • Google account for using Google Sheets and Google Chat.
  • Zapier account (free version is fine).

1. Connect the IXON Cloud to a webhook in Zapier using a trigger

First, we have to create a webhook in Zapier so we can use this to trigger alarm information from the IXON Cloud.

Open Zapier and make a new Zap:

Create a new Zap - IXON Cloud integration

Create a Trigger App. Select Webhooks as your Trigger App:

Step 2. Select webhooks as trigger app - IXON Cloud integration

Choose Catch Hook:

Choose catch hook - IXON Cloud integration

Copy the URL provided by Zapier:

Step 4. Copy webhook url - IXON Cloud integration

Open IXON Cloud and navigate to Messages -> Settings:

Step 5. Go the IXON Cloud settings - IXON Cloud integration

Add a new webhook:

Step 6. Add a new webhook - IXON Cloud integration

Enter a name and paste the URL from Zapier:

Step 7. Name the webhook and place Zapier url - IXON Cloud integration

You can now see your newly created Webhook:

Step 8. Webhook added succesfully - IXON Cloud integration

Go back to Zapier and press “Ok, I did this”. Zapier will now start listening for a sample Webhook.

Step 9. Check for example - IXON Cloud integration

Trigger an alarm you have configured in the Cloud Notify app of your device. A message will be created in your messages tab and a webhook will be sent to Zapier. Wait for a sample to show up as shown below:

Step 10. Pick a sample - IXON Cloud integration

We have now successfully created a Trigger App.

2. Create an action (example 1) to log the machine alarm in Google Sheets

The data collected in step 1 is now available for external applications. In this example, we will create a new row in a Google Sheets document to log the machine alarm information.

Add an Action App to our Zap.

Step 11. Finished trigger app - IXON Cloud integration

Choose Google Sheets as the action app:

Step 12. Create Google Sheets as action app - IXON Cloud integration

We want to create a new row in our sheet whenever an alarm is triggered:

Step 13. Create new spreadsheet row - IXON Cloud integration

You will need to grant Zapier access to your Google Drive account:

Step 14. Grant Google Sheet access with your Google account - IXON Cloud integration

Step 15. Login with Google account - IXON Cloud integration

Step 16. Choose the added Google account - IXON Cloud integration

Create a Google Sheets with column headers on the first row:

Step 17. Create Google Sheet row with headers - IXON Cloud integration

In Zapier, select your spreadsheet and configure what data you want to have placed in each column:

Step 18. Map the columns in Zapier - IXON Cloud integration

Let Zapier send a test to your spreadsheet:

Step 19. Send test to spreadsheet - IXON Cloud integration

Step 20. Test was successful - IXON Cloud integration

You can see the new row in your spreadsheet:

Step 21. Data added to spreadsheet - IXON Cloud integration

You can now give your Zap a name and turn it ON:

Step 22. Finish the Zap - IXON Cloud integration

3. Create an action (example 2) to send a message in Google Chat

Now we’ll use the alarm information from step 1 to create a Google Chat message. As mentioned in the beginning of this article, we cannot send the webhook straight to Google Chat because it requires a different format. That’s why we use Zapier to transform the data and push it to Google Chat using a new webhook.

Create a new Action App and choose webhooks:

Step 23. Create new webhook - IXON Cloud integration

Select POST request:

Step 24. Choose POST request - IXON Cloud integration

Open Google Chat and create a new room (or use an existing one):

Step 25. Create or choose the Google Chat room - IXON Cloud integration

Step 26. Name the chatroom - IXON Cloud integration

Select Configure webhooks:

Step 27. Configure webhooks - IXON Cloud integration

Give your incoming webhook a name:

Step 28. Name the incoming webhook - IXON Cloud integration

Copy the generated URL:

Step 29. Copy the webhook URL - IXON Cloud integration

Open Zapier, paste the URL, set Payload Type to “json” and add a key: ‘text’ with the data you want to show up in the message:

Step 30. Paste webhook URL as payload - IXON Cloud integration

Let Zapier send a test webhook to Google Chat:

Step 31. Send a test to Google Chat - IXON Cloud integration

Step 32. Test was successful - IXON Cloud integration

Open Google Chat and you can see the message that has been sent by Zapier:

Step 33. Test messages appears in Google Chat - IXON Cloud integration

You can now give your Zap a name and turn it on:

Step 22. Finish the Zap - IXON Cloud integration

That’s it! You can add as many actions or Zaps as you want, to use the data from the IXON Cloud in external applications.

Wrapping up

We showed you the steps on how to use IXON Cloud webhooks to update a Google Sheets document and create a new Google Chat message. You can use these examples to implement your own custom use cases!

New to IXON Cloud? Set up your free account today and test it yourself.

Mis niets van onze laatste productontwikkelingen, nieuws artikelen en tips van IXON cloud experts!
Meld je aan voor onze nieuwsbrief en blijf of de hoogte.

Meld je aan voor onze nieuwsbrief

Download de Android-app

Verbeter de dienstverlening voor je machines wereldwijd met IXON’s Industrial IoT platform.

Download
Download de iOS-app

Verbeter de dienstverlening voor je machines wereldwijd met IXON’s Industrial IoT platform.

Download
Get ready to connect!

De IXON Cloud is geheel webgebaseerd en toegankelijk op je smartphone of tablet.

connect.ixon.cloud
We’re ready to help!

Vragen? Wij kunnen helpen. Voor directe ondersteuning zijn wij ook telefonisch bereikbaar.

support.ixon.cloud

We gebruiken cookies en andere technieken om de gebruikerservaring van deze site te verbeteren, het website verkeer te analyseren en om te zien waar onze bezoekers vandaan komen. Lees voor meer informatie ons Privacy- en cookiebeleid.

Door akkoord te gaan stem je in met het gebruik van cookies en andere technieken.