HOW TO MANAGE UPDATE/ADD DATA ACROSS SHEETS
I am collecting answers from an oline survey on a Sheet called Survey.
After a news row is added, I need an automation to check if the same email address is already present on a separate Sheet called Lead.
If yes, then I need the values from Survey to update the corresponding columns in Lead.
If not, I need a new row to be added at the bottom of Lead.
How can I do that?