AppsScriptPulse

App pricing, update details, and Editor’s choice now available on Google Workspace Marketplace

 

Image credit: Google

Google Workspace Marketplace is proud to announce the availability for developers to display pricing for their applications published in the Google Workspace Marketplace, and the date their application listing was last updated.

Monetization of Google Workspace Marketplace Add-ons is a topic that has often been raised. This latest update from Google doesn’t directly address in-app purchasing but it does provide a way for listings to be more transparent about pricing. Check the source post for more details on this and other Google Workspace Marketplace updates.

Source: App pricing, update details, and Editor’s choice now available on Google Workspace Marketplace

TU4.6: Life After Apps Script – A chat with Eric Koleda (@erickoleda), Developer Advocate @ Coda Live TUESDAY 19 Oct. at 1200 PDT / 1500 EDT / 2000 GMT+1

In this episode of Totally Unscripted, we will catch up with Eric Koleda who has been a well known fixture to Google Workspace Developers for the better part of a decade. Now that his legendary career as a Google Workspace Developer Relations Engineer has come to a close, we will reminisce with Eric about the impact of Apps Script and how Workspace development has evolved. We will also take a look at the future and get some insights about his new role and the breakthrough technology at Coda, where he’s begun his new life after Apps Script.

This episode will be broadcast live TUESDAY 19 Oct. at 1200 PDT / 1500 EDT / 2000 GMT+1 and you can join the conversation in the YouTube Live chat.

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

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

Announcing the Google Forms API

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

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

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.

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

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

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

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

Bulk convert Google Docs to PDFs 2.0

Bulk convert all the Google Docs within a given folder to PDFs and optionally delete the Docs afterward, version 2.0

The following Google Apps Script tool is designed to bulk convert all Google Docs within a given Google Drive folder into PDFs. You can choose the destination folder for the PDFs to be put into and also whether you want the original Docs to be deleted. This tool does work on Shared drives.

It is an improved version of this Google Doc to PDF tool post.

Improvements / Features

  1. Maximum runtime – in order to prevent the tool from reaching the limits imposed by Google you can adjust the number of minutes the tool can run for. Change this in the ‘GlobalVariables.gs’ file in the Script Editor.
  2. Continue from where it left off – if you have a lot of Google Docs to convert and the above runtime is reached the tool will save its progress and prompt you to run it again, avoiding any file duplication.
  3. HTML popup – as well as the ‘Log’ sheet the tool now displays a direct popup to the user if it encounters a problem.
  4. PDF counter – after successfully running the tool will include the number of PDFs created as part of the success popup to the user.

Source: The Gift of Script: Bulk convert Google Docs to PDFs 2.0

Create Google Classrooms using Google Apps Script

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

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

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

How to Make Your NPM Package Available in Google App Script

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

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

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.

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

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

Multiple Sheets Action. Use Macro Recorder 🔴

Image credit: Max Makhrov

The idea: perform the same action on multiple sheets. The idea is not new, my approach was to use macro each time to see the correct code snippet. It was useful and saved me hours on my current project.

A clever solution from Max Makhrov with some boilerplate script that makes it easy to use a recorded macro across multiple sheets. To make this solution even better I’ve suggested an addition which activates the sheet which makes it easier to reference recorded macro functions. To see in action here is a copy of Max’s Google Sheet with updated code.

Source: Multiple Sheets Action. Use Macro Recorder 🔴

Totally Unscripted: Create your approvals hub by bringing DocuSign into Google Workspace – Live 29 Sept. at 1200 PDT / 1500 EDT / 2000 GMT+1

If you have had to electronically sign a document before you are likely to be one of the 200+ users who have used DocuSign. DocuSign provides a suite of services to support the entire contract lifecycle from eSignature to automation to analysis. Whilst DocuSign has its own full range of services and integrations DocuSign developers and partners build the customized and integrated experiences that account for roughly 60% of all of DocuSign’s transactions. In this episode of Totally Unscripted we are joined by Jeremy Glassenberg Product Leader, APIs at DocuSign. Jermey will provide an overview of DocuSign APIs and opportunities to integrate with Google Workspace. This episode will be broadcast live and you can join the conversation in the YouTube Live chat.

Show Live/Recording link – https://www.youtube.com/watch?v=EtSSzTH6yLc

