Loading...
Import your Google Contacts directly into Google Sheets for mail merge campaigns. Learn how to fetch, filter, select, and map contact fields using MassyMail's built-in importer.
MassyMail has a built-in Google Contacts importer that lets you pull your contacts directly from your Google account into your Google Sheet — no manual CSV export required. To access it, open the MassyMail sidebar via Extensions > MassyMail > Open, then look for the More Options menu in the campaign workspace. Click Import Contacts.
The import modal will open and begin fetching your contacts from Google Contacts via the Google People API. Depending on how many contacts you have, this may take a moment.
Once your contacts are loaded, you'll see a searchable, filterable table. Use the available filters to narrow down the contacts you want to import:
Using these filters effectively means you import only the contacts that are relevant to your campaign, keeping your sheet clean.

With your filtered list visible, select the contacts you want to import using the checkboxes next to each row. You can:
The total number of selected contacts is shown at the bottom of the modal, so you can confirm you have the right count before proceeding.
After selecting your contacts, MassyMail will prompt you to map contact fields to columns in your Google Sheet. The following fields are available to import:
For each field, you'll select which column in your sheet it should write to. If a column doesn't exist yet, you can create it during this step. Fields you don't need for this campaign can be left unmapped and won't be imported.

Once your field mapping is complete, click Import. MassyMail will process each selected contact and write the data to your sheet using the following rules:
When the import finishes, MassyMail will display a summary showing how many contacts were added, updated, and skipped. Your sheet is now ready for your mail merge campaign.

For a complete walkthrough of Gmail mail merge — including templates, scheduling, and tracking — see our Gmail Mail Merge: The Complete Guide. New to MassyMail? Install it free from the Google Workspace Marketplace.
Send personalized bulk email campaigns directly from Gmail using your Google Sheets data. Schedule campaigns, track opens and clicks, and manage templates without leaving Google Workspace.