Google Sheets
The Google Sheets pipe connects a spreadsheet to Active Reach in either direction. It’s the simplest way to get data in or out without code.
| Direction | What it does |
|---|---|
| Inbound (Sheet → Active Reach) | Read rows as contacts or events. Good for one-off list imports or a sheet your team keeps updated by hand. |
| Outbound (Active Reach → Sheet) | Append events (orders, opt-ins, conversions) to a tab as they happen — handy for quick pivots without a warehouse. |
Connect
Add the pipe
Go to Settings → Data Pipes → New pipe → Google Sheets.
Authorize Google
Sign in with the Google account that owns (or can edit) the sheet, and grant access. Active Reach only touches the sheet you select.
Pick the spreadsheet and tab
Choose the file and the worksheet (tab). For inbound, map the columns to contact fields (name, phone, email) or event properties. For outbound, choose which events to append and the column order.
Test and turn on
The wizard reads (or writes) a sample row so you can confirm the mapping before going live.
Field mapping
Inbound pipes map sheet columns to Active Reach fields. Phone and email are matched against existing contacts so you don’t create duplicates — a row updates the contact if it already exists, creates it if not.
Sync behaviour
- Inbound sheets are polled on a schedule; new and changed rows flow in.
- Outbound sheets receive rows in near-real-time as events fire.
- A header row is required and must stay stable — renaming a mapped column breaks the mapping until you re-map it.
Google Sheets is best for small to medium lists and ad-hoc exports. For high-volume or analytical workloads, use BigQuery or a warehouse connector.