This repository contains examples of using various Google Apps Script libraries. Each folder includes scripts demonstrating the usage of specific libraries, complete with explanations and best practices.
🔧 Library | 📝 Description | 🔗 Examples |
---|---|---|
📂 DriveApp | Access and manage Google Drive. | 🌐 View Examples |
📊 SpreadsheetApp | Manage and interact with Google Sheets. | 🌐 View Examples |
📅 CalendarApp | Interact with Google Calendar. | 🌐 View Examples |
✉️ GmailApp | Read and send emails with Gmail. | 🌐 View Examples |
🌐 UrlFetchApp | Fetch data from external APIs. | 🌐 View Examples |
🛠️ Utilities | Useful helper methods for data manipulation. | 🌐 View Examples |
📋 FormApp | Manage and automate Google Forms. | 🌐 View Examples |
⏰ ScriptApp | Manage triggers, OAuth tokens, and project settings. | 🌐 View Examples |
📄 DocumentApp | Create and edit Google Docs programmatically. | 🌐 View Examples |
🎨 HtmlService | Build custom user interfaces using HTML, CSS, and JS. | 🌐 View Examples |
🪵 Logger | Log information for debugging purposes. | 🌐 View Examples |
🗄️ PropertiesService | Store and retrieve script settings and user data. | 🌐 View Examples |
-
Open Google Apps Script:
- Open a Google Workspace app (e.g., Google Sheets, Docs).
- Navigate to Extensions > Apps Script.
-
Copy the Code:
- Browse the examples in the desired library folder.
- Copy the code into the Apps Script editor.
-
Test and Execute:
Customize and run the code in your Google Workspace environment.
Contributions are welcome! Whether it's fixing bugs, adding new examples, or improving documentation, feel free to submit a pull request. Please ensure all additions are well-documented and tested.