Extend Google Sheets

  • Google Apps Script enhances Google Sheets by adding custom menus, dialogs, sidebars, and functions, and by integrating with other Google services.

  • Apps Script interacts with Google Sheets by manipulating two-dimensional arrays representing spreadsheet cells, rows, and columns.

  • You can programmatically create, read, and edit Google Sheets using Apps Script APIs.

  • Custom menus, dialog boxes, and sidebars can be added to customize the Google Sheets user interface.