Beginners Intro to Pulling API Data into Google Sheets [BONUS: Secret APIs]
ฝัง
- เผยแพร่เมื่อ 25 พ.ค. 2024
- Have you heard the term API before and wondered what it means and what you can do with it? Look no further! This is an introduction to what API data is and how to pull it into Google Sheets via our No Code, beginner friendly API Connector Sheets Add-On. We'll dive into both crypto and hashtag-generator endpoints to give you a brief overview of the vast data accessible from just a few clicks! Finally, I'll give you a cool way to access hidden API's that give you direct access to the data many websites display.
If you are more of a reader, check out our brimming knowledge base of tutorials here: mixedanalytics.com/knowledge-...
Chapters:
0:00 What is an API?
1:34 Locating APIs
3:05 API Connector
3:45 GET Crypto Data
5:14 GET Hashtag Data
7:46 [BONUS] Hidden APIs
API Connector Add-On Download Link:
workspace.google.com/marketpl...
What is an API?
www.ceralytics.com/what-is-an...
CoinGecko Documentation:
www.coingecko.com/api/documen...
Hashtagy Documentation:
rapidapi.com/miguel.aka.kelte...
LeetCode:
leetcode.com/
API Connector Reddit:
/ api_connector
API Icon Courtesy of:
www.flaticon.com/authors/eucalyp - แนวปฏิบัติและการใช้ชีวิต
![[TH] 2024 PMSL SEA W3D3 | Summer | ถ้าไม่ถอดใจ อะไรก็เป็นไปได้](http://i.ytimg.com/vi/XNYhoNHaKvE/mqdefault.jpg)
Sir, you're a wizard. Thank you for this.
Thanks, this video is really great and simple
Glad it was helpful!
What about if you need to log in into a page to get access, can you scrape the data from there somehow with auto log in as well or it's not possible?
Very informative channel!
Glad you think so! Got some more good stuff coming :)
this is awesome, thanks!
You're welcome!
This is a really well made video, well done. Side note, you've got the most epic eyebrows! =D
Excellent
Awesome video - in your previous video re transfer crypto info from coingecko to google sheets. How do i get info from one sheet into another sheet. Do I just copy and paste?
Hellooo,
Easiest way to do this dynamically from one sheet to another is use the =nameOfSheet!A:Z. If you want to send it to another spreadsheet (I mix the terms up constantly), use the =IMPORTRANGE() function
Could you go over apis that require pagination? Ie. if the request returns 10 records, and a value for how many pages there are (ie. 5 pages) and the current page you are on (ie. page 1)
Sure I could do! But you should be aware that pagination is a premium feature: mixedanalytics.com/knowledge-base/pagination-handling/
please make a video for connecting API to get Facebook ads and Google ads into google sheets. I have read a few of your articles but it would be nice having a video about it to get more figure. Thank you so much
Will do soon. Thanks for the suggestion!
hey your tool is really cool!
Thank you :):)
Great work and thank for this video.
I will subscribe to your channel.
Can it do that for all API?
Great video, thanks!
I want to build a dashboard for my wife's digital marketing company. Right now she has multiple clients running multiple campaigns in FB ads that she manages. Is mixed analytics the way to go so that she can see things like cost per lead and have it update periodically instead of having to continuously go into FB to get information?
You can absolutely do that! We have a pre-built one that uses JMES path, but you could hack away another way by using a dump sheet from the API then routing the columns you want to a new sheet. Anyway, here is the dashboard we pre-built:
mixedanalytics.com/knowledge-base/import-facebook-ad-data-to-google-sheets/#num11
Let me know if you have any other questions!
That’s was great! Thank you!
This looks great but I'm concerned about the security of the data if using a 3rd party tool. Do you have any tips how to achieve the same thing with just a script in Google sheet or at least an open source tool?
API Connector runs entirely through Sheets and is secure, but if you'd like to make your own script, I suggest checking Ben Collin's blog for tutorials on that.
Is there an option to run the API requests automated e.g. every day? I want to import data from a newsletter tool and subsequently import the data to data studio.
Yes it's possible! Our premium plans allow for automation as frequently as hourly. It sounds like for your use case though, the Pro version should be sufficient. New users get 14-days free of pro mode, so give it a go :)
Holy crap. Coding is awesome
I like your style
Thanks :D Stay tuned for more!
Great app, just what I was looking for. May I ask how safe is it? If I provide keys and tokens and fetch a bunch of customer data - does the app developer have access to it? Or is end-to-end encrypted connection? Many thanks.
Thanks! The developer does not have access to your keys or tokens, all data is stored in your sheet only and requests run through Google's servers.
@@mixedanalytics thank you, in this case I will install it and give it a go. If it suits our needs, I may even go for the paid version. Thank you
Can you do a video on how to have authentication converted to base64?
Thanks for the great tuto. Just subscribed!
I have a request for you.
Is it possible to pull the prior day's OHLC of all coins from Binance (or other easier exchange to avoid the Binance 403 error :) ) into google sheets?
For example:
Symbols PriordayOpen PriordayHigh PriordayLow PriordayClose
BTC/USD 1.2 1.5 1.1 1.3
BTC/ETH 1.2 1.5 1.1 1.3
ETH/XRP 1.2 1.5 1.1 1.3
etc.
How do you that?
Thanks for following Desto! Got some more cool stuff coming :)
That darn 403 error is giving like every developer headaches for both us and our users lol. It's just cause Binance's service is used so heavily, they have to put in super conservative traffic limits (I guess) to keep their servers online. Anyway, the above is possible using the kline /api/v3/klines endpoint here: binance-docs.github.io/apidocs/spot/en/#kline-candlestick-data but then you would also add &startTime={yesterdayDateUNIXtime} appended on the end
Yes Great Video! I was wondering if you had a spreadsheet created with column A(Name), Column B(Street) and it has information on rows 1 thru 12 and you want to import the rows 13 and on with the API from Another site with the same A(Name), & B(Street) Column. will this populate from 13 on with the new information from the site. Or does this extension overwrite the other rows 1 through 12. Can you import into specific rows/fields? Goal is have a program that collect data from one source example appsheet that fills the rows with new information collected, and have another web site collecting data from the public and you wan to marry the two together. So both Website and appsheet add new information the rows. Example appsheet user have filled rows 1 thru 12 with Name & Street, I want to fill row 13 + with information from the website with Name and Street info. Is this possible to too?
Hi great question! So I've actually recently started tinkering with AppSheet and API Connector to see how well they play with each other. So theorereitcally you could just change the settings in API Connector from "overwrite" to "append" and you would be able to accomplish what you are talking about?
As for specific fields/rows, there are two ways to accomplish that depending on the API you are pulling from. One, you could check the endpoint and filter it accordingly. The second option would be to use our built-in JMES path for filtering the raw JSON that comes back to you (read more here: mixedanalytics.com/knowledge-base/filter-specific-fields-values/). Please note that last option is a premium feature.
This doesn't appear to be working anymore. Is it possible that something changed for leetcode or the way google spreadsheet works?
What error messages are you seeing?
I have an API am trying to connect to but it needs username and Password to access, how can i get pass this
Hey Mbazu,
I'm not sure which API you are connecting to, so I can't really tell you how to connect without more details. I suggest head over to our Reddit channel and leave a post there with information about the domain and what you want to do so our support crew can help :)
Here's the link: www.reddit.com/r/api_connector/
I got a 403 error; i'm not subscribed to this API. Any idea?
Hmm, that's probably a rate limit you are hitting. If you check out our reddit page you can see if anyone else has been having a similar issue www.reddit.com/r/api_connector/
¿how to create a button to run the api in google sheets?
This is probably what you are looking for: mixedanalytics.com/knowledge-base/importapi-custom-sheets-function/#num6
it give me error when I try doing the same tutorials you are doing. why?
What error do you see?
This not working
hello
Hi i need some answers 1. I have an automatically
calculations sheet and i need to sand it it answered values on my api link........ Plz halp