Look up from google drive to combine and aggregate data from multiple source files




  • Scott Henderson CTO
    Celigo University Level 1: Skilled
    Answer Pro
    Top Contributor

    I would recommend using integrator.io flows to load all the different data sources into a SQL database, and then you can use SQL to aggregate and/or join the data any way you like, and then if you want to sync the results of your queries back into your cloud apps, then it is super easy to build these "reverse etl" type flows too.

    There is no way to merge and aggregate different files together using only integrator.io flows, but flows can definitely help you get data from external files in a google drive folder into a SQL database, and then from a SQL database back into cloud apps or other files, etc...

  • Divya Navakumar
    Celigo University Level 3: Master

    Thank you, Scott 


Please sign in to leave a comment.