AppsScriptPulse

Apps Script V8 Runtime Explained For Non-Professional Developers

Learn how to use modern JavaScript features in your Apps Script code with the release of the Apps Script V8 runtime engine.

Somehow we missed this post from Ben Collins when it was originally published in February, 2020, but it is well worth visiting and adding to our V8 collection of posts. For those still catching up V8 is the new runtime for Google Apps Script which enables modern JavaScript syntax to be used in your code. Ben covers some of the basic differences now possible with V8, with lots of examples.

Source: Apps Script V8 Runtime Explained For Non-Professional Developers

Replays from SheetsCon 2020 – the world’s first, dedicated online conference for Google Sheets users

SheetsCon 2020 was the world’s first, dedicated online conference for Google Sheets users on 11th – 12th March 2020.

We had 11 world-class experts talk about how they craft solutions using Google Sheets and G Suite.

Over the course of two jam-packed days, we had everything from deep-dive tutorials on specific topics to cutting-edge solutions across different industries. We had 1-on-1 networking opportunities, roundtable discussion rooms with other professionals and an Expo Hall with vendors at the forefront of the Google Sheets movement.

Listen to all the replays and access all the templates when you enroll for free.

Whilst this was Google Sheets focused there are a number of sessions that cover Google Apps Script and G Suite Add-on development. As well as the replays there are a number of linked resources you can also use.

Source: SheetsCon 2020 Replays

JSJ 419: Google AppScript with Ben Collins

Today’s guest is Ben Collins, who creates online courses, writes tutorials, and teaches workshops around G Suite and App Script. Apps Script is a scripting platform developed by Google for light-weight application development in the G Suite platform. It is an implementation of JavaScript with the express purpose of extending Google apps.

Ben Collins is the guest on episode #419 of the Javascript Jabber podcast to discuss using Google Apps Script with Google Sheets.

The conversation includes Ben’s usage of automated sentiment analysis of feedback from his courses.

Source: JSJ 419: Google AppScript with Ben Collins

SHEETSCON 2020 – Free Online Conference for Google Sheets Users, 11-12 March, 2020 

SHEETSCON 2020

Come and celebrate Google Sheets at SheetsCon 2020, the world’s first, dedicated online conference for Google Sheets users.

Listen to world-class experts talk about how they craft solutions using Google Sheets and G Suite.

Over the course of two jam-packed days, you’ll hear everything from deep-dive tutorials on specific topics to cutting-edge solutions across different industries. You’ll have the chance to network with other professionals and meet vendors at the forefront of the Google Sheets movement.

Looks like a great event being hosted by Ben Collins for Google Sheets users. Click through to the SheetsCon 2020 website for the full agenda and free registration

Source: SheetsCon 2020

 

Gmail Mail Merge For A Specific Label With Apps Script – Ben Collins

Every Monday I send out a Google Sheets tip email and occasionally I’ll include a formula challenge…. It would have been too time consuming to reply to all 150 responses manually from my inbox. Since 95% of all my replies would be the same … it was a perfect case for automation.

Ben Collins expertly shares how he automates part of his Gmail inbox to review emails in Google Sheets and prepare draft replies to be sent as responses. As always Ben provides details of each step and the code.

PS Don’t miss Ben’s free Automation With Apps Script course  – enrolment closes 31 January 2020.

Source: Gmail Mail Merge For A Specific Label With Apps Script – Ben Collins

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

Goal Seek in Google Sheets – How To Use Goal Seek In Google Sheets

Learn how to use Goal Seek in Google Sheets. The Goal Seek feature enables you to change input values to make a formula result match the goal you specify.

We’ve highlighted the new Goal Seek Add-on previous in Pulse, but if you missed it or wanted to see some more practical use cases Ben Collins has expertly covered how to setup and use it.

Source: Goal Seek in Google Sheets – How To Use Goal Seek In Google Sheets

Subscribe to Apps Script Pulse...