Learn Google Apps Script and Become a Google Sheets Master

Use Google Apps Script to automate repetitive tasks, create custom functions, import data & connect to external tools

Created by: Ruben Portz
Founder of TractionPad

What Will I 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

Requirements

• Good understanding of Google Sheets
• Basic understanding of JavaScript

Target audience

• Google Sheets users interested in becoming more technical