Connectors

/

Insightly

Data replication

Sync Insightly data anywhere.

Insightly is a cloud-based customer relationship management (CRM) software that helps businesses manage their sales, marketing, and customer service activities. It provides a centralized platform for managing customer interactions, tracking leads and opportunities, and automating workflows. Insightly also offers project management tools, allowing teams to collaborate on tasks and projects, and track progress in real-time. The software integrates with popular business applications such as Google Apps, Office 365, and Mailchimp, making it easy to streamline workflows and improve productivity. With Insightly, businesses can gain valuable insights into their customers and improve their overall customer experience.

  • Standard
  • Alpha
  • 37 streams
Sync Insightly dataRead the docs
Insightly

One connector

Everything Insightly can do in Airbyte

  • Sync to your warehouse

    Land 37 Insightly tables in 50+ destinations on a schedule you control.

  • Incremental syncs

    Pull only the records that changed since the last run instead of reloading everything.

  • One authorization

    Authenticate Insightly once and Airbyte keeps every scheduled sync running on it.

  • Cloud or self-hosted

    Run the Insightly connector on Cloud, Self-Managed Enterprise.

Specifications

What to know before you sync Insightly

  • Support levelStandard
  • Available onCloud, Self-Managed Enterprise
  • Connector version0.3.26
  • Release stageAlpha

Sync capabilities

  • Full Refresh SyncSupported
  • Incremental SyncSupported
  • Destinations50+ Airbyte connectors

Set up in 10 steps

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

37 streams

Every table you can sync from Insightly

  • Activity Sets

  • Contacts

  • Countries

  • Currencies

  • Emails

  • Events

  • Knowledge Article Categories

  • Knowledge Article Folders

  • Knowledge Articles

  • Leads

  • Lead Sources

  • Lead Statuses

  • Milestones

  • Notes

  • Opportunities

  • Opportunity Categories

  • Opportunity Products

  • Opportunity State Reasons

  • Organisations

  • Pipelines

  • Pipeline Stages

  • Price Book Entries

  • Price Books

  • Products

  • Project Categories

  • Projects

  • Prospects

  • Quote Products

  • Quotes

  • Relationships

  • Tags

  • Task Categories

  • Tasks

  • Team Members

  • Teams

  • Tickets

  • Users

Authentication

Authenticate Insightly once

  • API Token

    Your Insightly API token.

Explore

Related connectors

IntercomSales & Support AnalyticsCertified Sources cloudself-managed-enterprise
JobNimbusSales & Support AnalyticsStandard Sources cloudself-managed-enterprise
JustCallSales & Support AnalyticsStandard Sources cloudself-managed-enterprise
Klaus ApiSales & Support AnalyticsStandard Sources cloudself-managed-enterprise
Less Annoying CRMSales & Support AnalyticsStandard Sources cloudself-managed-enterprise
MissiveSales & Support AnalyticsStandard Sources cloudself-managed-enterprise
All connectors

Common questions

Didn't find your answer?
Please don't hesitate to reach out.

Talk to sales

ETL, an acronym for Extract, Transform, Load, is a vital data integration process. It involves extracting data from diverse sources, transforming it into a usable format, and loading it into a database, data warehouse or data lake. This process enables meaningful data analysis, enhancing business intelligence.

Insightly's API provides access to a wide range of data related to customer relationship management (CRM) and project management. The following are the categories of data that can be accessed through Insightly's API:

1. Contacts: This includes information about individuals or organizations that are associated with a company, such as their name, email address, phone number, and job title.

2. Organizations: This includes information about companies or other types of organizations, such as their name, address, and industry.

3. Opportunities: This includes information about potential sales opportunities, such as the name of the opportunity, the expected revenue, and the stage of the sales process.

4. Projects: This includes information about ongoing projects, such as the project name, description, and status.

5. Tasks: This includes information about tasks that need to be completed as part of a project, such as the task name, due date, and status.

6. Events: This includes information about events that are scheduled, such as the event name, date, and location.

7. Notes: This includes information about notes that have been added to a contact, organization, opportunity, project, or task.

8. Emails: This includes information about emails that have been sent or received by a contact or organization.

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

The most prominent ETL tools to transfer data to include: Airbyte, Fivetran, StitchData, Matillion, Talend Data Integration. These tools help in extracting data from various sources (APIs, databases, and more), transforming it efficiently, and loading it into and other databases, data warehouses and data lakes, enhancing data management capabilities.

ELT, standing for Extract, Load, Transform, is a modern take on the traditional ETL data integration process. In ELT, data is first extracted from various sources, loaded directly into a data warehouse, and then transformed. This approach enhances data processing speed, analytical flexibility and autonomy.

ETL and ELT are critical data integration strategies with key differences. ETL (Extract, Transform, Load) transforms data before loading, ideal for structured data. In contrast, ELT (Extract, Load, Transform) loads data before transformation, perfect for processing large, diverse data sets in modern data warehouses. ELT is becoming the new standard as it offers a lot more flexibility and autonomy to data analysts.

Start moving Insightly data today

Free for 14 days on Airbyte Cloud. Set up the Insightly connector once and let Airbyte keep it in sync.

Try it freeTalk to sales