Apps Script 脚本库
可直接复制部署的Google Apps Script脚本,自动化您的Google Workspace任务。每个脚本均有注释并在GitHub上提供。
Google Workspace Monitoring
UtilsThis script monitors the official RSS feed of the “Google Workspace Status Dashboard.” When a new incident or update is detected, the script automatically sends a formatted email alert to the administrator.
使用场景
This script allows an IT manager to receive automatic, formatted alerts as soon as an incident occurs on Google Workspace services. By converting times to local time and filtering out duplicates, it provides immediate responsiveness to inform users before they overwhelm technical support.
Google Drive Security Audit (GAS)
UtilsAutomated script to detect publicly shared files on My Drive and Shared Drives, delivering a detailed security report via email.
使用场景
Regularly audit organization storage to ensure sensitive documents haven't been exposed through "anyone with the link" sharing settings.
Advanced DNS Checker for Google Sheets
SheetsA Google Apps Script tool for bulk auditing DNS records (MX, SPF, DMARC, A) within Google Sheets using the Google DNS API.
使用场景
IT administrators can monitor technical health and email security settings across multiple domains to ensure consistent deliverability.
Duplicate a folder tree (Google Drive Add-on)
UtilsThis add-on for Google Drive allows you to copy entire folder structures recursively.
使用场景
Google Drive does not natively allow you to duplicate a folder with its contents. This tool is essential for users who need to clone project folder templates, reorganize large archives, or reproduce annual organizational structures without having to manually recreate each subdirectory.
Google Slides file translation module based on Google Apps Script.
UtilsGoogle Slides file translation module based on Google Apps Script.
使用场景
A sales team based in France has prepared a 40-slide presentation for a new product. At 5 p.m., they learn that a crucial meeting with a potential investor in Brazil has been moved up to the next morning. The presentation must be available in Portuguese.
没有与您搜索匹配的脚本。
如何使用脚本?
几次点击即可复制并部署到您的Google Workspace。
复制代码
点击"查看代码"在GitHub上打开文件并复制其内容。
粘贴到Apps Script
打开script.google.com,创建新项目,将代码粘贴到编辑器中。
运行
授权所需权限并运行主函数。就这么简单!
所有脚本均为开源并定期更新。
Cet outil vous a fait gagner du temps ? Offrez-moi un café pour soutenir l'hébergement et le développement de nouveaux outils gratuits.