AppsScriptPulse

[Fixed] Google Apps Script Web App HTML form file-input fields not in blob compatible format

Image by Tumisu from Pixabay

HTML form file-input fields are not converted to compatible blob format when submitted. They are left in application/octet-stream format. The file-input fields are passed as application/octet-stream, so DriveApp.createFile(formBlob) does not work correctly … So the functionality provided by HtmlService is not consistent with the documentation

There was an annoying little Google Apps Script issue which meant when handling file uploads to published Web Apps some additional coding was required rather than just sending the file blob server side. Thankfully the open issue ticket for this has recently been marked and confirmed fixed.

Source: HTML form file-input fields not in blob compatible format

2-Way sync between sheets without a unique ID

How to setup 2-way sync within the same workbook without any unique ID.

I’m in the habit of adding IDs to sheets where I need to do lookups, but sometimes, I inherit a sheet without IDs in place (or I can’t edit the sheet structure). Spencer outlines a clever way to handle syncing between two sheets without using IDs in this video.

Source: 2-Way Sync: No Unique ID

Pseudo OnEdit Trigger for Google Document using Google Apps Script

In the current stage, there is not OnEdit trigger for Google Document. But I sometimes have the case that I want to use OnEdit trigger. So, as the current workaround, I created this sample script. I think that this workaround can be also used for Google Slides, Google Form and also Google Spreadsheet. In the case of Spreadsheet, what the existing OnEdit trigger and the time-driven trigger cannot do can be achieved.

Source: Pseudo OnEdit Trigger for Google Document using Google Apps Script

How to Automatically Add Teachable Students to Google Drive Files and Folders when they Enroll in your Course – Yagisanatode

Learn how to instantly share newly enrolled teachable students to Google Drive files and folders with Google Sheets and Apps Script.

Scott ‘Yagi’ Donald provides a very thorough walk-through of how he has connected a webhook from a third party service to Google Sheets to share specific Google Drive folders and files with named users. This post is well worth a visit as it contains a number of tips and tricks like using Google Forms to follow-up with user email addresses that are not associated with a Google account.

Source: How to Automatically Share Teachable Students to Google Drive Files and Folders when they Enroll in your Course – Yagisanatode

Adding Members to a mailing list using an API, Google Forms and Google Apps Script

Image credit: Baba Funke

I decided to explore something similar to a Webhook for Google Forms. In other words, something that triggers another action when a Google form is submitted. In this case, when a Google form is filled and submitted, the results should be sent to an API endpoint for adding members to a database. I found an answer in Google Apps Script, a coding language based on Javascript which allows for programmatically extending Google Apps like Google Forms, Sheets, Docs etc.

A nice explanation of how triggers can be used in Google Forms to push new data to other systems. The post is easy to read and includes lots of screenshots to help prevent you getting lost.

Source: Adding Members to a mailing list using an API, Google Forms and Google Apps Script

How to Fetch Employee Data from Workday by Building the Great Deku Tree Inside of Google Sheets

They say you only live once, and, with that, you may only once find yourself at a company with a video-game-centric culture. Life at Twitch creates a unique opportunity to bring the magic of gaming to your workday, even when you’re in esoteric corners of the work world such as People Analytics.

Ever wondered how people reporting was handled at Twitch? Max Brawer, Head of People Analytics at Twitch, brings his ‘A’ game outlining how a little Google Apps Script and some Workday API wrangling can be used for some fun reporting. You can read more in the source link and here’s Max’s old post on The Endless Possibilities of Freeing Your Data from Workday and Putting it into Google Sheets: a How-to.

Source: How to Fetch Employee Data from Workday by Building the Great Deku Tree Inside of Google Sheets

Totally Unscripted: Building successful Add-ons for Google Workspace – 24 November at 1200 PT / 1500 ET / 2000 GMT

