Skip to content
Sites

Exporting Survey Answers to Google Sheets

Surveys · Google Sheets How to Send Survey Responses to Google Sheets in GHL Customer Care Automatically send new survey submissions to Google Sheets using…

5 min read1,193 words3 explained imagesUpdated Fri, 11 Sep at 11:00 AM
View as markdownOpen in ClaudeOpen in ChatGPT
Each image has a one line explanation. Switch to full detail for the step it belongs to, the fields and buttons involved, examples and the whole procedure.
On this page
  1. 1. What Does Sending Survey Responses to Google Sheets Do?
  2. 2. Export vs Automatic Google Sheets Sync
  3. 3. Before You Begin
  4. 4. Prepare Your Google Sheet
  5. 5. Create the Workflow
  6. 6. Add the Survey Submitted Trigger
  7. 7. Add the Google Sheets Action
  8. 8. Map Data to Google Sheets
  9. 9. Test and Publish the Workflow
  10. 10. Export Existing Survey Submissions
  11. 11. Troubleshooting
  12. 12. Frequently Asked Questions
  13. 13. Related Articles
Surveys · Google Sheets

How to Send Survey Responses to Google Sheets in GHL Customer Care

Automatically send new survey submissions to Google Sheets using a workflow, or export existing survey responses directly from GHL Customer Care.
+.   mmmlkn n jjjj    
Video 1 Open in a new tab
Overview

GHL Customer Care lets you automatically send survey submission data to Google Sheets using a workflow. This is useful when you want new responses organized in a spreadsheet for reporting, team review, or additional processing without manually copying information.

Important

Exporting existing survey submissions and automatically sending future submissions to Google Sheets are two different processes. Use the native Export option for existing submissions and a Workflow for automatic Google Sheets updates.

1. What Does Sending Survey Responses to Google Sheets Do?

Using a GHL Customer Care workflow, you can automatically add information to Google Sheets whenever a contact submits a selected survey.

Typical workflow

Survey Submitted → Google Sheets → Create Spreadsheet Row

You can send information such as:

  • Contact name
  • Email address
  • Phone number
  • Survey-related contact fields
  • Submission information
  • Other values available to the workflow

2. Export vs Automatic Google Sheets Sync

Choose the method based on whether you need existing responses or want future survey submissions sent automatically.

MethodBest ForHow It Works
Export Survey SubmissionsExisting responsesExport submissions from GHL Customer Care and receive a download link by email.
Google Sheets WorkflowFuture submissionsA workflow runs after a survey is submitted and sends mapped data to Google Sheets.

3. Before You Begin

Prepare the required survey, Google account, and spreadsheet before building the workflow.

  • A published GHL Customer Care survey
  • A Google account connected to the GHL Customer Care sub-account
  • A Google Sheet where the data will be added
  • Column headers for the information you want to store
  • Access to Automation → Workflows
  • Premium Triggers & Actions enabled when required for the Google Sheets action

Note: Google Sheets is a Premium Workflow Action. Availability and usage charges can depend on the agency's current Premium Triggers & Actions configuration.

4. Prepare Your Google Sheet

Set up the destination spreadsheet before configuring the workflow so the required columns are ready for mapping.

  1. Open Google Sheets.
  2. Create a new spreadsheet or open an existing one.
  3. Select the worksheet where survey information should be added.
  4. Create a header row for the information you want to store.
NameEmailPhoneFeedbackSubmission Date

5. Create the Workflow

Create a workflow that will run when the selected survey is submitted.

  1. In your GHL Customer Care sub-account, go to Automation → Workflows.
  2. Create a new workflow or open an existing workflow.
  3. Add a new workflow trigger.
5. Create the Workflow (image 1 of 3) What this shows Surveys · Google Sheets How to Send Survey Responses to Google Sheets in GHL Customer Care Automatically send new survey submissions to… What this shows Illustrates the "5. Create the Workflow" section of "Exporting Survey Answers to Google Sheets". This screenshot appears in the "5. Create the Workflow" section of "Exporting Survey Answers to Google Sheets". For context, this section explains: Surveys · Google Sheets How to Send Survey Responses to Google Sheets in GHL Customer Care Automatically send new survey submissions to Google Sheets using a workflow, or export existing survey responses directly from GHL Customer Care. +. mmmlkn n jjjj Overview GHL Customer Care lets you automatically…. This part of the guide covers 12 fields, listed below. Image 1 of 3
Fields in this part of the guide Contact nameEmail addressPhone numberSurvey-related contact fieldsSubmission informationOther values available to the workflowA published GHL Customer Care surveyA Google Sheet where the data will be addedColumn headers for the information you want to storeAccess to Automation → WorkflowsHow to Access and Export Survey SubmissionsWorkflow Trigger - Survey Submitted
Buttons and menus referenced ExportWorkflowTypical workflowExport Survey SubmissionsGoogle Sheets WorkflowAutomation → WorkflowsSurvey SubmittedSurvey is+ Add ActionGoogle SheetsCreate Spreadsheet RowSites
Example values
Contact name
Priya Raman
Email address
priya.raman@northgatedental.com
Phone number
+1 312 847 1928

