One way to obtain your source sheet could be to export a set of records from a database such as Salesforce and then import your file (e.g. Configure your Google Sheetįirst, you’ll need to have a Google Sheet that contains your recipient email addresses, along with any other custom data you wish to include in your merge. Once you know you have access to mail merge and know to whom you may send (i.e., internal only or external addresses), open Chrome on a desktop-class computer, sign in to your Workspace account and follow the sequence below. In all cases, the quantity of Gmail messages you send must remain within the sending limits of your edition. The administrator may adjust this setting either for the entire organization or for specific organizational units.Īdditionally, by default, some Workspace editions restrict mail merge to internal recipients only a Workspace administrator may choose to allow sending a mail merge to external email addresses. In some cases, this setting may still show as Multi-send. An administrator may allow or prevent access to mail merge via a setting in the Admin Console: Apps | Google Workspace | Gmail | User Settings | Mail Merge. You should check with your Google Workspace administrator to learn how mail merge has been configured for your account. Google Chrome: Security and UI tips you need to know IOS vs Android Market Share: Do More People Have iPhones or Android Phones? Google Bard cheat sheet: What is Bard, and how can you access it?ĬhatGPT vs Google Bard (2023): An in-depth comparison To create a mail merge, you need a Google account with a supported edition of Workspace: Individual, Business Standard or Plus, Enterprise Standard or Plus, Education Plus and Nonprofits. Mail merge works well for customized recommendations, reminders or renewal messages.

This means you can create an email that takes custom fields from a spreadsheet and insert them into individual emails to personalize your message.

If your Workspace edition supports it, you may mail merge from Gmail using a Google Sheet as your data source. Personalize email communications with custom fields inserted into a mail merge message. How To Integrate Google Sheets With Mail Merge in Gmail

Download gmail icon to desktop