How to call Google Cloud Run (or Cloud Functions) from Google Apps Scripts

I struggled how to make an authenticated call from Apps Scripts to Cloud Run even though I had owner rights on the GCP project. This post describes how to do it without reinventing the wheel.

Some very useful setup tips for using Cloud Run with Google Apps Scripts including additional references if you are keen to explore more.

Source: How to call Google Cloud Run (or Cloud Functions) from Apps Scripts

Improve Performance of Google Apps Script with Memoization – Digital Inspiration

How to use JavaScript memoization to optimize and improve the performance of your Google Apps Script code. … Memoization is a simple optimization technique that can be used to improve the performance of your Google Apps Script code. The basic idea is that you cache the results of an expensive function call using closures. If the function is called again with the same arguments, the cached result is returned instead of calling and executing the function all over again.

Great tip from Amit Agarwal for improving the performance of data heavy functions. Follow the link to the source post to find out more and a code sample to get started that finds a particular value in a CSV file.

Source: Improve Performance of Google Apps Script with Memoization – Digital Inspiration

How to management deployments to Google App Script from clasp with a Github Action

This repository is an example of how to setup an automatic CI/CD process for Google Apps Script using GitHub Actions.

This solution come via Dimitri S on Twitter and provides a way to setup a continuous development workflow for Google Apps Script using clasp and Github. The basic recipe appears to be is you develop your code locally using your preferred IDE. You then use clasp to push your code to GitHub, which triggers a GitHub Action to deploy your code to script.google.com.

Source: GitHub – ericanastas/deploy-google-app-script-action

Totally Unscripted – Automating your workflows with Document AI – 22 September at 1200 PDT / 1500 EDT / 2000 GMT+1

We are back with another episode of Totally Unscripted this time joined by Anu Srivastava, Senior Developer Programs Engineer, Google Cloud. As part of this show we are looking at Document AI, one of the latest Google services that lets you do magical things with scanned document images:

Document AI uses machine learning on a scalable cloud-based platform to help your organization efficiently scan, analyze, and understand documents. Manually inputting invoices, receipts, and expenses can be time-consuming, but it doesn’t have to be. The Procurement Document AI is a tool that allows you to digitize unstructured content into structured data. This is just one of the many scenarios where Document AI can be used to develop smart workflows. In this episode of Totally Unscripted we are joined by Anu Srivastava, Senior Developer Programs Engineer, Google Cloud, who will show how Document AI can be used to automate a range of workflows. This episode will be broadcast live and you can join the conversation in the YouTube Live chat.

We ‘air’ at 1200 PDT / 1500 EDT / 2000 GMT+1 on Wednesday, with the recording immediately available – https://youtu.be/_KeRNBcz_4w .

[Testing] Concurrent writing to Google Sheets using Google Form and HTML form

When the users try to write to Spreadsheet using a form, the developers have to consider to the concurrent submission from the form. For example, when the multiple users submit the data with the form simultaneously, all data are possibly not to be saved to the Spreadsheet. So it is considered that it is important to know the information about the concurrent writing to Google Spreadsheet using a form. In this report, such situation was investigated.

A very useful analysis to see how many form submissions can be handled in Google Sheets at the same time. The experiment looks at both submissions using Google Forms and as a Web App.

Source: Concurrent Writing to Google Spreadsheet using Form

Using Google Apps Script as a Webhook

Google Apps Script projects can be published as web apps …. This is helpful if you’re building a tool with a simple UI (using HTMLService), but they can also be used as webhooks to do work within a user account.

Google provides the option of service accounts, so why use webhooks?

For my project, it was because I needed to send calendar invites to other people. Service accounts are generally the way to handle those kinds of jobs, but it needed to have full account delegation, which means it can act on behalf of any user in the domain. That wasn’t an option in this case, so a webhook became the next best option.

Brian Bennett highlights the benefits of using ContentService and Web Apps as a way to let you interface other services.

Source: Using Google Apps Script as a Webhook

Totally Unscripted – Wholly Sheets: Tips for building productivity solutions with Google Sheets 15 September at 1200 PDT / 1500 EDT / 2000 GMT+1

The Google Workspace developer community show, Totally Unscripted, is back this Wednesday! We’ll be broadcasting live at the usual time 1200 PDT / 1500 EDT / 2000 GMT+1 with Wednesday’s targeted as our new ‘day’.

