Similar to for those who know Google Merchant Center, I want to automatically fetch the CSV (Google Sheet file) to some collections that update on a regular basis.
Example: We realse monthly news / stories to our website, I want to skip the manual labour of checking each list that is going to have continued updates to make sure they were properly updated.
Since the copy writers of these news articles and other projects won’t have any time nor access to update this in the editor or designer, I want them to upload it in the csv and for that to then be fetched automatically on the 1st of every month.
I do not belive this requires a link, just a general function question I have been unable to find an answer to so for in the university nor other forums.
I’m not clear on which direction you’re trying to automate.
Is the data in a Google Sheet file, and you’re trying to automate updating the Webflow CMS from that sheet?
If that’s correct, you can use an automation platform like Make or Zapier. I’d probably recommend that you make those updates transactionally, as they happen rather than monthly, as it’s easier to determine what has changed, and the Webflow API works with one add/update/delete at a time anyway.
For what it’s worth, there are a number of solutions that will automate synchronization against AirTable for this kind of work. AirTable has a nicer, more controlled interface where you get built in type safety on the columns ( numbers, dates, etc ) that Sheets can’t provide. Those sync solutions cost a bit, but will eliminate a lot of setup for you particularly if you need a full 2-way sync. Check out Whalesync and Power Importer Pro.