So I’ve been desperately trying to figure out a way to sort posts using the amount of view, but of course, Webflow doesn’t support this. I’ve seen people suggesting using Zapier but you can only get new Google Analytics Goal as triggers in Zapier, so here’s what I’ve attempted.
- Get Google Analytics Blog views into Google Sheets that updates once a day.
- Use Sheet & Zapier to update a views field in the Blog Article CMS.
So #1 was easy. Used the Google Sheets Google Analytics addon to create a report that filtered for Blog Posts and runs once a day:
Then added a sheet that would be used by on a daily bases to get the views and slug for Zapier using an Array and regexreplace:
The idea here was that I could update the CMS posts on a daily basis with the new Views. I regexed the slug as I can’t use Title (we have posts with the same name for different regions, so would need their slug and not title to find the post to update).
This is pretty much how far I got. I’ve got two issues, one, how do I update just the views field for the post? Two, can I identify the post using it’s slug and not it’s Title?
Hoping someone has the experience or brainpower to figure out his last step.