Google Sheets Integration

Overview

The Google Sheets Integration automatically exports survey responses from SurveySensum to a Google Spreadsheet.

Once configured, new survey responses are pushed directly into your selected Google Sheet whenever the configured conditions are met. This enables teams to maintain a live spreadsheet of survey data for reporting, collaboration, analysis, and sharing.

Key Benefits

• Automatically sync survey responses to Google Sheets

• Filter which responses are exported using conditions

• Choose exactly which survey fields are included

• Keep a live, continuously updated spreadsheet

• Share survey data easily with stakeholders

Access Google Sheets Integration

To configure Google Sheets Integration:

1. Open the required survey.

2. Navigate to Integrations.

3. Locate the Google Sheets integration card.

4. Click Connect.

Connect Your Google Account

Before exporting responses, you must authorize SurveySensum to access your Google Sheets account.

Step 1: Sign In

1. Click Sign In.

2. Select the Google account you want to use.

3. Continue through Google's authentication flow.

Step 2: Grant Permissions

Review and approve the requested permissions.

SurveySensum requires access to:

• View Google Sheets

• Create Google Sheets

• Edit Google Sheets

• Update Google Sheets data

 Authorization is only required once per Google account. After successful authentication, the account becomes available for future Google Sheets integrations

Select a Google Account

After authorization:

1. Return to the Google Sheets Integration page.

2. Use the account dropdown.

3. Select the connected Google account.

Select a Google Spreadsheet

After selecting an account:

1. Open the Choose a Google Spreadsheet dropdown.

2. Browse available spreadsheets from your Google Drive.

3. Select the spreadsheet where responses should be exported.

Survey Responses

You can also search for spreadsheets using the search box provided within the dropdown.

Create an empty spreadsheet before configuring the integration if you want survey responses to be stored in a dedicated file.

Configure Response Conditions

Conditions determine which survey responses will be exported to Google Sheets.

Without conditions, every new survey response will be synced automatically.

To Add Conditions

1. Click Add Conditions.

2. Select the survey question.

3. Define the required criteria.

4. Add additional conditions or groups if needed.

5. Save the configuration.

Example

Export only responses where:

• NPS Group is Promoters
  

OR

• Overall Satisfaction equals "Satisfied"

Only responses matching the configured rules will be added to Google Sheets.

If no conditions are configured, all new survey responses will be exported.

Select Columns to Export

You can choose which survey fields are included in the spreadsheet.

Available options include:

All Columns

Exports all available survey questions and contact properties.

Columns with Questions

Exports only survey question responses.

Columns with Contact Properties

Exports only respondent information and contact fields.

Custom Column Selection

You can manually:

• Select specific columns

• Remove unnecessary columns

• Customize exported data structure
  

If a selected column is later deleted from the Google Sheet but remains selected in the integration configuration, the column will automatically be recreated during future syncs. To permanently stop exporting a column, remove it from the selected columns list within the integration settings.

Enable the Integration

Once configuration is complete:

1. Verify the account, spreadsheet, conditions, and columns.

2. Click Turn On in the top-right corner.

The integration will become active immediately and will appear in the All Integration Summary section, where it can be enabled, disabled, edited, or deleted at any time.

How Response Sync Works

When a new survey response is submitted:

1. SurveySensum evaluates the configured conditions.

2. If the response matches the conditions, it is exported.

3. If the response does not match the conditions, it is ignored.

4. Data is automatically added to the selected Google Spreadsheet.

Sheet Creation Behavior

When the first qualifying response is received:

• SurveySensum automatically creates a new worksheet (tab) inside the selected spreadsheet.

• The worksheet name matches the survey name.

Example:

Spreadsheet: Survey Responses

Worksheet: Telecom Survey

Response Data Structure

Each row represents a single survey response.

Example:

If a respondent skips a question or data is unavailable, the corresponding spreadsheet cell will remain blank.

Best Practices

To get the most value from Google Sheets Integration:

• Use dedicated spreadsheets for survey exports.

• Configure conditions to reduce unnecessary data.

• Select only the columns needed for reporting.

• Periodically review exported fields.

• Avoid manually deleting actively synced columns unless they are removed from the integration configuration.

Google Sheets Integration is ideal for teams that want a continuously updated survey data repository without manually exporting responses.