Automate & Prolong with Apps Script (Google Cloud for Scholar Builders)


Posted by Wesley Chun (@wescpy), Developer Advocate, Google Cloud

Within the earlier episode of our new Google Cloud for Scholar Builders video sequence, we launched G Suite REST APIs, exhibiting learn how to improve your functions by integrating with Gmail, Drive, Calendar, Docs, Sheets, and Slides. Nonetheless, not all builders want the lower-level model of programming requiring the usage of HTTP, OAuth2, and processing the request-response cycle of API utilization. Constructing apps that entry Google applied sciences is open to everybody at any degree, not simply superior software program engineers.

Enhancing profession readiness of non-engineering majors helps make our companies extra inclusive and helps democratize API performance to a broader viewers. For the budding knowledge scientist, enterprise analyst, DevOps employees, or different technical professionals who do not code day by day as a part of their career, Google Apps Script was made only for you. Quite than fascinated by growth stacks, HTTP, or authorization, you entry Google APIs with objects.

This video blends a normal “Hiya World” instance with numerous use circumstances the place Apps Script shines, together with circumstances of automation, add-ons that reach the performance of G Suite editors like Docs, Sheets, and Slides, accessing different Google or on-line companies, and customized features for Google Sheets—the power so as to add new spreadsheet features.

One featured instance demonstrates the facility to succeed in a number of Google applied sciences in an expressive method: a number of work, not a lot code. What might shock readers is that this whole app, written by a colleague years in the past, is comprised of simply four traces of code:

perform sendMap()

Apps Script shields its customers from the complexities of authorization and “API service endpoints.” Builders solely want an object to interface with a service; on this case, SpreadsheetApp to entry Google Sheets, and equally, Maps for Google Maps plus GmailApp for Gmail. Viewers can construct this pattern line-by-line with its corresponding codelab (a self-paced, hands-on tutorial). This instance helps scholar () builders…

Construct one thing helpful that may be prolonged into far more

Discover ways to accomplish a number of duties with out a whole lot of code

Think about what else is feasible with G Suite developer instruments

For additional exploration, take a look at this video in addition to this one which introduces Apps Script and presents the identical code pattern with extra particulars. (Be aware the second video emails the map’s hyperlink, however the app has been up to date to connect it as a substitute; the code has been up to date in every single place else.) You might also entry the code at its open supply repository. If that is not sufficient, study different methods you need to use Apps Script from its video library. Lastly, keep tuned for the subsequent pair of episodes which is able to cowl full pattern apps, one with G Suite REST APIs, and one other with Apps Script.

We look ahead to seeing what you construct with Google Cloud.