Jobs lets me set any tasks for Sheets: copy ranges, hide sheets, filter data, send emails.
Interesting script project from Max Makhrov for quickly creating automated Google Sheets tasks. The source code is available under a MIT licence and you can view/fork from Github.
Welcome to the Sheets to Apps Show, where we talk about how to tame endless spreadsheets into productive applications. App Maker is a tool that empowers a wide range of individuals in an organization to turn important processes that live in spreadsheets. Join us and see how App Maker can help you in your everyday tasks!
Calculating individual page speed performance metrics can help you to understand how efficiently your site is running as a whole.
In this post from James McNulty you can learn how to use Google Sheets and Google Apps Script to automatically check your website page speeds. As well as including everything you need to set this up James also shows how the results can be visualized in Data Studio
It’s been a while since we’ve posted updates on the Google Sheets Add-on “Formulas by Top Contributors”, but now the time has come around to make up for that !
Lots of other very useful utilities in this add-on which extends the formula/functions in Google Sheets including text matching with LEVENSHTEIN DISTANCE and JS_MAP & JS_SORT allowing you to include JavaScript syntax .sort() and .map()
I wanted to update one of my free Google Add-on apps that works with colour. What I had is just the standard HTML color input element where the user selects from the palette and that hexadecimal colour code … had always wanted to create a tool for a sidebar or dialogue box that would allow the user to easily access the standard colours or use the custom palette provided by the HTML color input”
Continue reading this post to find out how you can implement your own copy of the colour picker
Clever little script that extracts comments from YouTube videos and posts notifications to Gmail … this solution is useful if you want to track comments on other peoples YouTube videos
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.
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.
Jasper Duizendstra demonstrates how with a little bit of Google Apps Script you can easily use your Google Calendar to keep a record of how much time you spend on tasks and then query/report this via Google Sheets. The post contains instructions and code for getting started
