Google sheets mail merge labels for free#
Google sheets mail merge labels how to#

Var messages = GmailApp.getMessagesForThreads(threads) ĮmailArray. get all the messages for the current batch of threads get all email threads that match label from Sheet First, open Google Sheets and enter all the data you want to print on the labels.

Google sheets mail merge labels how to#

Var label = 'marketing-formula-challenge-#3' How to Use Google Sheets to Mail Merge Labels Step 1: Open Google Sheets. In this case, the function parses the From field into a name and email address using regular expression.įinally, this new array, containing the Name, Email Address and Message Body, is returned to whichever function called the extractEmails() function. Parse this with a map function, which creates a new array out of the original array where a function has been applied to each element. Retrieve all the messages with the getMessagesForThreads() method.įrom this array of messages, extract the From field and the body text. This returns an array of Gmail threads matching this query. Search for the messages under this label with the search query method from the GmailApp service. Part 1: Extract Gmail Emails To Google Sheet With Apps ScriptĪssuming all your emails are labeled, so that they’re all together in a folder, you can use Apps Script to search for this label and extract the messages into a Google Sheet. The last part is manual: a quick check of original email and response, add any customization and then press SEND.Next type the name of your label - say For Mail Merge - and click the Save. Following that, use Apps Script to create draft emails for everyone in the Sheet (the Gmail Mail Merge part). Inside the Google Contacts website, go to the Labels menu and choose Create Label.Then use a simple VLOOKUP formula to add a reply to each row, based on the category.

Google sheets mail merge labels for free#

Next, create a reply template for each of these categories, to say thank you for taking part and also sharing any feedback. Generate mailing lables from a spreadsheet of addresses for free using Google Docs, Google Sheets, and Autocrat (free add on).

each email) into 3 or 4 different categories, e.g.

Then use Apps Script to extract the solution responses into a Sheet with names and emails addresses.

Make sure all of the emails are labeled correctly in Gmail (you can use a filter to do this).

Learn more about Google Apps Script in this free, beginner Introduction To Apps Script course Gmail Mail Merge Script Outline