Spreadsheet Automation 101 Lesson 4: Access APIs Introduction

<div>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?<br>0:15 We want to create some magic inside of Google Sheets. And one of the coolest things is a database, right? When did you learn the secrets of Google Sheets? | Sheet Talking Episode 8 Esa Advanced Coding in Google Sheets for Programmers Google Sheet Side Quests

We can create, we can add da, we can add data inside two Google Sheets.<br>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.<br>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.<br>0:40 So for this use case, we are getting data on movies and we're getting it into Google Sheets. Learn to Code in Google Sheets, For Programmers | For Advanced Google Sheet Users Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet Scrape Google Maps in 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.<br>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.<br>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.<br>1:10 You already know about variables already, know about functions already know about a lot of stuff. Getting Started Coding in Apps Script VIBE CODE GOOGLE SHEETS

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.<br>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.<br>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 .<br>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. Anything is Possible in Google Sheets, But Not Everything Automate Google Sheets With Zero Experience Track Anything! In a Google Sheet Automation is not Magic

Just spend a few more minutes with me and we'll be fetching lots of data from all over the web.<br>1:55 Thanks and enjoy.</div> Hacks You Might Not Know