> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://documentation.celestory.io/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# 🔌 Connect Celestory with Zapier

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://storage.crisp.chat/users/helpdesk/website/891e6b525cd36000/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://storage.crisp.chat/users/helpdesk/website/59c95680255d7000/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://storage.crisp.chat/users/helpdesk/website/911c1772baf46000/c8c0882f-8c4a-4e3f-a388-8f462f_1nofpmp.png)

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

throught the Message dot.

![](https://storage.crisp.chat/users/helpdesk/website/3094a006d64dc200/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://storage.crisp.chat/users/helpdesk/website/f2bd3894dd736800/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://storage.crisp.chat/users/helpdesk/website/72a1170bb6518000/92247ae1-6cd9-4747-a451-1944e4_1lhxxxf.png)

## 6. Choose Celestory

![](https://storage.crisp.chat/users/helpdesk/website/74195f7afb421400/9170110a-bcb0-48a8-98ed-b39267_6j11e0.png)

## 7. Select the Receive Message trigger

![](https://storage.crisp.chat/users/helpdesk/website/6a5cdd7e0dcc6c00/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://storage.crisp.chat/users/helpdesk/website/80fcce3a874aa000/03cd7c98-4b4c-4a46-a8dd-877929_1p1tjhg.png)

Then click on Add a New Account

![](https://storage.crisp.chat/users/helpdesk/website/45e36ed9c155d000/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://storage.crisp.chat/users/helpdesk/website/25e55f24884b0000/ce54a02f-a6d0-41e9-b9ae-c7d042_1ryhqhl.png)

Then click on Continue

![](https://storage.crisp.chat/users/helpdesk/website/2d985e092b5ff400/c7308fdc-e3b9-4456-a87d-94f925_1km4kmi.png)

Then Test & Continue.

![](https://storage.crisp.chat/users/helpdesk/website/2395b3c4d83be400/669c833e-a070-400a-97bb-6ea929_15nk754.png)

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

![](https://storage.crisp.chat/users/helpdesk/website/96d4864b0b4da80/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://storage.crisp.chat/users/helpdesk/website/a6a28fcaa93b2800/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://storage.crisp.chat/users/helpdesk/website/2933036bc1671600/66cd5104-16cd-46c8-a1a1-19a0e0_1xzidaw.png)

Then Continue.

![](https://storage.crisp.chat/users/helpdesk/website/6c89465116b1a800/47c5d64b-74fb-4ec1-b512-1df54d_3f0jck.png)

Select your Google account.

![](https://storage.crisp.chat/users/helpdesk/website/d5002e0266be7000/88436bfe-7f1d-4430-8b70-a55c86_1ttglol.png)

Click on Continue.

![](https://storage.crisp.chat/users/helpdesk/website/954f1b9838f69800/d3b3ee45-081a-408d-b3cb-082be3_1gkgw2t.png)

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

![](https://storage.crisp.chat/users/helpdesk/website/f94747d31c769800/775f91ed-103c-404d-992a-5737f2_s7xq0i.png)

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

![](https://storage.crisp.chat/users/helpdesk/website/30fa3c079bc94c00/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://storage.crisp.chat/users/helpdesk/website/2b342218b3d02400/2bab2b5c-f5e8-499f-b55b-fcfb5d_10qn1wv.png)

The Continue.

![](https://storage.crisp.chat/users/helpdesk/website/6bafbb12c1a83000/2d272194-df3d-407b-94ea-5a0563_re6esw.png)

A summary of your zap appears.

![](https://storage.crisp.chat/users/helpdesk/website/31ab83a85b035e0/f42fc911-7f02-46b9-b089-35760e_815aiy.png)

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

![](https://storage.crisp.chat/users/helpdesk/website/9572cdcb671d3800/df253db7-51d0-42d2-902c-f30a43_izev6g.png)

Click on **ReTest&Continue**.

![](https://storage.crisp.chat/users/helpdesk/website/1eb4bd9071eb840/cb1a3b75-4c4a-42ec-aeed-5751b4_9cem9a.png)

Then **turn your Zap on**.

![](https://storage.crisp.chat/users/helpdesk/website/6d572a290cd4fc00/6f434ce4-6149-4b10-ae06-33f643_2iphe3.png)

![](https://storage.crisp.chat/users/helpdesk/website/95554870dea37800/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://storage.crisp.chat/users/helpdesk/website/d8038e726795d000/54ec20fa-996b-4d79-9de2-fe3983_tj0b8m.png)

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

![](https://storage.crisp.chat/users/helpdesk/website/35a02510fce9f00/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://storage.crisp.chat/users/helpdesk/website/4ed5725dc0a5bc00/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