AppsScriptPulse

Snippet, Beginner, Gmail

[Solved] Inline images break when embedded from the htmlBody of an existing Gmail draft

Tags:
| | 0 Comments |

Handy snippet from Andras Sztrokay to handle inline images when using Gmail draft messages as part of your script projects. As highlighted by Romain Vialard in the Google Apps Script community:

Google added the ability to easily retrieve the inline images in an existing draft via the getAttachments() method on October 30, 2018 (see Apps Script release notes)

Source: Inline images break when embedded from the htmlBody of an existing draft [GmailApp] [Apps Script]

Solutions, Gmail, Sheets, Web App, Beginner

Tracking Email Opens with Gmail, Sheets, and Apps Script

Tags:
| | 0 Comments |

This walkthrough will let you build a tracker for email opens using Gmail, Google Sheet, and Google Apps Script.

Interesting solution that popped up in the Google Apps Script community for logging email opens using Google Apps Script. The post includes a detailed walkthrough for setting this up as well as some caveats about reliability.

Source: Tracking Email Opens with Gmail, Sheets, and Apps Script

Solutions, Gmail, Beginner

Check Twilio Balance using Google Apps Script

Tags:
| | 0 Comments |

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

Solutions, Gmail, Beginner

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

Tags:
| | 0 Comments |

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

Add-on, Solutions, Docs, Gmail, Sheets, Slides, Intermediate

Content generation with Google Workspace Add-ons

Tags:
| | 0 Comments |

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

Add-on, Community News, Gmail

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

Tags:
| | 0 Comments |

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

Official News, Solutions, Forms, Gmail

Auto respond to feedback via Apps Script – Sheets to Apps

Tags:
| | 0 Comments |

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.

Add-on, Gmail

Building a Gmail Add-on with Apps Script

Tags:
| | 0 Comments |

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

Solutions, Forms, Gmail, Sheets

Hacking it: Generate PDFs from Google Forms

Tags:
| | 0 Comments |

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

Solutions, Gmail, Sheets, V8

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

Tags:
| | 0 Comments |

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