Get more things than just the poster and movie title by changing our script a bit. By creating different functions, we can get other data such as movie posters or directors.
Academy ↓
Hey there stranger!
Sign up to get access.
Spreadsheet Automation 101 Lesson 4: OmdbAPI Parameter Picker
About this Tutorial
Video Transcript
0:00 <affirmative>, can you feel that magic coming from our fingers? That absolute fire. We're, we're, we're spitting air. We're able to pick data from online, bring it inside of Google Sheets and we're able to programmatically like get it right based on this Titanic, right?
0:16 We can use Hackers is a cool title here. We can even do not just one word titles, but like jingle all the way here.
0:24 We get a poster of Jingle All the Way or Jingle all the way to we can guess movie titles and get the poster.
0:31 Wow, <laugh>. What's really fun too is we can get more things than just the poster, just the movie title, right?
0:38 We saw all of those options. If we do a little bit change to our script, now the first thing you might think about doing is creating different functions like get movie poster or get you know, director and then we just have to type in director for this poster director.
1:00 Okay? So let's just go grab the director and we can do this, right? We can get director a one and now we get the director.
1:10 Okay? Boom, we got the director. We got what Terminator as well. I think that's a James Cameron movie. No, Hernandez, I think it's, oh wait, the Terminator maybe is the real title.
1:23 The Terminator. There we go James Cameron. So that we are, we are able to do that if we create copy and paste the entire function.
1:33 But what if we could do that without copy and pasting the entire function and just call one thing. We are only changing this director or this poster, right?
1:42 So let's delete all of this and use the power of functions to change it. So we we're gonna do title per and we're gonna do get movie data and we're gonna pass this per parameter.
1:59 It's a shirt for short, for parameter as the variable for the values. So we're gonna save this use, get movie data and we're gonna get an error here cause there's no more get poster, but we don't need get poster anymore.
2:14 We're gonna get movie data, a one comma poster. Now we should be able to get the poster there. There we go.
2:24 And the director, instead of get director equals get movie data a one and in quotes we can do director. So this is pretty cool.
2:37 Now we have one function that we can call any number of times as long as we know what the parameters are of the J js o response, right?
2:45 We can ga gather any piece of data. Now that is pretty darn awesome. I really enjoy this. I hope you enjoy this too.
2:55 We are at the end of spreadsheet automation 1 0 1, but I have some more bonus lessons for you. I have some more information for you coming up soon.
3:06 Really, really cool. And thank you for joining me through this entire journey. I hope you learned how to code. I hope if you know how to code, you learned a little bit more about spreadsheets and spreadsheet automation.
3:17 We've put some triggers in all the way. We have time-based triggers. We have on edit, on open. We have all sorts of stuff at our disposal now.
3:27 But stick around. I have a few more bonus lessons for you to do a little bit more, get a little bit more out of your Google Sheets.
3:34 Bye.
0:16 We can use Hackers is a cool title here. We can even do not just one word titles, but like jingle all the way here.
0:24 We get a poster of Jingle All the Way or Jingle all the way to we can guess movie titles and get the poster.
0:31 Wow, <laugh>. What's really fun too is we can get more things than just the poster, just the movie title, right?
0:38 We saw all of those options. If we do a little bit change to our script, now the first thing you might think about doing is creating different functions like get movie poster or get you know, director and then we just have to type in director for this poster director.
1:00 Okay? So let's just go grab the director and we can do this, right? We can get director a one and now we get the director.
1:10 Okay? Boom, we got the director. We got what Terminator as well. I think that's a James Cameron movie. No, Hernandez, I think it's, oh wait, the Terminator maybe is the real title.
1:23 The Terminator. There we go James Cameron. So that we are, we are able to do that if we create copy and paste the entire function.
1:33 But what if we could do that without copy and pasting the entire function and just call one thing. We are only changing this director or this poster, right?
1:42 So let's delete all of this and use the power of functions to change it. So we we're gonna do title per and we're gonna do get movie data and we're gonna pass this per parameter.
1:59 It's a shirt for short, for parameter as the variable for the values. So we're gonna save this use, get movie data and we're gonna get an error here cause there's no more get poster, but we don't need get poster anymore.
2:14 We're gonna get movie data, a one comma poster. Now we should be able to get the poster there. There we go.
2:24 And the director, instead of get director equals get movie data a one and in quotes we can do director. So this is pretty cool.
2:37 Now we have one function that we can call any number of times as long as we know what the parameters are of the J js o response, right?
2:45 We can ga gather any piece of data. Now that is pretty darn awesome. I really enjoy this. I hope you enjoy this too.
2:55 We are at the end of spreadsheet automation 1 0 1, but I have some more bonus lessons for you. I have some more information for you coming up soon.
3:06 Really, really cool. And thank you for joining me through this entire journey. I hope you learned how to code. I hope if you know how to code, you learned a little bit more about spreadsheets and spreadsheet automation.
3:17 We've put some triggers in all the way. We have time-based triggers. We have on edit, on open. We have all sorts of stuff at our disposal now.
3:27 But stick around. I have a few more bonus lessons for you to do a little bit more, get a little bit more out of your Google Sheets.
3:34 Bye.
Courses
Add Icons To Your Sheets With a Domain Name
00:04:21
Add Tasks to Google Tasks From Google Sheets
Convert Google Sheets into a REST API
Build a Book Recommender with AI in Google Sheets
Build a License Key Generator and API in 20 Minutes
Create Your Own API by Deploying a Web App
Access Free API's with Google Sheets
Use Random Quote API in Google Sheets
OpenSea Data Inside Sheets
Tag Emails From A List of Members in Google Sheets
Spreadsheet Automation 101 Lesson 4: Access APIs Introduction
How to Validate Email Addresses
Build Your Own Free Domain Availability Checker
Build a Job Status Checker API in 15 Minutes
Spreadsheet Automation 101 Lesson 4: UrlFetchApp
Spreadsheet Automation 101 Lesson 4: OmdbAPI get ApiKey, get Data in URL
Spreadsheet Automation 101 Lesson 4: OmdbAPI Parameter Picker
Spreadsheet Automation 101 Lesson 4: OmdbAPI get data in Apps Script
Spreadsheet Automation 101 Lesson 4: JSON (beautifier) and OmdbAPI parameters
Quickstart Tutorial OpenAI API in Google Sheets
Shaman: AI Blog Writer
ChatGPT Clone in Google Sheets Part 1
ChatGPT Clone in Google Sheets Part 2
How To Set Up Stripe Webhook to Google Sheets with Google Script
00:22:10
Create Instant QR Codes
Access the Dictionary API to get Definitions for Words in Google Sheets
Spreadsheet Automation 101: Introduction to Pre-course Videos
Breaking Through Errors In Apps Script
Think Like a Programmer: Develop The Mindset of an Apps Script Coder
Tips to Navigating Thousands of Lines of Code In Apps Script
Spreadsheet Automation 101: Functions
Spreadsheet Automation 101: Variables
Spreadsheet Automation 101: Dot Notation
Spreadsheet Automation 101: Camel Case
Spreadsheet Automation 101: Parentheses
Spreadsheet Automation 101 Lesson 1: GetValue - Introduction to SpreadsheetApp
Spreadsheet Automation 101 Lesson 1: Spreadsheet Taxonomy
Spreadsheet Automation 101 Lesson 1: A1 Notation vs Row,Column Syntax
Spreadsheet Automation 101 Lesson 1: getActiveSpreadsheet() vs getActiveSheet()
Spreadsheet Automation 101 Lesson 1: onOpen() Trigger - Custom Menu
This Seems Like Automation
Spreadsheet Automation 101 Lesson 2: Get Values - Introduction
Spreadsheet Automation 101 Lesson 2: Arrays
Spreadsheet Automation 101 Lesson 2: For Loop
Spreadsheet Automation 101 Lesson 2: Bracket Notation
Spreadsheet Automation 101 Lesson 2: Logger.log()
Spreadsheet Automation 101 Lesson 2: If ( ){ } and Checkboxes
Spreadsheet Automation 101 Lesson 2: onEdit() Trigger
Introduction to Spreadsheet Automation 101 Lesson 3
Spreadsheet Automation 101 Lesson 3: MailApp
Spreadsheet Automation 101 Lesson 3: Email Yourself For Loop
Spreadsheet Automation 101 Lesson 3: Send Email Every Week Trigger
Spreadsheet Automation 101 Lesson 3: Email Other People For Loop
Spreadsheet Automation 101 Lesson 4: Access APIs Introduction
Spreadsheet Automation 101 Lesson 4: UrlFetchApp
Spreadsheet Automation 101 Lesson 4: OmdbAPI get ApiKey, get Data in URL
Spreadsheet Automation 101 Lesson 4: OmdbAPI get data in Apps Script
Spreadsheet Automation 101 Lesson 4: JSON (beautifier) and OmdbAPI parameters
Spreadsheet Automation 101 Lesson 4: OmdbAPI Parameter Picker
Automatically Clear Content | Refresh Reuse Recycle Templates
Automate Google Sheets With Zero Experience
Automatically Uncheck A Daily Checklist
Activate A Certain Sheet When Opening a Spreadsheet
Scoping Functions in Apps Script