Google App scripts:

Is a programming interface in the Google Suite platform.
Can replaced Microsoft excel Macros / VBA development
Runs on Google Cloud and allows users to automate tasks across Google Suite products, Google APIs and external APIs.
Interacts with other G Suite products: G Suite products like Gmail, Sites, Spreadsheets, Slides, Calendar can be integrated into one comprehensive system.
Is an alternative connector to other services like AdSense, Analytics, Maps, Google Analytics 360...
Is a Scheduling of tasks: Since Google Apps Script is in the cloud, user can set it up to run periodically without human interface.

Governance Rules

Key Features

Important

Building a script is not a magic solution. It will requires time build & maintain.
Data has to comply with EAR or ITAR regulations
No support will be provided for Google Apps Script.

Useful Links