We have MySql tables full of attributes, inventory, etc and want to sync this with Airtable multiple times a day. Not only new record additions, but also changes to data in existing rows.
If you have the skills to accomplish a sync of record updates and row additions, please message me or provide contact details and work reference.
I just finished building an application that does this. I can probably offer a solid solution with a custom Laravel App.
My application does the following currently:
Creates new records from mysql to airtable and it updates records every X minutes/hours.
It also has a link to execute updates on specific rows instantly
It also allows updating the database records from Airtable and a record of the changes made is kept on a separate Airtable for security reasons.
It’s pretty neat and something that is not possible to do with tools such as Zapier. You can reach me via contact%(at)%danielfarina.com
Leaving this here for anyone who comes across this in the future. There are some ETL solutions out there that solve this (workflow automation tools like Zapier don't suit this use case well).
Tools like Bracket track updates to existing cells, new rows, and even deleted content in both sources. So changes in Airtable are reflected in mySQL and vice-versa. You can also set changes to sync in only one direction if that fits your use case better too.