How I Automate CMS Collections in Framer

How I Automate CMS Collections in Framer

New

New

New

  • Guide

  • Automate
  • CMS
  • Guide

  • Automate
  • CMS
  • Guide

  • Automate
  • CMS

How I Automate CMS Collections in Framer

In this blog, I’ll show you exactly how I automate CMS collections in Framer, plus I’ll reveal a secret plugin to save tons of time.

image of Nandi Muzsik

Posted by

Nandi

Framer CMS dashboard displaying plugin integration menu with Google Sheets selected, highlighting synced collections and template opportunity data for SEO content management
Framer CMS dashboard displaying plugin integration menu with Google Sheets selected, highlighting synced collections and template opportunity data for SEO content management
Framer CMS dashboard displaying plugin integration menu with Google Sheets selected, highlighting synced collections and template opportunity data for SEO content management

Table of contents

How do I automate it?

Well before automation, I managed my CMS collections manually inside Framer.

On Framer University, I had a Template Opportunity CMS collection that displayed various data points for my template opportunity page. Each item in the collection had several fields:

  • Name

  • Template count

  • Search volume

  • Opportunity score (calculated manually!)

  • Color (selected using a dropdown based on the opportunity score)

  • Slug (not relevant for this tutorial)

How do I automate it?

Well before automation, I managed my CMS collections manually inside Framer.

On Framer University, I had a Template Opportunity CMS collection that displayed various data points for my template opportunity page. Each item in the collection had several fields:

  • Name

  • Template count

  • Search volume

  • Opportunity score (calculated manually!)

  • Color (selected using a dropdown based on the opportunity score)

  • Slug (not relevant for this tutorial)

How do I automate it?

Well before automation, I managed my CMS collections manually inside Framer.

On Framer University, I had a Template Opportunity CMS collection that displayed various data points for my template opportunity page. Each item in the collection had several fields:

  • Name

  • Template count

  • Search volume

  • Opportunity score (calculated manually!)

  • Color (selected using a dropdown based on the opportunity score)

  • Slug (not relevant for this tutorial)

Different fields from original CMS.

Different fields from original CMS.

Different fields from original CMS.

Every time I wanted to update the data, I had to manually tweak each value in Framer, which was both tedious and time-consuming.

As you might already know, Framer released plugins. These are little apps inside Framer that allow you to basically create and achieve things that you wouldn't be able to do without them. So for example, you can add cool effects to images, or sync your CMS collections. with Notion or let's say Google Sheets.

Using the Google Sheets plugin

Move data to Google Sheets

Instead of manually inputting data into Framer, I transferred everything to Google Sheets. I set up formulas in Sheets to automatically calculate the opportunity score based on template count and search volume.

For example, if I changed the search volume from 1,900 to 1,500, the opportunity score would instantly recalculate.

Every time I wanted to update the data, I had to manually tweak each value in Framer, which was both tedious and time-consuming.

As you might already know, Framer released plugins. These are little apps inside Framer that allow you to basically create and achieve things that you wouldn't be able to do without them. So for example, you can add cool effects to images, or sync your CMS collections. with Notion or let's say Google Sheets.

Using the Google Sheets plugin

Move data to Google Sheets

Instead of manually inputting data into Framer, I transferred everything to Google Sheets. I set up formulas in Sheets to automatically calculate the opportunity score based on template count and search volume.

For example, if I changed the search volume from 1,900 to 1,500, the opportunity score would instantly recalculate.

Every time I wanted to update the data, I had to manually tweak each value in Framer, which was both tedious and time-consuming.

As you might already know, Framer released plugins. These are little apps inside Framer that allow you to basically create and achieve things that you wouldn't be able to do without them. So for example, you can add cool effects to images, or sync your CMS collections. with Notion or let's say Google Sheets.

Using the Google Sheets plugin

Move data to Google Sheets

Instead of manually inputting data into Framer, I transferred everything to Google Sheets. I set up formulas in Sheets to automatically calculate the opportunity score based on template count and search volume.

For example, if I changed the search volume from 1,900 to 1,500, the opportunity score would instantly recalculate.

Recalculating opportunity score instantly after changing search volume.

Recalculating opportunity score instantly after changing search volume.

Recalculating opportunity score instantly after changing search volume.

Sync Google Sheets with Framer

With the data structured in Google Sheets, I used Framer’s Sheets plugin to create a synced collection. This allows Framer to pull real-time data directly from my Google Sheet.

Here’s how it works:

  • The Sheets plugin links to a specific Google Sheet from my account.

  • The opportunity score and color fields update dynamically based on my formulas.

  • Any changes I make to template count or search volume in Sheets automatically reflect in Framer after syncing.

One-click sync

Now, instead of manually updating values in Framer, I simply:

  • Change template count or search volume in Google Sheets.

  • Click the Sync button in Framer’s CMS.

  • Done! Framer updates everything instantly, including the correct sorting order.

Sync Google Sheets with Framer

With the data structured in Google Sheets, I used Framer’s Sheets plugin to create a synced collection. This allows Framer to pull real-time data directly from my Google Sheet.