Illustrative values showing the expected format. They are not read from the screenshot.

All 6 steps in this procedure
  1. Contact name
  2. Email address
  3. Phone number
  4. Survey-related contact fields
  5. Submission information
  6. Other values available to the workflow

6. Add the Survey Submitted Trigger

The Survey Submitted trigger starts the workflow when a contact submits a survey.

  1. Select Survey Submitted as the workflow trigger.
  2. Add the Survey is filter.
  3. Select the survey whose submissions you want to send to Google Sheets.
  4. Save the trigger.

Tip: Use the Survey is filter when only one survey should send information to this Google Sheet.

7. Add the Google Sheets Action

Add a Google Sheets workflow action after the trigger to send the submission information to the selected spreadsheet.

  1. Click + Add Action.
  2. Search for and select Google Sheets.
  3. Select the appropriate action, such as Create Spreadsheet Row.
  4. Select the connected Google account.
  5. Select the required spreadsheet.
  6. Select the worksheet where the information should be added.
7. Add the Google Sheets Action (image 2 of 3) What this shows Surveys · Google Sheets How to Send Survey Responses to Google Sheets in GHL Customer Care Automatically send new survey submissions to… What this shows Illustrates the "7. Add the Google Sheets Action" section of "Exporting Survey Answers to Google Sheets". This screenshot appears in the "7. Add the Google Sheets Action" section of "Exporting Survey Answers to Google Sheets". For context, this section explains: Surveys · Google Sheets How to Send Survey Responses to Google Sheets in GHL Customer Care Automatically send new survey submissions to Google Sheets using a workflow, or export existing survey responses directly from GHL Customer Care. +. mmmlkn n jjjj Overview GHL Customer Care lets you automatically…. This part of the guide covers 12 fields, listed below. Image 2 of 3
Fields in this part of the guide Contact nameEmail addressPhone numberSurvey-related contact fieldsSubmission informationOther values available to the workflowA published GHL Customer Care surveyA Google Sheet where the data will be addedColumn headers for the information you want to storeAccess to Automation → WorkflowsHow to Access and Export Survey SubmissionsWorkflow Trigger - Survey Submitted
Buttons and menus referenced ExportWorkflowTypical workflowExport Survey SubmissionsGoogle Sheets WorkflowAutomation → WorkflowsSurvey SubmittedSurvey is+ Add ActionGoogle SheetsCreate Spreadsheet RowSites
Example values
Contact name
Priya Raman
Email address
priya.raman@northgatedental.com
Phone number
+1 312 847 1928

Illustrative values showing the expected format. They are not read from the screenshot.

All 6 steps in this procedure
  1. Contact name
  2. Email address
  3. Phone number
  4. Survey-related contact fields
  5. Submission information
  6. Other values available to the workflow

8. Map Data to Google Sheets

Match the GHL Customer Care values available in the workflow with the corresponding columns in your Google Sheet.

  1. Select the GHL Customer Care value you want to send.
  2. Map it to the appropriate Google Sheets column.
  3. Repeat for each required field.
  4. Save the action.
Google Sheets ColumnExample GHL Customer Care Value
NameContact Name
EmailContact Email
PhoneContact Phone
FeedbackRelevant mapped field

Important: Not every survey answer automatically becomes a contact field. If you need a specific response in a workflow, confirm that the value is available in the workflow data picker or stored in an appropriate mapped field.

Screenshot: Show the Google Sheets field-mapping area with GHL Customer Care values mapped to the corresponding spreadsheet columns.

9. Test and Publish the Workflow

Test the workflow before relying on it for live survey submissions.

  1. Save the workflow configuration.
  2. Publish the workflow.
  3. Submit the selected survey using a test contact.
  4. Open the destination Google Sheet.
  5. Confirm that a new row was created.
  6. Verify that each value appears under the correct column.

