Learn ↓
This tutorial is available for all users. Start with a 7 Day Free Trial today and get access.
Hey there stranger!
Let's not be strangers any more. Start a FREE TRIAL today to view this tutorial, right now.
Spreadsheet Automation 101 Lesson 4: Access APIs Introduction
About this Tutorial
Video Transcript
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
Spreadsheet Automation 101: Functions
Think Like a Programmer: Develop The Mindset of an Apps Script Coder
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
Spreadsheet Automation 101 Lesson 3: Email Yourself Introduction
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