Automator Tip #5: Add Address Book Contacts to Gmail

By Dan Hinckley

35 responses. »

The Automator tip of the week walks you through one way to extract the contact information from Address book and put it into a format that you can upload to Gmail.

Gmail accepts csv files for importing contacts. Unfortunately Address Book does not export directly to csv. Why it doesn’t is a puzzle in it self, but thankfully we can get the same results through Automator with the use of some Microsoft Office actions.

To create a csv file Automator of your contacts in Address Book add the following actions to a workflow:

  1. Find People in Address Book, Set Whose to Name, is not equal to, and then use * in the input field – This tells automator to look through all the names in your address book and return everyone that doesn’t have a * in their name.
  2. Get Contact Information, Export Format: Spreadsheet (tabs) – This gathers all the information about each contact and puts it into a standard format we can work with.
  3. New Text File – I named it contacts.txt and saved it to my desktop – This will write the information from address book to a text file
  4. Import Text Files to Excel Workbook – Select New Workbook and mark the delimiters as Tab
  5. Save Excel Workbooks – Save Workbooks as contacts, on the desktop and select CSV(Comma Delimited) as the format
contacts.png

Import Address Book CSV File to Gmail

If everything was constructed correctly you should be able to run the workflow and 2 files will be written to your desktop. From here we can import our contacts.csv file into Gmail.

To import your contacts.csv to gmail:

  1. Login to Gmail
  2. Click Contacts
  3. Click Import
  4. Choose your contacts.csv file and click Import
  5. Follow the final instructions from Gmail and verify your contacts imported correctly
Gmail - Contacts - dhinckley@gmail.com.png

Now that we’ve showed how to complete this process with Automator, there is also an application – A to G that was built do extract Address Book Contacts and place them in a CSV file.

Importing Contacts from Gmail into Address Book is a bit easier.

About Dan Hinckley
Dan Hinckley is an experienced Mac user who converted to Apple products when they introduced them on Intel Processors. He loves helping others get more out of their devices! Subscribe to Maciverse.com to get the latest from Dan and the Maciverse Team!! Find out more about Dan:

35 Responses so far.

  1. Maximilian

    June 17, 2008 at 5:16 pm

    All works well until the import to excel and safe excel workbook – as I cannot find such functions in my automator. Where can I get them or how to build them? Thanks Max

  2. Dan

    June 17, 2008 at 5:21 pm

    Maximilian, Do you have Microsoft Office installed? If not these steps won’t be available but using Numbers may also work.

    I had Office 08 when I put this together.

  3. Hiposaasa

    August 10, 2008 at 8:37 am

    OOO, Interesting story))

  4. How To Import Gmail Contacts to Address Book

    November 15, 2008 at 6:01 am

    [...] Read this to Import Address Book Contacts to Gmail. [...]

  5. mohammad ramzan

    November 19, 2009 at 8:42 pm

    Satisfactory

  6. David

    July 6, 2010 at 10:29 am

    Of course now this article is a bit out-dated and Gmail has included the ability to import vCards from Address book =)

  7. Import Gmail Contacts to Address Book on Iphone | Linux tutorials

    August 13, 2011 at 9:36 pm

    [...] Read this to Import Address Book Contacts to Gmail. [...]

  8. Anonymous

    September 18, 2012 at 6:07 am
  9. Anonymous

    September 19, 2012 at 2:56 pm
  10. Anonymous

    September 20, 2012 at 10:17 am
  11. Anonymous

    September 22, 2012 at 12:15 am
  12. Anonymous

    September 22, 2012 at 9:44 am
  13. Anonymous

    September 23, 2012 at 12:15 am
  14. Anonymous

    October 3, 2012 at 6:59 am
  15. Anonymous

    October 5, 2012 at 1:00 am
  16. Anonymous

    October 13, 2012 at 7:35 pm
  17. Anonymous

    October 14, 2012 at 11:21 pm
  18. Anonymous

    October 16, 2012 at 10:43 pm
  19. Anonymous

    October 26, 2012 at 9:24 pm
  20. Anonymous

    November 5, 2012 at 12:20 pm
  21. Anonymous

    November 10, 2012 at 5:21 pm
  22. Anonymous

    November 17, 2012 at 7:03 pm

    ȫѶ

  23. Anonymous

    November 22, 2012 at 3:41 am
  24. Anonymous

    November 22, 2012 at 12:02 pm

    Ϊ

  25. Anonymous

    November 22, 2012 at 9:41 pm
  26. Anonymous

    November 23, 2012 at 8:21 am
  27. Anonymous

    November 24, 2012 at 8:43 am
  28. Anonymous

    December 9, 2012 at 11:54 am

    Χ

  29. Anonymous

    December 11, 2012 at 10:37 am
  30. Anonymous

    December 16, 2012 at 2:33 pm
  31. Anonymous

    December 19, 2012 at 7:57 pm

    http://www.066078.comȫ

  32. Anonymous

    January 6, 2013 at 1:53 pm

    2013

  33. Anonymous

    January 8, 2013 at 7:56 pm

    289817880

  34. Anonymous

    January 11, 2013 at 1:18 pm
  35. Anonymous

    February 14, 2013 at 2:33 am

Leave a Reply

Site powered by Go Fish Digital