Result: Future qualifying survey submissions can now send the mapped information to the selected Google Sheet automatically.

10. Export Existing Survey Submissions

If you need survey responses that have already been submitted, use GHL Customer Care's native export option instead of the workflow method.

  1. Go to Sites.
  2. Open Surveys → Submissions.
  3. Use the survey filter to select the required survey.
  4. Click Export.

GHL Customer Care sends a download link for the exported survey submissions to your email.

10. Export Existing Survey Submissions (image 3 of 3) What this shows Surveys · Google Sheets How to Send Survey Responses to Google Sheets in GHL Customer Care Automatically send new survey submissions to… What this shows Illustrates the "10. Export Existing Survey Submissions" section of "Exporting Survey Answers to Google Sheets". This screenshot appears in the "10. Export Existing Survey Submissions" section of "Exporting Survey Answers to Google Sheets". For context, this section explains: Surveys · Google Sheets How to Send Survey Responses to Google Sheets in GHL Customer Care Automatically send new survey submissions to Google Sheets using a workflow, or export existing survey responses directly from GHL Customer Care. +. mmmlkn n jjjj Overview GHL Customer Care lets you automatically…. This part of the guide covers 12 fields, listed below. Image 3 of 3
Fields in this part of the guide Contact nameEmail addressPhone numberSurvey-related contact fieldsSubmission informationOther values available to the workflowA published GHL Customer Care surveyA Google Sheet where the data will be addedColumn headers for the information you want to storeAccess to Automation → WorkflowsHow to Access and Export Survey SubmissionsWorkflow Trigger - Survey Submitted
Buttons and menus referenced ExportWorkflowTypical workflowExport Survey SubmissionsGoogle Sheets WorkflowAutomation → WorkflowsSurvey SubmittedSurvey is+ Add ActionGoogle SheetsCreate Spreadsheet RowSites
Example values
Contact name
Priya Raman
Email address
priya.raman@northgatedental.com
Phone number
+1 312 847 1928

Illustrative values showing the expected format. They are not read from the screenshot.

All 6 steps in this procedure
  1. Contact name
  2. Email address
  3. Phone number
  4. Survey-related contact fields
  5. Submission information
  6. Other values available to the workflow

11. Troubleshooting

Use these checks if survey submissions are not appearing in the expected Google Sheet.

The workflow does not run
Confirm that the workflow is published, the Survey Submitted trigger is configured correctly, and the Survey is filter points to the intended survey. Review the workflow execution history to confirm whether the contact entered the workflow.
No row appears in Google Sheets
Confirm that the correct Google account, spreadsheet, and worksheet are selected. Review the workflow execution history to check whether the Google Sheets action completed successfully.
Data appears in the wrong columns
Open the Google Sheets workflow action and review the field mapping. Confirm that each GHL Customer Care value is mapped to the intended spreadsheet column.
A survey answer is missing
Check how the survey question is configured and confirm that the required value is available to the workflow before mapping it to Google Sheets.

12. Frequently Asked Questions

Can I automatically send new survey submissions to Google Sheets?
Yes. Use the Survey Submitted workflow trigger followed by an appropriate Google Sheets workflow action, such as Create Spreadsheet Row.
Can I export existing survey submissions without creating a workflow?
Yes. Go to Sites → Surveys → Submissions, select the appropriate survey, and use Export. GHL Customer Care sends a download link for the exported submissions to your email.
Can the same contact submit a survey more than once?
Yes. GHL Customer Care tracks survey submissions independently, even when the same contact submits the survey multiple times.
Does every survey answer automatically update the contact record?
No. Responses connected to mapped contact fields can update those fields. Other responses remain available in the survey submission record.
Is the Google Sheets workflow action free?
Google Sheets is a Premium Workflow Action. Availability and charges depend on your agency's current Premium Triggers & Actions configuration.

Frequently asked questions

1. What Does Sending Survey Responses to Google Sheets Do?
Using a GHL Customer Care workflow, you can automatically add information to Google Sheets whenever a contact submits a selected survey. Typical workflow Survey Submitted → Google Sheets → Create Spreadsheet Row You can send information such as: Contact name Email address Phone number Survey-related contact fields Submission information Other values available to the workflow

Was this guide helpful?

Related guides

How to Access and Export Survey Submissions2 min read · 8 imagesNew Footer in Surveys2 min read · 3 imagesSurvey Create Contact on Partial Completion1 min read · 4 imagesPayments Integration in Surveys | Collect Payments & Sell Products1 min read · 5 images