Web Development
Data Science
Python
SQL
JavaScript
Artificial Intelligence
IT & Software
IT Certifications
Hacking
AWS
Arduino
DevOps
3D Modeling
Graphic Design
Photoshop
Drawing
Digital Painting
UX Design
Business
Data Analysis
Communication Skills
Project Management
Leadership & Management
Human Resources
Digital Marketing
Social Media Marketing
Marketing
SEO
Google Analytics
Branding
Excel
Office Productivity
SAP
PowerPoint
Microsoft Access
SharePoint
Finance & Accounting
Trading & Investing
Accounting
Bitcoin
Personal Finance
Video Editing & Animation
Photography
Adobe Premier Pro
Adobe Lightroom
Personal Development
Productivity
Career Development
Life Coaching
Health & Fitness
Meditation & Mindfulness
Yoga
Music
Music Production
Guitar
Piano
Singing
Language Learning
Teaching & Academics
Engineering
Math
LifestyleLearn Google Apps Script and Become a Google Sheets Master (Udemy.com)
Use Google Apps Script to automate repetitive tasks, create custom functions, import data & connect to external tools
Created by: Ruben Portz
Last updated January 2021
What you will 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
How it compares
Against the other 418 rated Udemy courses in Digital Marketing on CourseDuck:
- Rating4.2 out of 5higher than 16% of them
- Reviews225#268 of 419 by number of reviews
- Length1 hourshorter than 93% of them
- Last updatedJanuary 2021earlier than 75% of them
Course 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.
Udemy Discount
The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.
Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.
Instructor Details
- 4.2 Rating
225 Reviews
Ruben Portz
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.
More courses by Ruben Portz
Google Sheets Functions for Growth Marketing & Product Teams (2021)
4.6 (240 Reviews)
Provider: Udemy
Time: 1.1h
$19.99
More Digital Marketing courses
Licensed Digital Marketing Master™ with IIDM certification (2024)
4.9 (633 Reviews)
- Provider: Udemy
- Time: 7.8h
$199.99
Commercial Photography Marketing Masterclass (2023)
4.9 (109 Reviews)
- Provider: Udemy
- Time: 4.4h
$89.99
The "Best" Startup Pitch Deck - How To Raise Venture Capital (2014)
4.8 (1,293 Reviews)
- Provider: Udemy
- Time: 3.6h
$84.99
Affiliate Marketing For Beginners - NO Website Formula (2023)
4.8 (422 Reviews)
- Provider: Udemy
- Time: 10.4h
$79.99
Public Relations: How to Be a Government/PIO Spokesperson (2026)
4.8 (218 Reviews)
- Provider: Udemy
- Time: 2.1h
$59.99
Reviews
By Naveen Karki on 2/23/2025
Wonderful! It has everything one may need to start use of App Script.
By Rodney Forte on 10/27/2024
Great! I needed to find out the basics and I got what I was looking for!
By Bernard Kyeyune on 6/21/2024
Happy with the elaborate examples and handy reference Cheat Sheet
By Antonio on 4/30/2023
Not exactly what was expected, but still lot of interesting and useful stuff.
By Paola Andrea García tangarife on 9/22/2022
very few automation processes
By Mateo Riwilis on 5/15/2022
No explica nada sobre el codigo, directamente se manda a editarlo
By mathias beedie on 2/2/2022
The course was well thought. I understood everything the tutor explained.
By Anjeanette Alva on 11/11/2021
The only thing that is missing is example sheets to run the macros on the lesson. Other than that it's great!
By Alain Truong on 5/8/2021
Great to get a glance of the possibilities using google apps script in google sheet!
By Jennie Jenner on 2/14/2021
Good introductory course and excellent that it was free. Would be interested in more courses by Ruben (paid or free)
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 84 / 100
- Video Duration:
1h - Price: $34.99
- Provider: Udemy
- Updated:
January 2021 - Level:
All Levels - Language:
English - Certificate:
Yes
30-day money-back guarantee on most paid courses
Udemy Coupon Price Tracker
