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?
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.
Hi,
Is there any documentation of ifttt integration with Glide apps?
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
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/
Please ask if you need any help.
3 Likes
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 be of immense help.
Thank you!
@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/
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.
Sounds like an interesting project though…
1 Like
@Rosewebstudio
Thank you for your response. I think i’ll go with integromat. It has the capability to do exactly what I want.
1 Like
@Roger Excellent, perhaps once you have worked it through you could show off your app to us…
1 Like
Just curious, can you specify what sort of data and info can you extract from API calls?
1 Like
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.
1 Like
Oh so from the input text you will use that as an input to IFTTT to extract things like definition etc.?
1 Like
That’s what I was thinking, but looks like the integration with IFTTT doesn’t exist.
1 Like
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.
1 Like
Great, thanks. What are these? Can I use it to make an API call?
It is used to scrape data from specific URLs. If your API returns JSON then you can also use IMPORTJSON.
1 Like
Great, Thank you! But how do I make an HTTP request from Glide?
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.
With reference to
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
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?
1 Like
just extract.