Celestory includes 2 types of triggers activated by all players:

* Collect value of a variable (through a choice, an imput text...) which can be a boolean (true OR false), number (1,2,3...) or text type (username...)
* Collect Triger time

Connecting Celestory to Zapier or Integromat opens you the integration of more than 2000 apps! 

*Zapier and Integromat are exclusive to the Pro and Business Plan.* 

**_Note: In order to send data through Zapier, be sure to export your project first. Triggers will start to work only on exported app._**

## 1. Go into your selected project

create a Zapier block

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBallFIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--1af6ee49d2889ca56c27f9c163b88e49f969af53/e9055fa3-43f9-4914-9899-9172e3_10bppmn.png)

## 2. Connect your Zapier block to your graph

You have 3 differents ways to fill the message of the Zapier block:

* connect the value dot from another block
* connect directly a variable block
* enter an arbitrary value by opening the Zapier block

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBa2dEIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--0cbc98be58fabeb5c4a3bb3b0fa9c4f5e96a6431/84884323-5e68-43b3-ba1c-3a2d2c_fe9l0u.png)

the following example, we want to extract the value of the variable Username created from the Imput text bloc.

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBbDRFIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--2675c1a6af5ac0cf45f2f117df6140d9b5be7a66/c8c0882f-8c4a-4e3f-a388-8f462f_1nofpmp.png)

## 3. Link the targeted value to the Zapier block

throught the Message dot.

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBblVDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--0ec8bbf93f535f9be16de9aa351e703a02bce47c/753d5f74-4075-43bd-8dd7-9d4923_1u4czjo.png)

The value dot of the block will replace the message of the Zapier block.

## 4. Activate the integration

in Main Menu/Project Menu/Integration tab

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBdWtHIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--df2b1a89b58c958ec57f67f5681038695ab2f61d/7f86e3f1-4b15-47ef-a848-402ba7_vz3bhv.png)

The Client ID and Client Secret will help Zapier regognized Celestory triggers.

## 5. Go to your zapier account

and select Make a zap

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBcjREIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--805802a8bd689b34476a46f2af29c670d172b0c4/92247ae1-6cd9-4747-a451-1944e4_1lhxxxf.png)

## 6. Choose Celestory

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBc2NEIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--018fc408d4baaa2a9886ac721ed765ec35b79f30/9170110a-bcb0-48a8-98ed-b39267_6j11e0.png)

## 7. Select the Receive Message trigger

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBcE1EIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--1339ee2accd8600e4c6884f21a22fe8fd1f0681d/c7e61a4f-9fa4-4a28-88e4-cc482e_1nofmv.png)

*Note: New Shared project trigger let you know when somebody give you the sharing access to a project, which can be useful if a co-worker wants to share with you some new interactive scenario.*

Then click on Continue.

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBZ29FIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--be0799907fb580495da8c1158c3f1085156898c2/03cd7c98-4b4c-4a46-a8dd-877929_1p1tjhg.png)

Then click on Add a New Account

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBdWtDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--88be4944a30742379bad00af064c4c2ffaff2f34/a964c0b5-c49c-4e10-becf-981f69_rdew36.png)

## 8. Copy the Client ID and Client Secret of your project

in the new window will pop-uping-up.

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBandDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--c160d9a028b519cc4ade492f025d3b2f9a537943/ce54a02f-a6d0-41e9-b9ae-c7d042_1ryhqhl.png)

Then click on Continue

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBbWdDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--9be727c8d28bc216f510ceb1f953b12d403b117c/c7308fdc-e3b9-4456-a87d-94f925_1km4kmi.png)

Then Test & Continue.

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBaTBDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--44956d12542c39a8d2a14165d67ffc2ddc81d982/669c833e-a070-400a-97bb-6ea929_15nk754.png)

The "Message A" message indicates that's working.

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBbndFIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--1372b9b118d06bfd19bc16493992f2b5fa423b7d/786ad8ec-3fba-43aa-8068-99ab41_16fxot5.png)

Then select the second tool of your voice that will receive the data.

In this example, we select Google Sheet.

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBc2tFIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--c88fc0511abed27a032c8efabe24e3a7e7962195/eb1004aa-a901-46f5-adbf-3281ca_47xpyw.png)

Then select the Action you want it to do.

In this example, we want to Create a speadheet row (aka enter a value in a cell).

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBbElDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--93fb02ddc630969caf419adf9bde8dc550615759/66cd5104-16cd-46c8-a1a1-19a0e0_1xzidaw.png)

