Get to know Google Apps Script Quick Info

by

Google Apps Script is a cloud-based scripting language for light-weight application development in the G Suite platform. It provides a way to automate tasks across Google products and third-party services. The main classes in Google Apps Script cover various Google services like Sheets, Docs, Drive, and others, as well as general utility functions. Here’s a list of some of the main classes:

  1. Spreadsheet Service (SpreadsheetApp): Used for accessing and modifying Google Sheets. Classes include Spreadsheet, Sheet, Range, etc.
  2. Document Service (DocumentApp): Used for creating and manipulating Google Docs. Classes include Document, Body, Paragraph, etc.
  3. Drive Service (DriveApp): For interacting with Google Drive. Classes include File, Folder, Drive, etc.
  4. Calendar Service (CalendarApp): Allows interaction with Google Calendar. Classes include Calendar, Event, EventSeries, etc.
  5. Mail Service (GmailApp): For sending emails, creating drafts, and managing labels in Gmail. Classes include GmailMessage, GmailThread, GmailLabel, etc.
  6. User Interface (Ui): For creating user interfaces. This is part of SpreadsheetApp, DocumentApp, and other services.
  7. HTML Service (HtmlService): Used to create and serve HTML content and client-side scripts.
  8. Utilities Service (Utilities): Provides various utility methods for string manipulation, encoding, date formatting, etc.
  9. Properties Service (PropertiesService): To store script data. Classes include ScriptProperties, UserProperties, DocumentProperties, etc.
  10. Data Studio Service (DataStudioApp): For developing Google Data Studio community connectors.
  11. JDBC Service (Jdbc): For connecting to external SQL databases.
  12. Language Service (LanguageApp): For language translation and detecting language.
  13. Maps Service (Maps): For integrating with Google Maps.
  14. Cache Service (CacheService): Provides a cache for temporarily storing data.
  15. UrlFetch Service (UrlFetchApp): To make HTTP requests.
  16. Content Service (ContentService): For creating content like RSS feeds.
  17. Script Service (ScriptApp): For managing triggers and accessing script/project properties.
  18. Lock Service (LockService): Provides methods for preventing concurrent access to sections of code.
  19. Tag Manager Service (TagManagerApp): To access Google Tag Manager accounts and containers.

These classes provide a robust framework for interacting with many of Google’s most popular services and building custom applications or automations within the G Suite ecosystem.