The next episode of Totally Unscripted is scheduled usual time Wednesday 24 November. For the episode we are looking at ‘Building successful Add-ons for Google Workspace’, joined by two top add-on developers, Romain Vialard, Founder of Scriptit & John McGowan, CEO of Unicorn Magic, and Elena Kingbo, Program Manager on the Google Workspace Platform team and involved in the Google Workspace Marketplace:

The Google Workspace Marketplace offers users and administrators alike a wide variety of third party solutions that extend Google Workspace. Creating a successful add-on for the Marketplace takes more than a bit of luck to stand out from the crowd. In this episode we will chat with two purveyors of well-known add-ons Romain Vialard, Founder of Scriptit & John McGowan, CEO of Unicorn Magic, to hear what it takes to create a thriving business in the world of Workspace Add-ons. Also joining us will be Elena Kingbo, Program Manager on the Google Workspace Platform team, who helps guide developers through their Add-on journey.

As always the show is broadcast live and you can ask questions via chat, but also interested to hear in advance any of your burning questions for our panel using the comments section below or tweeting them to @AppsScriptInfo. What are your pain points? If you haven’t published a Workspace Add-on what are the blockers? Or anything else you would like to hear more?

How to get Google Lighthouse reports using PageSpeedInsights API and Google Apps Script

Lighhouse

Image: CC-BY Google

Lighthouse is an open-source, automated tool for improving the quality of web pages. You can run it against any web page, public or requiring authentication. It has audits for performance, accessibility, progressive web apps, SEO and more.

On StackOverflow there is a nice question/answer from Mert Dökümcü on How to send Google Lighthouse reports to Slack using PageSpeedInsights API and Google Apps Script. You can read the full solution there and below is an excerpt from Mert’s post (copied here CC-BY-SA Mert Dökümcü) of the bit that really interested me, getting results from PageSpeedInsights .

First and foremost, get…

Once you have these, go to https://script.google.com/home and create a new script. The following code should do the trick:

var mobileData = fetchDataFromPSI('mobile');
var desktopData = fetchDataFromPSI('desktop');
function pageSpeedApiEndpointUrl(strategy) {
const apiBaseUrl = 'https://www.googleapis.com/pagespeedonline/v5/runPagespeed';
const websiteHomepageUrl = ''; // Your website
const apikey = ''; // Your API key
const apiEndpointUrl = apiBaseUrl + '?url=' + websiteHomepageUrl + '&key=' + apikey + '&strategy=' + strategy;
return apiEndpointUrl;
}
function fetchDataFromPSI(strategy) {
const pageSpeedEndpointUrl = pageSpeedApiEndpointUrl(strategy);
const response = UrlFetchApp.fetch(pageSpeedEndpointUrl);
const json = response.getContentText();
const parsedJson = JSON.parse(json);
const lighthouse = parsedJson['lighthouseResult']
const originLoadingExperience = parsedJson['originLoadingExperience']
const result = {
'overall_performance': originLoadingExperience['overall_category'],
'score': lighthouse['categories']['performance']['score']*100,
'firstContentfulPaint': lighthouse['audits']['first-contentful-paint']['displayValue'],
'speedIndex': lighthouse['audits']['speed-index']['displayValue'],
'timeToInteractive': lighthouse['audits']['interactive']['displayValue'],
'firstMeaningfulPaint': lighthouse['audits']['first-meaningful-paint']['displayValue'],
}
return result; 
}

Checking Google Groups membership recursively using Google Apps Script

Learn how to check indirect membership of users or groups in the context of the Google Groups Service using Apps Script.

This is a great post if you want to learn about how to programmatically navigate the hierarchy of Google Groups, which may also come in handy when you are processing other tree like structures often found in JSON. All the code needed to run this is provided and clearly explained.

Source: Getting Google Groups membership recursively using Apps Script

The Gift of Script: Convert Google Doc to PDF in a given folder

Convert a Google Doc into a PDF in a given folder and optionally delete the original Doc file.

