Google Apps Script

Google Apps Script is a rapid, cloud-based development platform for automating, customizing, and extending Google Workspace applications using modern JavaScript.

Google Apps Script provides a server-side JavaScript environment for building business solutions directly within the Google ecosystem. You write code in a browser-based editor; scripts are hosted on Google's servers, eliminating deployment overhead. The platform offers built-in services to directly interact with Google Workspace data: for example, you can write a script to automatically pull data from a Google Sheet, format it into a Google Doc, and email the resulting file via Gmail. It supports creating custom menus, dialogs, and functions within apps, and can connect to external APIs via the UrlFetch service, making it a powerful tool for workflow automation and lightweight application development.

https://developers.google.com/apps-script