What is the most effective way to connect Webflow and Google Sheets to create a dynamic 'reviews' page that updates automatically with new reviews from the Google Sheet?
TL;DR
- Use Make.com to watch changes in a structured Google Sheet and connect it to a Webflow CMS collection with matching fields.
- Automate syncing by mapping sheet columns to CMS fields and schedule regular updates, then display reviews on a Webflow page using a CMS collection list.
To create a dynamic 'reviews' page in Webflow that automatically updates from Google Sheets, you need to connect the sheet to Webflow’s CMS using automation. Here’s the most effective and reliable method.
1. Connect Google Sheets to Webflow via Make (Integromat)
- Sign up at Make.com (formerly Integromat), a powerful no-code automation tool.
- Create a new Scenario and set Google Sheets as the trigger.
- Authenticate Google Sheets and choose the trigger type — use “Watch Rows” or “Watch Changes” depending on your needs.
- Select your spreadsheet and worksheet that contains the reviews data.
2. Format Your Google Sheet Properly
- Set up structured columns in your Google Sheet for fields like:
- Reviewer Name
- Rating (optional)
- Review Text
- Date (optional)
- Image URL (optional)
- Make sure the sheet has a header row for your columns.
3. Set Up Webflow CMS Collection for Reviews
- In Webflow, go to CMS → Create New Collection and name it “Reviews”.
- Add fields that match your Google Sheet columns (e.g., Name, Review, Rating, etc.).
- Make sure the field types match — for example:
- Review text → Rich Text
- Image URL → Image
- Rating → Number
4. Add a Webflow Module in Make.com
- In the same scenario, add a new module for Webflow → “Create a Live Item”.
- Connect your Webflow account via API Key (copy it from Webflow → Account Settings → API).
- Choose your site and the “Reviews” collection.
- Map each Google Sheet column to the corresponding Webflow CMS field.
5. Automate the Sync and Set Schedule
- Set your scenario to run on a schedule (e.g., every hour) or in real-time if preferred.
- Enable your scenario once finished, and test with a sample row.
6. Design the Reviews Page in Webflow
- Go to Pages → Create a new CMS Template Page for the Reviews collection.
- Or use the CMS collection list on a static page to show multiple reviews.
- Style the items using Collection List components (bind them to CMS fields).
Summary
The most effective method is using Make.com to sync Google Sheets to Webflow’s CMS. Set up a collection for reviews, automate data sync via Make, and display the results using Webflow’s CMS tools. This ensures your reviews page updates automatically whenever new entries are added to the Sheet.