Need a hand? We've got you covered.

Knowledge Base Home aero-right Contact Lists Importing / Exporting Integrations aero-right How do I import my list from Google Sheets?

How do I import my list from Google Sheets?

Contact Lists Importing / Exporting Integrations Updated on February 6, 2020

You can import contacts from your Google Drive by following these simple steps:

  1. Log in to your Benchmark account.
  2. Click on Contacts from the Dashboard menu.
  3. Select the Create New List button on the top-right of the page.
  4. Choose the Regular List option and click Next.
  5. Now, select the Import From A Service option then, click Next.
  6. Scroll down and click on the Google Drive integration icon
  7. Connect to Google Drive by clicking on the Google Drive icon.
  8. On the Google page, choose an account to continue.
  9. Now, select the Allow button.
  10. When prompted back to Benchmark, select a Google Drive Spreadsheet, Worksheet and a Benchmark Contact List or create a new list.
  11. Click Save & Next.
  12. Select and match the fields to be mapped, click Save & Next when done.

Important

  • Email Field- if not labeled as “email” our system can not detect this column in your sheet.

Important

  • You can only import files created on Google Drive.
  • This integration can only import files owned/created by you. If you are trying to import a sheet that you do not own, we recommend you first create a copy of the data to a new sheet in your Google Drive.
  • We recommend you delete all empty columns from the sheet you are importing. Empty columns may cause the integration to break.
  • If trying to import an external file to Google Drive, the data must be in the format XLS or XLSX.
  • If there are multiple sheets in the file, only the first sheet will be imported.

The final number of imported contacts may be less than the projected number due to the filtering of certain emails. Benchmark Email removes role-based emails, duplicates, unsubscribes and blocked domains. Click Here to learn more.

Note: Since this integration offers a one-time import if you need to import more contacts at a later time, you will have to repeat the steps above. However, when you go to import again, you can choose the previous connection or create a new one.

If you have additional questions, please feel free to contact our Support team via email, LiveChat or by phone.

Did this answer your questions?
0 0

Can't find what you're looking for?

Submit a Ticket

view ticket history