You can import surveys from Google Forms into Marvin to analyze responses, make notes on them and add participant data to the research panel as well.
Integrating your accounts
To import surveys from Google Forms, you need to integrate your Marvin account with Google.
In the left navigation bar, select "Integrations" and click "Connect" under Google Forms. You’ll see the login page open in another tab.
Once you enter your account credentials, you’ll see a request for the following permissions. To continue importing Google Forms, please grant access.
You’ll see a confirmation that the integration is complete.
Importing forms
Please navigate to the project to which you want to add a Google Form.
In the "Files" tab, click "Add new files". Select the option to import from Google Form when you hover over "Surveys".
You’ll see a list of the Google Forms surveys you can import. Choose your survey and click "Select".
You can choose to import data from specific questions or all questions in the form. Each question is imported as a separate column.
If you want to remove columns, uncheck the ones you want to leave out.
Participant data
To begin, you need to identify the columns that contain participant data, such as names and email addresses. Marvin will auto detect the column using AI.
In case it hasn't detected it correctly, click "Select from all columns". Select any other column that you want Marvin to consider as responses for participant names
If you don't have the names of respondents, click "Survey doesn't contain respondent names" to proceed.
Similarly, Marvin will detect the column that contains emails.
To choose another column, click "Select from all columns".
If you don't have respondent emails, click "Survey doesn't contain respondent emails" to proceed.
You can also add these participants to your Research Panel in Marvin. We recommend you do this to maintain your participant database. You can also keep track of all the interactions each user has with the different teams and channels in your company.
Categorization of questions
Marvin will use AI to automatically categorize each question in the survey as open-ended, NPS, single choice, card sort, and ranking.
You can check the AI mapping for each question. Marvin will highlight the ones where you need to confirm the categorization. If Marvin has correctly identified the type of question, click "Yes".
To change the categorization, click "No" and choose the right type of question.
Complete the import once you've checked all the questions. You can also check and revise after the survey has been uploaded.
It may take a few minutes to complete the import. The task will continue running in the background even if you navigate away. You'll find the survey in the project files once the upload is complete.
Viewing the data in Marvin
Marvin presents all the survey data in three tabs – Summary, Individual Respondents and, Responses.
Summary
You’ll see all the data grouped by question in the Summary tab.
Individual respondents
Use this tab to view all the responses of one participant in a single table. Easily navigate between respondents by clicking on their name
Responses
To view all responses in one, easy-to-read table, head to the Responses tab. You can add file tags and edit data directly from the table.
Filter data
You have a few options to filter and analyze the survey data.
Click the drop down menu against "Filter responses by" to see filters for individual questions. You can choose to view data of specific responses to questions. You can apply multiple filters here. For example, you can focus on a data set of users who "Use your product twice a week" and are "Windows users".
Similarly, you can choose to see only the single-choice, multiple-choice, NPS or ranking responses when you click the drop down menu that says "Single choice".
Visualize data
Marvin can arrange all the metadata or quantitative data in a bar graph or pie chart (or notes in case of open-ended questions) when you click "Pie Chart". You'll see the open-ended responses or qualitative data as notes in case of open-ended questions. Use these notes for analysis and cross-project analysis.
Import new responses
Marvin can also import the latest responses to the survey. All you have to do is click "Import new responses" on the top navigation bar.