For our return we’ll be bringing you an episode on ‘Wholly Sheets: Tips for building productivity solutions with Google Sheets’. Tune in live to ask questions or immediately watch the recording on demand.

Full show description below:

Spreadsheets are the swiss army knife of productivity tools where they are used (and sometimes misused) as databases, workflow engines, project management tools, custom calculators, and oh yeah… spreadsheets. In this episode of Totally Unscripted, we will chat with Jonathan Butler, Software Engineer at Viriya Consulting, and Spencer Farris, a Google Sheets & Apps Script Consultant, about how they are build spreadsheet solutions that range from small problem-solving automations to full blown critical applications.

Guests:

Track Customer Subscriptions with Google Spreadsheet & App Script by sending an Email Automatically

Do you still spend time every day monitoring your sales report, identifying which customer subscription is going to expire soon, and manually draft an email to send out to your customer? Would it be better if this manual task can be automated every day for you? If that’s the case, this article can be a great help for you!

Following on from some recent Google Sheet payment solutions here’s a tutorial that highlights how you can use Sheets and Apps Script as a payment reminder tool. Combine with Stripe or Razorpay and you have a complete subscription management solution.

Source: Track Customer Subscriptions with Google Spreadsheet & App Script by sending an Email Automatically

How to Request Payments with Stripe Checkout and Google Sheets – Digital Inspiration

How to use Google Sheets to generate Stripe payment links and request payments in any currency from customers anywhere in the world!

We’ve previously featured Amit Agarwal’s Razorpay and Google Sheets payment solution. This latest example from Amit highlights how to integrate Stripe payments with Google Sheets. The source post contains the code you’ll need, how to setup and also automation options.

Source: How to Request Payments with Stripe Checkout and Google Sheets – Digital Inspiration

Create personal stock portfolio tracker with Google Sheets and Google Data Studio

Image credit: All Stacks Developer

The idea is to take advantage of what Google Sheets and Google Data Studio offer and pull them together to build a personal stock portfolio tracker.

This post provides an insight into how you can maximise the combination of Google Sheets, Data Studio and Apps Script to create powerful dashboards. The source link provides an overview of the solution and if you are interested in finding out more about how this solution works visit LION stock portfolio tracker guide (from there you can make a copy of the demo and see the code).

Source: Create personal stock portfolio tracker with Google Sheets and Google Data Studio

How to Create Automated Snapshots of your Google Sheet using Google Apps Script

In this video, we’ll show you how to automate snapshots of your Google Sheets and have those logs stored in a separate Google Drive folder so that you can keep your logs nicely organized for future reference. To do this, we’ll be using Google Apps Script to create a script that references the SpreadsheetApp library and the DriveApp library.

There seems to be an increasing number of YouTube channels dedicating content to highlight Google Apps Script solutions. Here’s the latest one we’ve come across from aguycalledjoe at bootstrapping.tools

How to Use Service Accounts and OAuth2 in Google Apps Script

Image: Dmitry Kostyuk

Give your scripts privileges that your users don’t have … In 99% of all cases, authorizations in Google Apps Script are extremely straightforward. When a user executes their script, they run it as themselves with their respective authorization scopes. … However, what if you need to give more rights to your app beyond what your intended users will have? … This is where service accounts come in.

A useful post to find out more about service accounts and how to use them with Google Apps Script. The tutorial put together by Dmitry Kostyuk includes example code for using a service accounts with Firestore, BigQuery and the Admin Directory API.

Source: How to Use Service Accounts and OAuth2 in Google Apps Script

Create Google Calendar events from sending yourself a Gmail on a mobile device using Google Apps Script

This Google Apps Script allows you to create a Google Calendar event by sending yourself an email in Gmail. Unlike Gmail’s current feature to create Google Calendar events, this script allows you to be on a mobile device.

We’ve featured a couple of contributions from Al Chen in the past and this is another great one. For some context Al has also posted Productivity hack for creating a Google Calendar event by sending yourself an email. For the source code and setup follow the link at the end of the post. If you use Product Hunt and find this solution you can upvote here.

Source: GitHub – al-codaio/events-from-gmail: Create Google Calendar events from sending yourself a Gmail on a mobile device using Google Apps Script.

Subscribe to Apps Script Pulse...