The following Google Apps Script is designed to create a PDF file of a Google Doc in a Drive folder that you specify, with the option to delete the original Doc. This snippet of code is from larger developed solutions and allows you to understand and replicate the process.

This post is somewhat of an updated version of this Convert Doc to PDF and move into a new folder blog post. Whilst the code in it still works it was part of my early days of learning Apps Script and it was also when Google allowed for files to exist in more than one place (a feature now replaced by Shortcuts).

Source: The Gift of Script: Convert Google Doc to PDF in a given folder

Letting users run a Google Apps Script on Google Sheets without authorizing scopes and showing the source code

This is a sample workaround for letting users running Google Apps Script on Google Spreadsheet without both authorizing the scopes and showing the script.

The post highlights the use of the existing =IMPORTML() Google Sheets function and a publish webapp to run a Google Apps Script without the end user having to authorize the script. A limitation of this approach, and also important warning to keep in mind, is the deployed web app needs to be deployed to run as the script owner and by anyone who has the web app link.

Source: Letting Users Running Google Apps Script on Google Spreadsheet without both Authorizing Scopes and Showing Script

Totally Unscripted: What’s new in the world of Chat Apps? – 17 November at 1200 PT / 1500 ET / 2000 GMT

For our next episode of Totally Unscripted we look at Google Chat, specifically Google Chat Apps. As part of this we will be joined by Aidha Shaikh who leads the Chat App strategy at Google. This episode will be broadcast live and you can join the conversation in the YouTube Live chat.

Chat bots (aka Chat Apps) offer developers a framework for building solutions within conversations and direct messages inside of Google Chat. As Google Chat has become a more integral part of Google Workspace, Chat Apps have evolved to offer developers new capabilities which in turn creates opportunities for richer interactions, integrations and workflows. In this episode, we will discuss “What’s new in the world of Chat Apps” with Aidha Shaikh, Product Manager on the Google Workspace Platform team, who leads the Chat App strategy at Google.

How to Write Google Apps Script Code Locally in VS Code and Deploy It With clasp

Google Apps Script Power Up

Why Write GAS Code Locally?

When it came out, the new Google Apps Script IDE was, of course, a big deal. It’s way better than the legacy one. It brought syntax highlighting, keyboard shortcuts, command palette and just a much better UI experience.

In fact the reason it’s so good is that it’s built on top of VS Code Monaco editor. But it’s definitely still far away from what a real VS Code installation can do. You can get all the functionality of the online IDE and much more more: autocomplete, custom themes, installation of modules, linting, snippets, etc.

The bare minimum that you would need is :

  • A VS Code installation (duh!)
  • Node.js + NPM : a JavaScript runtime with a built-in module installer;
  • Autocomplete;
  • clasp: a CLI utility to sync your GAS code

Let’s get into it!

Source: How to Write Google Apps Script Code Locally in VS Code and Deploy It With clasp

How to Delete Blank Rows from Tables in Google Documents – Digital Inspiration

How to remove all blank rows from one or more tables in a Google Docs document with Google Apps Script. You may also delete blank rows from tables in Google Slides.

Source: How to Delete Blank Rows from Tables in your Google Documents – Digital Inspiration

Keep a Journal of Special Moments using Twilio Programmable SMS and Google Sheets

Learn how to build a Google Sheet journal that accepts new entries via text message. My toddler recently turned two and a half and my second daughter was born three weeks ago, so special moments are abundant but the ability to remember them is severely compromised. His suggestion of recording a memory every day in an Excel sheet or leather bound journal resonated with me, but after a few days of trying to find time to open up Excel and write a memory I realized I needed a more lightweight solution. … Twilio makes it easy and cheap to set up a dedicated phone number that can record those text messages to a Google sheet.

Nice example on the Twilio blog on using their service with Google Sheets. There is little setup required but this can all be achieved in 4 lines of code. Unfortunately, sending/receiving SMS messages with Twilio is not free, but it might be a service you keep in mind for Apps Script projects.

