AppsScriptPulse

Create a mail merge using Gmail and Google Sheets | Sheets to Apps

Whether you are in sales, marketing, education, project management, data analysis, etc., it’s common for people to want to send emails to multiple recipients with information that is customized to each. In this episode, learn about Martin Hawksey’s mail merge solution, which helps anyone send emails with customized content from a Google spreadsheet, and Gmail.

See the YouTube description for all the links you need.

Release Notes  |  Apps Script  |  Google Developers – January 21, 2020

The first release notes in 2020 for Google Apps Script are mostly related to the announcement of general availability of G Suite Add-ons and cover:

  • Manifest file structure changes (Note: “Manifest fields that previously supported Gmail add-ons still exist, but are now deprecated”)
  • Extension of the Card service
  • A Conference Data service has been added to sync Google Calendar with 3rd part conferencing applications

Visit the source link for more details.

Source: Release Notes  |  Apps Script  |  Google Developers

Google Apps Script snippet for Google Sheets to view json strings in a modal dialog

View json strings in a modal dialog

View json strings in a modal dialog. Activate the cell that contains a JSON string Click menu item A foldable JSON will be shown in the modal dialog

Handy little Google Apps Script snippet from Riël Notermans (Zzapps) that makes it easier to view any JSON you are storing in a Google Sheets cell.

Source: Zzapps/google_sheets_json_viewer

G Suite Updates Blog: G Suite Add-ons now generally available in Calendar, Gmail, and Google Drive

Take action without leaving G Suite

Image credit: Google – Take action without leaving G Suite 

Last year we announced the beta of G Suite Add-ons, a new cross-suite platform that connects G Suite to your favorite workplace apps. Beginning today, G Suite Add-ons will begin rolling out to all users.

Whilst the Add-on ecosystem is being extended making them generally available to end users developers will have to wait until you can start developing new add-ons for G Suite:

Organizations can also build their own add-ons using Apps Script. Note that the developer feature will be fully available in early February

Source: G Suite Updates Blog: G Suite Add-ons now generally available in Calendar, Gmail, and Google Drive

AppSheet purchased by Google Cloud – News – Google Groups

Google Cloud has acquired AppSheet. Do I care? At first I thought, “Not really, it’s just interesting news.”

I guess that I do care in the sense that I want to be valued as a programmer, and no-code development feels like programmers are being thrown away in favor of something else. The driving force behind this is development costs. Even if an independent programmer only charged $5 dollars an hour, in two hours the customer would have paid $10 dollars, which is twice as much money as the $5 a month AppSheet plan.

It was recently announced that Google has acquired AppSheet a low-code platform for business users that lets you build applications that can integrate into a variety of sources including Google Sheets. This has resulted in an interesting thread on the Google Apps Script Community Google Group linked to from the source link at the end of this post, in particular, impact on Apps Script developers. On the one hand you can argue that products like AppSheet, with there low/no code environments remove the need for developers. However, the general consensus on the thread is rather than removing developer opportunities it may in fact create them with opportunities to extend the basic functionality of AppSheets. This comment from Alan Wells in particular caught my eye:

What AppsSheet does, is increase the number of apps and code being created, as opposed to lots of business creating no apps at all.  It’s kind of like, you need a lot more mechanics if everyone can afford a car.  If only the rich can afford a car, then there aren’t going to be many car mechanic jobs.  So, I think that AppSheet is filling a need, which increases the number of apps.  Some of those apps will crash, and they’ll need the equivalent of an auto body technician to repair the damage.  This is part of the evolution of the computing industry.

You can join in on this discuss using the following link:

Source: AppSheet purchased by Google Cloud – News – Google Groups

Google Apps Script growth analysis based on Stackoverflow analysis

Source: Kanshi Tanaike

An interesting analysis prepared by Kanshi Tanaike of the ‘google-apps-script’ tag usage on Stackoverflow which shows that since 2016 there has been an increase in questions related to the tag with a bigger increase in 2019. Clicking through to the source post you’ll also see the data shows that new users asking questions about Google Apps Script is growing quicker than those who are answering them.

Source: Trend of google-apps-script Tag on Stackoverflow 2020

iterate ~80x faster through spreadsheet using map function in apps script

use array map method instead of “for” loops to iterate faster through 2-dimensional spreadsheet data.

Sourabh Choraria shares his experience of using Array.map to find values in a Google Sheet and the performance benefit of using this approach.

Source: iterate ~80x faster through spreadsheet using map function in apps script

G Suite Training & Automation 20-21 February 2020 F2F and Online organized by SW gApps LLC

G Suite Training & Automation Conference Speakers

SW gApps LLC is hosting a G Suite and automaton training conference for organizations who have invested in Google’s productivity software known as G Suite. Send your associates to be more equipped and productive!

SW gApps LLC which is run by long time Google Apps Script contributor Steve Webster is running a two day training event for anyone interested in G Suite. Speakers and trainers include James Ferreira (Google, G Suite Specialist), Alexandrina Garcia-Verdin (Google, G Suite Developer Advocate [remote]) Ben Collins (Google Developer Expert and Google Sheets Developer & Data Analytics Instructor) as well as Steve Webster and Eric Schwartz from SW gApps LLC. There is an early bird registration available until February for either attending in-person or a reduced fee for remote attendees. You can follow the source link for more details.

Source: G Suite Training & Automation

Google Sheets Sort By Color And Google Sheets Filter By Color, With Apps Script

Use Google Apps Script to create Google Sheets sort-by-color and filter-by-color features and replicate the functionality that Excel has.

Love the clever workaround Ben Collins uses to let you filter and/or sort a Google Sheet by cell colour. Ben’s post includes all the code you need and an explanation of how it works … or you can just make a copy of the sheet and start using yourself.

Source: Google Sheets Sort By Color And Google Sheets Filter By Color, With Apps Script

How I Email: Ben Collins, Google Sheets Developer & Data Analytics Instructor – The Gmail Genius

Google Sheets expert Ben Collins shares tips and tricks for getting the most out of G Suite for your personal or business email.

In this interview Ben also shares a number of Google Apps Script based solutions he has developed and shared for managing his inbox including “I wrote a small program that automatically creates a draft reply from each row of my Google Sheet. Based on the sentiment of the response, the program adds a generic thank you message. Now my workflow is to go directly to my draft Gmail folder, review these draft emails (which include the feedback so I don’t even have to look at the Google Sheet) and add a custom response before hitting send”. You can view the interview for a link to the example script Ben shared for this.

Source: How I Email: Ben Collins, Google Sheets Developer & Data Analytics Instructor – The Gmail Genius

Subscribe to Apps Script Pulse...