Spreadsheet Automation 101 Lesson 4: OmdbAPI get ApiKey, get Data in URL

<div>0:00 All right, for this lesson, we're gonna actually jump out of Google Sheets. We, we will come back to it. So make a a, make a sheet in your document.<br>0:09 If you're following along, call it API key, all lowercase if you wish, and put your API key there when we get it.<br>0:15 So we're gonna go to om db api.com. You have to go over to API key. You can get a free one.<br>0:23 Just enter your email name, how you're using it. We're learning how to use APIs in how to access APIs in Google Sheets.<br>0:30 And hit submit should be very, very quick. You should be able to get this by email. Learn to Code in Google Sheets, For Programmers | For Advanced Google Sheet Users Access Free API's with Google Sheets Scrape Google Maps in Google Sheets

You will have a thousand daily limit .<br>0:36 I have my own API key, so don't take mine. Go get your own. It's absolutely free. But let's talk about getting, how do we get data from om d b?<br>0:46 Okay let's go back to api. We have some usage and some parameters . If you're, if you're ever trying to figure out how to use APIs, there will almost always be documentation about the usage.<br>1:01 So if we scroll down, we see the usage, send all data requests to this url, and it has here, I don't know if you can really see it that well.<br>1:10 ODB api.com/question mark. API key equals your key. Upgrade Your Outreach LIVE COWORK SESSION

So it has some brackets here. We don't need those brackets. It's just showing us that we need a put in our API key and then an ampersand.<br>1:22 Okay, so what does that ampersand mean? It means that anything after that ampersand, we can add parameters . So in this particular case, we can add a t.<br>1:32 This is the parameters .

It has a parameter here, has some options, has some other data , and it tells you what it gets.<br>1:38 So for what it is, so we have a movie title to search for, we're gonna be able to search for a title like Titanic and get back all of the information in the api.<br>1:47 Essentially, that's what's going on. We are calling this this URL that has some data at the end. Learn to Code in Google Sheets, For Programmers | For Advanced Google Sheet Users

And we're saying, what do you have?<br>1:53 And it will send back a response, which will be our data , and we'll capture that data in our Google sheet.<br>1:58 And then we're gonna parse through it with some data on which we'll get to later. But just to be clear, in this particular case, the API is a restful api.<br>2:12 We can actually access this by the url. So check out this, we can take our url, copy it. We're gonna go to a new new place where you need to enter our API key.<br>2:24 I have mine saved here. Put our API key in. Then just like in this example, have an amper sand. GPT in SHEETS Access Free API's with Google Sheets Automatic Screenshot in Google Sheets

Okay?<br>2:33 So we add an amper sand, then T equals, and we're just going to type in Titanic. So we get, let me put this all in here for you.<br>2:45 So that's the whole URL that we're, we are putting in. And we're just gonna put this in a URL in Chrome.<br>2:52 And what do we get back is text. This is the response we get. Just like we would get in on a website, we Would get, get some data back.<br>3:00 But that data then is parse, like what's the html, what's the css, what's, what's all the parts of it. And then it builds a sort of browser.<br>3:06 We'll build it together. Automatic Screenshot in Google Sheets

But here we just have some data . What's really cool about this data , which I'll show you in another video about J S O N.<br>3:16 This is j s O and it's structured. It actually has the title here, Titanic has year. It has a lot of data in here, and we're gonna be able be able to parse that inside of our Google sheet.<br>3:30 So I'm gonna pass that along to next video. We're gonna actually parse this. We can literally take this exact url, URL and put it in this fetch.<br>3:42 So we will take all of this url, put it into this fetch, hit command S for save. Extract URLs from Google Sheets Scrape Google Maps in Google Sheets

Now, when we run, get data and we log, it's the exact same data that we get here in our, in our url in our Chrome browser.<br>4:00 This is pretty cool because what it allows us to do is check if our, if our code is wrong but this is correct, then okay, we did something wrong in our code.<br>4:09 But if we use the URL in our u in our browser and it's wrong, okay, we know it's the URL, not our code.<br>4:16 It gives us that power to see what is actually wrong with what we're doing. So that's really cool. Check URL Status from a Google Sheet!

So sometimes you might misspell Titan Titanic and you're gonna get response, false movie not found, and you're like, ah, if your code is right, you have the right name, Titanic, or if you don't have the right name, but your code is right, you're gonna get this error .<br>4:36 So really, really cool way to see, okay, we got our url, got some data . Now we can go write our, write our code in the next video.</div>