At my company, we're looking to automize the process of sending a results report to users that answer an evaluation we have created via Google forms, since we do a lot of market research for clients we will definitely be creating new zaps for each research campaign our clients request. Since these forms are quite long, I was wondering if there is any way to just have Zapier copy a new row from one google sheet to another, our process for creating these evaluations is simple.
- An evaluation and/or survey created via Google forms
- A Google sheet (which we call a "calculator") that determines values and assigns scores based on each question's answers (in a lot of cases some of these questions are multiple choice, but each choice has different values assigned and are not always numerical, they can be used to categorize the respondent in some cases meaning the value given is qualitative and is dependent on the answers of other questions)
- A google slide with linked tables and graphs that summarizes the info from the Google sheet and serves as an easy-to-read report.
So far the process has just been coping the new responses from the form spreadsheet into the calculator sheet, then updating the slides presentation and exporting as a PDF.
In order to keep the automatization of the process simple and quick in the future, I'm looking for a way for the zap to simply trigger when there is a new response, and copy said response to the calculator worksheet (everything else I have figured out)
thank you to all who answer in advance
Best answer by MohSwellamView original