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.
Posted by
Nandi
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.
