From ActiveCampaign to Google Sheets: managed, scheduled, no code.
Kondado replicates 29 ActiveCampaign pipelines with 644 fields to Google Sheets on a configurable schedule ranging from every 5 minutes to daily, enabling automated reporting and analysis without coding.
Kondado enables you to send ActiveCampaign data to Google Sheets through a direct integration that automates data replication. Connect your ActiveCampaign account as a data source, designate Google Sheets as your destination, and select from 29 available pipelines containing your marketing, sales, and CRM information. The platform transfers your data on a configurable schedule, eliminating manual CSV exports and ensuring your team always works with current information.
With your ActiveCampaign data automatically flowing into Google Sheets, you can build custom reports, share live dashboards with stakeholders, and combine marketing metrics with other business data sources. This automation saves hours of manual work while keeping your agency or internal teams aligned on campaign performance and customer engagement metrics.
What You Can Do With ActiveCampaign Data in Google Sheets
Once your data arrives in Google Sheets, you can analyze the Contacts pipeline to segment audiences by custom field values and tag assignments, or track deal progression using the Deals pipeline to monitor pipeline health and forecast revenue. The Campaigns pipeline allows you to correlate email performance metrics with sales outcomes, creating unified views that connect marketing activities directly to revenue impact. These automated data flows enable agencies and marketing teams to build dynamic scorecards, calculate conversion rates across custom dimensions, and share live insights with clients or executives without manual data preparation.
Try out all the features for free for 14 days
Replicated to Google Sheets
ActiveCampaign data available for Google Sheets
Tables Kondado writes into your Google Sheets, on a schedule you control.
29
available pipelines
644
extractable fields
Google Sheets
Destination
Available integrations
Accounts
Contains information about accounts, including ID, registered URL, contact count, and account name.
Accounts: Contacts
Presents relationships between accounts and contacts, including account and contact IDs, as well as the creation timestamp of the link.
Accounts: Custom Fields (Data)
Includes values of custom fields for accounts, such as value ID, account ID, and creation timestamp.
Accounts: Custom Fields (Meta)
Provides metadata for custom fields, including field ID, field type, and available options.
Accounts: Notes
Records notes associated with accounts, featuring fields like note ID, note text, and creation date.
Campaigns
Contains data about campaigns, including ID, campaign name, and current status.
Campaigns: Messages
Presents messages sent in campaigns, with fields such as message ID and message content.
Campaigns: Messages: Content
Includes the content of campaign messages, detailing the text and visual elements used.
Contacts
Stores information about contacts, including ID, name, and contact details.
Contacts: Custom Fields (Data)
Contains values of custom fields for contacts, such as value ID and associated contact ID.
Contacts: custom fields (meta)
Includes metadata such as field ID, type, available options, and whether the field is required or visible in forms.
Contacts: list activity
Records contact activity in lists, including contact ID, list ID, and date/time of the activity.
Contacts: notes
Contains notes associated with contacts, featuring fields like note ID, note text, and creation date.
Contacts: tags
List of tags assigned to contacts, including tag ID, contact ID, and tag creation date.
Contacts: tasks
Includes tasks related to contacts, featuring fields like task ID, status, and due date.
Deals
Represents deals with fields like deal ID, value, status, and creation date.
Deals: activities
Records activities associated with deals, including activity ID, type, and activity date.
Deals: custom fields (data)
Contains values of custom fields for deals, including field ID and field value.
Deals: custom fields (meta)
Includes metadata for custom fields of deals, such as field ID, type, and whether it is required.
Deals: secondary contacts
List of secondary contacts associated with deals, including contact IDs and deal IDs.
Deals Tasks
View tasks associated with deals, including fields such as ID, status, and created timestamp.
Lists
Manage contact lists, with information on ID, name, and contact count.
List Contacts
Examine the relationship between lists and contacts, including list ID, contact ID, and created timestamp.
Pipelines
Visualize sales pipelines, with details on ID, name, and stages of deals.
Scores
Track scores assigned to contacts or deals, including ID and score value.
Tasks Outcomes
Analyze task outcomes, with fields such as ID, status, and completion date.
Tasks Types
Explore different types of tasks, including ID, name, and description.
User Groups
Manage user groups, with information on ID, name, and assigned permissions.
Users
View information about users, including ID, name, and created timestamp.
Sync data automatically — no code, no manual exports.
1
Connect ActiveCampaign on Kondado
Authenticate your ActiveCampaign credentials to establish the data source connection, enabling access to your marketing automation and CRM pipelines.
2
Configure Google Sheets destination
Designate Google Sheets as your target and specify the workbook where your data should land, ensuring proper sharing permissions for your team.
3
Select data and set schedule
Choose from 29 available pipelines including Contacts, Deals, and Campaigns, then configure your update frequency from every 5 minutes to daily to keep reports current.
Try out all the features for free for 14 days
Hundreds of data-driven companies trust Kondado
Why Kondado?
Focus on extracting value from your data and leave the rest to us
Answers about sending ActiveCampaign data to Google Sheets automatically
How often can I schedule ActiveCampaign data updates in Google Sheets?▼
Kondado offers configurable update frequencies ranging from every 5 minutes to daily, allowing you to balance data freshness with API usage. You can set different schedules for different pipelines, such as updating Contacts every 15 minutes while refreshing Campaigns data daily. This flexibility ensures your Google Sheets reports reflect near-real-time information without overwhelming your ActiveCampaign API limits.
Which specific ActiveCampaign objects can I replicate to spreadsheets?▼
You can replicate 29 distinct pipelines including Contacts, Deals, Campaigns, Accounts, and Lists, encompassing 644 total fields of marketing and CRM data. This includes related data such as Contacts: Tags, Deals: Activities, and Campaigns: Messages, enabling comprehensive analysis of customer relationships and marketing performance. Each pipeline arrives as a separate sheet or tab within your Google Sheets workbook.
Can I merge ActiveCampaign contact data with sales data from other platforms in Google Sheets?▼
Yes, you can replicate data from multiple sources into the same Google Sheets workbook, then use VLOOKUP or QUERY functions to join ActiveCampaign contact records with information from PostgreSQL, MySQL, or other CRM systems. This enables unified customer views that connect marketing engagement metrics with transaction histories or support tickets. Many users create master dashboards that blend ActiveCampaign pipeline data with financial or operational datasets.
What happens to my existing formulas when new ActiveCampaign data arrives?▼
Kondado updates the data ranges within your designated sheets while preserving any formulas, charts, or pivot tables you've built in adjacent columns or separate sheets. Your calculated fields and dashboard references remain intact as the underlying contact, deal, or campaign data refreshes automatically. This allows you to build persistent reporting frameworks that update seamlessly with each scheduled replication.
How do custom fields from ActiveCampaign appear in Google Sheets?▼
Custom fields replicate through dedicated pipelines such as Contacts: Custom Fields (Data) and Deals: Custom Fields (Data), which store the actual values linked to your records. The corresponding metadata pipelines provide field definitions, types, and available options, helping you interpret the values correctly in your Google Sheets formulas. This structure maintains data integrity while giving you full visibility into your custom field configurations.
Is it possible to send ActiveCampaign data to Power BI or BigQuery instead of Google Sheets?▼
Absolutely, Kondado supports multiple destinations allowing you to send the same ActiveCampaign pipelines to Power BI, BigQuery, Looker Studio, or Google Sheets simultaneously. You can configure different destinations for different use cases, such as sending detailed contact data to BigQuery for SQL analysis while delivering summary reports to Google Sheets for executive review. This flexibility supports diverse analytical workflows across your organization.
Can I filter which contacts or deals get replicated to Google Sheets?▼
While Kondado replicates entire pipelines, you can apply filters within Google Sheets using QUERY functions or filter views to display only specific segments, such as contacts with particular tags or deals in specific stages. For more granular control at the source level, you can select specific pipelines like Contacts: Tags or Deals: secondary contacts rather than replicating the full contact or deal tables. This approach lets you tailor your data volume to specific reporting needs.
'%3E%3Cpath d='M51,41a9.978,9.978,0,0,0-7.857,3.835L22.648,34.588a9.69,9.69,0,0,0,0-5.176l20.5-10.247a10.1,10.1,0,1,0-1.791-3.577L20.857,25.835a10,10,0,1,0,0,12.33L41.352,48.412A9.994,9.994,0,1,0,51,41Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M33,47.645V60.71c.024-.014.05-.018.073-.033l11-7A2,2,0,0,0,45,51.992V40.012Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M31,47.645,19,40.011V51.992a2,2,0,0,0,.927,1.688l11,7c.023.015.049.019.073.033Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M32,21.693l12-7.634L33.076,7.086a2,2,0,0,0-2.152,0L20,14.059Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M12,35.556,0,27.922V39.9A2,2,0,0,0,.927,41.59l11,7c.023.014.049.019.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M52,35.556l12-7.634V39.9a2,2,0,0,1-.927,1.687l-11,7c-.023.014-.049.019-.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M47,38.914a2,2,0,0,0-.924-1.686L38,32.074V27.922l12,7.634V48.621c-.024-.014-.05-.019-.073-.033L47,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M13,33.821l12-7.634L14.076,19.214a2,2,0,0,0-2.152,0L1,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M17,38.914a2,2,0,0,1,.924-1.686L26,32.074V27.922L14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M32,45.91l12-7.634L33.076,31.3a2,2,0,0,0-2.152,0L20,38.276Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M14.076,19.214a2,2,0,0,0-2.152,0L1,26.187l12,7.634,12-7.634Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M49.924,19.214a2,2,0,0,1,2.152,0L63,26.187,51,33.821,39,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M26,27.922,14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726V38.914a2,2,0,0,1,.924-1.686L26,32.074Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M27.076,25.138A2,2,0,0,1,28,26.824V30.8l1.848-1.179A4,4,0,0,1,31,29.123V23.428L19,15.794v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M36.924,25.138A2,2,0,0,0,36,26.824V30.8l-1.848-1.179A4,4,0,0,0,33,29.123V23.428l12-7.634v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M33.076,31.3a2,2,0,0,0-2.152,0L20,38.276,32,45.91l12-7.634Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M50.348,42.573c0-9.411-8.691-12.336-16.348-14.416v-16.1a32.837,32.837,0,0,1,9.363,1.656l2.778,1.11,2.228-5.57L45.584,8.134A38.043,38.043,0,0,0,34,6.046V1H30V6.081c-8.213.594-16.348,4.86-16.348,13.471,0,9.036,8.841,11.732,16.348,13.744V50.074a33.591,33.591,0,0,1-12.006-2.511l-2.683-1.341-2.684,5.367,2.684,1.342c.243.121,5.7,2.792,14.689,3.152V63h4V56.065C44,55.462,50.348,50.3,50.348,42.573Zm-30.7-23.021c0-5.133,5.96-7.016,10.348-7.446V27.071C23.512,25.243,19.652,23.535,19.652,19.552ZM34,50.043V34.393c6.5,1.882,10.348,3.761,10.348,8.18C44.348,48.377,37.873,49.744,34,50.043Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
