Hi all.
I have a zap where it insert the row to the sheets whenever there is form submission.
However, I would like to create another zap to retrieve all the data of the row in the sheets.
The trigger action is row inserted in sheets, then send email.
But when I test trigger, it shows only the row and ID, no other data anymore.
The reason for having two separate zap is because I have some columns in the sheets that set the value through the formula.
Is there any suggestion or solution for this?