This guide explains how you can prepare recipients list in your Google Contacts for importing into Google Sheet for Mail Merge.
Go to contacts.google.com and select one or more contacts that you wish to export to the Google Sheet.
Please do make sure that the imported contacts have a primarily email address associated with them. If the email address is not available, you can still manually type the email inside the Google Sheet.
Label the Contacts
Inside the Google Contacts website, go to the
Labels menu and choose
Create Label. Next type the name of your label - say
For Mail Merge - and click the Save button to create your contacts group.
Import the Contacts
Switch to the Mail Merge sheet and choose "Import Contacts" > "From Google Contacts" as shown in the screenshot.
You'll now be presented with a list of labels (or Contact Groups) that are found in your Google Contacts. Select the
label that you created in the previous step and choose
Import Contacts to bring all the contacts for that label into the sheet.
The import wizard will bring only the name and email address of the recipients from Google Sheets into the spreadsheet.
If you would like to import more contact information, like the company name, the phone number, the title and so on, you can export contacts in a CSV file and import into sheets.
Export Google Contacts
Go to the Google Contacts website and click the
Export button in the left sidebar. Here choose the correct label from the drop-down and choose "Google CSV" for the export format.
Click the "Export" button and it will download a CSV file on your desktop that you can upload to Google Sheets.