Summary

In this chapter, we extensively investigated the capabilities provided by the Google Workspace Platform to design and build custom applications using Apps Script and AppSheet. Apps Script has a powerful API and is easy to work with since it is based on well-defined and widely popular JavaScript constructs. Apps Script's tight integration with Workspace services such as Sheets, Docs, and Forms makes it very useful for solving mundane manual tasks. We also touched upon the limitations of Apps Script and the security guardrails that the Workspace platform has put in place. Apps Script is not just limited to integration with Workspace services; it can also be used to build simple standalone web applications that can be hosted on the Google Cloud Platform.

We then moved on to look at AppSheet, which is a low-code platform that Google recently acquired and integrated with this cloud portfolio. AppSheet makes building simple applications even more elegant with its hand-off...