In the episode we broke the exclusive news that the new Script Editor will be rolling out to all users starting on 07 December 2020. I can’t thank Keith enough for taking the time out to share this news to the Totally Unscripted audience first and also to Charles for making possible as well as providing an expert tour of the new Apps Script Editor.
More official news and resources will be published next week and we’ve setup a category on AppsScriptPulse to capture these and community contributions.
If you missed the live episode the recording is included in the source post.
Source: Totally Unscripted Exclusive: Detailed look at the new Google Apps Script IDE/Script Editor and launch – MASHe
Pivot tables are a quick and powerful way to analyse data. Using Google Apps Script, there is an ability to build and modify pivot tables in Google Sheets. In this post I’ll share some tips and tricks for interacting with pivot tables in Google Sheets.
Source: Working with Pivot Tables in Google Sheets using Google Apps Script
Google Sheets users can already use the magic of AutoFill to expand data automatically detecting a series of numbers, letters or dates. This feature is particularly powerful even when your series includes text or repeating dates. In this post I’ll highlight how you can also use AutoFill in your Google Apps Script projects
This post is designed for both no/low coders and expert developers interested in finding out how you can use AutoFill in your Google Sheets/Apps Script projects.
Source: Adding some AutoFill magic to your Google Sheets Apps Script projects
Back in 2015 I shared a post on Tips on emailing inline Google Charts from Sheets using Apps Script, which looked at how you can email charts from Google Sheets. This solution is one I use in my work on a daily basis and remains largely unchanged. More recently I was faced with the problem that I couldn’t include a Combo Chart. In this post I revisit this problem and share a solution for including copies of your Google Sheet charts in your email reports.
Whilst this solution focuses on extract Google Sheets chart images for the purpose of emailing, the technique might be of interest for other situations where you need to use a chart image.
Source: Dashboards in your inbox – Revisting tips on emailing inline Google Sheet chart images with Google Apps Script
As part of Next OnAir week 2 the focus was on ‘Productivity and Collaboration’ Charles Maxson from the G Suite DevRel team not only provided some highlights from the week, but he also premiered the new Google Apps Script IDE.
This post includes a recording to a live demo of the new Google Apps Script editor. No news on when the new Script Editor will be generally available, but from the demo it looks like Google have focused on making it easier for developers to code and debug scripts.
Source: First look at the new Google Apps Script Integrated Development Environment (IDE) Script Editor – MASHe
Last year I had a ‘mail merge using Gmail and Google Sheets’ contribution accepted on the G Suite Developers Solution Gallery. Just over 6 months on there has been lots of useful feedback and requests for solutions to some of the limitations of the original published script. In the meantime Google has also made the new V8 runtime for Google Apps Script generally available. Given this it seemed appropriate to revisit the original solution updating it for V8 as well as covering the most commonly asked for changes. In this post I’ll highlight some of the coding changes as well as some easy modifications.
This post picks up some common requests I get for features like advanced send parameters (cc, bcc, sender name/from, replyTo), sending emails with emoji/unicode and scheduling/triggering bulk emails. Some other areas covered in this post might be of general interest to Apps Script developers interested in using formatted Google Sheets cell values for currencies, dates and more as well as detecting/ignoring filtered hidden rows.
Source: A bulk email/mail merge with Gmail and Google Sheets solution evolution using V8 – MASHe
The problem: hyperlinks in Google Sheets can be in three different formats so if you have a script or add-on that relies on handling links in cells it can cause some headaches.
This article covers a thorough walkthrough of using Advanced Sheets Service to read hyperlinks from cells with different link formats.
Source: Everything a Google Apps Script Developer wanted to know about reading hyperlinks in Google Sheets … but was afraid to ask
This post covers a range of techniques and includes a typical pattern for writing structured data like JSON responses from third party sources.
Source: Google Apps Script Patterns: Writing rows of data to Google Sheets the V8 way
Earlier in the year I managed to get a bulk emailing script published in the G Suite Developer Solutions Gallery. In this post I want to show you how you can extend this script so that you can send personalised images using Gmail, Sheets and Slides.
Source: Send bullk emails with personalised images in G Suite using Google Apps Script
I always enjoy presenting at DevFest as usually it is a reason to explore something new. In the case of DevFest London it was an opportunity to think about how voice interfaces could be used as part of a Google Slide presentation. In this post I’ll share some of the ideas I explored and how they did/didn’t work out.
In practice not all these experiments worked out but hopefully the post contains some useful snippets for navigating Google Slides in the editor, exporting slides as images and extracting text from the speaker notes.
Source: Hacking Google Slides as a voice enabled presentation tool using Google Apps Script – MASHe
Simplify the process of producing visually rich mail merges using Gmail and combining it with data from Google Sheets. With this solution you can automatically populate an email template created as a Gmail draft with data from Google Sheets. Merged emails are sent from your Gmail account allowing you to respond to recipient replies.
Source: Repost: Sending bulk email (mail merge) using Gmail and Google Sheets – MASHe
Over the last 10 years of Google Apps Scripts there have been a number of bulk email solutions shared by the community. This post revisits some of these examples and shares one of the latest examples from the GSuite Solutions Gallery
TL;DR A new solution for creating and distribute visually rich bulk emails with Gmail and Google Sheets.
Source: Google Apps Script Patterns: Celebrating 10 years by revisiting mail merge/bulk emailing – MASHe
This is a popular post from 2018….
In the previous post in the Google Apps Script Pattern series we looked at selectively updating rows of data in a Google Sheet. For this post we will look at a couple of patterns for inserting multiple rows of data into Google Sheets.
Source: Google Apps Script Patterns: Writing rows of data to Google Sheets – MASHe
Custom functions have been in Google Apps Script since it’s public launch in 2009. These let you extend Google Sheets function list allowing you to create and share your own spreadsheet formula. This post provides some guidance on writing custom Google Sheet functions that can handle both single and range inputs
Source: Google Apps Script Patterns: Writing custom formulas/functions and handling single and range inputs – MASHe
Summary of posts by other G Suite GDEs highlighting announcements from Google Next ’19
Source: G Suite, Apps Script and App Maker posts from Google Next ’19 – MASHe