I'd like to combine 3 type of reports, that is report A, B and C. All of them are daily updated report by the logistics supplier and send to my email as attachments. at the end of month, I will get 30 emails for report A, 30 reports for report B, 30 reports for report C.
I use google script to automatically save the daily attachments in .xlsx onto Google drive files, file A for report A, file B for report B, file C to report C. the google script code is created not by me, I just searched it online and find it workable for my request. I can not adjust and create more code flexibly. I am a google script new hand.
By some certain fields, It is possible to join report A, B, C onto one consolidated report. but this process is manual at the moment.
the question is, can I have the report automatically consolidated by DOMO R / Python script?
because I will use the consolidated report to show dashboard finally on DOMO card. If DOMO can have this kind of coding function, I prefer to use DOMO rather than google script.
I think it should be at ETL there is a script area for me to create code. but I failed to find it pls see the following screenshot.