A Few Possibilities
Examples of automation that have been created
Websites
Pipelines
Automatically build and publish a website after changes to a database or source code.
Smart Backups
Database backups push to another hosting provider for disaster recovery. Slack notification and email sent if issues with the backup.
Compliance Archive
Scroll through a few thousand page website and take screenshots based on compliance requirements.
Check for website issues
Custom built scanner to look for issues like SEO, accessibility, dead links, spelling, and validation errors. Runs on a schedule and before a site launch.
Reporting
Custom Reports
Pull key stats from Google Analytics without having to remember what the custom events are named.
Engineering API Calls
With a click of a button inside Google Sheets, get the latest changes to an external API. No engineer needed.
Google Tag Manager / Pixel implementations
Custom written event tracking pumping into Google Analytics and advertising pixels.
Dashboards in Google Data Studio
Visually show trends in data from multiple different data sources over time. Easily filter and sort results. Automatically receive reports via email.

Internal Systems
Employee Review
Employees fill out a questionnaire in a Google Form. A styled report in Google Docs with the answers and prompts for the employee's manager is generated.
Standup Generator
Survey that asks what the new sprint name should be. Based on the answers, a poll is created. If someone hasn't answered, and they aren't on time off, they get a reminder in Slack.
Vacation Tracker
Managers can approve / deny personal time off with one click after they receive an email. Information is given to the manager for them to make an informed decision. Employee is notified of the results.