# Import any API into your Google Sheet
**URL:** https://community.glideapps.com/t/import-any-api-into-your-google-sheet/24411
**Category:** Ask for Help
**Created:** [March 17, 2021, 7:37pm UTC](https://community.glideapps.com/t/import-any-api-into-your-google-sheet/24411 "2021-03-17T19:37:11Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@eltintero](https://community.glideapps.com/u/eltintero)
#### Post date: [March 17, 2021, 7:37pm UTC](https://community.glideapps.com/t/import-any-api-into-your-google-sheet/24411/1 "2021-03-17T19:37:12Z")
Hi guys,
I’ve been playing with [https://apipheny.io/](https://apipheny.io/)
It’s a cool app that allows you to bring API data into your google sheet, without creating scripts or coding.
I’ve been speaking with the founder, and he recorded this video on how to bring data from an API into the sheet, and display it in Glide:
[Import Stock Data & Create App From Google Sheets (Apipheny + Glide Demo) - Y](https://www.youtube.com/watch?v=SelNmGGmEQg)
Hope you find it useful!
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [March 17, 2021, 8:16pm UTC](https://community.glideapps.com/t/import-any-api-into-your-google-sheet/24411/2 "2021-03-17T20:16:11Z")
Is this what you were recording yesterday?
---
### Author:  [@Purvang\_Joshi](https://community.glideapps.com/u/Purvang_Joshi)
#### Post date: [March 17, 2021, 9:09pm UTC](https://community.glideapps.com/t/import-any-api-into-your-google-sheet/24411/3 "2021-03-17T21:09:34Z")
Yes. I was using this, it’s interesting when you’ve no idea how to code.
Anyways, Glide has a roadmap to build a little postman inside builder. It’ll be a lot easier to implement any kind of API.
It’ll ultimately benefit faster retrieving data to the app. It’s been struggle when updating back to the app from sheets.
Glide maybe taking 15 to 20 seconds to refresh values.
Let’s see, what happens.
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [March 17, 2021, 9:25pm UTC](https://community.glideapps.com/t/import-any-api-into-your-google-sheet/24411/4 "2021-03-17T21:25:22Z")
Uuufff… great tip Jesus!
I used to use another Add-On called _ **API Importer** _ but they are out of market and I think Apipheny does almost the same.
They had a custom function called _API()_ which was wonderful and powerful, the best thing was the fact, you could reference a cell as a status flag or trigger so, if that cell changes its value, your API call is executed and the data is updated. No script nor timed trigger!!
Here you can see how they showed this function:
But I can see that Apipheny has a something similar with _**APIPHENY()**_ function. I going to test it and I hope it has the same features that the API() function mentioned above.
Gracias @eltintero
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [March 17, 2021, 9:43pm UTC](https://community.glideapps.com/t/import-any-api-into-your-google-sheet/24411/5 "2021-03-17T21:43:17Z")
Hi!
15 to 20 sec to refresh values? What API are you using that lasts so long?
In my demo [IIoT APP](https://community.glideapps.com/t/glide-with-iot-iiot-industrial-iot-and-domotic-applications/22698) where my laptop works as server and replies external calls (and I have a poor upload speed too), the updating lasts 8-10 sec but if I had used a Webhook, the process would last 4-6 sec.
Of course, while more data is requested, the updating will last more (my demo uses 12 variables)
Saludos Joshi.
---
### Author:  [@Purvang\_Joshi](https://community.glideapps.com/u/Purvang_Joshi)
#### Post date: [March 17, 2021, 10:00pm UTC](https://community.glideapps.com/t/import-any-api-into-your-google-sheet/24411/6 "2021-03-17T22:00:51Z")
I’m talking about refreshing sheets data to glideapp.
Example:
First of all, I’ve Pro Apps, which are enabled auto refresh when someone using it.
When I trigger an API or Webhook from glideapp itself, the API response writes to the sheet. And sheets will send data to GlIde.
So, in most cases, we want realtime response in app.
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [March 17, 2021, 10:29pm UTC](https://community.glideapps.com/t/import-any-api-into-your-google-sheet/24411/7 "2021-03-17T22:29:43Z")
Well, my demo is using a Pro plan too and does the same what you are writing otherwise, the updating would be slower…
When I press the button highlighted in yellow, a value is sent to my GS (the button turns to red) , this fires a script and requests an API call which is replied by my laptop, the newer data is written into GS and waits to be read by Glide about 3-4 sec. When Glide finally reads my GS, my updating button turns back to blue and the operation is over.
You can test it here without problems [https://iiot-v2.glideapp.io](https://iiot-v2.glideapp.io)
Regards!
---
### Author:  [@Purvang\_Joshi](https://community.glideapps.com/u/Purvang_Joshi)
#### Post date: [March 17, 2021, 10:42pm UTC](https://community.glideapps.com/t/import-any-api-into-your-google-sheet/24411/8 "2021-03-17T22:42:15Z")
Nice. I need to test more on this.
Thanks ✌