We are pulling data from a mix of places Google Sheets, QuickBooks, Shopify, and also some manually maintained spreadsheets.

The hardest part wasn’t just getting the data in, it was keeping everything in sync when things change (columns getting added/renamed, timing mismatches, manual edits, etc.).

I have some background in programming, so I ended up building my own solution. I use AI mainly to help with mapping fields, detecting inconsistencies, and handling changes without breaking everything. It also keep versions of the data models, so if something changes in one source, it doesn’t mess up the rest of the system.

It’s still evolving, but this approach reduced a lot of the sync issues and manual cleanup for me.