Google Apps Script is a great way to extend the functionality and potentially automate processes while working in Google Workspace.
Google Apps Script can be thought of as the Google equivalent to Microsoft’s Visual Basic.
For a more practical place to start I highly recommend https://www.labnol.org/ which has a significant archive of Google Apps Scripts to perform various functions in Google Workspace, including:
- Importing csv files into Google sheets
- Sending email from Gmail to slack
- List Google Drive folders and files