For my Next session earlier this year I needed to show the Gmail inbox of my test account, but didn’t want it appear empty. So I throw together a quick #appsscript to create dummy emails, using data generated in @mockaroodev. Now you can too! https://t.co/CgEQU5WnJJ pic.twitter.com/Y8tHb6Ynch
— Eric Koleda (@erickoleda) November 18, 2019
Nice little helper script from Eric Koleda using a model you might want to use in other projects to testing/debugging.
After 10 years at Google I had accumulated a lot of labels in Gmail, most of them unused for years. Managing them in the UI was too tedious, so I put together a Sheet + Apps Script to allow me to manage them in bulk. Now you can too! https://t.co/YTLVNFgbKd pic.twitter.com/p0NX8hJpRe
— Eric Koleda (@erickoleda) November 15, 2019
Use this spreadsheet to manage your Gmail labels in bulk! To get started, follow the steps below:
You can then use the spreadsheet to create, rename, and delete labels. You can also merge labels, which deletes a label but also moves all of it’s messages to another label.
When ready, click “Bulk Labels > Perform actions” to make the updates.
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.
Source: Repost: Sending bulk email (mail merge) using Gmail and Google Sheets – MASHe
Al Williams shares an example of how using Google Apps Script with Gmail lets you write more advanced filtering/action scripts which can be executed automatically on a time based trigger.
Source: Hack Your Gmail: A Quick Start For Google App Scripting | Hackaday
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
Source: Automating YouTube comment notifications using Google Sheets
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.
Source: Google Apps Script Patterns: Celebrating 10 years by revisiting mail merge/bulk emailing – MASHe
Since this year (2019) Google will have more strict policy regarding the Gmail scope. If in the past for sending notifications we were used to request the Send Email scope to user, now it is less comprehensible and on Google side you will have to provided lot of more details and your application can be rejected. So it become time for thinking to send email as the application and not as the user. Say Hello to RelayApp service
Source: Build your own Mail Service for Apps Script with Glitch & Gmail SMTP relay
