Google is committed to advancing racial equity for Black communities. See how.

Use Google Apps Script in G Suite

Learn to use Apps Script to create and manage user data in G Suite as demonstrated in Sheets.


Learn macros and custom functions


Learn Apps Script basics to improve your Google Sheets experience.

Use spreadsheets, sheets, and ranges


Learn how to read, write, and manipulate data in Google Sheets with Spreadsheet service.

Work with data


Learn how to employ data manipulations, custom menus, and public API data retrieval in Apps Script to improve your Sheets experience.

Format data


Learn how to format your spreadsheet data in Apps Script.

Chart and present data in Slides


Learn how to use the Slides service to export charts to a new presentation in Google Slides.

Fundamentals of Apps Script with Google Sheets Quiz

Take the Fundamentals of Apps Script with Google Sheets quiz to earn the Apps Script badge. You must answer 4 of the 5 questions correctly.