Need views for automation

Use case: I want the data from Table A,B,C,D,E,F to flow into Table G. I want this table G have data whenever a new record gets created in the tables. Initally I created a relationship but that isn't useful as the user has to pick a case every time. So my thought is to make couple pipelines to execute this. Please guide if I am doing it right?

------------------------------
XYZ
XYZ
------------------------------