Move Insightly data anywhere it matters.

Sync Insightly activity sets, contacts and countries to any warehouse or AI app.

Sync Insightly free Read the docs

Source

Insightly

Snowflake
BigQuery
Postgres
Databricks
Claude

Streams: 37
Destinations: 50+
Standard support: 0.3.26

Overview

What is the Airbyte Insightly connector?

The Airbyte Insightly connector extracts data from Insightly and loads it into 50+ destinations such as Snowflake, BigQuery, Databricks or Postgres, with full refresh and incremental sync. It publishes 37 streams you can select per connection.

01
Sync to your warehouse
Land 37 Insightly tables in 50+ destinations on a schedule you control.
02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
03
One authorization
Authenticate Insightly once and Airbyte keeps every scheduled sync running on it.
04
Cloud or self-hosted
Run the Insightly connector on Cloud, OSS, Hybrid.

37 streams

Every table you can sync from Insightly

Activity Sets
Sync modes FullIncr.
Contacts
Sync modes FullIncr.
Countries
Sync modes FullIncr.
Currencies
Sync modes FullIncr.
Emails
Sync modes FullIncr.
Events
Sync modes FullIncr.

Activity Sets
Sync modes	FullIncr.

Contacts
Sync modes	FullIncr.

Countries
Sync modes	FullIncr.

Currencies
Sync modes	FullIncr.

Emails
Sync modes	FullIncr.

Events
Sync modes	FullIncr.

Setup

Live in ten steps

Go to the Airbyte website and sign up for an account.
Once you have logged in, click on the ""Sources"" tab on the left-hand side of the screen.
Scroll down until you find the Insightly source connector and click on it.
Click on the ""Create new connection"" button.
Enter your Insightly API key and click on the ""Test connection"" button to ensure that the connection is working properly.
Once the connection has been tested successfully, click on the ""Save & Continue"" button.
Choose the data you want to sync from Insightly and click on the ""Save & Continue"" button.
Configure the sync settings, such as the frequency of the sync and the destination for the data.
Click on the ""Save & Run"" button to start the sync process.
Monitor the sync progress and ensure that the data is being transferred correctly.

Configuration fields

Insightly configuration fields
Field	Type	Description
start_date*	string	The date from which you'd like to replicate data for Insightly in the format YYYY-MM-DDT00:00:00Z. All data generated after this date will be replicated. Note that it will be used only for incremental streams.
token*	string	Your Insightly API token.

Hybrid deployment

Sovereign by architecture, not by policy.

The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.

Cloud
OSS
Hybrid

Your environment

DataConnectorsCredentialsKeys

↕ metadata only

Airbyte control plane

OrchestrationMonitoringUI

FAQ

Insightly connector questions

What data can I sync from Insightly with Airbyte?

37 streams, including Activity Sets, Contacts, Countries, Currencies, Emails, Events, Knowledge Article Categories, Knowledge Article Folders and more.

Does the Insightly connector support incremental sync?

Yes. The Insightly connector supports incremental sync on selected streams, and full refresh on every stream.

Where can I run the Insightly connector?

Run the Insightly connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.

Didn't find your answer? Talk to sales