Source: Keep a Journal of Special Moments using Twilio Programmable SMS and Google Sheets

Enhanced menus in Google Sheets improves findability of key features (and an important update for Google Workspace Developers)

New Google Sheets menus
New Google Sheets menus

We’re updating the menus in Google Sheets to make it easier to locate the most commonly-used features. Some of your favorite menu items may have moved a little, but all existing functionality is still available. We hope that their new home will be more intuitive and make it easier and faster to navigate the product.

Google Workspace Updates

Google have updated the menus in Google Sheets to help with discoverability. For Google Workspace Developers one of the big changes is the new Extensions menu which replaces ‘Add-ons’ and includes links to Macros, Script Editor and AppSheet. Whilst painful if you need to update support documentation the new structure will hopefully make the location of these tools more intuitive. We covered the Google Sheets menu update in the latest episode of Totally Unscripted:

Source: Enhanced menus in Google Sheets improves findability of key features

Google Workspace Recap E044: Google DevRel team members Charles Maxson and Steve Bazyl talk about the Workspace Developer Ecosystem

We welcome two amazing members from the DevRel (Developer Relations) team this episode.

Charles Maxson is a Developer Advocate at Google where focuses on inspiring developers of all types to build solutions that leverage Google Workspace as a platform.

Steve Bazyl is a Developer Relations Engineer and Advocate at Google and has worked with various Google Workspace APIs and partners for over a decade. Google Workspace Developer Links

Totally Unscripted co-host, Charles Maxson, and regular guest Steve Bazyl recently featured on the Google Workspace Recap podcast talking about recent trends and development within the Google Workspace developer ecosystem.

Bulk create Google Drive Folders and add Files 2.0

Bulk create Google Drive folders with optional files copied into each one. With full control over naming.

Bulk create Google Drive folders with optional files, from a Google Sheet

Bulk create Google Drive folders with optional files, from a Google Sheet

This post is a variation of this Bulk create Google Drive Folders and add Files tool post.

Key Functionality

  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 folders and files to handle and the above runtime is reached the tool will complete the current row/folder and prompt you to run it again, without duplicating any folders or files already created.
  3. Popups – as well as the ‘Log’ sheet the tool displays a direct popup to the user if it encounters a problem.
  4. Full naming control – you have the ability to tweak every single folder and file name that is created by the tool. See the Concatenate section below to understand the true power of this.
  5. Clickable links – created by the tool which means you can navigate directly to the new folders and files directly from the Google Sheet.
  6. Add more files – the tool currently has columns for 10 files to be added to each folder, but you can actually append more as long as you follow the same convention of 2 columns per file (1 file name and 1 file ID). Do this before you run the tool as you cannot add more files to a folder once it has been created.
  7. Add more folders – after running the tool you can either choose to clear all of the data within it (use the ‘Reset sheets’ option from the ‘Admin’ menu) and start again or you can simply append further rows/folders and re-run without any duplication (if the ‘Folder Link’ column is not blank/empty then it will skip that row).

Source: The Gift of Script: Bulk create Google Drive Folders and add Files 2.0

Totally Unscripted: How SADA builds on Google Workspace – 3rd November at 1200 PDT / 1500 EDT / 1900 GMT

Totally Unscripted returns on 03 November at 1200 PDT / 1500 EDT / 1900 GMT (earlier time for those not watching in North America), this time joined by guests Kelly Wright (Director of Google Workspace, SADA) and Kevin Tuuri (Solutions Architect, SADA):

SADA is a Google Cloud Premier Partner that focuses on Google Cloud consulting, migration and deployment, custom development, user adoption, and change management services. As an industry leader in helping organizations implement Google Workspace, SADA has developed a practice area that builds custom solutions as unique as their customers. In this episode of Totally Unscripted, we will hear from Kelly Wright, Director of Google Workspace, and Kevin Tuuri, Solutions Architect, about how they help customers get more out of Google Workspace by customizing they way they use it. This episode will be broadcast live and you can join the conversation in the YouTube Live chat. – https://youtu.be/b_wiI8InwC0

