AppsScriptPulse

How to Generate a Report of Bounced Email Addresses in Gmail with Google Apps Script – Digital Inspiration

The bounced email report for Gmail lists all the email address that bounced. It also provides the response provided by the recipient’s server for rejecting your email.

Nice script example shared by Amit Agarwal for getting a bounced email report from your Gmail account.

Source: How to Generate a Report of Bounced Email Addresses in Gmail – Digital Inspiration

G Suite Solutions —  Apps Script Powered Workflow Automation

Laura Taylor recently spoke at SheetsCon on the topic of Automation with Apps Script. During the presentation, she walked through a simple approval workflow for a hypothetical small business to demonstrate the power of Apps Script to automate workflow inside G Suite. She also showcased modern ECMAScript features supported by the new Apps Script V8 Javascript runtime.

The article is an overview of the workflow covered in the author’s presentation along with install instructions for trying it out in your G Suite domain.

Source: G Suite Solutions —  Apps Script Powered Workflow Automation

Workflow to collect and approve budgets using Apps Script in Google Sheets

Gathering inputs from multiple sources and then taking action on each becomes taxing when the task needs to be realized with frequency and with multiple stakeholders. An example is quarterly or annual budget approvals for a finance team.

In this article the author will share how to use an Apps Script in a Google Sheet to automatically create a budget submission form that you can share with end users, and when their responses arrive in the sheet, you can collaborate with other reviewers to send emails in bulk depending on whether you are approvingrejecting, or asking for more information about their request. The emails use a Google doc as a template that pulls information from the sheet such as a user’s name, the budget values they entered, or special comments.

Source: Workflow to collect and approve budgets using Apps Script in Google Sheets

Email scheduler for Gmail – overview

Email scheduler spreadsheet columns image

Email scheduler spreadsheet columns

Over the next few blog posts I look to explore my development of an email scheduler for Gmail that is designed to let you schedule when you want an email composed in your drafts to be sent (by specifying the date/time).

This was written prior to Google introducing an email scheduler themselves.

Source: The Gift of Script: Email scheduler for Gmail – overview

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

Create a mail merge using Gmail and Google Sheets | Sheets to Apps

Whether you are in sales, marketing, education, project management, data analysis, etc., it’s common for people to want to send emails to multiple recipients with information that is customized to each. In this episode, learn about Martin Hawksey’s mail merge solution, which helps anyone send emails with customized content from a Google spreadsheet, and Gmail.

See the YouTube description for all the links you need.

Manage Gmail with Google Apps Script

Ever had a messy inbox full of mails? Does it bother you to skip the inbox? Luckily, Google has provided many services that we can harness its utilities to organize the mail using personal preferences or workflow.

You will able to make an auto email archiver/remover after following the steps. This will be done by using Google Apps Script and setting the schedule trigger. The code is pretty simple and straightforward since Google has already provided us with ready-to-use objects for managing Gmail.

Source: Manage Gmail with Google Script

Bulk save emails from Gmail

Screenshot of setup sheet for tool.

Screenshot of setup sheet for tool.

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.

Source: The Gift of Script: Bulk save emails from Gmail – overview

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

Send bullk emails with personalised images in G Suite using Google Apps Script

Earlier in the year I managed to get a bulk emailing script published in the G Suite Developer Solutions Gallery. In this post I want to show you how you can extend this script so that you can send personalised images using Gmail, Sheets and Slides.

Source: Send bullk emails with personalised images in G Suite using Google Apps Script

Gmail scopes automatically invalidated when a user changes the password requiring re-authentication 

I stumbled upon this particular oddity a few weeks ago when a client asked me to resolve an issue.
It turns out that if your application leverages gmail scopes, those scopes are automatically invalidated when a user changes the password on that gmail account. The client in question had changed their password which triggered an authorization prompt. Something to watch out for.
Nice highlight from Dimu Designs, the source thread is open for other ‘gotchas’.

Source: The more you know! – Google Groups

Bulk send emails from a Google Sheet

This is designed to loop through each row of a Google Sheet and send an email containing information from it. This means you can send personalised emails with ad-hoc information for each recipient quickly.

It has been developed so that it is easily expandable for you to add further columns/rows. The script has a number of features to achieve this:

  1. A menu option for easily selecting to send email, with a confirmation dialogue popup.
  2. A timestamp as confirmation for when an email was sent.
  3. A check that an Email Address is present and there is no current value in the Email Sent column – to prevent repeat email sending but also allow ad-hoc emailing by clearing this column for those you wish to send again.
  4. A try/catch to help automatically deal with problematic emails that may break the script – an error message will be written into the Email Sent column and the script will continue on to the next row.

Source: The Gift of Script: Bulk send emails from Google Sheet

Creating dummy data for Gmail using Google Apps Script

Nice little helper script from Eric Koleda using a model you might want to use in other projects to testing/debugging.

Bulk Gmail Label Manager (made with Google Apps Script)

Use this spreadsheet to manage your Gmail labels in bulk! To get started, follow the steps below:

  1. Make a copy of this spreadsheet.
  2. Wait a few moments for the “Bulk Labels” menu to appear.
  3. Click “Bulk Labels > Pull labels”.
  4. When prompted, grant the script authorization to your account.

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.

Repost: Sending bulk email (mail merge) using Gmail and Google Sheets – MASHe

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

Hack Your Gmail: A Quick Start For Google App Scripting | Hackaday

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

Automating YouTube comment notifications using Google Sheets

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

Google Apps Script Patterns: Celebrating 10 years by revisiting mail merge/bulk emailing – MASHe

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

Build your own Mail Service for Apps Script with Glitch & Gmail SMTP relay

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

Subscribe to Apps Script Pulse...