I want to implement a report function, but I don't know the steps

[wd9337812]

I have an external API to fetch data and a Googlesheet data source, how can I merge their data by primary key and display the report in my app, can you teach me the steps and what functions to use, thank you very much!