Confused about how 3rd party automation works (Zapier, Integromat) with wix databases

I just got started with Wix about a week ago, and as I expected all of the more technical aspects of the platform are initially very confusing for me, which is why I’m reaching out here.

I am using wix for managing my online business. Prior to finding wix, I knew that I would need to set up processes to aggregate all of the data from all of the different platforms we use in which we need to receive or send data, so I decided to make a centralized database in airtable.

My original goal was to have this airtable database be the central source of all data from the business, allowing me to simplify automations (Made in integromat) by having all of them either going to or from one location as opposed to many.

After I made my database in airtable is when I made the switch to wix, which brings me to my issue. I am trying to figure out how to essentially connect/sync the wix database to the airtable database, so that way I can manage all dynamic web functions from airtable and have it automatically update the corresponding data in wix.

Now, I am not sure if this approach of having airtable as the central database is even the best approach now, since wix has it’s own database built in. Maybe it would be better to have the wix database be the core data source?

I know that the solution must be pretty straightforward, but the terminology and documentation is very foreign to me, so I would appreciate some guidance on this, as well as any resources that I can check out that will give me a good understanding of this side of the wix platform.

Any thoughts or suggestions are very much appreciated, thanks!!

Tommy, I see that you have had no answers yet. Are you still interested, or have you found a direction?