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.
Study Planner

Study Planner Script using Google Spreadsheets

Xero

Xero API integration with Google Spreadsheets

Trello

Trello API Integration with Google Spreadsheets

LinkedIn

LinkedIn API integration with Google Spreadsheets

Ocean Insights API Integration with Google Spreadsheets

Workflow automation using SolveCRM, Google Apps and Xero