---
title: "Gmail Mail Merge For A Specific Label With Apps Script – Ben Collins"
author: "Martin Hawksey"
date: 2020-01-29T19:17:15+00:00
canonical_url: https://pulse.appsscript.info/p/2020/01/gmail-mail-merge-for-a-specific-label-with-apps-script-ben-collins/
markdown_url: https://pulse.appsscript.info/p/2020/01/gmail-mail-merge-for-a-specific-label-with-apps-script-ben-collins.md
categories:
  - "Gmail"
  - "Sheets"
  - "Solutions"
tags:
  - "@benlcollins"
  - "benlcollins.com"
featured_image: https://pulse.appsscript.info/files/2020/01/gmailMailMergeReplyTemplates.jpg
description: "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%..."
---

# Gmail Mail Merge For A Specific Label With Apps Script – Ben Collins

![Gmail Mail Merge For A Specific Label With Apps Script – Ben Collins](https://pulse.appsscript.info/files/2020/01/gmailMailMergeReplyTemplates.jpg)

> [https://www.benlcollins.com/spreadsheets/gmail-mail-merge-for-a-specific-label-with-apps-script/](https://www.benlcollins.com/spreadsheets/gmail-mail-merge-for-a-specific-label-with-apps-script/)
> Every Monday I send out a [Google Sheets tip email](https://www.benlcollins.com/google-sheets-tips/) 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**](https://www.benlcollins.com/automation-with-apps-script/)  – enrolment closes 31 January 2020.

Source: *[Gmail Mail Merge For A Specific Label With Apps Script – Ben Collins*](https://www.benlcollins.com/spreadsheets/gmail-mail-merge-for-a-specific-label-with-apps-script/)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2020/01/gmail-mail-merge-for-a-specific-label-with-apps-script-ben-collins/](https://pulse.appsscript.info/p/2020/01/gmail-mail-merge-for-a-specific-label-with-apps-script-ben-collins/)*