Append List Items, Paragraphs and table cell items with a date-time stamp in Google Docs using Google Apps Script – Yagisanatode

Learn how to append a date-time stamp to list items, paragraphs and more in Google Docs with Google Apps Script

A very slick example from Scott ‘Yagi’ Donald which shows a very simple method for appending text at the current cursor position and all achieved in just over 50 lines of code, with comments. Head over to the source for the full code and explanation.

Source: Append List Items, Paragraphs and table cell items with a date-time stamp in Google Docs using Google Apps Script – Yagisanatode

Mergo: Designing a template gallery in a Google Workspace add-on

Mergo is a mail merge add-on for Gmail. With the new gallery, users can easily create, share & reuse templates.

Instead of starting your email from scratch, you can open the gallery and select a template: it will appear as a draft in Gmail.

We recently had Romain Vialard join us on Totally Unscripted to talk about some of his add-ons. This post is another example of Romain’s continual exploration of Apps Script, this time looking the new Grid view for the CardService. You an find out more in the source link.

Source: Mergo: Designing a template gallery in a Google Workspace add-on

Creating a web app with Google Sheets

A wonderful set of video tutorials showing you how to set up a web app and connecting it to a Google Sheet. It starts off with a simple form and covers areas like getting data from a sheet and sending it back and using Materialize CSS for to easily create a good looking app. Plus, it also looks at connecting a Google Calendar to the app and how to create multiple pages in the web app.

Totally Unscripted: The Pulse of the Google Apps Script Community WEDNESDAY 27 October at 1200 PDT / 1500 EDT / 2000 GMT+1

The AppsScriptPulse website was launched in 2019, providing a curated collection of the latest Google Apps Script contributions from both Google, but focusing on community contributions. The site now has over 600 solutions, snippets, tutorials and resources updated almost daily. In this episode of Totally Unscripted we are joined by Romain Vialard, Phil Bainbridge and Scott ‘Yagi’ Donald who have individually provided the top 3 Pulse contributions for 2021.

We will discuss the solutions they have created which range from offline Apps Script development with VS Code/clasp to document automation to creating games in Google Slides. This episode will be broadcast live and you can join the conversation in the YouTube Live chat.

Celebrating 1,000 posts by Bruce Mcpherson (@brucemcpherson)

Google Apps Script Meetup at Google Cloud Next '18
Google Apps Script Meetup at Google Cloud Next ’18

I’m sure many in the Google Workspace developer community will know the name Bruce Mcpherson and his website https://ramblings.mcpher.com/. There are very few people who can say they have written the book on Google Apps Script and Bruce is one of them with his O’Reilly publication ‘Going GAS’.

At Pulse we recently discovered that Bruce was getting close to his 1,000th post. This milestone has now been reached with Bruce’s latest contribution ‘Creating a connector for Data Studio‘. To help mark this achievement we got in touch with some of the many ‘Bruce fans’ to reflect on Bruce’s work to date and the impact it has had on their own work.

If you would like to add your own comment feel free to use the comments section.


Laura Taylor – Google Workspace GDE

Bruce Mcpherson is one of the most prolific technical writers I’ve ever encountered.  His intricate systems knowledge along with his unique writing style make for very fascinating and helpful reading.  Not only is Bruce a prolific writer but also a prolific developer, contributing a number of open source libraries many of which are used daily in the Apps Script ecosystem.  A great debt of gratitude is owed Bruce as he has shared his knowledge with so many.  Thank you, Bruce, for your service to the Apps Script community.

Ben Collins – Google Workspace GDE

