Google Workspace Apps Script Samples

repository·main·Indexed 26 days ago

https://github.com/googleworkspace/apps-script-samples

A collection of sample code and projects demonstrating how to use the Google Apps Script platform to interact with Google Workspace APIs. Includes AI-powered implementations such as AutoSummarize AI, Gemini custom functions for Google Sheets, a FACT_CHECK tool using Vertex AI Agent Engine, an Email Classifier for Gmail, and a Drive document renaming add-on.

Tokens: 14.1K
Snippets: 28
Records: 124
Agent score: 88%

What's inside googleworkspace-apps-script-samples

Overview of the Out of Office (OOO) Assistant Add-on
main
The OOO Assistant is a Google Workspace add-on designed to extend multiple Google Workspace user interfaces. It provides functionality across Chat, Calendar, Gmail, Drive, Docs, Sheets, and Slides.
Technical implementation details:
- Google Chat: Uses app commands.
- Other UIs (Calendar, Gmail, Drive, Docs, Sheets, Slides): Uses homepages and universal actions.
https://github.com/googleworkspace/apps-script-samples/blob/main/solutions/ooo-assistant/README.md
Overview of Developer Docs Link Previews Add-on
main
This Google Workspace Add-on generates custom link previews for pages on the Google developer documentation site. It utilizes AI to generate summaries for the linked pages.
https://github.com/googleworkspace/apps-script-samples/blob/main/ai/devdocs-link-preview/README.md
Overview of the FACT_CHECK Custom Function
main
The FACT_CHECK custom function is a Google Sheets tool that uses a Vertex AI Agent Engine (ADK Agent) to perform fact-checking. It analyzes statements and grounds responses using web information. It leverages the LLM Auditor ADK AI Agent (Python sample) for reasoning and a Gemini model for output formatting.
https://github.com/googleworkspace/apps-script-samples/blob/main/ai/custom-func-ai-agent/README.md
Overview of Email Classifier
main
The Email Classifier is a Google Apps Script Gmail add-on that uses the Gemini API to automatically classify unread emails. It categorizes emails into needs-response, action-required, or for-your-info, applies corresponding Gmail labels, generates draft responses for replies, and logs all activity to a Google Sheet.
https://github.com/googleworkspace/apps-script-samples/blob/main/ai/email-classifier/README.md
Clean up data in a spreadsheet using Clean Sheet
main
Clean Sheet is a Google Sheets editor add-on designed to help users clean up data within a spreadsheet. For detailed implementation information, architectural patterns, and official documentation, refer to the Google Developers guide for Clean Sheet.
https://github.com/googleworkspace/apps-script-samples/blob/main/solutions/editor-add-on/clean-sheet/README.md
Aggregate content from multiple documents
main
This automation allows you to aggregate content from multiple Google Docs into a single document. For implementation details and additional context, refer to the official Google Apps Script samples documentation.
https://github.com/googleworkspace/apps-script-samples/blob/main/solutions/automations/aggregate-document-content/README.md
Copy macros to other spreadsheets
main
This sample demonstrates how to create a Google Workspace Add-on that allows users to copy macros from one spreadsheet to other spreadsheets. For detailed implementation information and official guidance, refer to the Google Developers documentation on sharing macros.
https://github.com/googleworkspace/apps-script-samples/blob/main/solutions/add-on/share-macro/README.md
Use the Translate Google Docs Add-on
main
The Translate add-on enables translation of selected text within a Google Document. It supports translating from a defined set of source languages to a defined set of destination languages.
https://github.com/googleworkspace/apps-script-samples/blob/main/docs/README.md
Explore Google Apps Script Samples by API
main
This repository contains various sample code and projects for the Google Apps Script platform. You can find implementation examples for the following Google APIs:
- AdminSDK: Manage domains and apps.
- Advanced Services: Access Google APIs via Advanced Google services.
- Calendar: List upcoming events or create vacation calendars.
- Classroom: Manage Google Classroom.
- Data Studio: Build connectors and handle authentication/authorization.
- Docs: Cursor inspector and translation add-ons.
- Drive: Manage files/folders and view activity.
- Forms: Notification add-ons.
- Gmail: Sending emails and performing mail merges.
- People: Listing connections.
- Sheets: Managing Form responses, custom menus, and custom functions.
- Slides: Translation and progress bar add-ons.
- Tasks: Listing tasks or building simple tasks web apps.
https://github.com/googleworkspace/apps-script-samples/blob/main/README.md
Use Date Add and Subtract add-on
main
The Date Add and Subtract sample add-on for Google Sheets provides custom functions specifically designed for date manipulation within spreadsheets.
https://github.com/googleworkspace/apps-script-samples/blob/main/sheets/README.md
Use the Cursor Inspector Google Docs Add-on
main
The Cursor Inspector add-on provides real-time inspection of the current cursor position or text selection within a Google Document. The inspection data is displayed in a sidebar and refreshes automatically every few seconds.
https://github.com/googleworkspace/apps-script-samples/blob/main/docs/README.md
Project Overview: Standup Chat App
main
The Standup Chat App is a Google Chat application that uses AI to create summaries of consolidated Chat threads. It then posts these summaries back into the top-level Chat message, streamlining the standup process within Google Chat.
https://github.com/googleworkspace/apps-script-samples/blob/main/ai/standup-chat-app/README.md