Google Apps Script 總覽
透過集合功能整理內容
你可以依據偏好儲存及分類內容。
Google Apps Script 可讓您快速開發應用程式,輕鬆建立與 Google Workspace 整合的業務應用程式。您可以使用新式 JavaScript 編寫程式碼,並存取 Gmail、日曆、雲端硬碟等常用 Google Workspace 應用程式的內建程式庫。您不需要安裝任何軟體,只要在瀏覽器中使用程式碼編輯器,然後將指令碼儲存到 Google 雲端硬碟,即可在 Google 伺服器上執行。
如果您是 JavaScript 新手,Codecademy 提供多種 JavaScript 課程。(請注意,這些課程並非由 Google 開發,也與 Google 無關)。
Apps Script 可以做什麼?
Apps Script 的用途十分廣泛,你可以執行下列操作:
參加快速入門導覽課程
請嘗試下列任一快速入門導覽,在 5 分鐘內啟動並執行 Apps Script 專案。
除非另有註明,否則本頁面中的內容是採用創用 CC 姓名標示 4.0 授權,程式碼範例則為阿帕契 2.0 授權。詳情請參閱《Google Developers 網站政策》。Java 是 Oracle 和/或其關聯企業的註冊商標。
上次更新時間:2025-08-31 (世界標準時間)。
[null,null,["上次更新時間:2025-08-31 (世界標準時間)。"],[[["\u003cp\u003eGoogle Apps Script is a cloud-based platform for rapidly developing business applications that integrate with Google Workspace.\u003c/p\u003e\n"],["\u003cp\u003eIt uses JavaScript and provides built-in libraries for Google Workspace applications like Gmail, Calendar, and Drive.\u003c/p\u003e\n"],["\u003cp\u003eWith Apps Script, you can customize Google Workspace, automate tasks, interact with other Google services, and create web apps and add-ons.\u003c/p\u003e\n"],["\u003cp\u003eNo installation is needed as Apps Script provides a browser-based code editor and stores your scripts in Google Drive, executing them on Google's servers.\u003c/p\u003e\n"],["\u003cp\u003eExplore quickstarts for automation, custom functions, or building a Chat bot to quickly get started with Apps Script projects.\u003c/p\u003e\n"]]],[],null,["# Google Apps Script overview\n\n|-------------------------------------------------------------------------------------------------------------------------------------------|\n| Got 5 minutes? Help us improve our Google Workspace documentation by taking a quick [online survey](https://forms.gle/XcqRP3PJiQv9ADuj9). |\n\nGoogle Apps Script is a rapid application development platform that makes it\nfast and easy to create business applications that integrate with\nGoogle Workspace. You\nwrite code in modern JavaScript and have access to built-in libraries for\nfavorite Google Workspace applications like Gmail,\nCalendar, Drive, and more. There's\nnothing to install---we give you a code editor right in your browser, and\nyour scripts are saved to Google Drive and run on Google's servers.\n\nIf you're new to JavaScript, Codecademy offers\n[a number of JavaScript courses](https://www.codecademy.com/catalog/language/javascript).\n(Note that these courses weren't developed by and aren't associated with\nGoogle.)\n\nWhat can Apps Script do?\n------------------------\n\nApps Script is versatile. Among other things, you can:\n\n- Add [custom menus](/apps-script/guides/menus), [dialogs, and sidebars](/apps-script/guides/dialogs) to Google Docs, Sheets, and Forms.\n- Write [custom functions](/apps-script/execution_custom_functions) and [macros](/apps-script/guides/sheets/macros) for Google Sheets.\n- Publish [web apps](/apps-script/execution_web_apps) --- either standalone or embedded in Google Sites.\n- Interact with other [Google services](/apps-script/guides/services), including AdSense, Analytics, Calendar, Drive, Gmail, and Maps.\n- Build lightweight [add-ons](/apps-script/add-ons/overview) and publish them to the Google Workspace Marketplace. If you anticipate building large scale add-ons, refer to [Build a Google Workspace add-on using HTTP endpoints](/workspace/add-ons/guides/alternate-runtimes).\n\nTry a quickstart\n----------------\n\nTry one of the following quickstarts to get an Apps Script project up and\nrunning in less than 5 minutes.\n\n- [Automation quickstart](/apps-script/quickstart/automation): Build and run a simple automation that creates a Google Doc and emails you a link to it.\n- [Custom function quickstart](/apps-script/quickstart/custom-functions): Create a custom function that calculates the sale price of discounted items.\n- [Google Chat bot quickstart](/apps-script/quickstart/chat-bot): Create a simple Chat bot that can be directly messaged and responds by echoing your messages.\n\n|---|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|\n| | Want to see Apps Script in action? The Google Workspace Developers channel offers videos about tips, tricks, and the latest features. [Subscribe now](https://www.youtube.com/channel/UCUcg6az6etU_gRtZVAhBXaw) |"]]