I was really excited to discover the workflow that automatically adds to a Google Sheet upon survey completion (instead of having to export and append each time).
However, I have some questions about the functionality if anyone can help. I'll be creating multiple surveys that use this workflow and I'll want the same column headers and piped text used each time, but I'll want it going to a different Google sheet for each survey. When I tried to copy a survey I was testing to see if it will work, it locks the Google sheet it points to so I can't just redirect it to another sheet. It's also painstaking to add all the fields I'll want to use so having a template workflow won't seem to work either. The only thing I can think of is to have all surveys dump into the same sheet and use a survey identifier to separate the responses later, but that sort of defeats part of the usefulness of this workflow! Any thoughts? Thanks!