Google Sheets Integrations
SurveyMars enables automatic synchronization and management of survey data through Google Sheets. Users can directly sync survey responses to Google Sheets for convenient data analysis and processing.
Feature Access
1. Navigate to the survey distribution page and locate "Integrations" section. Click the "Go>>" button to access data integration settings
Connecting Google Sheets
1. Click the "Connect " button
2. Select Google account login method:
- If already logged in: Choose to use current account or switch to another account
- If not logged in: Click the login button to sign in to Google
3. Complete Google authorization:
- Confirm permissions in the authorization popup
- Click "Next" to complete authorization
Setting Up Data Synchronization
1. Choose data synchronization target:
- Use existing spreadsheet: Paste Google Sheets link
- Create new spreadsheet: Click "Create New Sheet" button
2. Confirm integration settings:
- Verify spreadsheet settings
- Click "Connect to sheet" to complete setup
3. Handle historical data:
- If survey has existing responses, system will prompt to sync historical data
- Choose whether to include existing responses
Managing Google Sheets Integration
1. Pause data synchronization:
- Click integration switch to pause data sync at any time
2. Delete integration connection:
- Click "Delete" button
- Confirm deletion in the popup window
3. View synchronized data:
- Click "View Your Spreadsheet" to open synchronized sheet
- Sheet supports editing response content
Note: Question order cannot be changed, new questions sync automatically
Important Notes
- Data integration requires Google account authorization
- Question order in spreadsheet is fixed and cannot be adjusted
- New survey questions automatically sync to spreadsheet
- Data integration can be paused or deleted at any time
- Deletion of integration connection requires confirmation
FAQs
Q: Do I need a Google account to use Google Sheets integration?
A: Yes, data integration requires Google account authorization. You'll need to sign in to your Google account to connect and sync data.
Q: Can I use an existing Google Sheets spreadsheet?
A: Yes, you can either use an existing spreadsheet by pasting the Google Sheets link, or create a new spreadsheet using the "Create New Sheet" button.
Q: What happens to historical survey data when I set up integration?
A: If your survey has existing responses, the system will prompt you to sync historical data. You can choose whether to include existing responses in your Google Sheets.
Q: Can I change the order of questions in the spreadsheet?
A: No, the question order in the spreadsheet is fixed and cannot be adjusted. However, new survey questions will automatically sync to the spreadsheet.
Q: How do I pause data synchronization?
A: You can click the integration switch to pause data synchronization at any time. This allows you to temporarily stop syncing without losing your configuration.
Q: Can I edit response data directly in Google Sheets?
A: Yes, the synchronized sheet supports editing response content. You can click "View Your Spreadsheet" to open and edit the data directly in Google Sheets.
Q: What happens if I delete the integration connection?
A: When you delete the integration, you'll need to confirm your decision in a popup window. This will remove the connection and stop data synchronization.
Q: Can I switch between different Google accounts?
A: Yes, if you're already logged into Google, you can choose to use your current account or switch to another account during the connection process.
Q: How often does data synchronization occur?
A: Data synchronization occurs automatically when new survey responses are submitted. The integration provides real-time updates to keep your Google Sheets current.
