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
- Create a Reviews CMS Collection in Webflow with relevant fields (Name, Review Text, Rating, etc.).
- Structure your Google Sheet to match these fields and set up a Make scenario to watch new rows and send data to Webflow’s CMS.
- Use a Collection List in Webflow Designer to display CMS items dynamically on the reviews page.
To create a dynamic 'reviews' page in Webflow that auto-updates with data from Google Sheets, you need to connect Google Sheets to Webflow's CMS using an automation tool and publish updates automatically.
1. Set Up a Webflow CMS Collection for Reviews
- Go to Webflow Designer > CMS and create a new Collection called “Reviews” (or similar).
- Include essential fields like:
- Name (text)
- Review Text (rich text or plain text)
- Rating (number or text)
- Date (date field)
- Image (for user photos, if needed)
2. Prepare Your Google Sheet
- Structure your columns to match the Webflow CMS fields (e.g., Name, Review, Rating, etc.).
- Ensure each row represents a single review.
3. Connect Webflow and Google Sheets Using Make (formerly Integromat)
- Sign up at make.com and create a new scenario.
- Add the following steps:
- Google Sheets module: Use "Watch Rows" to monitor new rows added to your sheet.
- Webflow module: Use "Create Live Item" or "Update Live Item" to send data to the CMS.
- Authenticate both your Google and Webflow accounts during setup.
- Set field mappings to match your Google Sheet columns with Webflow CMS fields.
- Turn on the scenario and schedule it to run automatically (e.g., every 15 minutes).
4. Display CMS Items on the Reviews Page
- In Webflow Designer, go to your Reviews page.
- Add a Collection List bound to your Reviews CMS Collection.
- Design the layout to show the name, review text, and other fields dynamically.
5. Optional: Use Webflow Logic (Beta) or Other Tools
- Webflow Logic (if available) may offer limited features for internal automation but not direct Sheets support.
- Alternatively, Zapier is more beginner-friendly than Make but has fewer data handling capabilities with Webflow CMS.
Summary
To auto-update your Webflow reviews page from Google Sheets, create a CMS Collection in Webflow, connect it to Google Sheets using Make, and use a Collection List on the page to display reviews dynamically. This ensures your page updates automatically when new reviews are added to the sheet.