How to Learn Apps Script [INTRODUCTION]

⭐ Apps Script full course: https://www.gotsheet.xyz/apps-script-... AI has made writing Apps Script a lot easier, but it'll pay off if you know what's going on before copying and pasting a bunch of stuff into your code editor. The first roadblock you hit will stop you in your tracks. This is the introduction to a project-based Apps Script course I'm developing. If you're new to Apps Script or rusty with it, this is a great tutorial where I walk through the basics of how it works and how to use it. We go through simple examples by building macros first. Then we take a look at how those are executed and where the code is stored. Finally, we'll write our own simple script in the Apps Script editor and I'll show you around the official documentation. ──────────────────── 💰 Deals & Tools • Convert PDFs and images to Excel - https://lido.app/link/eamonn • Connect Google Sheets or Excel directly to your business systems like CRMs, databases, and APIs - https://coefficient.io/?via=eamonn • 20% off Beehiiv (3 mo.): https://beehiiv.com/partners/got-shee... • My full tech stack: https://gotsheet.xyz/c/business-tech-... • My recommended gear: https://amzn.to/4l47CyW Disclosure: affiliate links may earn me a small commission at no cost to you. ──────────────────── ⌚ Timestamps 00:00:00 - you're in the right place 00:00:57 - lay of the land 00:01:21 - why AI tools aren't enough 00:01:42 - A blank sheet 00:01:55 - How we automate with apps script 00:02:37 - What is a macro 00:02:45 - Extensions menu 00:03:10 - Record a macro 00:04:05 - Running the Macro 00:04:47 - Remove a Macro 00:05:00 - Macro with relative reference 00:05:25 - Keyboard Shortcut 00:06:05 - Macro summary 00:06:15 - Opening Apps Script 00:07:45 - Saving the Apps Script 00:08:12 - Apps Script line by line 00:08:45 - What's a FUNCTION? 00:09:32 - declaring variables 00:10:55 - Dot Notation 00:13:07 - semicolons 00:14:34 - let's make a function 00:16:13 - Running the custom script 00:16:42 - Importing script to macros list 00:17:30 - Apps Script Documentation 00:19:42 - scope of authorization 00:20:19 - The Sheet Class 00:20:47 - The Range class 00:21:27 - how can i help you ──────────────────── 🌐 Site: https://eamonncottrell.com 📇 LinkedIn:   / eamonncottrell   🐦 X/Twitter:   / eamonncottrell