Google Sheets Integration for Surveys

Can I set up Google Sheets before I begin collecting feedback?

Yes. It's common practice to prepare your Google Sheets integration before responses start rolling in!

But even you have collected responses, no worries. There's a handy "Send a one-time backfill" option so you and import all of your current responses and continue from there.

Part 3 — Adding rules

To send a survey's feedback to your Google Sheets file:

1

Click Edit to the right any published Survey → ex. "Museum NPS"

2

Pick Add a rule

3

Select your Question and Response settings → (ex. "Any question" with "Any response" which sends every response to your spreadsheet)

4

Name your spreadsheet in the Send responses to box → (ex. use any name, including the Survey's name, such as "Museum NPS")

5

Recommended: Check Send a one-time backfill → to upload existing feedback into your new Sheet

6

Click Save rule

Part 4 — Enabling

1

Click "Disabled" to "Enabled"

From your Connections page → click the "Disabled" toggle and switch to the green "Enabled" setting. 

About setting up multiple Google Sheets

Your Delighted Google Sheets integration must create the Google spreadsheet so that Surveys knows where to export the results!

And you can create as many Google Sheets as you may need through our integration. We even keep track of them for you, so that if your target spreadsheet has already been created in Google Sheets → you can select it from the drop-down menu. 

Back to top

Testing Rules and viewing your responses in Google Sheets

Open Google Sheets and locate your target Delighted Surveys integration file. (You may need to refresh your Google Drive or pick Recent from the sidebar.)

Send a test message!

To test your Google Sheets integration: 

1

Open your Google Sheets integration 

2

Select Test 

3

Pop open Google Sheets and view your test results! 

4

Did it work? (Note: You can Delete this row!)

Viewing responses

The integration will create a column for each field including a combination of native response fields — ex. Response ID, Project ID, Survey ID, Survey Name, Response Created timestamp, and Response Updated timestamp.

Most importantly, you'll see the Responses to your questions — both your partial and completed responses.

Responses will be updated after a 10 minute delay to allow respondents to complete their questions.

Back to top

Connecting multiple Surveys to a single Google Sheet

News flash! You have two options: 

1. You can connect all of your surveys to separate Google Sheets
2. Combine multiple surveys into a single Google Sheet — each with a tab of their own!

2. To send feedback from a published Survey to an existing Google sheet:

1

Click Integrations → and reopen the Google Sheets integration

2

Click Edit → found on your Survey's tile (ex. "Museum Gift Shop")

3

Select Add a rule

4

We defaulted to "Any question" with "Any response" for the Question and Response settings

5

Pick Send responses to → and choose an existing spreadsheet from the list (ex. "Museum NPS")

6

Optional: → click Send a one-time backfill

7

Select Save rule

Back to top

Editing Rule settings — (ex. changing questions, responses, and Google Sheets too!) 

Use the Edit option to alter and refine your Rule selections. In this case, we'll filter the Rule just send responses for Detractors (0-6) from an NPS question to an existing Google Sheets file: 

1

Open your Google Integration

2

Pick Edit → seen in the corner of your Survey's tile 

3

Change the "Question" and "With response" settings → (ex. we picked an NPS question with 0-6, Detractors only, as our "With response" choice)

4

Select Send responses to → (ex. we picked "New spreadsheet")

5

Name your new spreadsheet → (ex. Museum detractors) 

6

Select Save rule

Back to top

Filtering Rules and Sheets for team members — by response type (ex. numeric, graphical, text)

Create as many rules as you need for a single survey. Why you ask? Well here's a potential use case:

• Set up separate Google sheets tied to specific Rules, so team members only see the data that’s relevant to them! (How convenient will that be?)

You can filter by all of your questions — and generate new spreadsheets for team members — based on any type of question in your questionnaire. For example, our A) Museum NPS survey questionnaire has been segmented in the below image by Rules for:

• B) Text questions
• C) Numeric scale-point questions
• D) Graphic scale-point question types.

In the Rule making process, you can generate — and share — separate Google Sheets emphasizing the specific questions and responses you filter with the Google Sheets integration, all from the same survey. Filter your spreadsheets by any type of question you can possibly create!

Use your Google Sheets Sharing options to pass these spreadsheets over to the affected team members. 

Let's review our three examples and show you how their unique Sheets are created. 

B	Graphic scale Rule	Pick from a range of responses from a graphic survey question (in this case a "Smileys" graphical question) and send it to a new Google Sheet. The sheet will only display responses respondents that answer this graphical (ex. Smileys) Likert scale question. (The full response is included to provide context.)
C	Numeric scale Rule	Pick from a range of responses from a numeric survey question and only send responses to a new Google Sheet for those who have answered that question. (The full response is included for context.)
D	Text entry Rule	Display only responses that from those that leave comments to a text question.  (The full response is included for context.)

Graphic scale Rule

1

Open your Google Sheets integration → and click Edit in your survey's tile

2

Select Add a rule

3

In the Add a rule model's settings, make the following selections:

Setting	Explanation
Question	Pick a graphic question type → (ex. a "Smilies" question with a "5-point scale")
With response	Pick your low scale point and high scale point for the graphic response → (ex. look carefully for the smileys icons in the image below that track the scale points)
Send responses to	Select New spreadsheet → and name your Sheet (ex. "Food choice satisfaction")

4

Recommended: Click Send a one-time backfill

5

Save your very cool new Rule 

Numeric scale Rule

1

Open your Google Sheets integration → and click Edit in your survey's tile

2

Select Add a rule

3

In the Add a rule model's options, make the following selections:

Setting	Explanation
Question	Pick a numeric question type → (ex. an "NPS" question with an "11-point scale")
With response	Pick your low scale point and high scale point for the numeric response → (ex. we picked 9-10, which represent Promoters in NPS research)
Send responses to	Select New spreadsheet → and name your Sheet (ex. "NPS promoters")

4

Recommended: Click Send a one-time backfill

5

Save your fabulous new Rule 

Text entry Rule

1

Open your Google Sheets integration → and click Edit in your survey's tile

2

Select Add a rule

3

In the Add a rule model's options, make the following selections:

Setting	Explanation
Question	Pick a text question type → (ex. "What can we do . . . )
With response	Choose "Is not empty"
Send responses to	Select New spreadsheet → and name your Sheet (ex. "Text response feedback")

4

Recommended: Click Send a one-time backfill

5

Save your amazing new Rule 

Back to top

Deleting rules

To remove a Rule from your Google Sheets integration:

1

Open the Google Integration

2

Pick Edit → seen in your Survey's tile in the Connections section

3

Select the X → seen at the far right of the tile

4

Click Yes, delete rule → and poof, the connection is broken. If you need it back again, simply recreate the Rule

Back to top

Why is there the 10-minute delay before Google Sheets updates?

By default, we include a 10-minute delay between a response being received in Surveys and a new row being created in Google Sheets. This delay ensures that respondents have adequate time to leave comments before syncing begins.

After 10 minutes have expired, any completed (or partially completed) response will be forward from Surveys to your Google Sheet — and a new row will be added to the connected spreadsheet(s).

Back to top

Why can't I sync data to any spreadsheet in my Google Sheets Account?

For security reasons, our integration cannot view spreadsheets in your Google Sheets account that it did not create. 

As a result, you cannot sync data to pre-existing spreadsheets created outside of the Delighted Google integration.

Back to top