Connect multiple CMS databases from multiple websites

I’d like to create a database of information on the “Mother Website” that pulls CMS items from the “Clone Websites”.

Essentially a bunch of clients would be updating their CMS items on their own and the Mother site would be reflecting those changes in either real time or published after approval. This can obviously be done with custom code and in the long run may be better off built outside of webflow considering the actual websites and CMS database is the product, but I don’t have enough money saved up yet to hire a proper team of developers.

I’ve heard rumours that Webflow is actually a bunch of individual websites hooked up into one, so maybe it’s possible but not really what it was intended for?

Do you guys think this would be best done through the Webflow API, a custom back-end dev, or by using airtable + make?

The diagram you shared above is great!

I’m a fan of the final option you suggested. I’d bring all your data into a centralized database (Airtable). Once it’s all in Airtable, you can clean it or approve it, and finally sync that into your Mother website.

One of the tricky parts in making this work with Make is getting updates to be real-time. We’re actually about to launch a two-way sync feature at Whalesync which should make this all much easier since we sync data in real-time.

Lmk if you’re still trying to build this and I can get you early access :).