# Glide app with Sheets and IFTTT

**URL:** <https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483>\
**Category:** Ask for Help\
**Created:** [November 28, 2019, 8:26pm UTC](https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483 "2019-11-28T20:26:33Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Zachary\_Blender](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zachary_blender/32/1893_2.png) [@Zachary\_Blender](https://community.glideapps.com/u/Zachary_Blender)\
**Post date:** [November 28, 2019, 8:26pm UTC](https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483/1 "2019-11-28T20:26:33Z")

</div>

I have a google sheets setup that downloads data from my fitbit and performs various actions using IFTTT. It is quite manual (three different sheets need to be opened for the IFTTT formula to run successfully. Could this kind of setup be bundled and packaged with Glide?

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [November 29, 2019, 3:23am UTC](https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483/2 "2019-11-29T03:23:39Z")

</div>

Welcome to the community!

Possibly. Without more info we couldn’t say for sure. When you say it is a manual process, I’m not sure why or what you mean.

The downloading of data from the fitbit part would not be possible directly with Glide or Google Sheets but if a 3rd party app (like IFTTT) can save the data to a spreadsheet, the spreadsheet most likely can preform any calculation you desire.

---

<div class="post-metadata">

**Author:** ![Roger](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Roger](https://community.glideapps.com/u/Roger)\
**Post date:** [December 3, 2020, 6:53am UTC](https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483/3 "2020-12-03T06:53:23Z")

</div>

Hi,

Is there any documentation of ifttt integration with Glide apps?

---

<div class="post-metadata">

**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\
**Post date:** [December 3, 2020, 7:19am UTC](https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483/4 "2020-12-03T07:19:52Z")

</div>

Hi 🙋‍♂️ @Roger just wanted to welcome you to the community, great to meet you.

I am not aware of any documentation with regards to IFTTT

There is some reading you can do on their own website

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/9/79e529d1227d58fdc724d05347717e0e13100c04.jpeg)

So the data you integrate and add to google sheets via IFTTT could then be used to feed into a glide app.

Simple example

Twitter - IFTTT - google sheet - glide app

If you need to learn more about glide here is a link to the documentation [https://docs.glideapps.com/all/](https://docs.glideapps.com/all/)

Please ask if you need any help.

---

<div class="post-metadata">

**Author:** ![Roger](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Roger](https://community.glideapps.com/u/Roger)\
**Post date:** [December 3, 2020, 9:08am UTC](https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483/5 "2020-12-03T09:08:18Z")

</div>

Hey @Rosewebstudio,  
Thank you for the IFTTT info, but did not exactly find what I was looking for.

May be you can help with the explanation below:

1. I am taking text as input from a user. The text gets stored in Google Sheet.
2. Now I want to use this text and make an external API call (something like reddit / wiki) to retrieve additional data and info.
3. This data gets stored in another field of the sheet.

I was thinking of doing step2 above using IFTTT. Is it possible? Any recommendations would be of immense help.

Thank you!

---

<div class="post-metadata">

**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\
**Post date:** [December 3, 2020, 10:15am UTC](https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483/6 "2020-12-03T10:15:46Z")

</div>

@Roger great question. I have not explored the abilities you raise in point 2 so cannot really comment.

Using IFTTT to do what you want is probably out of the scope of this forum, perhaps better posted somewhere like this? or somewhere similar [https://www.reddit.com/r/ifttt/](https://www.reddit.com/r/ifttt/)

An expert on IFTTT can advise whether your proposal is achievable.

Perhaps it’s also worth exploring something like zapier or integromat rather than IFTTT? These offer some great automation for google sheets, integromat especially.

> **[Integromat](https://www.integromat.com/en/)**
>
> Integromat is an easy to use, powerful tool with unique features for automating manual processes. Connect your favorite apps, services and devices with each other without having any programming skills.

> **[Zapier | The easiest way to automate your work](https://zapier.com/)**

Sounds like an interesting project though…

---

<div class="post-metadata">

**Author:** ![Roger](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Roger](https://community.glideapps.com/u/Roger)\
**Post date:** [December 3, 2020, 10:25am UTC](https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483/7 "2020-12-03T10:25:22Z")

</div>

@Rosewebstudio  
Thank you for your response. I think i’ll go with integromat. It has the capability to do exactly what I want.

---

<div class="post-metadata">

**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\
**Post date:** [December 3, 2020, 10:27am UTC](https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483/8 "2020-12-03T10:27:29Z")

</div>

@Roger Excellent, perhaps once you have worked it through you could show off your app to us…

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 3, 2020, 10:41am UTC](https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483/9 "2020-12-03T10:41:16Z")

</div>

> [@Roger](#):
>
> Now I want to use this text and make an external API call (something like reddit / wiki) to retrieve additional data and info.

Just curious, can you specify what sort of data and info can you extract from API calls?

---

<div class="post-metadata">

**Author:** ![Roger](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Roger](https://community.glideapps.com/u/Roger)\
**Post date:** [December 3, 2020, 11:10am UTC](https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483/10 "2020-12-03T11:10:56Z")

</div>

@ThinhDinh

Typically, these APIs return JSON data. Therefore, it’ll need bit of post processing to get what I want.  
Not sure if I answered your question.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 3, 2020, 1:07pm UTC](https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483/11 "2020-12-03T13:07:40Z")

</div>

Oh so from the input text you will use that as an input to IFTTT to extract things like definition etc.?

---

<div class="post-metadata">

**Author:** ![Roger](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Roger](https://community.glideapps.com/u/Roger)\
**Post date:** [December 3, 2020, 1:45pm UTC](https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483/12 "2020-12-03T13:45:43Z")

</div>

That’s what I was thinking, but looks like the integration with IFTTT doesn’t exist.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 3, 2020, 1:47pm UTC](https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483/13 "2020-12-03T13:47:15Z")

</div>

Not sure if it helps but probably you can try looking at IMPORTXML or IMPORTHTML to look for the info you need, if you want alternatives for Integromat, for example.

---

<div class="post-metadata">

**Author:** ![Roger](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Roger](https://community.glideapps.com/u/Roger)\
**Post date:** [December 3, 2020, 2:06pm UTC](https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483/14 "2020-12-03T14:06:26Z")

</div>

Great, thanks. What are these? Can I use it to make an API call?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 3, 2020, 2:37pm UTC](https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483/15 "2020-12-03T14:37:54Z")

</div>

It is used to scrape data from specific URLs. If your API returns JSON then you can also use IMPORTJSON.

> **[bradjasper/ImportJSON](https://github.com/bradjasper/ImportJSON)**
>
> Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet - bradjasper/ImportJSON

---

<div class="post-metadata">

**Author:** ![Roger](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Roger](https://community.glideapps.com/u/Roger)\
**Post date:** [December 3, 2020, 3:46pm UTC](https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483/16 "2020-12-03T15:46:21Z")

</div>

Great, Thank you! But how do I make an HTTP request from Glide?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 3, 2020, 3:54pm UTC](https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483/17 "2020-12-03T15:54:06Z")

</div>

Probably you can do it with scripts, if you can be more specific about what you are trying to get back then we can give better solutions for you.

---

<div class="post-metadata">

**Author:** ![Roger](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Roger](https://community.glideapps.com/u/Roger)\
**Post date:** [December 3, 2020, 4:02pm UTC](https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483/18 "2020-12-03T16:02:21Z")

</div>

With reference to

> [@Glide app with Sheets and IFTTT](https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483/5):
>
> Hey @Rosewebstudio, Thank you for the IFTTT info, but did not exactly find what I was looking for. May be you can help with the explanation below: I am taking text as input from a user. The text gets stored in Google Sheet. Now I want to use this text and make an external API call (something like reddit / wiki) to retrieve additional data and info. This data gets stored in another field of the sheet. I was thinking of doing step2 above using IFTTT. Is it possible? Any recommendations would …

in step 2, as an example I’d like to execute the below API:  
"[https://en.wikipedia.org/w/api.php?format=json&action=query&prop=extracts&exintro&explaintext&redirects=1&titles=Spanish](https://en.wikipedia.org/w/api.php?format=json&action=query&prop=extracts&exintro&explaintext&redirects=1&titles=Spanish)

the value of “titles” to be taken from a cell in google sheet.

in step 3:  
parse json data and update google sheet.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 3, 2020, 4:27pm UTC](https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483/19 "2020-12-03T16:27:05Z")

</div>

> [@Roger](#):
>
> in step 2, as an example I’d like to execute the below API:  
> "[https://en.wikipedia.org/w/api.php?format=json&action=query&prop=extracts&exintro&explaintext&redirects=1&titles=Spanish](https://en.wikipedia.org/w/api.php?format=json&action=query&prop=extracts&exintro&explaintext&redirects=1&titles=Spanish)
> 
> the value of “titles” to be taken from a cell in google sheet.
> 
> in step 3:  
> parse json data and update google sheet.

The JSON response looks like:

`{"batchcomplete":"","query":{"pages":{"26929":{"pageid":26929,"ns":0,"title":"Spanish","extract":"Spanish may refer to:\n\nItems from or related to Spain:\nSpaniards, a nation and ethnic group indigenous to Spain\nSpanish language\nSpanish cuisine"}}}}`

Which specific parts of the JSON string do you want to extract? Just the `extract`?

---

<div class="post-metadata">

**Author:** ![Roger](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Roger](https://community.glideapps.com/u/Roger)\
**Post date:** [December 3, 2020, 4:38pm UTC](https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483/20 "2020-12-03T16:38:06Z")

</div>

just extract.

[Next page](https://community.glideapps.com/t/glide-app-with-sheets-and-ifttt/2483.md?page=2)
