Collect new SurveyMars responses in rows on Google Sheets
SurveyMars are great at capturing user information, but exporting their results takes time. Zapier can help you analyze those entries in a spreadsheet automatically with this integration. Once you set it up, it will catch every new entry you receive on a survey, saving the results to a new row on Google Sheets so you don't have to do it yourself.
SurveyMars are great at capturing user information, but exporting their results takes time. Zapier can help you analyze those entries in a spreadsheet automatically with this integration. Once you set it up, it will catch every new entry you receive on a survey, saving the results to a new row on Google Sheets so you don't have to do it yourself.
- When this happens...Get Responses
Triggers when there is submitted a new response of the survey.
- automatically do this!Create Spreadsheet Row
Create a new row in a specific spreadsheet.
- Free forever for core features
- 14 day trial for premium features & apps
Survey TitleRequired
Response statusRequired
Whether marked
Collector source types
Collector details =
Collector details like
Collector details !=
Collector details not like
Response number >=
Response number <=
Response score >=
Response score <=
Response completion time >=
Response completion time <=
Time spent on the response (s) >=
Time spent on the response (s) <=
JSON for query conditions by question (needs URL encoding)
File Link Expires
Question number for answer to be returned
Whether to return simple information
Try ItSummarizing research topicRequired
Detailed descriptionRequired
Number of questionsRequired
Language (1: ChineseSimplified, 2: English)Required
Survey type (1: Survey, 3: 360, 4: Form, 5: FormActivity, 6: FormSign)Required
Task ID (task_id from "AI Create Survey" response)Required
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try It