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.
Have you ever created a Google Sheet projects where you could really use a select all checkbox (they call them ‘Tick-boxes’ in Google Sheets)? Sure you can copy a range of … Continue reading
Great post not only showing you how to make a ‘select all’ checkbox but you also get an in depth explanation of how this works. Once you fishish this post you might want to read this other Yagisanatode on How to check if there is a Tick Box (Check Box) in a cell or range
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.
