Census
Connect Census, a reverse ETL platform, with Webflow to sync data from your cloud warehouse directly to CMS collections and automate content updates.
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:
- Navigate to Destinations in Census and click New Destination
- Select Webflow and authorize Census to access your Webflow account through OAuth
- Configure syncs by mapping your warehouse data to Webflow CMS collection fields using the Slug field as the unique record identifier
- 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.
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.
This integration page is provided for informational and convenience purposes only.
Google Analytics
Track website performance, user behavior, and marketing campaigns by connecting Google Analytics 4 with Webflow. Monitor traffic, conversions, and audience insights directly in your Webflow dashboard while maintaining complete design control and privacy compliance.
Awesome Table
Display dynamic, filterable tables and interactive data visualizations from Google Sheets directly on your Webflow site. Create searchable directories, live dashboards, and responsive data views without coding.
AddThis
Turn your visitors into engaged customers.
Related integrations
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.
