I have multiple Google Forms that output different data (answers) and I am adding more and varied forms every day. (so I have a lot of individual sheets collecting various data) However, some of that data is universal, for example, name, email, age, date of birth etc. (about 25 fields ALWAYS have the same column name, IN THE SAME ORDER in sheets results for every form) I want to create a zap that will populate a single “Master Sheet” with the fields that are “universal” to every sheet without having to map each of those fields every time a new form is created.
It’s quick and easy to set a zap that triggers on “New Row Created”, and that generates the data I need. And the action “Create New Row” is simple as well. But mapping all the fields for each new form is very time consuming. Is there a way to automatically associate by column name instead?? It’s super frustrating because all the data I need have the same “name” but are keyed to different sheets. I can’t figure out how to automate this association.
Ideally, the Zap would:
- Trigger on “New Row Created” in any worksheet within a sheet. (I can create a zap for each worksheet but it would be better to automate it because I’m adding sheets everyday)
- (this is really the key) The data returned by the trigger would be disassociated with the google sheet and become “stand alone” values, just a column name and a value.
- Action “Create New Row” would populate a new row in my separate Master Sheet with the values returned by the “stand alone” step. (Avoiding having to remap the fields for every new sheet)
Alternatively:
- A sheets or zap function that would automatically make a copy of any new row (in its entirety, not mapped) and past it into the Master Sheet. The fields I need are the first 20 or so, in the same order, with the same column names in each sheet created. I just need it to populate in a single step.
Ideas??