Create and Mail to a Google Sheet

You can create a mailing list during the Mail My Doc by Click2Mail Google Add-on order process.  After creating your Google Doc and clicking "Mail My Doc by Click2Mail" from the Add-on menu, click "Create/Import".

Click "Create Sheet".

Click "Add Address".

Enter mailing address information.  Click "Add +next address" to enter additional addresses.  Click "Add address and finish" when you have entered all of your mailing addresses.

The records you entered will be displayed.  Click "Save to Sheet".  

Next, save the sheet with a meaningful name.  

Now you will import the Google Sheet for use as a mailing list.

Click "Create/Import" again and then click "Import Sheet".

Select the sheet you want to import and click "Select".

Now tell us how to print the information in the sheet on your mailpiece.  This is done by dragging the blue boxes seen to the right of "My Sheet Fields" into the white "Click2Mail Fields" boxes.  There is an excellent animated tooltip located on this screen that demonstrates this action.  Your sheet does not need to have all of the "Click2Mail Fields" information in individual columns, but at the minimum, we must have a First Name and Last Name OR Organization field and individual fields for the Address, City, State, Zip and Country (only required if you have international addresses) fields.

Click "Continue" when you are ready to proceed.

Select records from the sheet to which you are mailing and click "Continue".

We will classify your addresses as non-mailable, non-standard, standard or international.  You are encouraged to try correcting non-mailable and non-standard addresses by clicking them and reentering information.  Non-mailable addresses will not be imported.  Click "Continue" when you are ready to proceed.

Give the sheet a meaningful name.  It will be available for your use as a mailing list in the future.  Click "Import".

Select the sheet from your list of mailing lists and click "Continue" to proceed through the order process.