Skip to main content

MySql to Airtable Sync

  • June 11, 2018
  • 5 replies
  • 51 views

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.

Thanks!

5 replies

Forum|alt.badge.img+19
  • Inspiring
  • 351 replies
  • June 11, 2018

Hi Danny, we can help with this.

Ping me via email at dan@openside.com and I can provide more details.

Dan


  • Author
  • New Participant
  • 2 replies
  • June 11, 2018

Hi Danny, we can help with this.

Ping me via email at dan@openside.com and I can provide more details.

Dan


Sent you a message. Look forward to discussing.
Thanks!


Forum|alt.badge.img+3
  • Participating Frequently
  • 586 replies
  • June 12, 2018

Hi Danny,

This is something that is well within my area of expertise and I would be glad to help you out.
You can reach me on andrewjohnson56782@gmail.com

Best Wishes,
Andrew


  • Participating Frequently
  • 9 replies
  • June 20, 2018

Hey Danny,

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

Cheers


Forum|alt.badge.img+3
  • Known Participant
  • 13 replies
  • May 24, 2023

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.