Hi,
I’m wanting to create a ‘reviews’ page similar to this, however I want it to dynamically update based on data in a Google Sheet (which is where all our reviews currently go to). I.e. the ‘reviews’ page would update when new reviews are added to the Google Sheet.
What would be the best way to display/connect Webflow to GSheets to be able to do this?
Hi @TomWrench,
You could use Zapier to connect Google Sheets to Webflow.
You’ll need to create a Collection with whatever fields you need (reviewer name, review content, etc.). Whenever a new review is added to the Google Sheet, you can create a “live item” in the CMS that publishes automatically or just create an item in the Collection that’s ready to publish manually.
Thanks! This helps a lot 
However, we get thousands of reviews and I note the limit for the business plan is 10,000 items. Do you know if this limit can be increased?
I don’t know that there’s a way to increase that limit.
In an ideal world, you’d be able to add the reviews to your site from Google Sheets using the Zapier integration and then also delete older reviews using the API or an integration to stay under the limit. But as far as I can tell there’s no way to automate the deletion of Collection Items, so you’d have to delete them manually which isn’t ideal with the volume you’ve got.
I’m pasting a link to another thread that could help shed some light on what’s possible in terms of deleting items via the API.
Hi it can surely done with zapier but its paid and limit of 10,000 items. I have created a cloneable project that reads directly from google sheets using google v4 api have a look
https://webflow.com/website/Google-Sheets-data-in-Webflow
You should consider using Byteline data sync to update reviews (or other data) between Google Sheets and Webflow CMS. It offers 2-way and 1-way sync, eliminating the need for complex automation setups like Zaps.
With Byteline, any additions, modifications, or deletions in your Google Sheets are automatically mirrored in Webflow, ensuring your CMS stays up-to-date without manual intervention. Custom filters enable precise data synchronization, allowing you to sync only records that meet specific criteria.
Here are some key features:
Late to this thread, but wanted to share a simpler approach.
Instead of Zapier → CMS sync (which can hit limits and requires maintenance), you can turn your Google Sheet directly into a REST API and fetch it client-side.
I’ve been using a tool called GetSheetAPI for this - you point it at your sheet, get a JSON endpoint back, then fetch in Webflow custom code. No sync delays, no automation to maintain.
Pros:
For SEO, CMS sync is still better (crawlers need the content in HTML). But for a dynamic reviews wall like the Memberstack example, this client-side approach is way simpler.