In Action, can we add a new row in parent sheet, get the id of the newly inserted data and insert that into a new child sheet?

[christoph]

You could first create a unique ID into a user specific column, insert that ID into the new row of your parent sheet, then have a relation looking for that ID and retrieve the Row ID through a lookup.