AppsScriptPulse

Author: Martin Hawksey

Member of Google Developers Experts Program for Google Workspace (Google Apps Script) and interested in supporting Google Workspace Devs.
BeginnerFormsSheetsSolutionsV8

Create a book tracker using Apps Script and the Google Books API in 10 minutes

Tags: ,
| | 0 Comments |

I wanted a quick and easy way for my kids to track the books they read, as well as a way for my wife to catalog all the books in the house. I know there are other services out there like Goodreads that can store your book list…but I just wanted to house the data myself, and not have to create accounts for my young kids.

Nice little project that glues together Google Forms and Sheets and the Google Book API with a little but of Google Apps Script. Follow the link for more information and the source code.

Source: Create a book tracker using Apps Script and the Google Books API in 10 minutes

FormsIntermediateOfficial NewsSolutions

Announcing the Google Forms API

Tags: ,
| | 0 Comments |

Google is proud to announce the Google Forms API! The Forms API is currently available in Restricted Beta, with Open Beta expected to follow in Q4. … The new Google Forms API provides programmatic access for managing forms and acting on responses, empowering developers to build powerful integrations on top of Forms.

The Forms API is currently in Restricted Beta. We encourage you to apply here to be an early adopter to get started with the API today! We’ll also send you important updates about Open Beta and improvements to the API. To keep up to date with all the APIs of your favorite Google Apps, please subscribe to the Google Workspace Developer Newsletter.

On Totally Unscripted we were delighted to have Christian Schalk (Developer Advocate, Google) and Hannah Pho (Software Engineer, Google) as well as early Forms API partners Charles Kemp (Strategic Alliances Manager, Zapier) and Charles Wiles (CEO, Zzish), talk about the new Forms API. A recording of the show is on YouTube and show notes will soon be added to the Totally Unscripted website.

Source: Announcing the Google Forms API

Community News

Totally Unscripted: Introducing the new Google Workspace Forms API! – Live 13 Oct. at 1200 PDT / 1500 EDT / 2000 GMT+1

Tags:
| | 0 Comments |

Google Workspace offers developers REST APIs to interact programmatically with nearly every product and feature within the suite. In this episode of Totally Unscripted, we are going to take a first look at a BRAND NEW API for Workspace that is being announced earlier in the day at Google Cloud Next. Curious what that API is? Tune in to the broadcast live where we are joined by guests Christian Schalk (Developer Advocate, Google) and Hannah Pho (Software Engineer, Google) along with early Forms API partners Charles Kemp (Strategic Alliances Manager, Zapier) and Charles Wiles (CEO, Zzish) to find out and you can join the conversation in the YouTube Live chat.

Community News

What is Google’s Dev Library––a new open-source platform for developers

Tags:
| | 0 Comments |
Image credit: Google

Developers worldwide are creating open-source tools and tutorials; however, they have difficulty getting them discovered. The content published often spanned on many different sites—from GitHub to Medium. Therefore Google decided to create a space where the best projects related to Google technologies can be highlighted in one place—introducing the Dev Library, a curated archive of projects and articles built specifically using Google technologies.

For Google Apps Script community contributors here’s an opportunity to submit some of your work to be showcased in Google’s new Dev Library:

Not all the articles or projects submitted by you, get on the site! A team of Google experts look for accuracy and relevancy in each featured piece, so you know when you view the content on the site, it has the stamp of approval from Google.

Source: What is Google’s Dev Library––a new open-source platform for developers

Community News

Next ‘21: Must-see Google Workspace sessions for developers and creators #GoogleCloudNext

Tags: ,
| | 0 Comments |
Image credit: Google

Google Workspace offers a broad set of tools and capabilities that empowers creators and developers of all experience levels to build a wide range of custom productivity solutions. For professional developers looking to integrate their own app experiences into Workspace, the platform enables deep integrations with frameworks like Google Workspace Add-ons and Chat apps, as well as deep access to the full suite of Google Workspace apps via numerous REST APIs. And for citizen developers on the business side or developers looking to build solutions quickly and easily, tools like Apps Script and AppSheet make it simple to customize, extend, and automate workflows directly within Google Workspace.

At Next ‘21 we have 7 sessions you won’t want to miss that cover the breadth of the platform. From no-code and low-code solutions to content for developers looking to publish in the Google Workspace Marketplace and reach the more than 3 billion users in Workspace, Next ‘21 has something for everyone.

Click through to the source to read more about the must-see Google Workspace sessions for developers and creators.

Source: Next ‘21: Must-see Google Workspace sessions for developers and creators

