Create a copy of a group of entities

[maxcime]

Hi all, 

I have this structure:

Analysis, with many risks, with many actions, example:

Analysis

Analysis ID	Analysis Name
1	TestAnalysis

Risk

Risk ID	Risk Name	Analysis ID Ref	Value
1	Risk1	1	12
2	Risk2	1	26

Action

Action ID	Action Name	Risk ID Ref
1	Action1	2
2	Action2	2

In my App I can create another new empty analysis or create a new analysis copied from one existed (like the Alalysis with ID = 1). Beyond the copy of the analysis's values, I need to copy all the related risks and all the related action of each risk. Obviously, all the IDs must be changed with the correct references.

How can I do this operation automatically? Do I need AppsScript? I use Sheet like database.

Thank you for support

Best regards

Massimo Cimetti