Import Subscriber Data From Google Spreadsheets

A recent addition for ActiveCampaign downloaded users includes the ability to import subscriber data from Google Spreadsheets.

Just click the image for “Google Docs” when importing from an external service. You will then see a link to “Authorize Google Spreadsheets”:

image

After clicking that link, you will be taken to the Google site to confirm that you want ActiveCampaign to access your documents. Click “Grant access” to confirm:

image

You will then be taken back to the subscriber import page, where you should see text confirming that you have authorized access to your Google spreadsheets:

image

Proceeding with the import, you will be prompted to choose which spreadsheet and worksheet you wish to import (you can only import one worksheet at a time):

image

You can then map the data to the appropriate fields in the ActiveCampaign software:

image

We recommend your Google spreadsheet be clean and readable, with column headers and no missing rows:

image

This will ensure an accurate import. When finished, your Google spreadsheet data will appear as new subscribers:

image

Please note: Your server will need the PHP DOM extension in order to use the Google Spreadsheets import source. We hope to include support for this in the hosted version soon.

Let us know if you have any questions or problems!

A trial is worth a thousand words.
Get started today, no credit card required.

 
 
  • SARAH BYNUM

    by signing up for $9 includes what? I AM SO DUMB ABOUT ALL THIS AND THE COMPANY THAT IS SUPPOSED TO BE HELPING ME IS NOT. PLEASE EXPLAIN. THANKS SARAH

    • Anonymous

      I would suggest contacting us with any specific questions you have – http://www.activecampaign.com/contact/

  • I was looking for some sort of tutorial about this subject, thank you for sharing. 

  • Pingback: Updates to Google Contacts and Spreadsheets Importing()