Get Data from multiple apps

I have a corporate account that will have multiple locations all with their own databases, no sub apps, individual paid apps. I need to pull the data from all locations, (info in their databases) into the corporate account and to then generate reports with all that information combined.

How can I do this?

I’ve tried figuring this out through the bubble app connector and/or api and I just simply don’t fully understand. Please help!

Currently pulled all the data, but still need to figure out how to combine the data together and generate averages, sums, total counts and more.

Maybe try Parabola to process the data

Thanks but looking more at just using google api at this point with sheets, send the data then do calculations, then send data back to corporate account with calculated number. trying to work on the google sheets api now.

Hey, Scott. Any luck with solving this problem?

I kind of facing the same problem right now and was woundering if google sheet api solved problem for you?