How to Learn Apps Script [INTRODUCTION]

Veröffentlicht am: 05 Januar 2026
auf dem Kanal: Eamonn Cottrell

1,528

⭐ 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

Auf dieser Seite können Sie das Online-Video How to Learn Apps Script [INTRODUCTION] mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Eamonn Cottrell 05 Januar 2026 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 1,528 Mal angesehen und es wurde von 51 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

9,532

225