- Introduction
- Automating repetitive tasks in Google Sheets using Macros
- Introduction to the Google Apps script editor in Google Sheets
- Introduction to the Spreadsheet service: SpreadsheetApp, Spreadsheet, Sheet, and
- Creating custom formulas in Google Sheets
- Creating a custom menu and menu items in Google Sheets
- Trigger Apps Script via the onOpen() function in Google Sheets
- Trigger Apps Script via call-to-action buttons
- Trigger Apps Script via built-in timers (hourly, daily, etc.)
- Fetching external data with Apps Script
- Making API calls to 3rd party tools with Apps Script (Example: Slack)
What you'll learn
- Create a Slack message bot in Google Sheets
- Write custom formulas in Google Sheets
- Automate repetitive tasks using Macros or scripts
- Make API requests to external sources for data collection
- Send spreadsheet data to 3rd party tools
- Understand the SpreadsheetApp service in Google Sheets
- Change the layout of Google Sheets with sidebars & menus
- Connect multiple 3rd party tools via Apps Script
Description
Google Apps Script for Google Sheets
In this course, I'll show you how to create:
Custom functions
Ways to automate repetitive tasks
Fetch data from external sources
Send data from sheets to external tools like Slack
Trigger scripts automatically while asleep
Change the spreadsheet layout with menus, sidebars and popups
To help you navigate the world of Apps Scripts, I've created a cheat sheet with the most important functions. This should take you through to the end of the course even if you've never worked with JavaScript.
Other Courses
FREE Course Find Winning Shopify Dropshipping Products FAST!
Learn how to find & sell winning Shopify Dropshipping Products from a 7-Figure Entrepreneur!
Six Sigma for Beginners - A brief overview of Six Sigma
Make yourself familiar with Six Sigma
Speak Hindi Through English (Mini Course)
In This Course We Will Learn How To Speak Proper Hindi,Like a Native.
About the instructors
- 4.44 Calificación
- 30937 Estudiantes
- 4 Cursos
Ruben Portz
Founder of TractionPad
I'm the creator of TractionPad. An online platform where I share growth & marketing templates to help startups build repeatable sales systems.
Before that, I worked as the Head of Growth at Seneca Learning which is an online learning platform that I've helped grow to over 6 million users and expand internationally. I've also spent a year in Venture Capital supporting a portfolio of Seed & Series A startups. I'm also a guest lecturer at Imperial College London for the MEng in Design Engineering programme and work as an Entrepreneur in Residence during the yearly London School of Economics startup accelerator.
Student feedback
Course Rating
Reviews
Lo he estado siguiendo y a pesar que los layouts en google ya cambiaron, explica bien y se entiende perfecto. Gracias!
Good course but i would appreciate more explanation