BeginnerClassroomSheetsSolutionsV8

Create Google Classrooms using Google Apps Script

Tags: ,
| | 0 Comments |

Creating a Google Classroom and maintaining it can be a bit hectic for so many students in a school. Say you are the moderator of your school and your task is to create 10 Google Classrooms for different teachers. Manually doing this can be a very hectic process, that’s where Google Apps Script comes in.

Using Google Apps Script, you can automatically create Google Classroom with the data in the Google Sheet, and paste the Class code in the Google Sheet.

Source: Create Google Classrooms using Google Apps Script

GotchasIntermediateSolutionsV8

Executing Function with Minutes timer in Specific Times using Google Apps Script [and tips on creating triggers in V8]

Tags:
| | 0 Comments |

This is a sample script for executing a function with the minutes timer in the specific times using Google Apps Script. For example, when this sample script is used, the following situation can be achieved: Execute a function every 10 minutes only in 09:00 – 12:00 and 15:00 – 18:00 for the weekday.

A clever bit of coding from Kanshi Tanaike for running a Google Apps Script on a defined schedule. The part I found particularly interesting was the solution for programmatically setting triggers in the V8 runtime:

This sample script used Web Apps. Because when v8 runtime is used, when the trigger is set from the function executing by a trigger, the trigger is disabled. This is the recognized bug. But unfortunately, this has still not been resolved. (September 21, 2021) But, when the trigger is installed by Web Apps, no issue occurs. So, please deploy Web Apps.

For the sample code and explanation visit the source link.

Source: Executing Function with Minutes timer in Specific Times using Google Apps Script

IntermediateLibrarySolutionsV8

How to Make Your NPM Package Available in Google App Script

Tags: , ,
| | 0 Comments |
Boboss74, CC BY-SA 4.0, via Wikimedia Commons

I recently came across GAS — Google App Script and immediately the first hurdle I had to overcome to was make my NPM packages available on there. I had to hop through a couple loops to make this happen. I wanted to call out the steps in this blog so it’ll hopefully help someone out there as well.

In Pulse we’ve previously highlighted a couple of approaches for using NPM libraries in Google Apps Script. The linked source post come from, recent guest on Totally Unscripted, Nima Poulad, Senior Software Engineer at DocuSign. Nima highlights a quick and dirty approach of using eval() on hosted NPM libraries, but goes on to show how Browseify can be used to convert NPM libraries, highlighting some considerations for this approach.

Source: How to Make Your NPM Package Available in Google App Script

Community News

Totally Unscripted: Never lost for Words – The art of building Google Workspace Developer Documentation – Live 06 Oct. at 1200 PDT / 1500 EDT / 2000 GMT+1

Tags:
| | 0 Comments |

Imagine trying to be a successful developer without good documentation? Yet as developers, we often don’t admit how lost we would be without it. Truth is, creating and maintaining developer documentation is an art; Developers demand content that is concise, but thorough; simple to find and up to date, while covering every obscure feature ever released. If developing a solution is a journey for developers, it’s technical writers who are the unsung heroes who guide us to success with their thoughtful art. In this episode of Totally Unscripted, Kara Ireland and Nathan Gammie will join us from the Google Workspace Developers documentation team, who will give a glimpse into how their team creates the content that keeps Workspace developers on a journey to success.  This episode will be broadcast live and you can join the conversation in the YouTube Live chat.

This episode is a great opportunity to find out how to develop clear and concise documentation. As well as discovering some of the processes behind the scenes of the Google Workspace Developers documentation you can join the live show YouTube chat to ask questions and become a better technical writer.

Community News

DocuSign Developer Conference – 26-27 October 2021 [online]

Tags:
| | 0 Comments |

DocuSign Developer ConferenceLearn, share and create the future of agreements at DocuSign’s first developer conference.

As part of our next Totally Unscripted episode we’ll be joined by Jeremy Glassenberg (Product, DocuSign) and  Nima Poulad (Senior Software Engineer, DocuSign) to talk about how to Create your approvals hub by bringing DocuSign into Google Workspace (Broadcast live 29 Sept. at 1200 PDT / 1500 EDT / 2000 GMT+1).

If building on the DocuSign platform is something that you want to find out more about, there is a great opportunity to learn more at the DocuSign Developer Conference 26-27 October. The agenda includes a range of sessions where you can learn about integrations, including a session from TU regular Christian Schalk, on Building a DocuSign Apps Script Library. Follow the source link for more details and how to register for free!

Source: DocuSign Developer Conference