AppsScriptPulse

Check Twilio Balance using Google Apps Script

In this post, we will learn how to check the Twilio Balance using Apps Script and send an email to the user when the threshold level meets.

Nice post that introduces interacting with the Twilio service using Google Apps Script. The post includes lots of useful screenshots and illustrations to help you create you own billing alert system.

Source: Check Twilio Balance using Apps Script

Templated Emails With Google Apps Script To Make Your Brand Team Happy

If your organization is using G-Suite (now known as Google Workspaces) then you’re hopefully using Google Apps Script to automate your email communication. (If you aren’t, why not? It’s a brilliant way to manage your communications.) You probably have different types of emails — for different purposes.

Do all of your emails have the same look-and-feel? Do they all match your organization’s branding requirements? How easy is it to update the format for all of them if you need to change a core/base element? Maybe the company tagline and color theme changed — how quickly can you get all of your emails updated?

I am going to show you how to create templated emails so that all of the emails you send have the same look-and-feel and are easy to maintain/update.

Source: Templated Emails With Google Apps Script To Make Your Brand Team Happy

Content generation with Google Workspace Add-ons

Google Workspace Add-ons

Image credit: Google

Back when G Suite, err… Google Workspace Add-ons launched, support for Docs, Sheets, and Slides was conspicuously absent. Sure, they’ve long supported their own flavor of add-ons, but the idea of building an add-on two different ways didn’t sit well with me. Thankfully I didn’t have to wait too long for the editors to catch up. … Now that add-ons work in the editors I had the chance to build a few small demos to try them out.

Recently it was announced that Google Workspace Add-ons now support the extension of the Editors (Docs, Sheets and Slides). Steven Bazyl (Google, DevRel) has shared an overview to help you get started with Workspace Add-ons. The examples Steven shares are particularly useful if you want to start developing add-ons that work across editors as well as in Gmail. This post is particularly useful for tips on handling different host applications. Follow the link to the source for all the code and more details…

Source: Content generation with Google Workspace Add-ons

Develop My First Gmail Add-on via Google Apps Script: My Software Engineer Internship at dialoggBox

I’m a teacher-turned-developer actively searching my first software engineer job during the pandemic after graduating from Hackbright Academy. As a bootcamp new grad, I am lucky to get an internship opportunity to develop a gmail add-on product at dialoggBox to gain my first industry experience and learn how to work with stakeholders.

My article will be composed of three parts:

  • What service do dialoggBox and this gmail add-on provide?
  • What was my experience using Google Apps Script to build an add-on product?
  • How did I develop each section of the gmail add-on?

The actual details of the add-on developed by the author, Nancy Dai, are promised in a follow-up post but this post serves as a useful insight into the main things to look out for when developing Gmail Add-ons.

Bonus: Following the link to the dialoggBox website I spotted they were using icons from freepik.com which also took me their sister site flaticon.com, which in turn took me to their ‘Icons for Slides and Docs’ add-on.

Source: Develop My First Gmail Add-on via Google Apps Script: My Software Engineer Internship at dialoggBox

Auto respond to feedback via Apps Script – Sheets to Apps

Course evaluations can be a bit overwhelming when receiving mass amounts of feedback, but thanks to Apps Script this is a problem of the past. In this episode of Sheets to Apps, we’ll show you how to create and use an Apps Script for Google Sheets that allows you to respond to feedback on Google Forms via email.

In a recent episode of Sheets to Apps Ben Collins’ clever ‘Respond to feedback from students in a course’ in the G Suite  Solutions Gallery is featured. See the YouTube video description for related links.

Building a Gmail Add-on with Apps Script

I recently sent an email where I typed code inline in the message body. I spent a good 15 minutes going through and formatting each line of code to look like, well, code. I wanted an extension like Code Blocks that would instantly format my text to a specific preset style.

A well chronicled article by Kelsey Kripp on how to dive right into Apps Script for G Suite to build your own Gmail add on!

Source: Building a Gmail Add-on with Apps Script

Hacking it: Generate PDFs from Google Forms

Some time ago, I had a request from one of my colleagues to help automate a rather repetitive and might I add, highly prone to error, process. One of the clients required her to fill in the same form several times in a day, manually, and then send it back for approval and signing. Of course, I’m simplifying a bit but that was what it was in essence.

In this detailed post, Neha demonstrates how to use Google Forms to generate professional looking PDFs from the data submitted via the form, using Google Sheets and Apps Script.

Source: Hacking it: Generate PDFs from Google Forms

Capture Gmail Messages in a Google Sheet using Google Apps Script | Practical Ecommerce

With Google Apps Script, marketers can capture Gmail messages, parse them for relevant information, and add them row-by-row to a Google spreadsheet. This can be especially helpful for capturing leads or contacts.

A comprehensive write-up from Armando Roggio on using Google Apps Script to copy emails from your Gmail account to Google Sheets. As an added bonus the tutorial is also written using the new V8 runtime syntax.

Source: Capture Gmail Messages in a Google Sheet | Practical Ecommerce

A bulk email/mail merge with Gmail and Google Sheets solution evolution using V8 – MASHe

Last year I had a ‘mail merge using Gmail and Google Sheets’ contribution accepted on the G Suite Developers Solution Gallery. Just over 6 months on there has been lots of useful feedback and requests for solutions to some of the limitations of the original published script. In the meantime Google has also made the new V8 runtime for Google Apps Script generally available. Given this it seemed appropriate to revisit the original solution updating it for V8 as well as covering the most commonly asked for changes. In this post I’ll highlight some of the coding changes as well as some easy modifications.

This post picks up some common requests I get for features like advanced send parameters (cc, bcc, sender name/from, replyTo), sending emails with emoji/unicode and scheduling/triggering bulk emails. Some other areas covered in this post might be of general interest to Apps Script developers interested in using formatted Google Sheets cell values for currencies, dates and more as well as detecting/ignoring filtered hidden rows.

Source: A bulk email/mail merge with Gmail and Google Sheets solution evolution using V8 – MASHe

Using Google Apps Script to capture who sends email from your delegated gmail account

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

Subscribe to Apps Script Pulse...