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?
@jacquestroussard98578 ай бұрын
This is a really well made video, well done. Side note, you've got the most epic eyebrows! =D
@ucvietnguyen21153 жыл бұрын
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
@mixedanalytics3 жыл бұрын
Will do soon. Thanks for the suggestion!
@alecthecatholic3380 Жыл бұрын
Holy crap. Coding is awesome
@hockeyOK3 жыл бұрын
Thanks, this video is really great and simple
@mixedanalytics3 жыл бұрын
Glad it was helpful!
@TheBuilder3 жыл бұрын
I like your style
@mixedanalytics3 жыл бұрын
Thanks :D Stay tuned for more!
@shafaqagha2 жыл бұрын
Very informative channel!
@mixedanalytics2 жыл бұрын
Glad you think so! Got some more good stuff coming :)
@tinkievonjin38932 жыл бұрын
this is awesome, thanks!
@mixedanalytics2 жыл бұрын
You're welcome!
@jamieukulele3 жыл бұрын
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?
@mixedanalytics3 жыл бұрын
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
@1971dejandim Жыл бұрын
Excellent
@MrMayankpasi Жыл бұрын
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
@Valnurat6 ай бұрын
Can you do a video on how to have authentication converted to base64?
@Osirls Жыл бұрын
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?
@mixedanalytics Жыл бұрын
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.
@siddharthnibjiya2 жыл бұрын
hey your tool is really cool!
@mixedanalytics2 жыл бұрын
Thank you :):)
@GaryJones-wd5ve2 жыл бұрын
This doesn't appear to be working anymore. Is it possible that something changed for leetcode or the way google spreadsheet works?
@mixedanalytics2 жыл бұрын
What error messages are you seeing?
@MarkPhipps-MochaVegan3 жыл бұрын
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?
@mixedanalytics3 жыл бұрын
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!
@cristianedeataide12 жыл бұрын
That’s was great! Thank you!
@domerodriguez45882 жыл бұрын
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.
@mixedanalytics2 жыл бұрын
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 :)
@emmanuelnyanful1433 Жыл бұрын
Great work and thank for this video. I will subscribe to your channel. Can it do that for all API?
@Mr_MicDaniel3 жыл бұрын
I have an API am trying to connect to but it needs username and Password to access, how can i get pass this
@mixedanalytics3 жыл бұрын
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/
@richardgao18822 жыл бұрын
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)
@mixedanalytics2 жыл бұрын
Sure I could do! But you should be aware that pagination is a premium feature: mixedanalytics.com/knowledge-base/pagination-handling/
@52weekhigh113 жыл бұрын
I got a 403 error; i'm not subscribed to this API. Any idea?
@mixedanalytics3 жыл бұрын
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/
@sergey-mihaylov2 жыл бұрын
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.
@mixedanalytics2 жыл бұрын
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.
@sergey-mihaylov2 жыл бұрын
@@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
@emmanuelnyanful1433 Жыл бұрын
it give me error when I try doing the same tutorials you are doing. why?
@mixedanalytics Жыл бұрын
What error do you see?
@palleter002 жыл бұрын
¿how to create a button to run the api in google sheets?
@mixedanalytics2 жыл бұрын
This is probably what you are looking for: mixedanalytics.com/knowledge-base/importapi-custom-sheets-function/#num6
@desto34833 жыл бұрын
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?
@mixedanalytics3 жыл бұрын
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
@gufranmirza7760 Жыл бұрын
This not working
@cosemp12862 жыл бұрын
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?
@mixedanalytics2 жыл бұрын
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.