Google Sheets integration

Our automatic importer works with Google Spreadsheets to check for new updates on a repeat basis. In this document, we will cover the following:

  1. Preparing your Google Spreadsheet
  2. Setting up the automatic import
  3. Resetting the automatic import
  4. Import frequency and adding new data

Prepare your Google Spreadsheet

Before you use the importer to connect your Google sheet to ActiveCampaign, there are a few things that you will need to keep in mind in order for the import to work.

Column naming and order
The first three columns should be system Email, First name, and Last name. You can name the column headers anything you like, but ActiveCampaign assumes they exist in that order and position. If your first three columns are not in that order, this will cause the importer to fail.

Custom fields start in column D and can be named anything you like and contain any text values. The system will use the header row to determine the custom field names in ActiveCampaign.

Google_sheet_fields.png

Remove blank rows at the end
To ensure our system calculates the correct row to start on (when the importer runs again), make sure there are no extra blank rows at the end of your spreadsheet. Not removing these rows can also cause the importer to fail.

Remove_blank_rows.png

Here is an example of how your Google Sheet should look:

Example_google_sheet.png

Note the order of the first three columns (Email address, First name, Last name) and that all blank rows have been removed.

Once your spreadsheet is formatted to the specifications listed above, you are now ready to set up the automatic import.

Back to top.

Setting up the Automatic Import

  1. Click on Contacts from the top navigation menu to go to the Contacts Overview page. Click on "Import."

    Contacts_then_import.png

  2. Locate Google Spreadsheets from the list of available automatic imports and click on it.

    Google_sheets_icon.png

  3. The Google Docs modal will open. Click “Next.”

    Google_Docs_click_next.png

  4. You will be asked to log into your Google account if you are not already.
  5. On the next screen, click “Allow” to give ActiveCampaign access to your Google Spreadsheets.

    Click_Allow.png
  6. Optional - Select which list you want to add contacts to from your Google spreadsheet by clicking it. Click “Next” to continue.

    Choose_spreadsheet.png

  7. On the next screen, choose one of the import options by clicking it. You can choose to either import contacts and auto import new contacts in the future, or, import contacts and do not auto import new contacts in the future.

    choose_import_option.png

  8. Select your spreadsheet from the Spreadsheet dropdown. Then, click “Next.”

    Choose_from_spreadsheet_dropdown.png

  9. On the next screen, select a worksheet and click “Next.”

    Choose_worksheet.png

Your Google Spreadsheet is now connected to ActiveCampaign and contacts will be automatically imported into your account.

Google_automatic_import_done.png


Back to top.

"Reset" the import

You can click the “Reset” button to have the importer start at the very first spreadsheet row the next time it runs. By default we’ll check for new rows at the end of the spreadsheet for seven days, then we’ll start from the beginning again (see the section below for more details). If you need to force the importer to start from the beginning, this is the way to do it.

Click_reset.png

Back to top.

Import frequency and adding new data

ActiveCampaign will process 1,000 rows at a time, every 30 minutes. If your spreadsheet has more than 1,000 rows, you will not see all of your data in your account right away. When new rows are added to the bottom of the spreadsheet, those will be imported within 30 minutes (once the system reaches that page).

ActiveCampaign only checks for new rows at the end of your spreadsheet. We recommend sorting by “date added” (you could have a column called that, which will become a custom field in ActiveCampaign) in ascending order. This way new contacts will always appear at the very bottom of the spreadsheet.

Every seven (7) days the entire spreadsheet will be imported from the beginning; any changes you make to the data that was already imported won’t show up for almost a week.

Any empty custom field cells in your spreadsheet should be denoted with ~|, and those will appear as blank/empty in ActiveCampaign.

Back to top.

Have more questions? Submit a request