When I moved from the Microsoft world to the Google world, around 2014, there was one site I kept landing on… and that was Bruce’s! I remember early in my Google Workspace and Apps Script journey, when I was in over my head with a client project, I emailed Bruce to ask if I could use one of his many libraries in the project. He quickly replied “of course!” and proceeded to help me with a few questions I had too. I had the great pleasure of meeting Bruce in person at Next 2019 and he’s a wonderful character with many great stories. We’re lucky to have Bruce as our talisman in the Google Workspace developer group. Cheers to the next 1,000!

Eric Koleda – Former Google Developer Relations

Bruce has been a pillar of the Apps Script community for years, and hitting 1000 posts is but one sign of his love and dedication to the productivity space. My favorite post of Bruce’s ( although it’s so much more than a post) is about cGoa, an OAuth2 library for Apps Script. When the Apps Script engineering team released the /usercallback endpoint they imagined many developers building their own OAuth2 code, but I think Bruce may have been the only person not employed by Google to wade into the murky waters of implementing an authorization library. Throughout this project and others Bruce has always focussed on usability and making sure that users could get to working code quickly. Congratulations Bruce!

Chanel Greco – Google Workspace GDE

I really appreciate how Bruce actively shares his Apps Script knowledge with others through his blog, his books or by answering questions on the different community platforms. 

When searching for something Apps Script related, sooner or later, you’ll land on one of Bruce’s many resources. Many of us have developed our own Apps Script skills thanks to his contributions.

Thank you Bruce!

Charles Maxson – Google Developer Relations

Congratulations on 1,000 posts Bruce! (and THANK YOU from everyone who’s ever tried to use Apps Script – your work has no doubt been discovered and essential for all!)

I myself ‘met’ Bruce through his book “Going GAS: From VBA to Google Apps Script” where he became my personal interpreter in translating my years of Office VBA knowledge into Google Apps Script. As one of the original pioneers who started building solutions on Google Apps G Suite Workspace, what’s amazing is how Bruce has continued to give back to the community by sharing posts, libraries, videos, insights and expertise for such a long time. Having the privilege to work with Bruce now as a Google Developer Expert, he continues to amaze me how much knowledge he’s amassed and still humbly shares as regularly as ever.

Looking forward to you rambling on for another 1,000 Bruce!!!

Anu Srivastava – Google Developer Relations

Thank you so much for all your content! Especially for helping out the Apps Script community!

Clark Lind – Google Apps Suite Workspace GDE Hack

Thank you Bruce for all you have done for the GAS community. You have had worldwide impact and influence and continue to do so. I hope you continue influencing the next generation of scripters coming along. I’ve copied  learned so much from you over the years, it has helped me in my own work and career. You have shown me just how much there is to learn, and how much I don’t know. ;)

Thank you!

Adam Morris — Google Developer Expert & Integrations Director @ Faria Education Group

I like writing libraries, but what I like even more is not having to write them. It’s a grand world indeed that we live in our current universe where we can run into problems and challenges in code, and embark on a journey that leads us to individuals such as yourself, who by their very prolific endeavours establish an even grander world. Thank you.

Andrew Roberts – Freelance Dev and Google Wordspace GDE

One of the true stalwarts of the Apps Script community, Bruce has been an inspiration and endless source of knowledge for the many years I have been involved in Apps Script. Back in my early days of having to Google for how to do most things, Bruce’s site was inevitably the site I’d end up at. The guy literally wrote the book! Almost getting to 1000s posts is an amazing achievement.

Bruce publishing a list of his libraries inspired me to trawl the web and compile an automatically updating list of other Apps Script libraries I could find. Although Bruce’s still make up the vast majority of those available.

The post that particularly stands out for me, and I had lots of fun deploying, was on parallel processing with Apps Script to get around the execution limit. It even displays a funky little graph you can watch.

Thanks again Bruce for your continued support and contributions. 

Riël Notermans – Google Developer Expert and company owner of Zzapps, a Workspace reseller

Me, Martin and Bruce.

There are some people that I always look forward to seeing and to spend time with. Bruce is well in that list ;) Actually it has been for too long. 

