Sir, you're a wizard. Thank you for this.

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?

This is a really well made video, well done. Side note, you've got the most epic eyebrows! =D

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

Holy crap. Coding is awesome

Thanks, this video is really great and simple

I like your style

Very informative channel!

this is awesome, thanks!

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?

Excellent

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

Can you do a video on how to have authentication converted to base64?

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?

hey your tool is really cool!

This doesn't appear to be working anymore. Is it possible that something changed for leetcode or the way google spreadsheet works?

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?

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.

Great work and thank for this video. I will subscribe to your channel. Can it do that for all API?

I have an API am trying to connect to but it needs username and Password to access, how can i get pass this

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)

I got a 403 error; i'm not subscribed to this API. Any idea?

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.

it give me error when I try doing the same tutorials you are doing. why?

¿how to create a button to run the api in google sheets?

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?

This not working

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?

hello