I have a lot of experience within the Google domain. I use Apps script to automate almost everything inside the google domain. Within apps script you have directly acces to:
- Sheets
- Docs
- Slides
- Maps
- Calendar
- Gmail
- External API's
Creating a custom function? Miles based on two addresses in your sheet? Import data from an external API?