Movie Marathon Maker

0:00 Here's how to use the movie marathon spreadsheet that I just created. Make sure you actually make a copy of it. 0:07 If you haven't made a copy of it, it's available in two places on Better Sheets, Better Sheets.co/slash tools. You'll find it there and at the bottom of this video. 0:16 If you're just watching this video on Better Sheets, you'll find it. It's free for anyone who's a member, monthly member, or lifetime member, and also You can get it at tools. 0:25 If you're a lifetime member, you can get it there, bettersheets.co.tools. So here's how to use it. There's two ways to use it. Spreadsheet Automation for Beginners How To Create a Stop Watch in Google Sheets Better Sheets Videos Checklist Movie Marathon Planner

0:34 There's Movies and Movies Instant. I'm going to go through the Movies Instant because it's really cool. You can just type in any movie here, Casper, and it'll load the poster, it'll load the runtime, it'll load the end time, which is approximating and rounding up from your Your time, and it'll have the 0:50 plot here. So that's how you use this instant one. What happens is that you are going to need an OMDB API key, which you can set up here. 1:01 I have mine already here, but you can delete this and put in your own. You just go to omdbapi.com. It's free, just it'll be emailed to you. Spreadsheet Automation 101 Lesson 4: OmdbAPI Parameter Picker Learn to Code in Google Sheets, For Programmers | For Advanced Google Sheet Users Movie Marathon Planner

1:10 You click the link in the email to activate it. grab your API key and put it right here in C3. 1:15 So that's all you need to do. It's free, but it's free for 1,000. And what happens is you load up your movies and Google Sheets is going to reload these sort of functions all the time. 1:29 And you might run out of your like 1,000 credits or something, because it reloads it over some like 20 minutes or so. 1:37 So, what I did is I made a movies one where you just list your movies. Once you see which ones you want to do, because this will be really quick to see the poster, read the plot. Scrape Google Maps Learn to Code in Google Sheets, For Programmers | For Advanced Google Sheet Users Learn to Code in Google Sheets, For Programmers Movie Marathon Planner

1:48 If you're like, oh, this is the right one, or not the right one, or whatever. I think it's really cool and really fun. 1:53 But here, this movies one, you just list your movies. Like, I have here, I've listed every single day of the month. 1:59 Oh, wait, I have to do. One more, I think, here. One second. Actually, I have a separate list here. Let me just copy and paste it into here. 2:11 There we go. And what I want to do is have the whole list. Every day has a different movie. Start time, 5 p.m. 2:19 But the reason we have the run time and the end time is so that you may want to adjust. Better Sheets Videos Checklist Movie Marathon Planner

The start time based on how long the movies are, in case you want to get the kids to bed or whatever. 2:29 This is sort of all kids' movies that I did here. But then you go up to movie schedule and you go fetch movie data . 2:35 Just one click, fetch movie data . You'll have to authorize it the first time you run it, but what it's going to do is it's going to go through every single one, run the API, get the poster, get the end time, and it will get the. 2:49 There it goes. Now it will run the end time. Movie Marathon Planner

And also, what you can do is go up to Movie Schedule and Add Movies to Your Calendar, and it'll take all of these movies, put them on the calendar on the day, on the time. 3:02 We will see it here. There it is. Everyone is on the time. Let's see all. On the fifth Scooby-Doo, yep. 3:20 And here's all of the script for you. If you want to read the script and see anything inside of it, how it's working, how it's done, just go up to extensions app script . 3:31 All the script is written there for you.

Just about 300 lines of code and a really cool little A movie marathon maker with a little bit of setup, OMDB, some posters, some really cool stuff. 3:44 Feel free to ask for any features, ask for any updates. Once you get it, I should be releasing some updates as people ask for them. Movie Marathon Planner