Google Workspace is a collection of business tools provided by Google. These include Gmail, Calendar, Spreadsheets, Docs, Forms, Slides, Drive, Sites and many others. We can use Google Apps Script to write custom functionality on top of these applications.
Here are the examples of problems we have solved using Google Apps Script:
- Adding custom business logic.
- API Integration with Google Spreadsheets for third party services (Trello, Ocean Insights, PayPal, Google Drive, Xero Accounting API and many others).
- Workflow automation using Google Apps (Spreadsheets, Sites, Cloud Printer, Drive) & third party apps (CRMs, Accounting solutions).
- Using Google Analytics to develop reports based on Google Spreadsheets data.