Sync Insightly CRM to Google Sheets
Automatically sync your Insightly CRM data into Google Sheets with Flatly's no-code, triggerless, turnkey integration service.
Source: Insightly CRM
Insightly is a SaaS-based CRM solution targeted at small and mid-sized businesses.
Auth: Basic Authentication
Available datasets
- ActivitySets
- Contacts
- Contacts+Details Combo
- Contacts+Emails Combo
- Contacts+Events Combo
- Contacts+FileAttachments Combo
- Contacts+Links Combo
- Contacts+Notes Combo
- Contacts+Tasks Combo
- Countries
- Currencies
- CustomObjects
- CustomObjects+Records Combo
- Emails
- Emails+Comments Combo
- Emails+FollowRecords Combo
- Emails+File Attachments Combo
- File Categories
- Follows
- Leads
- Leads+Details Combo
- Leads+LinkEmailAddresses Combo
- Leads+Emails Combo
- Leads+Events Combo
- Leads+FileAttachments Combo
- Leads+Links Combo
- Leads+Notes Combo
- Lead Sources
- Lead Statuses
- Leads+Tasks Combo
- Milestones
- Notes
- Notes+Comments Combo
- Notes+FileAttachments Combo
- Opportunities
- Opportunities+Details Combo
- Opportunity Categories
- Opportunities+Emails Combo
- Opportunities+FileAttachments Combo
- Opportunities+Follows Combo
- Opportunities+Links Combo
- Opportunities+Notes Combo
- Opportunities+StateHistory Combo
- Opportunities+Tasks Combo
- Opportunity State Reasons
- Organisations
- Organisations+Details Combo
- Organisations+Events Combo
- Organisations+FileAttachments Combo
- Organisations+Follows Combo
- Organisations+Links Combo
- Organisations+Notes Combo
- Organisations+Tasks Combo
- Pipelines
- Pipeline Stages
- Price Books
- Products
- Project Categories
- Projects
- Projects+Details Combo
- Projects+Emails Combo
- Projects+Events Combo
- Projects+FileAttachments Combo
- Projects+Follows Combo
- Projects+Links Combo
- Projects+Milestones Combo
- Projects+Notes Combo
- Projects+Tasks Combo
- Quotes
- Relationships
- Task Categories
- Tasks
- Tasks+Details Combo
- Tasks+Comments Combo
- Tasks+Links Combo
- Teams
- Team Members
- Tickets-Alltime
- Tickets-Last X days Date-ranged
- Tickets+Details-Alltime Combo
- Tickets+Details-Last X days Combo Date-ranged
- Tickets+Comments-Alltime Combo
- Tickets+Comments-Last X days Combo Date-ranged
- Users
Destination: Google Sheets
Multiple Sheet Tabs in the same Sheet are supported. Google Sheets is an alias for Google Drive which supports multiple formats.
Auth: OAuth
Supported file formats
- Google Sheets (Parsed)
- Google Sheets (Raw)
- XLSX (Parsed)
- XLSX (Raw)
- CSV (Parsed)
- CSV (Raw)
- NDJSON
- Markdown (Table)
- Markdown (Key-Value)
How it works
- 1
Connect Insightly CRM
Authenticate Insightly CRM (Basic Authentication) and Google Sheets (OAuth) in the Flatly dashboard. You only have to do this once.
- 2
Choose your datasets
Pick which Insightly CRM datasets to sync and set your sync frequency. The frequencies available to you depend on your Flatly plan.
- 3
Data lands in Google Sheets
Flatly uploads your Insightly CRM data to Google Sheets automatically and refreshes it based on your sync frequency.
Google Sheets
Your data, live in Google Sheets
Flatly refreshes multiple sheets in your Google Drive using isolated folder permissions while still allowing custom naming, moving and sharing.
- Multiple Sheet Tabs Supported.
- Each synced data set gets its own named tab inside a single Google Sheet, so everything stays organized and easy to reference from formulas or Looker Studio.
- Minimal Drive permissions.
- Flatly only has access to its own App Folder — it cannot read or modify anything else in your Google Drive. It also requests your account email to track which Drive is connected to each job.
- Looker Studio ready.
- Google Looker Studio reads Google Sheets files directly from Google Drive, making it easy to build dashboards on top of your synced data without any additional connectors.
“The interface is unbelievable. Flatly is so easy to use. After years of struggling with Zapier this is life changing.”
Full data refresh
Maintain up-to-date flat files when any nested or bundled data changes in your source app.
Connection Management
Manage multiple tenants, with connection health monitoring.
Bulk Job Management
Control multiple jobs at the same time, with live progress monitoring.
Merged datasets
Export left-joined combo objects like deals+products.
Write options
Refresh one flat file or create a stack of timestamped versions.
Filterability
Include only the columns or views essential for your reporting.
Notifications
Get alerts about your syncs via email, webhooks or Slack notifications.
Logging
Access up to one thousand log entries for your sync operations.
Custom Field Enrichment
Get useful values in your data instead of identifiers or definitions.
Metadata Attachment
See file statistics alongside your flat files to keep track of their origins.
Dark UI Mode
Reduce eye strain and save energy by using our built in dark mode.
Programmatic Jobs
Queue jobs by making API calls or agent requests.
Time Stamp Enrichment
Get human-readable dates and times from UNIX timestamps.
High frequency
10-minute refresh cycles mean your data store is near real-time.
High capacity
Reliably flatten billions of cells to CSV files without hiccups.
Advanced Security
Two-factor authentication and Destination Lock controls.
Stripe-powered Billing
Reliable payments provider with automatic, familiar invoicing and 1% of Sales to Stripe Climate.
Mobile access
Manage your sync operations from your phone if you are traveling.
Connect Insightly CRM to Google Sheets
Get started today with a 14-day free trial. No credit card required. Both human and AI support are available.