Collect and organize feedback with Appcues + Zapier + Google Sheets
Appcues + Zapier + Google Sheets
Instead of exporting all of your valuable in-app survey data, pasting it into sheets, and moving everything around until you have the format you want, you could automatically pipe survey data from your product over to google sheets or excel? We’re talking about enabling real time analysis, right from your google suite.
What metric will this impact?
This formula is all about protecting your team’s time. Nobody likes spending time manipulating CSV’s, especially when they could be shipping awesome product improvements.
How does this work?
First, publish a feedback form into your product, using appcues. See our Product Feedback Build Guide.
Then, set up a spreadsheet with headers in the first row in excel online or google sheets.
Finally, set up your zap. First, create the zap, select Appcues as the trigger and "Form Submitted" as the trigger event.
Connect your Appcues account in the next step, it will look similar to this but with your account ID.
Paste in the flow ID of the flow you built above ( how to find your flow ID).
Select Test and Review, you should end up with a piece of sample data. Then select Done Editing to move on to the Action portion.
In the Action section select Google Sheets and (most likely) select the Create Spreadsheet Row option. Depending on your exact use case you may want a different option, but for this example it's most likely you'll want the Create a Row option.
Choose or connect your Google Sheets user.
Use the appropriate Drive (probably "My Google Drive"), find the spreadsheet, and select the worksheet.
Zapier should then pull in the names of the columns you created in that sheet and you can match them up with the form fields it found while testing in the Trigger stage.
Important: you want to select the "Interaction Response Value", not the label. The label is simply the question text and will be the same for every response, the value is what the person selected as their answer.
Test it! You should get that same information in the Google Sheet as is shown in the zap. Turn everything on, and you’re ready to go!