Google Sheets

Google Sheets is a natural home for lead lists. Connect it to import rows as contacts.

What you can do

• Import — read a spreadsheet’s rows and ingest each as a contact.

Google Sheets is a source. OpenContact lists your spreadsheets, and for the one you pick, reads the rows and runs them through the pipeline.

How to connect

1. In OpenContact, go to Connections → Google Sheets and click Connect.
2. Authorize OpenContact with your Google account (read-only access to your sheets).
3. Your spreadsheets become importable.

Preparing your sheet

OpenContact maps columns by their header row. Include a header named Email (required), and optionally First Name and Last Name. Rows without an email are skipped.

Example

Keep a shared “Event signups” sheet and import it into OpenContact, verify the addresses, and fan the clean ones out to your ESP. See Importing contacts.