Hanging out in real life or virtually discussing some features that work great or not, or listening to what Bruce has to say about, well, anything, it is a great experience. Professionally I would not know where to begin the ‘thank you’s’, but one of the most recent is with Bruce ‘mentoring’ me on a Kubernetes project. I got a kickstart in understanding the concepts, together with Bruce pieces of great code and his well-known ramblings really got me going. Congrats Bruce and looking forward to meet again!

Amit Agarwal – Founder @ Digital Inspiration and Workspace GDE

Thank you Bruce for your amazing contributions to the Google community. You cannot imagine how much impact your work has had on the lives of so many developers worldwide. Personally, I have admired your coding style and learnt so much by looking at your work. Thank you again!

Martin Hawksey – University of Edinburgh and Google Workspace GDE 

It’s hard to say exactly when I started following Bruce’s work, but one of the first posts I reshared was Managing Libraries with Google Apps Script from June 2012. Managing libraries is a very fitting way to celebrate Bruce’s contribution to the Google Apps Script community. Using his own Github/AppsScript visualisation tool you can explore the 100+ Google Apps Script repos, including libraries, Bruce has shared

One library that I’ve used a lot in my own work is cGoa, which lets you do OAuth2 for Apps Script in a few lines of code. There are a couple of other OAuth2 libraries, but as someone also writing about Google Apps Script solutions, the cGoa setup is straightforward and easy for others to follow. From one post from Bruce it has featured in six of my own, an example of the value of Bruce’s ‘ramblings’ to the community.

Thank you Bruce!

Sending Outlook Emails using Microsoft Account with Google Apps Script

This is a sample script for sending Outlook emails using Microsoft account with Google Apps Script. Before you use this script, please install OnedriveApp which is Google Apps Script library. And, please authorize your Microsoft account for using Microsoft Graph API.

The author of this contribution, Kanshi Tanaike, always comes up with interesting Google Apps Script solutions. This particular example uses a OnedriveApp library which makes it easy to interact with other part of the Microsoft Graph API expanding the possibilities.

Source: Sending Outlook Emails using Microsoft Account with Google Apps Script

Issues reporting with translation [using Google Apps Script and Google Forms/Sheets

In this post Baz Roberts highlights the benefits of Google Apps Script Language Service to translate Google Form responses into another language.

Source: Issues reporting with translation

Totally Unscripted: Enough of this sheet. A look at Coda with Eric Koleda, Developer Advocate @coda_hq

As part of our last episode of Totally Unscripted we spoke to former Google Workspace DevRel Eric Koleda about his new role supporting the Coda community.

Coda provides word-processing, spreadsheet, and database functions. It’s a canvas that blends spreadsheets, presentations, apps, and documents together. The software can integrate with third-party services like Slack and Gmail.

Eric gave a fantastic overview of the Coda platform highlighting opportunities for developers to integrate with services like Google Apps Script via the Coda REST API and the new Coda Packs, which are currently in beta.

The clip is an excerpt from the full show where we get to see these features in action and some additional resources referenced are linked below:

Sending Multiple Emails using Batch Request with Gmail API using Google Apps Script

This is a sample script for sending multiple emails using the batch request with Gmail API using Google Apps Script. When multiple emails are sent using “ GmailApp.sendEmail ” and “ MailApp.sendEmail ”, a loop is used. But in this case, the process cost becomes high. In this post, I would like to introduce the sample script for reducing the process cost under this situation. Gmail API can be requested with the batch request. The batch request can be processed with the asynchronous process. By this, I thought that the process cost for sending multiple emails. So, this sample script sends multiple emails using the batch request with Gmail API.

I imagine many in the Apps Script developer community have a script or two that sends email. This post highlights a solution using the Gmail API to send emails in a batch, keeping in mind the limitations highlighted in the post.

Source: Sending Multiple Emails using Batch Request with Gmail API using Google Apps Script

Subscribe to Apps Script Pulse...