Пікірлер
@lordleroyyoung 6 күн бұрын
Can I do the reverse....Google Sheets data into Google Wallet
@apipheny 5 күн бұрын
Hi! It depends if the API you're using accepts POST requests. If the API accepts POST requests, then you can send a POST request from your Google Sheet to the API. So if you want to send data from Google Sheets to Google Wallet, check the Google Wallet API documentation to see if you can make POST requests.
@healthutifull 8 күн бұрын
thank you much!!! the most useful video ever on this topic. so much gatekeeping around here....
@apipheny 5 күн бұрын
You're very welcome!
@rafatahmed2972 22 күн бұрын
Hey, how can I find what each id means? Say im looking for a specific player, how would I find what id value that is? Can't seem to find it in the docs...
@apipheny 22 күн бұрын
Hi! Good question. I wasn't able to find out how after a quick search, but you should be able to find that info in one of three ways: 1.) On their website: www.google.com/search?q=site%3Ahttps%3A%2F%2Fwww.api-football.com+player+ids or 2.) By using one of the endpoints (look for an endpoint that gets all player names + IDs) or 3.) In the rapidapi docs: Overview: rapidapi.com/api-sports/api/api-football Tutorials: rapidapi.com/api-sports/api/api-football/tutorials FAQs: rapidapi.com/api-sports/api/api-football/discussions
@maxtannchen9797 22 күн бұрын
Didn't work for me.
@apipheny 22 күн бұрын
What happened when you tried to make the API request?
@102devv Ай бұрын
how can i get all informations from rapidapi and get all of them with one api
@apipheny Ай бұрын
Hi! I'm not quite sure what you mean, can you clarify?
@pmexplore Ай бұрын
How can i do this for a list 300 of Facebook pages where I want to scrape some general public data such as followers and engagement? Taking this into a google sheet.
@apipheny Ай бұрын
Hi! To do that what you will do is using our "reference a range of cell values" feature which you can learn more about here: apipheny.io/reference-cell-value-api-request/ So what you will do is enter all the facebook page URLs in one column and then use our "reference cell range" feature to reference all of those values in your API request.
@risteaalin Ай бұрын
Why didn’t you create a Google and already configure it so I can just change the APIs myself?
@apipheny Ай бұрын
Hello! I'm not sure what you mean, can you clarify? Apipheny is a universal API connector for Google Sheets that allows users to connect any API they want.
@mattioni6 Ай бұрын
i want to get collection stats, how do i make it provide more results?
@apipheny Ай бұрын
Hi! Which stats are you looking for? You have to find the correct endpoint in the OpenSea API documentation that can get the data that you're looking for. Here is an example of an endpoint: docs.opensea.io/reference/list_collections To get more results you need to add/edit the "limit" parameter in your API URL or you will need to use pagination to get the rest of the results: apipheny.io/pagination/
@rasmusmagelund Ай бұрын
How to setup output to a specific cell, and how to change data example dots to commas when output ?
@apipheny Ай бұрын
Hello! You can try using the =APIPHENY forumla to get outputs to specific columns: apipheny.io/apipheny-custom-function/ To change dots to commas you will need to use a google sheets formula: www.google.com/search?q=change+periods+to+commas+google+sheets
@rasmusmagelund 2 ай бұрын
How to get macro-economic data by countries into Google Sheets
@apipheny 2 ай бұрын
Hello! You can try using this API in Apipheny to get microeconomic data: eodhd.com/financial-apis/macroeconomics-data-and-macro-indicators-api Here is our tutorial explaining how to connect this API to your google sheet using Apipheny: apipheny.io/eod-historical-data-api/
@elijahwilliamhunt 2 ай бұрын
The Apiphany extension isn't opening. I'm just getting a spinning purple circle.
@apipheny 2 ай бұрын
Hello! The reason this usually happens is due to being signed in to multiple google accounts. Some users experience this issue and other users don't. It's a bug that Google is aware of and needs to fix. In the meantime, what you can try doing to fix it is signing out of your other google accounts, or sign in to your google account by itself in a different browser. I hope that helps you resolve the issue!
@elijahwilliamhunt 2 ай бұрын
@@apipheny Thanks! I never would have thought of that!
@hawkeye.6096 2 ай бұрын
I love it when some gives perfectly clear and easy instructions to follow. I am so new to all things api and google sheets and I've been bitching with chat bots and trying to find a faster way to extract nfl data cause I know the stupid technology it out there lol. Thank you very much sir
@apipheny 2 ай бұрын
You're very welcome 😁
@hawkeye.6096 2 ай бұрын
@@apipheny oh the took for it is yours?
@apipheny 2 ай бұрын
@@hawkeye.6096 I'm not sure what you mean, can you clarify?
@YerkoBegic 2 ай бұрын
Pulling so much data I don't need. How can I display just the symbol and current price? Let's say I want to show something like this: Bitcoin BTC $59,541.47 Ethereum ETH $2,408.34 USDC USDC $1.00 Cardano ADA $0.362
@apipheny 2 ай бұрын
Hi! You can either use a different API that provides that data you want the way you want it, or you can try using the filter feature in Apipheny: apipheny.io/response-viewer/
@YerkoBegic 2 ай бұрын
how would you do from coinmarketcap?
@apipheny 2 ай бұрын
Hi! Here's our CMC video: kzbin.info/www/bejne/fZmXi5djm8uhZtE&lc=Ugy7krwqEgLi6xX5SRJ4AaABAg And blog post: apipheny.io/coinmarketcap-api-google-sheets/
@darryltj08 3 ай бұрын
This was very helpful! DO you know any apis where i can get 2023-24 player data?
@apipheny 3 ай бұрын
Hello! Good question. Off the top of our head, we are not sure. You will have to look through the APIs that are available in RapidAPI to determine if there is an API that can provide that data. Or you can look for an third party API outside of RapidAPI: www.google.com/search?q=basketball+api
@darryltj08 3 ай бұрын
@@apipheny Thanks. I actually found it give the data if you change the year. This video was a life saver and now i am able to begin machine learning with nba data. Really appreciate ya!
@CCHCrypto 3 ай бұрын
Hello , thanks for sharing. Is it still working?
@apipheny 3 ай бұрын
Hi! Yes it should still be working
@morcillonga1 2 ай бұрын
Yo intenté pero ya no funcionan.
@gumballdegree 3 ай бұрын
Next video, can you do banking transactions using plaid?
@apipheny 3 ай бұрын
Yeah sure we'll look into it and see if we can make a video!
@gumballdegree 3 ай бұрын
@@apipheny that would be so sick!
@agostinhoserra 4 ай бұрын
How can we use this API in MacOS Numbers?
@apipheny 4 ай бұрын
Not sure, we only cover google sheets right now: apipheny.io/coingecko-api/
@paranoya733 4 ай бұрын
Can we do different url's endpoints in different sheets?
@apipheny 4 ай бұрын
Yeah definitely! You can call different endpoints in any sheet you want.
@jp.gaviria 5 ай бұрын
This aint free tho, instead of paying for this epiphany thing you can use google apps script and chatgpt 4 to craft a function that will run on google sheets and a render server all on a free plan. The struggle is to get the API for free. But dont give any money to this bullshitter
@relaxengine8786 5 ай бұрын
Thank you!
@apipheny 5 ай бұрын
You bet!
@johnfrancispederson 5 ай бұрын
Yo did they take away the free stuff? I swear I just used this last year.
@apipheny 5 ай бұрын
Hey I'm not sure but try clicking the "Create demo account" button on their pricing page: www.coingecko.com/en/api/pricing If that doesn't work try contacting Coingecko support to confirm.
@abdullahhafeez2210 5 ай бұрын
It says data could not be sparsed when I follow the procedure. Please help
@apipheny 5 ай бұрын
Hi there, we also have a written tutorial you can try following: apipheny.io/youtube-api-google-sheets/ If that doesn't work please contact support, thanks!
@kesbetik 6 ай бұрын
Good Job. Google Gemini recommended your video.
@apipheny 6 ай бұрын
Awesome, thank you!
@pierrebecher 6 ай бұрын
can I also reference a dynamich range like {{{A1:A3}}}} for example?
@apipheny 6 ай бұрын
Hello! Yes that is correct, you can do that. More info: apipheny.io/reference-cell-value-api-request/
@polaroidale6105 6 ай бұрын
@@apipheny Is it working on header and body ?
@apipheny 6 ай бұрын
@@polaroidale6105 We are currently working on that feature right now - the ability to reference a range of cells in the header and body. This new feature should be ready in the next ~1 month.
@polaroidale6105 6 ай бұрын
@@apipheny Awesome
@RobertAgee-ys2tp 7 ай бұрын
But can you do it dynamically for Post requests in the Body?
@apipheny 7 ай бұрын
Hi there! Yes you can: apipheny.io/reference-cell-value-api-request/
@game-party-evening 7 ай бұрын
cool thanks for help!
@apipheny 7 ай бұрын
No problem!
@apipheny 8 ай бұрын
✨ Exclusive offer from Coingecko API ✨ Unlock the full power of the Coingecko API with coupon code “APIPHENY20” and enjoy a generous 20% discount on the monthly or annual subscription plan! Don’t miss this chance to access comprehensive cryptocurrency data at an unbeatable value. Join today and harness the potential of the Coingecko API like never before. 1.) Go to Coingecko: apipheny.io/coingecko-signup 2.) Sign in to your account or sign up for an account 3.) Choose “annually” on the pricing page and click to purchase one of the plans 4.) Follow the steps to checkout 5.) On the payment screen click “Add promotion code” and enter the code “APIPHENY20” to get 20% off the monthly or annual plan Get your discount now at apipheny.io/coingecko-signup with coupon code “APIPHENY20”
@apipheny 8 ай бұрын
✨ Exclusive offer from Coingecko API ✨ Unlock the full power of the Coingecko API with coupon code “APIPHENY20” and enjoy a generous 20% discount on the monthly or annual subscription plan! Don’t miss this chance to access comprehensive cryptocurrency data at an unbeatable value. Join today and harness the potential of the Coingecko API like never before. 1.) Go to Coingecko: apipheny.io/coingecko-signup 2.) Sign in to your account or sign up for an account 3.) Choose “annually” on the pricing page and click to purchase one of the plans 4.) Follow the steps to checkout 5.) On the payment screen click “Add promotion code” and enter the code “APIPHENY20” to get 20% off the monthly or annual plan Get your discount now at apipheny.io/coingecko-signup with coupon code “APIPHENY20”
@apipheny 8 ай бұрын
✨ Exclusive offer from Coingecko API ✨ Unlock the full power of the Coingecko API with coupon code “APIPHENY20” and enjoy a generous 20% discount on the monthly or annual subscription plan! Don’t miss this chance to access comprehensive cryptocurrency data at an unbeatable value. Join today and harness the potential of the Coingecko API like never before. 1.) Go to Coingecko: apipheny.io/coingecko-signup 2.) Sign in to your account or sign up for an account 3.) Choose “annually” on the pricing page and click to purchase one of the plans 4.) Follow the steps to checkout 5.) On the payment screen click “Add promotion code” and enter the code “APIPHENY20” to get 20% off the monthly or annual plan Get your discount now at apipheny.io/coingecko-signup with coupon code “APIPHENY20”
@apipheny 8 ай бұрын
✨ Exclusive offer from Coingecko API ✨ Unlock the full power of the Coingecko API with coupon code “APIPHENY20” and enjoy a generous 20% discount on the monthly or annual subscription plan! Don’t miss this chance to access comprehensive cryptocurrency data at an unbeatable value. Join today and harness the potential of the Coingecko API like never before. 1.) Go to Coingecko: apipheny.io/coingecko-signup 2.) Sign in to your account or sign up for an account 3.) Choose “annually” on the pricing page and click to purchase one of the plans 4.) Follow the steps to checkout 5.) On the payment screen click “Add promotion code” and enter the code “APIPHENY20” to get 20% off the monthly or annual plan Get your discount now at apipheny.io/coingecko-signup with coupon code “APIPHENY20”
@apipheny 8 ай бұрын
✨ Exclusive offer from Coingecko API ✨ Unlock the full power of the Coingecko API with coupon code “APIPHENY20” and enjoy a generous 20% discount on the monthly or annual subscription plan! Don’t miss this chance to access comprehensive cryptocurrency data at an unbeatable value. Join today and harness the potential of the Coingecko API like never before. 1.) Go to Coingecko: apipheny.io/coingecko-signup 2.) Sign in to your account or sign up for an account 3.) Choose “annually” on the pricing page and click to purchase one of the plans 4.) Follow the steps to checkout 5.) On the payment screen click “Add promotion code” and enter the code “APIPHENY20” to get 20% off the monthly or annual plan Get your discount now at apipheny.io/coingecko-signup with coupon code “APIPHENY20”
@apipheny 8 ай бұрын
✨ Exclusive offer from Coingecko API ✨ Unlock the full power of the Coingecko API with coupon code “APIPHENY20” and enjoy a generous 20% discount on the monthly or annual subscription plan! Don’t miss this chance to access comprehensive cryptocurrency data at an unbeatable value. Join today and harness the potential of the Coingecko API like never before. 1.) Go to Coingecko: apipheny.io/coingecko-signup 2.) Sign in to your account or sign up for an account 3.) Choose “annually” on the pricing page and click to purchase one of the plans 4.) Follow the steps to checkout 5.) On the payment screen click “Add promotion code” and enter the code “APIPHENY20” to get 20% off the monthly or annual plan Get your discount now at apipheny.io/coingecko-signup with coupon code “APIPHENY20”
@wiseman235 8 ай бұрын
outstanding video - God bless you. just wondering does it fetch / get the price update it frequently?
@apipheny 8 ай бұрын
Thanks! Yes you can schedule your requests using our scheduling feature (for paid plans): apipheny.io/schedule-requests
@Yanto_Rundy96 8 ай бұрын
Thanks for sharing buddy. I have a question, let see i have my own data in spreadsheet and my students want to see them out how can it be truly accessed from the front-end/students' screen?
@apipheny 8 ай бұрын
Hello! I'm not sure I understand your question - can you clarify?
@Yanto_Rundy96 8 ай бұрын
@@apipheny I meant that if I have data in my spreadsheet and wanting my students can view the data from the front end side, or is it possible for them to get the data from back end/spreadsheet?
@apipheny 8 ай бұрын
@@Yanto_Rundy96 It depends, they can get the data via Google Sheets API on the back end. Or they can just open Google Sheets and view the data on the front end. Or you can connect your Google Sheet to a data visualizer. I hope that helps.
@Groot-x5l 8 ай бұрын
thanks
@apipheny 8 ай бұрын
No problem!
@miguelbaptista4390 9 ай бұрын
Hi! Im pulling a range of cells but each of the results imports the headers aswell so it doesnt use the previous headers.
@apipheny 9 ай бұрын
Hi there, thanks for letting us know! Please contact our support for help: apipheny.io/support
@rajeswarip5098 9 ай бұрын
Where did you paste the url from the gecko, I don't understand how to do it?
@apipheny 9 ай бұрын
Hi! If I understand your question correctly, you need to find the URL you want (that gets the data you need) from the Coingecko API documentation. Then you paste that URL into Apipheny, where it says "API URL". The video explains it step by step, but contact our support if you need further help: apipheny.io/support
@polololo8377 10 ай бұрын
Thats a great help ! Is there a way to automate this in sheets? For example if I want to download all players data from one league on daily basis automatically ?
@apipheny 9 ай бұрын
Hey there, yes you can use our scheduling feature to accomplish that: apipheny.io/schedule-requests/
@gabrielepetriello7224 10 ай бұрын
Hi there, i link with api different cryptos but i'm noticing that they are not updated live
@apipheny 10 ай бұрын
Hello! To update the data on an hourly basis, you will need to use the scheduling feature: apipheny.io/schedule-requests/
@7850202 10 ай бұрын
Thank you, Ive added 1 of the chosen crypto asset. Would you refer to way to get pack of interested results, e.g. btc, bnb.... up to 10-20-more items, and way to renew it hourly. thanks
@apipheny 10 ай бұрын
Hi! You can use the "stack URLs" feature to call multiple endpoints at the same time: apipheny.io/stacking-urls/ And you can use the scheduling feature to renew it hourly: apipheny.io/schedule-requests/
@rawgue362 10 ай бұрын
such a long video without actually explaining the most important feature one wants to fetch i.e the price of a token, not a list, not all coins IDs, not metadata etc. Everyone want to keep track of their individual tokens, how can u do that? How can I track a custom list of lets say 100 different tokens that I want to individually select?
@apipheny 10 ай бұрын
Hello! To accomplish this, what you can do is create an endpoint URL for each crypto you want to keep track of, then use the "stack URLs" feature to call those URLs at the same time: apipheny.io/stacking-urls/ The coinmarketcap API has an endpoint that allows you to get data for a specific crypto asset, and you just need to change the "parameter" in the URL
@averagedudeusa9722 10 ай бұрын
I really appreciate your effort to help, but that coin ranking website is a total waste of our time. they want me to create an account in order to extract data for google sheets. man this whole thing is so badly planned by the developer community that it is a waste of time. I will give you a like because you are a nice guy.
@apipheny 10 ай бұрын
I appreciate your feedback. Luckily there are many different crypto APIs to choose from. You don't need to use the coinranking API. Check out our other tutorials: www.google.com/search?q=site%3Aapipheny.io+crypto
@UtkarshRastogi1997 10 ай бұрын
it says api dosnt exist
@apipheny 10 ай бұрын
Please contact our support if you need help troubleshooting: apipheny.io/support/
@ThunderstruckElectronix 11 ай бұрын
Cool little project. I'll try it out :) Ty
@apipheny 10 ай бұрын
Awesome! Thanks so much.
@cryptotab250 11 ай бұрын
😊 thanks
@apipheny 11 ай бұрын
You're very welcome!
@treyaz123 Жыл бұрын
Hello Apipheny, Greatly appreciate the video, Have one question on Team Numbers do you have a resource that we can look at to correlate the team number to specific teams? Thank you
@apipheny Жыл бұрын
Hey, good question. I believe this is what you're looking for: rapidapi.com/api-sports/api/api-nba/discussions/41656
@treyaz123 Жыл бұрын
Excellent Thank you. Is there a way i can pull All NBA Teams with Players of teams stats in one pull. Then i can breadown data so i can then pull api of specific stats? Thank you@@apipheny
@treyaz123 Жыл бұрын
Can i pull all teams & all player stats at once? Thank you
@apipheny Жыл бұрын
@@treyaz123 Not sure! You'll have to test the different API endpoints that the API offers to see what's possible. Or you can contact the API's support team. I only tested the API once to create this video demo.
@saas-space Жыл бұрын
Amazing tool!
@apipheny Жыл бұрын
Thank you so much 😊 Don't forget to join our referral program, for 50% unlimited recurring commissions! apipheny.io/affiliate-program
@BrandonBaumbach-yy1zg Жыл бұрын
🙏 *Promo sm*
@apipheny Жыл бұрын
💪
@abderrahimaourir Жыл бұрын
I tried it for Twitter but it doesn't work, any idea why?
@apipheny Жыл бұрын
Hi, there could be many reasons why. Please contact support for troubleshooting with details about the error you're getting. apipheny.io/support