some of the things I do with Google Scripts are:
- Auto-populate form that changes its behavior based on input, that uploads images to the specified folder on Drive.
- Show google sheet data to the website with beautiful design templates and formats.
- Make a portal for employees to update data in Google Sheets in the specified format and different access rights (the website can use that)
- Generating PDF reports and sending them via mail with Google Scripts.
- Display the gallery on the Website with images in the Folder-tree from Google Drive.
- Send report emails based on events on Google Calendar.
etc