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?
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.
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.