Hello,
Is there a way to automatically sync the CMS data to our own DB e.g MySQL? I have seen some tutorials on how to sync with Notion, Airtable,etc, but i am looking to sync it with our own DB
I’d recommend that you establish a single source of truth, and sync in one direction only.
If the CMS is your SSoT, you can code your CRUD operations manually as automations that trigger off of CMS webhooks, and update your MySQL db accordingly. Make, Zapier, n8n are all good automation platforms for this.
If MySQL is your SSoT, you can do the same, or look into internal triggers and add-ons that support outbound CRUD operations as updates occur.
Keep in mind if you’re planning to do batch operations in MySQL, you’ll quickly overwhelm the Webflow API’s rate limits. You might look into powerimporter pro and whalesync to see if they can buffer that for you adequately.
Hey Abhishek It is possible to automatically sync CMS data from Webflow to your own MySQL database. There are several tools and services available that can help achieve this. One option is to use a third-party integration tool such as Hightouch or Zapier to connect your MySQL database to Webflow and sync the CMS data automatically. Another option is to use a custom solution such as the Webflow external database syncing tool. It is important to experiment with different tools and configurations to achieve the desired functionality for your website, Try this -Connect your MySQL to Webflow integration in 2 minutes | Zapier
@ankitparmar Thanks for replying. The link that you shared triggers the zapier flow on form submission. We wanted the sync to get triggered whenever we make a change to any CMS item.
Use Webflow Webhooks.
They sync your CMS to an external source on create, update, and delete.
Any of those CRUD actions trigger the Webhook which then automatically sends that data to an external service. I usually add Make (Integromat) as the glue service to whatever datastore I’m moving it to, but it’s not required.
Here’s the API:
Here’s a tutorial on how to use it, and set it up in Webflow:
If you want to make your life easier you can use my Webflow Webhook Creator tool:
Via Make (Integromat):
Put all of this together and you get what you need
Hey Michael
In regards to MySQL (SSoT) sending changes to Webflow, would the updates made in an MySQL database have a long lag time before it syncs into the CMS in Webflow?
Do you know about High Touch as an option?
Depends on your sync code, but pretty much instantaneous once you make the API call.
There are strict API call limits though, I think 100 per minute? So this will begin to break down a bit if you are trying to push large volumes of data in over short timeframes.
Yeah interesting, really appreciate that Michael
Fingers crossed Webflow makes some large data syncing improvements down the line.
You can use Byteline to perform a 2-Way or 1-Way sync between MySQL and Webflow CMS. Byteline is a no-code platform, so this works by a simple configuration.
Following are some of the features:
- 2-Way : You can create, update, or delete a record on Webflow CMS or MySQL; it will sync to the other side. Optionally, you can choose a 1-Way sync.
- Webflow changes are synced in real-time using Webhooks. MySQL changes are detected using polling (5 mins).
- Custom filters : You can optionally configure filters to fine-tune the data to sync.
- Manages all field types , including multi-reference fields, URLs, numbers, and images.
- It offers a friendly dashboard showing each record change and field-level details.
- Historical sync : We sync the existing data before making the sync live.
Below is a short YouTube video to demonstrate the functionality.
I have created my own solution that allows to DIRECTLY integrate Webflow with databases such as MySQL and MongoDB, as well as Airtable and others, without CMS collections.
I have created four very large applications based on this solution (written in backend, not JS!) and I can confirm that everything has been working for years.
The architecture is a bit more complicated, but it allows you to add all possible enterprise tools as well as 3rd party services.
I tried to explain everything on Youtube. Please check https://www.youtube.com/watch?v=7eXX4-G3sqU
If you have any more questions, feel free to e-mail me (email in profile) - thanks