Linking SurveySparrow as a source
This source is currently in alpha. The interface and available tables may change.
The SurveySparrow connector syncs your survey and feedback data into the PostHog Data warehouse, so you can analyze surveys, responses, questions, and contacts alongside your product data.
Prerequisites
You need a SurveySparrow account that can create a private app, which is how SurveySparrow issues API access tokens.
Adding a data source
- In PostHog, go to the Sources tab of the data pipeline section.
- Click + New source and click Link next to this source.
- Enter your credentials (see Configuration below) and click Next.
- Select the tables you want to sync, choose a sync method and frequency, then click Import.
Once the syncs are complete, you can start querying this data in PostHog.
When linking SurveySparrow, you'll need:
- Access token – create a private app under Settings → Apps & Integrations in SurveySparrow and generate an access token. The token is displayed only once, so copy it when it's created.
- Data center – the region your SurveySparrow account is hosted in. Tokens are only valid against their own region's API host:
| Region | API host |
|---|---|
| US | api.surveysparrow.com |
| EU | eu-api.surveysparrow.com |
| Asia-Pacific | ap-api.surveysparrow.com |
| Middle East | me-api.surveysparrow.com |
| UK | eu-ln-api.surveysparrow.com |
| Sydney | ap-sy-app.surveysparrow.com |
| Canada | ca-api.surveysparrow.com |
If you're unsure which data center your account uses, check your SurveySparrow account settings or contact SurveySparrow support.
Sync modes
Each table can be synced in one of several modes, depending on what the source supports:
- Webhook (when available) – the source pushes changes to PostHog in real time. Fastest freshness, lowest ongoing cost, and the only mode that reliably captures updates and deletes.
- Incremental – only new or updated rows are synced on each run, using a cursor field (such as an
updated_attimestamp). Cheaper than a full refresh, but deletes aren't captured. - Append only – new rows are appended using a cursor field; existing rows are never updated. Ideal for immutable, append-only tables like event logs.
- Full refresh – the whole table is reloaded on every sync. Use it when a table has no reliable cursor or when you need deletions reflected.
See sync methods for a full explanation of how each mode works and how to choose between them.
The responses table supports incremental sync on completed_time, using SurveySparrow's server-side submission date filter. Only completed responses are synced – partial (in-progress) submissions are not imported. All other tables are full refresh only, since their API endpoints expose no reliable incremental cursor.
Configuration
| Option | Type | Required |
|---|---|---|
Access token | password | Yes |
Data center | select | Yes |
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
surveys | A survey in the SurveySparrow account, such as a conversational form, NPS, CSAT, or CES survey. | Full refresh | — | — |
responses | A completed submission to a survey, including the answers given to each question. | Incremental, Full refresh | completed_time | — |
questions | A question belonging to a survey. | Full refresh | — | — |
contacts | A contact stored in the SurveySparrow audience, used to share surveys and track who responded. | Full refresh | — | — |
contact_lists | A named list grouping contacts for survey distribution. | Full refresh | — | — |
Troubleshooting
- If you get an authorization error, your access token is invalid or revoked, or it's being sent to the wrong region. Check the data center matches your account, or generate a new token under Settings → Apps & Integrations, then reconnect.
- If you get a permission error, your access token is missing scopes for the resources you're syncing. Grant read access for those resources when creating the private app, then reconnect.
If your sync is failing or data looks wrong, see the Data warehouse troubleshooting guide. If that doesn't help, contact support – we're happy to help.