Google Apps Script
  • 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)