Spreadsheet Automation 101 Lesson 4: Access APIs Introduction

<div>0:00 All right, so far we have been taking data Learn how to manage and manipulate data in your Google Sheets effectively. Opens in new tab inside of our sheets and doing things with it, right? We're able to trigger Discover how to automate actions in your sheets with triggers. Opens in new tab 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?

We can create, we can add da, we can add data Learn how to manage and manipulate data in your Google Sheets effectively. Opens in new tab inside two Google Sheets.<br>0:26 In this section and this lesson, we're going to pull data Learn how to manage and manipulate data in your Google Sheets effectively. Opens in new tab 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 Learn how to manage and manipulate data in your Google Sheets effectively. Opens in new tab 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 Learn how to manage and manipulate data in your Google Sheets effectively. Opens in new tab where Understand how to filter data using the WHERE clause in queries. Opens in new tab we're choosing any title we're using parameters Explore how to use parameters to customize your data queries. Opens in new tab or some kind of data Learn how to manage and manipulate data in your Google Sheets effectively. Opens in new tab 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 Get familiar with the basics of Google Sheets and its functionalities. Opens in new tab apps, so you are very comfortable with that.<br>1:10 You already know about variables already, know about functions Master the use of functions to perform calculations and data analysis. Opens in new tab 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.<br>1:25 Once we do that, we can automate scripts that pull that data Learn how to manage and manipulate data in your Google Sheets effectively. Opens in new tab , we can update them, copy and paste values Learn how to paste values without formatting in your sheets. Opens in new tab from that data Learn how to manage and manipulate data in your Google Sheets effectively. Opens in new tab onto our sheets to sort Find out how to sort your data for better organization and analysis. Opens in new tab of keep logs.<br>1:36 Sometimes we have lots of options and literally this becomes an infinite number Understand number formatting and how to work with numerical data. Opens in new tab of possibilities. So I'm glad you've made it this far into spreadsheet Get familiar with the basics of Google Sheets and its functionalities. Opens in new tab .<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.

Just spend a few more minutes with me and we'll be fetching lots of data Learn how to manage and manipulate data in your Google Sheets effectively. Opens in new tab from all over the web.<br>1:55 Thanks and enjoy.</div>