Here’s how it works:

  • The Sheets plugin links to a specific Google Sheet from my account.

  • The opportunity score and color fields update dynamically based on my formulas.

  • Any changes I make to template count or search volume in Sheets automatically reflect in Framer after syncing.

One-click sync

Now, instead of manually updating values in Framer, I simply:

  • Change template count or search volume in Google Sheets.

  • Click the Sync button in Framer’s CMS.

  • Done! Framer updates everything instantly, including the correct sorting order.

Sync Google Sheets with Framer

With the data structured in Google Sheets, I used Framer’s Sheets plugin to create a synced collection. This allows Framer to pull real-time data directly from my Google Sheet.

Here’s how it works:

  • The Sheets plugin links to a specific Google Sheet from my account.

  • The opportunity score and color fields update dynamically based on my formulas.

  • Any changes I make to template count or search volume in Sheets automatically reflect in Framer after syncing.

One-click sync

Now, instead of manually updating values in Framer, I simply:

  • Change template count or search volume in Google Sheets.

  • Click the Sync button in Framer’s CMS.

  • Done! Framer updates everything instantly, including the correct sorting order.

Syncing Sheets to Framer.

Syncing Sheets to Framer.

Syncing Sheets to Framer.

This means no more adjusting numbers, recalculating scores, or manually setting colors in Framer. It’s all handled in Sheets, and Framer imports the final, polished dataset.

Before automation, I had to:

  • Manually update search volume, template count, opportunity score, and color in Framer.

  • Recalculate scores one by one.

  • Adjust colors based on score ranges.

Now, all I do is update two values in Sheets, hit Sync in Framer, and everything updates perfectly. No extra steps, no headaches.

Wrapping up

If you’re working with CMS collections in Framer, stop wasting time with manual updates. The Sheets plugin is a game-changer, making your workflow way more efficient. With this setup, you can focus on building and designing, while your data updates itself in the background.

This means no more adjusting numbers, recalculating scores, or manually setting colors in Framer. It’s all handled in Sheets, and Framer imports the final, polished dataset.

Before automation, I had to:

  • Manually update search volume, template count, opportunity score, and color in Framer.

  • Recalculate scores one by one.

  • Adjust colors based on score ranges.

Now, all I do is update two values in Sheets, hit Sync in Framer, and everything updates perfectly. No extra steps, no headaches.

Wrapping up

If you’re working with CMS collections in Framer, stop wasting time with manual updates. The Sheets plugin is a game-changer, making your workflow way more efficient. With this setup, you can focus on building and designing, while your data updates itself in the background.

This means no more adjusting numbers, recalculating scores, or manually setting colors in Framer. It’s all handled in Sheets, and Framer imports the final, polished dataset.

Before automation, I had to:

  • Manually update search volume, template count, opportunity score, and color in Framer.

  • Recalculate scores one by one.

  • Adjust colors based on score ranges.

Now, all I do is update two values in Sheets, hit Sync in Framer, and everything updates perfectly. No extra steps, no headaches.

Wrapping up

If you’re working with CMS collections in Framer, stop wasting time with manual updates. The Sheets plugin is a game-changer, making your workflow way more efficient. With this setup, you can focus on building and designing, while your data updates itself in the background.

Framer Navigator

Learn the fundamentals of Framer for free.

Build your ideas with ease by learning the basics of website building with Framer.

Nandi portrait's background
Nandi's portrait

Framer Navigator

Learn the fundamentals of Framer for free.

Build your ideas with ease by learning the basics of website building with Framer.

Nandi portrait's background
Nandi's portrait

Framer Navigator

Learn the fundamentals of Framer for free.

Build your ideas with ease by learning the basics of website building with Framer.

Nandi portrait's background
Nandi's portrait

More posts

More posts

  • Framer University waitlist signup page featuring a futuristic landscape illustration with a lone figure overlooking a city beneath a massive floating structure

    Building a Hero Section with Midjourney + Framer

    Guide

    Framer University waitlist signup page featuring a futuristic landscape illustration with a lone figure overlooking a city beneath a massive floating structure

    Building a Hero Section with Midjourney + Framer

    Guide

    Framer University waitlist signup page featuring a futuristic landscape illustration with a lone figure overlooking a city beneath a massive floating structure

    Building a Hero Section with Midjourney + Framer

    Guide

  • Typography-focused visual with the phrase 'No More Layout Jumping' in varying font sizes and weights on a dark background, emphasizing smooth web design transitions

    How to Avoid Layout Jump on Framer Websites

    Guide

    Typography-focused visual with the phrase 'No More Layout Jumping' in varying font sizes and weights on a dark background, emphasizing smooth web design transitions

    How to Avoid Layout Jump on Framer Websites

    Guide

    Typography-focused visual with the phrase 'No More Layout Jumping' in varying font sizes and weights on a dark background, emphasizing smooth web design transitions

    How to Avoid Layout Jump on Framer Websites

    Guide

Nandi Muzsik

How can I improve Framer Uni?

Let me know if there’s a missing feature or something that could be improved.

Share feedback

Nandi Muzsik

How can I improve Framer Uni?

Let me know if there’s a missing feature or something that could be improved.

Share feedback