0:00 All right, so far we have been taking data inside of our sheets and doing things with it, right? We're able to trigger scripts that we're writing we're doing really cool stuff, but like, I want to shoot fire from my fingertips, right?
0:15 We want to create some magic inside of Google Sheets. And one of the coolest things is a database, right? We can create, we can add da, we can add data inside two Google Sheets.
0:26 In this section and this lesson, we're going to pull data from anywhere in the web in all over the web, inside of Google Sheets.
0:34 So we're gonna end up using the URL fetch app. I'll teach you that, but we're also gonna use OM DB api.
0:40 So for this use case, we are getting data on movies and we're getting it into Google Sheets. We're going to use, we're gonna end up with this, get movie data where we're choosing any title we're using parameters or some kind of data items.
0:56 I'm gonna teach you j s o n how to use the URL fetch app. It's way easier than you ever imagined.
1:02 You really just have to call a url, but you're gonna learn that in this section. We've already u we've already learned spreadsheet apps, so you are very comfortable with that.
1:10 You already know about variables already, know about functions already know about a lot of stuff. We have gone a long way, and getting information from the web into Google Sheets is probably one of the coolest things you could possibly do.
1:25 Once we do that, we can automate scripts that pull that data, we can update them, copy and paste values from that data onto our sheets to sort of keep logs.
1:36 Sometimes we have lots of options and literally this becomes an infinite number of possibilities. So I'm glad you've made it this far into spreadsheet.
1:44 Automation 1 0 1 Ace is very much an introduction, so don't feel like we're gonna go too deep into it. Just spend a few more minutes with me and we'll be fetching lots of data from all over the web.
1:55 Thanks and enjoy.