Then Continue.

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBcUlEIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--1afc4d1a09ded3e90e70f343460c6079e71c5106/47c5d64b-74fb-4ec1-b512-1df54d_3f0jck.png)

Select your Google account.

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBa3NHIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--a2823b07314bc3280718d76df191341f0824729b/88436bfe-7f1d-4430-8b70-a55c86_1ttglol.png)

Click on Continue.

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBbkFFIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--c907d25ff96161f1727be8f41fa776b2d8d9effa/d3b3ee45-081a-408d-b3cb-082be3_1gkgw2t.png)

Select your targeted spreadsheet and the worksheet (aka the Tab).

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBZzhIIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--aaca7312a5f68a17383810fd433bd4ffcf375389/775f91ed-103c-404d-992a-5737f2_s7xq0i.png)

In this example, the spreadsheet as a Username value to indicate the column.

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBbnNDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--7c954b77f0ea490b03108034bbc28d4b59790d19/30013cc1-f629-40dc-9109-a6b741_w6eqfc.png)

Username will be recognized. Select the data you want to collect.  
You can select the Incoming message or the Date of the Trigger.

In this example, let's select Incoming Message.  

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBbDRDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--c69a02b5c58095df6925ad3c7f5b69e3b6e35f1f/2bab2b5c-f5e8-499f-b55b-fcfb5d_10qn1wv.png)

The Continue.

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBcHdEIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--12c83fe4819d36d615c6cdf8f365c6cabecf6d8c/2d272194-df3d-407b-94ea-5a0563_re6esw.png)

A summary of your zap appears.

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBbjRDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--3a671c94483d8e494a167b4c99b4bf27e97996e0/f42fc911-7f02-46b9-b089-35760e_815aiy.png)

You can Test & Review. Your spreadsheet collect the sample data.

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBbklFIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--c4ee7eefeef07d0403e71de27495a482488c0365/df253db7-51d0-42d2-902c-f30a43_izev6g.png)

Click on **ReTest&Continue**.

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBaEVDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--e0dd90447081e1eaec090601f07ebeda64bd5b80/cb1a3b75-4c4a-42ec-aeed-5751b4_9cem9a.png)

Then **turn your Zap on**.

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBcWtEIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--be768c5afefafd07c65764d9ff96bf723406c1b3/6f434ce4-6149-4b10-ae06-33f643_2iphe3.png)

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBbkVFIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--1a76a42a28651b89ca4b4a5c573d58522f7f84ea/8453972b-410d-4480-a0e0-11e5dd_1pd4p1l.png)

## 9. Test your exported app

**_Note: In order to send data through Zapier, be sure to export your project first. Triggers will start to work only on exported app._**

here we test the export in the Discovery marketplace.

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBbDhHIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--5d85adc6a200a17c3bd6675cd576356e0d9b4775/54ec20fa-996b-4d79-9de2-fe3983_tj0b8m.png)

As a regular user, you enter the value of the username variable with an Imput block.

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBcHdDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--8a37f254d5f834bb65fe13f7e0d5381d4b9e9c11/1873737a-7e55-4814-9bf9-096ab8_4qoff0.png)

## 10. Your user data is created

Directly in your spreadsheet. Every user playing the app will continue to fill the value of the spreadsheet.  

![](https://chatwoot.fr.nocodespacelab.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBZ29EIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--838f2dc79d1e2557d490940755f2db1f1396b134/4bd0cdb7-194a-465d-b443-b4376b_5s34v3.png)

✨

**Congratulations**

**You know how to implement data triggers, transfer data and action a third-party app. For marketing, personalized content or learning records, you have unleashed the possibilities of more than 2000 apps and thousand of connections.**

Here are few examples of what you can do with Celestory connecting Zapier to another service:

*   🎓 Create your school online, with **Podia](https://zapier.com/apps/podia/integrations)
Here are few examples of what you can do with Celestory connecting Zapier to another service:
    🎓 *Create your school online, with Podia or Teachable*
*   🕹️ Creating gamification around team tasks, with **Loresome
*   🤚 Assigning a candidate to a job offer and annotating it, with **Crelate
*   🏫 Sending a xAPI file to an LMS, with **Watershed
*   📊 Display surveys as real among your audience, with **Google Slide
*   🔗 Send a custom url to measure click ratio based on user profiles, with **Rebrandly
*   ▶️ Send a custom video to a group of users, with **Crowdcast
*   🔎 Determining the size of a company based on a prospect's email address, with **Hunter
*   📱 Send or update a Record to the app builder, with **Adalo

With Zapier, you can do all the integration of Integromat (mail, angenda, slack, stripe...). To learn more, to go: 🔌 Connect Celestory with Integromat