Census

Connect Census, a reverse ETL platform, with Webflow to sync data from your cloud warehouse directly to CMS collections and automate content updates.

Install app
View website
View lesson
A record settings
CNAME record settings
Census

How to integrate Census with Webflow

The easiest way to set up your Census Webflow integration is by using the Census app with OAuth authentication. You can also build with the Webflow and Census APIs for specialized use cases like cross-system data orchestration or real-time sync monitoring.

Use the Census app

The Census native integration syncs data from major cloud data warehouses (Snowflake, BigQuery, Redshift, Databricks) to Webflow CMS collections automatically.

Set up the integration through the Census Webflow connector:

  1. Navigate to Destinations in Census and click New Destination
  2. Select Webflow and authorize Census to access your Webflow account through OAuth
  3. Configure syncs by mapping your warehouse data to Webflow CMS collection fields using the Slug field as the unique record identifier
  4. Select your preferred sync behavior and configure your schedule

Census supports three sync behaviors:

  • Update or Create (Upsert): Creates new items when they don't exist or updates existing items when they do, using the slug field as the unique identifier
  • Update Only: Modifies existing Webflow items without creating new ones — useful for enriching manually created content
  • Mirror: Maintains exact synchronization between your warehouse and Webflow, including automatic deletions when items no longer exist in your source data

Caution: Mirror sync deletes items from Webflow that no longer exist in your Census source. If your source query has filtering errors or incomplete data, Mirror syncs can unintentionally delete production content. Test thoroughly before using Mirror in production.

Scheduling and field mapping

Configure syncs to run on custom schedules from weekly to continuous intervals. Trigger syncs after dbt Cloud or Fivetran jobs complete, use programmatic triggering via Census API, or chain multiple syncs in sequences when collections have reference field dependencies.

Use Census's visual interface to map warehouse columns to Webflow collection fields. The sync configuration supports conditional mappings like "Set If Empty" to avoid overwriting existing content, templated fields using Liquid syntax for data transformations, and options to skip null values.

Census automatically validates data before syncing — detecting null values in required fields, identifying duplicate slugs, automatically skipping problematic records, and reporting failures in the Census interface.

Important limitations

Webflow enforces a 10,000-item limit across all CMS collections combined on standard plans — not per collection. Plan your data architecture to stay within this constraint, or contact Webflow about Enterprise plans with higher limits.

The integration respects Webflow API rate limits of 60 requests per minute for Starter/Basic plans and 120 requests per minute for CMS/Business plans. Initial full syncs of large collections may take significant time — a 5,000-item sync on a Basic plan could take over 83 minutes.

Build with Webflow and Census APIs

The Census API (base URLs at https://app.getcensus.com/api/v1 for US and https://app-eu.getcensus.com/api/v1 for EU) and Webflow Data API support custom integration workflows for advanced use cases.

Monitor syncs with webhooks

Configure Census webhooks to receive real-time notifications when syncs complete or fail. Available events include sync.success, sync.failed, sync.completed, sync.triggered, sync.started, sync.alert.raised, and sync.alert.resolved.

Build middleware that receives Census webhook events and updates a Webflow collection tracking sync status, sends Slack notifications, or triggers cache invalidation for updated content. V

Frequently asked questions

  • Navigate to Destinations in Census and click New Destination. Select Webflow and log into your Webflow account to authorize Census access. After authorization, configure your first sync by selecting a source query from your warehouse, choosing a target Webflow collection, and mapping fields between your warehouse columns and Webflow collection fields.

  • Use Update or Create when you want Census to add new items and update existing ones based on the slug field. Choose Update Only when you need to enrich manually created Webflow content without creating new items. Select Mirror only when Webflow should exactly match your warehouse data, including deletions — test thoroughly before using Mirror in production since it permanently removes items no longer in your source.

  • Census automatically manages Webflow API rate limits of 60 requests per minute on Starter and Basic plans and 120 requests per minute on CMS, eCommerce, and Business plans through exponential backoff when receiving 429 responses. Initial full syncs of large collections take significant time due to these rate limits — a 5,000 item sync on a Basic plan could take over 83 minutes.

  • Yes, use Census sync sequences to chain syncs when collections have reference field dependencies. Reference fields in Webflow require Webflow-generated item IDs from target collections. Sync parent collections first and capture the returned Webflow item IDs, store these IDs back to your data warehouse, then configure dependent collection syncs to run after parent syncs complete using the stored IDs to populate reference fields.

  • Webflow enforces a 10,000-item limit across all CMS collections combined on standard plans — not per collection. Census syncs attempting to create items beyond the limit will fail. Consider splitting data across multiple Webflow sites, archiving old content, or upgrading to Webflow Enterprise for higher limits. Implement monitoring through Census sync alerts to catch capacity issues before they impact production.

Census
Census
Joined in

Description

Census is a Universal Data Platform that syncs data from cloud data warehouses like Snowflake, BigQuery, Redshift, and Databricks to over 200 business applications using SQL-based queries. The platform lets teams activate warehouse-resident data by pushing it to operational tools without manual exports.

Install app

This integration page is provided for informational and convenience purposes only.


Other Analytics and targeting tools integrations

Other Analytics and targeting tools integrations

Zuko

Zuko

Connect Zuko Analytics with Webflow to track detailed form interactions, identify drop-offs, and optimize conversion performance through behavioral insights.

Analytics and targeting tools
Learn more
The Facebook Pixel

The Facebook Pixel

Use the Facebook pixel to understand the actions people are taking on your website.

Analytics and targeting tools
Learn more
Optimizely

Optimizely

Add Optimizely's experimentation platform to your Webflow site for A/B testing and personalization.

Analytics and targeting tools
Learn more
Nocodelytics

Nocodelytics

Connect Nocodelytics with Webflow to track user behavior, clicks, and conversions without coding custom analytics.

Analytics and targeting tools
Learn more
Matomo (formerly Piwik)

Matomo (formerly Piwik)

Connect Matomo's privacy-focused analytics with Webflow to gain deep insights into visitor behavior while maintaining complete data ownership. Track conversions, visualize user journeys, and optimize your site's performance without compromising user privacy or sharing data with third parties.

Analytics and targeting tools
Learn more
Marketo

Marketo

Connect Marketo with Webflow to capture leads, track visitor behavior, and create personalized marketing campaigns directly from your Webflow site.

Analytics and targeting tools
Learn more
Klaviyo

Klaviyo

Connect Klaviyo's powerful email marketing and SMS automation with Webflow to create personalized customer journeys, capture leads through embedded forms, and sync e-commerce data for abandoned cart recovery and behavioral targeting — all without leaving your visual design environment.

Analytics and targeting tools
Learn more
Hotjar

Hotjar

Connect Hotjar's powerful user behavior analytics with Webflow to understand how visitors interact with your site. Track heatmaps, session recordings, and gather feedback to optimize user experience and boost conversions — all without coding.

Analytics and targeting tools
Learn more
Google Tag Manager

Google Tag Manager

Connect Google Tag Manager to Webflow to manage all your marketing and analytics tags from one central dashboard. Deploy tracking pixels, conversion scripts, and third-party tools without touching code, while maintaining site performance and privacy compliance.

Analytics and targeting tools
Learn more

Related integrations

No items found.

Get started for free

Try Webflow for as long as you like with our free Starter plan. Purchase a paid Site plan to publish, host, and unlock additional features.

Get started — it’s free