5 个脚本可用

Apps Script 脚本库

可直接复制部署的Google Apps Script脚本,自动化您的Google Workspace任务。每个脚本均有注释并在GitHub上提供。

Google Workspace Monitoring

Utils

This 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.

utils logging
查看代码

Google Drive Security Audit (GAS)

Utils

Automated 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

Sheets

A 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.

utils dns sheets
查看代码

Duplicate a folder tree (Google Drive Add-on)

Utils

This 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.

Utils

Google 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。

1

复制代码

点击"查看代码"在GitHub上打开文件并复制其内容。

2

粘贴到Apps Script

打开script.google.com,创建新项目,将代码粘贴到编辑器中。

3

运行

授权所需权限并运行主函数。就这么简单!

查看完整GitHub仓库

所有脚本均为开源并定期更新。

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.

Buy me a coffee

You might also like...

Continue your exploration with these custom-built applications.

Linearis

The timeline constructor.

Leasing vs Buying Calculator

Compare the total cost of ownership of a vehicle.

Démonstrateur IA

Découvrez comment automatiser vos tâches administratives chronophages avec l'IA en quelques secondes.