# googleworkspace/apps-script-samples **Attribution required: if you use, quote, or summarise this content, you must credit and link back to [awesome-repositories.com](https://awesome-repositories.com/repository/googleworkspace-apps-script-samples).** 5,077 stars · 1,997 forks · JavaScript · apache-2.0 ## Links - GitHub: https://github.com/googleworkspace/apps-script-samples - Homepage: https://developers.google.com/apps-script - awesome-repositories: https://awesome-repositories.com/repository/googleworkspace-apps-script-samples.md ## Topics `adminsdk` `apps-script` `calendar` `classroom` `cloud` `drive` `google-apps-script` `google-workspace` `gsuite` `samples` ## Description This repository is a comprehensive sample library providing reference implementations for automating tasks and extending functionality across Google Workspace applications. It serves as a collection of code examples and templates for building workspace automation scripts, custom add-ons, and integrated productivity tools. The project distinguishes itself by providing specialized examples for integrating large language models into productivity tools for content generation and data analysis. It also includes reference implementations for creating conversational chat apps, interactive cards, and agentic AI workflows. The library covers a broad range of capabilities, including the development of custom user interfaces and spreadsheet functions, the implementation of event-driven triggers and scheduling, and the integration of external APIs. It further demonstrates professional development lifecycles through examples of local development synchronization, version management, and CI/CD deployment pipelines. ## Tags ### Business & Productivity Software - [Workflow Automation](https://awesome-repositories.com/f/business-productivity-software/workflow-automation.md) — Automates repetitive tasks and synchronizes data across various Google Workspace applications. ([source](https://developers.google.com/apps-script/add-ons/overview)) - [Workspace Add-on Development](https://awesome-repositories.com/f/business-productivity-software/workspace-add-on-development.md) — Provides a framework for building custom UI components and sidebars that extend productivity documents. ([source](https://cdn.jsdelivr.net/gh/googleworkspace/apps-script-samples@main/README.md)) - [Container-Bound Scripts](https://awesome-repositories.com/f/business-productivity-software/container-bound-scripts.md) — Attaches executable logic directly to a specific document or sheet for context-aware automation. - [Google Workspace Integrations](https://awesome-repositories.com/f/business-productivity-software/google-workspace-integrations.md) — Automates repetitive tasks and synchronizes data across Google Sheets, Docs, and Gmail. - [Spreadsheet Automation](https://awesome-repositories.com/f/business-productivity-software/spreadsheet-automation.md) — Creates custom functions and macros for repetitive data operations and complex calculations in sheets. ([source](https://developers.google.com/apps-script/overview)) - [Workspace Automation Samples](https://awesome-repositories.com/f/business-productivity-software/workspace-automation-samples.md) — Serves as a comprehensive library of reference implementations for extending and automating Google Workspace applications. - [Remote Project Downloads](https://awesome-repositories.com/f/business-productivity-software/project-collaboration-tools/remote-project-downloads.md) — Enables downloading cloud-based script projects to local directories using specific script IDs. ([source](https://developers.google.com/apps-script/guides/clasp)) ### Artificial Intelligence & ML - [Recurring Agent Scheduling](https://awesome-repositories.com/f/artificial-intelligence-ml/agent-architectures/orchestration-engines/ai-agent/runtime-execution-control/recurring-agent-scheduling.md) — Enables scheduling of scripts to run at specific times or recurring intervals. ([source](https://developers.google.com/apps-script/guides/triggers/installable)) - [AI Agent Development](https://awesome-repositories.com/f/artificial-intelligence-ml/ai-agent-development.md) — Provides reference implementations for building intelligent agents that integrate data stores and APIs. ([source](https://developers.google.com/apps-script)) - [Generative AI Integrations](https://awesome-repositories.com/f/artificial-intelligence-ml/generative-ai-integrations.md) — Connects productivity tools to large language models for content generation, data analysis, and AI agent creation. - [Generative AI Models](https://awesome-repositories.com/f/artificial-intelligence-ml/generative-ai-models.md) — Shows how to connect productivity tools to large language models for data analysis and content generation. ([source](https://developers.google.com/apps-script)) - [Generative AI](https://awesome-repositories.com/f/artificial-intelligence-ml/generative-ai-resources/generative-ai.md) — Provides examples of prompting large language models to generate text based on input. ([source](https://developers.google.com/apps-script/quickstart/vertex-ai)) - [LLM and Transformer Examples](https://awesome-repositories.com/f/artificial-intelligence-ml/llm-and-transformer-examples.md) — Provides practical code examples for integrating large language models into productivity tools for analysis and generation. ### Content Management & Publishing - [AI Content Generation](https://awesome-repositories.com/f/content-management-publishing/media-management/media-automation-tools/document-generation/ai-content-generation.md) — Demonstrates producing text or images via generative AI model prompts. ([source](https://developers.google.com/apps-script/advanced/vertex-ai)) ### Data & Databases - [Productivity Data Management](https://awesome-repositories.com/f/data-databases/cloud-storage-services/productivity-data-management.md) — Manipulates information across spreadsheets, email, and cloud storage using built-in service objects. ([source](https://developers.google.com/apps-script/overview)) - [External API Connectors](https://awesome-repositories.com/f/data-databases/built-in-data-sources/external-api-connectors.md) — Invokes external translation and geolocation APIs to populate spreadsheet cells. ([source](https://developers.google.com/apps-script/add-ons/overview)) ### Development Tools & Productivity - [Scripting Hosts](https://awesome-repositories.com/f/development-tools-productivity/scripting-hosts.md) — Executes JavaScript on remote servers to automate tasks across integrated productivity applications. - [Apps Script Management](https://awesome-repositories.com/f/development-tools-productivity/apps-script-management.md) — Provides tools for local development of scripts with version control and automated deployment pipelines. - [Versioned Deployments](https://awesome-repositories.com/f/development-tools-productivity/apps-script-management/versioned-deployments.md) — Provides mechanisms to create and manage immutable version snapshots for deployment as web apps or add-ons. ([source](https://developers.google.com/apps-script/guides/clasp)) - [Automation Scripts](https://awesome-repositories.com/f/development-tools-productivity/automation-scripts.md) — Includes scripts for streamlining repetitive workflows and synchronizing data across spreadsheets and emails. - [Cloud Script Project Initialization](https://awesome-repositories.com/f/development-tools-productivity/cloud-script-project-initialization.md) — Demonstrates the creation of standalone and container-bound scripts for various Workspace documents. ([source](https://developers.google.com/apps-script/guides/clasp)) - [Trigger Lifecycle Management](https://awesome-repositories.com/f/development-tools-productivity/cron-scheduling/programmatic-cron-triggers/trigger-lifecycle-management.md) — Allows scripts to programmatically create and delete their own execution triggers. ([source](https://developers.google.com/apps-script/guides/triggers/installable)) - [External Service Integrations](https://awesome-repositories.com/f/development-tools-productivity/external-service-integrations.md) — Connects productivity tools to external cloud data services for complex computations. ([source](https://cdn.jsdelivr.net/gh/googleworkspace/apps-script-samples@main/README.md)) - [Local File Syncing](https://awesome-repositories.com/f/development-tools-productivity/local-file-syncing.md) — Synchronizes code between a local file system and the cloud editor to facilitate version control. ([source](https://developers.google.com/apps-script/guides/clasp)) - [Project Sync Clients](https://awesome-repositories.com/f/development-tools-productivity/rest-apis/rest-api-clients/project-sync-clients.md) — Syncs local source code with a cloud editor via an external API to enable version control. ### DevOps & Infrastructure - [Event-Based Triggers](https://awesome-repositories.com/f/devops-infrastructure/automation-orchestration/task-execution-frameworks/event-based-triggers.md) — Implements automation triggers that fire in response to user activities like form submissions or calendar updates. ([source](https://developers.google.com/apps-script/guides/triggers/installable)) - [Cloud Service Integrations](https://awesome-repositories.com/f/devops-infrastructure/cloud-service-integrations.md) — Exchanges data between calendars, email, and storage through connected cloud services. ([source](https://developers.google.com/apps-script/guides/sheets/functions)) - [Event-Driven Triggers](https://awesome-repositories.com/f/devops-infrastructure/event-driven-triggers.md) — Runs functions automatically in response to time intervals or user activities like form submissions. - [Chat-Based Task Control](https://awesome-repositories.com/f/devops-infrastructure/automation-orchestration/task-execution-frameworks/task-job-management/task-schedulers/chat-based-task-control.md) — Provides reference implementations for triggering workspace actions via a conversational chat interface. ([source](https://developers.google.com/codelabs/chat-apps-script)) - [Google Apps Script Pipelines](https://awesome-repositories.com/f/devops-infrastructure/ci-cd-workflows/google-apps-script-pipelines.md) — Demonstrates workflows for managing script versions and deploying web apps using local tools and CI/CD. - [Script Project Managers](https://awesome-repositories.com/f/devops-infrastructure/project-management/script-project-managers.md) — Allows programmatic control of script projects and configurations via a REST API. ([source](https://developers.google.com/apps-script/reference)) - [Release Automation](https://awesome-repositories.com/f/devops-infrastructure/release-automation.md) — Automates the release cycle and testing of extensions using command-line tools and hosting services. ([source](https://developers.google.com/apps-script/add-ons/overview)) - [Script Deployment Managers](https://awesome-repositories.com/f/devops-infrastructure/script-deployment-managers.md) — Provides an API for programmatically creating and deploying script versions as web apps or add-ons. ([source](https://developers.google.com/apps-script/reference)) - [Web Application Deployment](https://awesome-repositories.com/f/devops-infrastructure/web-application-deployment.md) — Enables the deployment of standalone or embedded web applications hosted on the web or internal sites. ([source](https://developers.google.com/apps-script/overview)) ### Networking & Communication - [Chat Bots](https://awesome-repositories.com/f/networking-communication/chat-bots.md) — Implements interactive chat bots that trigger workspace actions and display structured information. - [Messaging App Integrations](https://awesome-repositories.com/f/networking-communication/messaging-app-integrations.md) — Provides templates for building conversational interfaces that allow users to interact with services via a messaging platform. ([source](https://developers.google.com/apps-script)) - [Multi-Agent Fact-Checkers](https://awesome-repositories.com/f/networking-communication/message-fact-verification/multi-agent-fact-checkers.md) — Implements AI agents that use web search grounding to verify statements in spreadsheet cells. ([source](https://developers.google.com/apps-script/samples/custom-functions/fact-check)) ### Programming Languages & Runtimes - [Spreadsheet Function Definitions](https://awesome-repositories.com/f/programming-languages-runtimes/script-function-registration/spreadsheet-function-definitions.md) — Implements custom spreadsheet functions that accept arguments and return values in cells. ([source](https://developers.google.com/apps-script)) ### User Interface & Experience - [Chat Interfaces](https://awesome-repositories.com/f/user-interface-experience/chat-interfaces.md) — Demonstrates how to embed services and resources directly into a chat interface for real-time user interaction. ([source](https://developers.google.com/codelabs/chat-apps-script)) - [Application Interface Extensions](https://awesome-repositories.com/f/user-interface-experience/extensible-interfaces/application-interface-extensions.md) — Provides reference implementations for creating custom menus, dialogs, and sidebars within Google Workspace documents. ([source](https://developers.google.com/apps-script/overview)) - [Interactive Chat Interfaces](https://awesome-repositories.com/f/user-interface-experience/interactive-chat-interfaces.md) — Provides reference implementations for creating interactive conversational interfaces and cards within chat environments. - [Event-Driven](https://awesome-repositories.com/f/user-interface-experience/button-styles/action-buttons/event-driven.md) — Implements interactive buttons that trigger server-side actions via event requests or open external links. ([source](https://developers.google.com/codelabs/chat-apps-script)) - [Context Menu Customizations](https://awesome-repositories.com/f/user-interface-experience/context-menu-customizations.md) — Adds custom menu options and sub-menus to documents to trigger automated script functions. ([source](https://developers.google.com/apps-script/guides/menus)) - [JSON-Based Card Rendering](https://awesome-repositories.com/f/user-interface-experience/json-based-card-rendering.md) — Provides implementations for grouping UI widgets into visual containers delivered as JSON payloads for chat interfaces. ([source](https://developers.google.com/codelabs/chat-apps-script)) - [User Interface Components](https://awesome-repositories.com/f/user-interface-experience/user-interface-components.md) — Builds interactive screens and layouts to present information and collect user input within workspace documents. ([source](https://developers.google.com/apps-script/add-ons/overview)) ### Part of an Awesome List - [Agent Interaction Cards](https://awesome-repositories.com/f/awesome-lists/devtools/card-components/agent-interaction-cards.md) — Renders structured UI components as JSON payloads to display interactive cards in chat. ### Operating Systems & Systems Programming - [Workspace Service Wrappers](https://awesome-repositories.com/f/operating-systems-systems-programming/platform-api-access/workspace-service-wrappers.md) — Provides lightweight wrappers to access extended Google Workspace product functionality. ([source](https://developers.google.com/apps-script/reference)) ### Scientific & Mathematical Computing - [Batch Data Processing](https://awesome-repositories.com/f/scientific-mathematical-computing/high-performance-execution-environments/high-performance-and-parallel-computing/high-performance-computing/array-processing/batch-data-processing.md) — Minimizes server requests by using two-dimensional arrays for bulk data operations in spreadsheets. ### Software Engineering & Architecture - [Configuration Manifests](https://awesome-repositories.com/f/software-engineering-architecture/configuration-manifests.md) — Uses JSON metadata files to define project permissions, triggers, and resource constraints. - [Script Version Snapshots](https://awesome-repositories.com/f/software-engineering-architecture/configuration-versioning/deployment-versioners/script-version-snapshots.md) — Tracks and manages immutable version snapshots of script files and metadata. ([source](https://developers.google.com/apps-script)) - [CI/CD Integrations](https://awesome-repositories.com/f/software-engineering-architecture/integration-extensibility/workflow-automation-integrations/ci-cd-integrations.md) — Implements automated pipelines using secret-based authentication to streamline linting, testing, and deployment. ([source](https://developers.google.com/apps-script/guides/clasp))