How I Set Up an Automated CMS Collection with Google Sheets

Webflow is an incredible platform for building beautiful, dynamic websites. But if you’ve ever had to manually update dozens or hundreds of CMS elements, you know the pain is real.

So I automated the entire process using Google Sheets + Make.com (formerly Integromat). Now I can update content from a spreadsheet and it’s instantly reflected in Webflow CMS without coding, without stressing about APIs, without the hassle.

‍

Why automate Webflow CMS with Google Sheets?

‍

Let’s be honest: Webflow CMS is a powerful, but not always the most efficient tool for bulk editing or data management.

‍

Here’s what automation with Google Sheets gives you:

1. Easy spreadsheet-style editing
2. Real-time updates to your website
3. Sync new CMS items or edit existing ones
4. Better collaboration with clients or team members

‍

Tools I used

• Webflow (CMS enabled)
• Google Sheets (one spreadsheet = one CMS collection)
• Make.com (an automation tool that connects the two)
• (Optional) Zapier or Pabbly as alternatives

‍

How I set it up?

Step 1: Prepare your Google Sheet.Start with a clean spreadsheet.

• Column A: Title
• Column B: Slag
• Column C: Description
• Column D: Image URL (if using images)
• Column E: Any custom CMS fields (such as Category, Tags, etc.)

Make sure your column headers match the Webflow CMS fields you plan to populate.

‍

Step 2: Create a Webflow CMS CollectionSet up your CMS with the same fields as your table.

Example:

• Title (Plain Text)
• Slag (Automatic or Text)
• Description (Rich Text)
• Image (Image or URL)
• Category (Optional or Reference)

Tip: You can leave the CMS blank and it will auto-populate.

‍

Step 3: Set up the script in Make.com

• This is where the magic happens.
• Create a new scenario in Make.com
• Add the Google Sheets module → Row Tracking
• Connect to your spreadsheet
• Select a spreadsheet and set it to track new or updated rows
• Add the Webflow module → Create/Update CMS Item
• Connect your Webflow account (you’ll need an API key)
• Select a site and CMS collection
• Map each column from Google Sheets to the corresponding CMS field in Webflow
• (Optional) Add filters or routers if you want to send different content to different CMS collections.

‍

Step 4: Run and Test

Click “Run Once” in Make.com to test it out. If everything is set up correctly, your CMS collection should now be automatically populated from Google Sheets.

‍

Want Webflow to update your Google Sheets too?

‍

Just add another Webflow module at the beginning:

Trigger: Track new/updated CMS items in Webflow

Action: Update row in Google Sheets

You now have a fully synchronized system perfect for teams, VA workflows, and client data submissions.

‍

Things to watch out for:

1. Duplicate slugs will cause sync errors
2. Rich text fields require proper formatting
3. Image URLs must be direct links (e.g. from Dropbox or Google Drive, set to “public”)
4. Webflow API limits apply (60 requests per minute)
5. Test with 1–2 rows before scaling to hundreds.

‍

Setting up an automated Webflow CMS collection with Google Sheets has completely changed the way I work. I no longer dread major content updates and my clients love the ability to edit a spreadsheet instead of navigating through Webflow CMS.

It’s fast, scalable, and just plain smarter.