We’re getting data on movies and getting it into Google Sheets. Let’s create some magic inside Google Sheets!
Explore ↓
Hey there stranger!
Sign up to get access.
Spreadsheet Automation 101 Lesson 4: Access APIs Introduction
About this Tutorial
Video Transcript
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.
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.
Courses
Spreadsheet Automation 101: Introduction to Pre-course Videos
Think Like a Programmer: Develop The Mindset of an Apps Script Coder
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
Add Icons To Your Sheets With a Domain Name
00:04:21
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
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