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.
This tool is designed to bulk save emails (and associated attachments) from a specified Gmail label into a Google Drive folder, with relevant threads combined into a single PDF document.
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.
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.
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.
Regular Google Apps Script Community contributor Bruce Mcpherson has published a list of all the Google Apps Script libraries he’s developed since 2012. The list includes links to the source repositories and if you spot a library you like the sound of you can search for more information on Bruce’s Desktop Liberation site .
We created a series of Google Apps scripts to group together the coordinates of every restaurant within a given neighbourhood. Next, we developed a formula to calculate the mid-point of that group of restaurants and determine the distance between the furthest apart restaurants in that neighbourhood.
This post was highlighted by Tim Leighton-Boyce and while no Apps Script code is included it’s a useful usecase of how Apps Script is helping businesses deliver.
Whether it’s event planning, research aggregation, budgeting, report creation, or reaching out to customers for campaigns; it’s helpful to be able to automate tasks using a script in Google Sheets for example.
Monitoring Google App Maker adoption in our Organisation. For this I realized an Apps Script project calling the Cloud SQL Admin API, a REST API for administering your instances programmatically in order to Lists instances under a given project in alphabetical order by instance name.
Data will be displayed on a DataStudio dashboard.
