--- description: Use a Workflow Template to automatically send CSAT surveys to customers with closed conversations and save data in Google Sheets, CRMs or other data warehouse. title: How to Send CSAT to Customer and Save Data in Google Sheets or CRMs image: https://assets1-proxy.respond.io/api/v1/image/assets%2F11f7a662b80a4675973850b067c01fa5%2F3f43c48b21b24f4e8b02b100c0c8fab0 --- [NewWe just raised $62.5M in Series B! 🎉 What it means for you![arrow-icon](https://assets1-proxy.respond.io/api/v1/image/assets%2F11f7a662b80a4675973850b067c01fa5%2Fe43213a7a9314673bd8d2060c25f9b87)](https://respond.io/blog/respond-io-raises-62-million-series-b) Help me with... ⌘ 1. [All Collections >](/help) 2. [ Conversation Led Growth >](/help/conversation-led-growth) 3. [ Retain Customers >](/help/retain-customers) 4. How to Send CSAT to Customer and Save Data in Google Sheets or CRMs # How to Send CSAT to Customer and Save Data in Google Sheets or CRMs > In this article, you'll discover how to automatically send CSAT surveys to customers with closed conversations and save data in Google Sheets, CRMs or other data warehouse. With a Workflow, you can automatically send customers a CSAT survey when any conversation is closed. Then, you can save the data to keep track of positive and negative customer feedback and monitor satisfaction levels over time. ## Benefits of Sending CSAT and Saving Data Use CSAT surveys to: * Understand customer satisfaction levels and identify areas for improvement * Track data to gain insights into customer preferences, needs, and expectations * Identify dissatisfied customers and provide an opportunity to address their concerns, potentially turning them into loyal customers ## Method for Sending CSAT and Saving Data * Send CSAT survey and save data using Workflow Templates ### Send CSAT survey and save data using Workflow Templates **Method Objectives** * Set up your Google Sheet, CRM or data warehouse to receive survey data. * Select a Workflow Template and customize Ask a Question steps if needed. * Manage positive response and save data in Google sheet or data warehouse. * Manage negative response and save data in Google sheet or data warehouse. * Manage invalid and no responses. #### Set up your Google Sheet, CRM or data warehouse to receive survey data To get started, there are a few steps to take before creating your Workflow. Depending on where you want to save your CSAT responses, here’s how you can prepare the external platform. #### Set up your Google Sheet Create a Google Sheet with the following headings: Agent ID, Agent Name, Team, CSAT Score, CSAT Follow Up Feedback, First Response Time, Resolution Time, Conversation Category, Conversation Summary, Contact ID.You may edit the headings as desired to meet your business needs, but note that if you change them, you will also need to edit the column mapping in the [Save to Google Sheet step in the Workflow](https://respond.io/help/support-use-case/send-csat-and-save-data#manage%5Fpositive%5Fresponse%5Fand%5Fsave%5Fdata%5Fin%5Fgoogle%5Fsheet%5For%5Fdata%5Fwarehouse). ![](https://assets2-proxy.respond.io/ph8r57dk1q9w/NA4m5ND6B8jMiQMq1UI86/3c44353ee1aa6010f387c66f1cad5f41/csat-1.png?fm=avif&w=1000) #### Set up your CRM or data warehouse All CRMs and data warehouses will be set up differently, but here are some things you should prepare:- Find out which API keys you need.- Determine which fields in your CRM or data warehouse are available for saving CSAT data. These will be needed for mapping purposes when you set up the Workflow.- Add any custom fields necessary to your CRM or data warehouse. **Workflow Setup** There are workflow templates set up by our team that you can use immediately. These templates can be edited to fit your business needs. > Learn more about [Workflow Templates here](https://respond.io/help/workflows/workflows-overview#creating%5Fa%5Fnew%5Fworkflow%5Ffrom%5Fa%5Fselected%5Ftemplate). #### Select a Workflow Template and customize Ask a Question steps if needed There are two templates to choose from depending on where you want to save your data. Here’s how to select and set them up. #### Select template to save CSAT responses to a Google Sheet On the respond.io platform menu, click **Workflows > + Add Workflow**. Then, click **CSAT to Google Sheet** \> **Use Template** ![](https://assets2-proxy.respond.io/ph8r57dk1q9w/4LMsdW8ReljTeO2HtsxEWI/e900652889d73ad9862a1d931360c024/csat-2.png?fm=avif&w=1000) #### Select template to send CSAT responses to a CRM or data warehouse On the respond.io platform menu, click **Workflows > + Add Workflow**. Then, click **CSAT to Data Warehouse** \> **Use Template** ![](https://assets2-proxy.respond.io/ph8r57dk1q9w/6JWcSBScreqSccDTsvXc8N/fa2d8e6d755f7add600c13bd9141ebcd/csat-3.png?fm=avif&w=1000) The template is set up with an Ask a Question step triggered after a conversation is closed. You may edit the question and multiple choice replies if desired. The response is automatically saved as a [Variable](https://respond.io/help/dynamic-variables/how-to-use-dynamic-variables#workflows) named _csat\_score_. > **Note:** If you change the 👍 and 👎 response options here, you’ll also need to change the responses in the branch configuration. The default timeout branch is 6 hours, but this can also be edited or toggled off. ![](https://assets2-proxy.respond.io/ph8r57dk1q9w/rV3n4UGg71ufm0xVwbD65/4aa711edaab02db7ac6b5e78bed53d72/csat-4.png?fm=avif&w=1000) #### Manage positive response and save data in Google sheet or data warehouse The branch step is set up to handle positive and negative responses differently. First, we’ll look at managing a positive response. ![](https://assets2-proxy.respond.io/ph8r57dk1q9w/4z85cL0PEENNKr9SLxrXHz/47a6dc5bfad6eb8baf388cfe5bd74903/csat-5.png?fm=avif&w=1000) When the customer selects 👍, they will be routed to this branch where they’ll receive a message and their responses will be saved. Edit the Send Thank You Message step as desired. ![](https://assets2-proxy.respond.io/ph8r57dk1q9w/FD5JzOZRE7BQybeRZtaUv/6e704e170caf9a03008c8767d53c58a4/csat-6.png?fm=avif&w=1000) There are two ways to save positive responses. #### Saving responses in a Google Sheet Configure the data to send to a Google Sheet.Select the Google Sheet you’ve prepared earlier for saving CSAT data > Add relevant Variables to the Column Mapping fields. Learn more about the [Add Google Sheets Row Step here](https://respond.io/help/workflows/workflow-steps#step%5Fadd%5Fgoogle%5Fsheets%5Frow). ![](https://assets2-proxy.respond.io/ph8r57dk1q9w/3YAwyP0zSUPZjfZ4csf8Ve/1c44e865028f3f67e15662a6c842d4bd/csat-7.png?fm=avif&w=1000) Here’s an example of how we would match Variables to the available columns. ![](https://assets2-proxy.respond.io/ph8r57dk1q9w/hKgBbnfZeQSefka52QCQd/d75ca21b047fd48cb593aa1010862ddd/csat-column-mapping-2.jpg?fm=avif&w=1000) Here’s what the Google Sheet should look like after receiving positive feedback: ![](https://assets2-proxy.respond.io/ph8r57dk1q9w/6SvcuFxtWIzDzt9e7KabB2/7117820058d6eeff409ccdeef82bed8d/csat-8.png?fm=avif&w=1000) #### Saving responses in a CRM or data warehouse Configure the HTTP request step to send the data to your CRM or a data warehouse. Learn how to [configure the HTTP request here](https://respond.io/help/workflows/step-http-request). ![](https://assets2-proxy.respond.io/ph8r57dk1q9w/46LKPHnMe2DLe3hqfqJgRF/20ce3aa68a136aaaaee851aa891d466c/csat-9.png?fm=avif&w=1000) #### Manage negative response and save data in Google sheet or data warehouse If a negative response is given, the branch step will route to an [Ask a Question step](https://respond.io/help/workflows/workflow-steps#step%5Fask%5Fa%5Fquestion) to get a follow up feedback. Edit the question as desired. ![](https://assets2-proxy.respond.io/ph8r57dk1q9w/52a7lUJkGMXnx69OE1Np29/389aa6385d716bb04a1a63a17b22e992/csat-10.png?fm=avif&w=1000) Edit the Send Thank You Message and Send Fail Message steps if desired. Then, depending on which template you’ve chosen, the response will be saved accordingly. #### Saving responses in a Google Sheet Select the same Google Sheet you’ve created to save CSAT responses and map the fields accordingly. Learn more about the [Add Google Sheets Row Step here](https://respond.io/help/workflows/workflow-steps#step%5Fadd%5Fgoogle%5Fsheets%5Frow). ![](https://assets2-proxy.respond.io/ph8r57dk1q9w/45iLw5b5wozqdgYoWXozzf/8fe18671cf5b3af33cd419d01ac7b3cb/csat-11.png?fm=avif&w=1000) Here’s an example of how we would match Variables to the available columns. ![](https://assets2-proxy.respond.io/ph8r57dk1q9w/1FtA9QxTfYbNjh4oUIRe8Y/2ac4cf017caffe32bf884cf4230a4ed3/csat-column-mapping-2.jpg?fm=avif&w=1000) Here’s what the Google Sheet should look like after receiving negative feedback: ![](https://assets2-proxy.respond.io/ph8r57dk1q9w/2EbsPbXfGGGY9aQUsoyoBX/022964059f9d00816311fe57ca8579b6/csat-12.png?fm=avif&w=1000) #### Saving responses in a CRM or data warehouse Configure the HTTP request step to send the data to your CRM or data warehouse.Learn how to [configure the HTTP request here](https://respond.io/help/workflows/step-http-request). ![](https://assets2-proxy.respond.io/ph8r57dk1q9w/DCa6elJ6rLoDV1JbtW3X9/900389ac93f700071e6e3203ba8fd9af/csat-13.png?fm=avif&w=1000) If no feedback is given, the Fail Message will be sent, and all the data except _CSAT Follow Up Feedback_ will be saved. Configure _Save CSAT Feedback 3 step_ exactly as done for the first two CSAT Feedback steps. ![](https://assets2-proxy.respond.io/ph8r57dk1q9w/7diQRkjwuiaz02mDxXnLmu/df923a55a4d04e41061263ead42f0eda/csat-14.png?fm=avif&w=1000) #### Manage invalid and no responses If a customer replies with answers that are not in the provided options, this will be considered invalid and the customer will be routed to the Failure: Invalid branch. If a customer does not reply within the time frame you’ve configured earlier, the customer will be routed to the Failure: Timeout branch. The Workflow is set up with a [Jump Step](https://respond.io/help/workflows/workflow-steps#step%5Fjump%5Fto) if the response is invalid. This will jump back to _Ask for CSAT_ step. The default configuration is one jump, but you can edit the number of jumps allowed. ![](https://assets2-proxy.respond.io/ph8r57dk1q9w/30Xc5dmXThahbLDTPsGo5A/700a2f42333ed74ba29bdbb1cff6c566/csat-15.png?fm=avif&w=1000) If the customer continues to send invalid responses, or if there is no response, a Fail Message will be sent. Edit the message as desired. ![](https://assets2-proxy.respond.io/ph8r57dk1q9w/4dnvhXcGKnISpAhmUPa4Q6/2efc3db33c88775edff8de090e4c2307/csat-16.png?fm=avif&w=1000) Share this article [![Telegram](https://assets1-proxy.respond.io/api/v1/image/assets%2F11f7a662b80a4675973850b067c01fa5%2F44daca77a4844f0c8fd29040ddeba057?width=22)](https://api.whatsapp.com/send?text=https://respond.io/help/retain-customers/send-csat-and-save-data)[![Facebook](https://assets1-proxy.respond.io/api/v1/image/assets/11f7a662b80a4675973850b067c01fa5/fff57eeb01160bc604392f519b4f3461ca16f0fa1b6a587b20b142cdf1ad0ba7?placeholderIfAbsent=true&width=22)](https://www.facebook.com/sharer/sharer.php?u=https://respond.io/help/retain-customers/send-csat-and-save-data)[![Linkedin](https://assets1-proxy.respond.io/api/v1/image/assets/11f7a662b80a4675973850b067c01fa5/7aaf8d87b5410844d83e06a4ed663e4f551b8c5ef51dbb20a8ff064a1eed9a0f?placeholderIfAbsent=true&width=22)](https://www.linkedin.com/sharing/share-offsite/?url=https://respond.io/help/retain-customers/send-csat-and-save-data)[![Twitter](https://assets1-proxy.respond.io/api/v1/image/assets%2F11f7a662b80a4675973850b067c01fa5%2F4e03e02422a94e8eab9b8b41457c2371?width=22)](http://twitter.com/share?url=https://respond.io/help/retain-customers/send-csat-and-save-data) ## Related articles 👩‍💻 * [How to improve lead targeting and automatically send purchase events to Meta when a customer makes a paymentLearn how to automatically send purchase data to Meta to eliminate spam leads, improve ad targeting, and boost ROI, all with a ready-to-use Workflow Template. ](/help/retain-customers/how-to-improve-lead-targeting-and-automatically-send-purchase-events-to-meta-when-a-customer-makes-a-payment) * [How to Qualify Leads and Track Conversions with TikTok Lower Funnel EventsLearn more about qualifying leads and tracking conversions using a Shortcut-triggered Workflow that tags contacts and sends Lower Funnel Events to TikTok for better ad targeting. ](/help/retain-customers/how-to-qualify-leads-and-track-conversions-with-tik-tok-lower-funnel-events) * [How to Route New and Returning ContactsLearn how to identify new & returning customers to route & manage them separately using Workflows. ](/help/retain-customers/route-new-and-returning-contacts) * [How to Route VIP ContactsLearn how to identify VIP Customers to route and manage them differently from other Customers using Workflows. ](/help/retain-customers/route-vip-contacts) * [How to Send Outbound Support MessagesFollow up on customers’ issues as needed by sending outbound messages. ](/help/retain-customers/send-outbound-messages) Can't find what you're looking for? 🔎 [Contact Support](/contact-us) 2026-10-12T09:29:40.756Z help ```json {"@context":"https://schema.org","@graph":[{"@context":"https://schema.org","@type":"TechArticle","articleBody":"Use a Workflow Template to automatically send CSAT surveys to customers with closed conversations and save data in Google Sheets, CRMs or other data warehouse.","author":{"@type":"Person","image":"https://assets2-proxy.respond.io/ph8r57dk1q9w/4IHLTWbmWN0uXBc5x4jthC/59252fcdb357304ce07be76043047b7a/Susan_Swier_Avatar.svg","name":"Susan Swier","url":"https://respond.io/author/susan-swier"},"dateCreated":"2024-11-26T08:38:21.000Z","dateModified":"2026-10-09T03:37:08.235Z","datePublished":"2024-11-26T08:38:21.000Z","headline":"How to Send CSAT to Customer and Save Data in Google Sheets or CRMs","image":"https://assets2-proxy.respond.io/ph8r57dk1q9w/NA4m5ND6B8jMiQMq1UI86/3c44353ee1aa6010f387c66f1cad5f41/csat-1.png","mainEntityOfPage":"https://respond.io/help/retain-customers","publisher":{"@id":"https://respond.io/#organization"},"thumbnailUrl":"https://assets2-proxy.respond.io/ph8r57dk1q9w/NA4m5ND6B8jMiQMq1UI86/3c44353ee1aa6010f387c66f1cad5f41/csat-1.png","url":"https://respond.io/help/retain-customers/send-csat-and-save-data"},{"@context":"https://schema.org","@id":"https://respond.io/help/retain-customers/send-csat-and-save-data#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Help","item":"https://respond.io/help"},{"@type":"ListItem","position":2,"name":"Conversation Led Growth","item":"https://respond.io/help/conversation-led-growth"},{"@type":"ListItem","position":3,"name":"Retain Customers","item":"https://respond.io/help/retain-customers"},{"@type":"ListItem","position":4,"name":"How to Send CSAT to Customer and Save Data in Google Sheets or CRMs","item":"https://respond.io/help/retain-customers/send-csat-and-save-data"}]},{"@type":"Organization","@id":"https://respond.io/#organization","name":"Respond.io","alternateName":"respond.io","url":"https://respond.io/","image":["https://assets1-proxy.respond.io/api/v1/image/assets%2F11f7a662b80a4675973850b067c01fa5%2F3f43c48b21b24f4e8b02b100c0c8fab0"],"logo":"https://assets1-proxy.respond.io/api/v1/image/assets%2F11f7a662b80a4675973850b067c01fa5%2F4045649d540241d398c39ab07b2b62bb","description":"Respond.io is an AI-powered customer conversation platform that helps businesses manage conversations, automate workflows and scale sales, marketing and support operations. Trusted by 10,000+ B2C brands, it unifies WhatsApp, TikTok, Instagram and Facebook in a single AI-powered team inbox for chats, calls and campaigns.","email":"success@respond.io","telephone":"+6011-54211197","foundingDate":"2017-02-17","address":{"@type":"PostalAddress","streetAddress":"Level 41, Permata Sapura Tower, Jalan Pinang","addressLocality":"Kuala Lumpur","addressRegion":"Federal Territory of Kuala Lumpur","postalCode":"50088","addressCountry":"MY"},"areaServed":"Worldwide","contactPoint":{"@type":"ContactPoint","contactType":"Customer Service","url":"https://respond.io/contact"},"sameAs":["https://respond.io/","https://www.facebook.com/getrespondio/","https://www.linkedin.com/company/respondio/","https://play.google.com/store/apps/details?id=com.respond.inbox.io","https://www.youtube.com/@respondio","https://twitter.com/respond_io","https://apps.apple.com/my/app/respond-io-inbox/id1667772955","https://www.g2.com/products/respond-io/reviews","https://www.producthunt.com/products/respond-io","https://zapier.com/apps/respondio/integrations","https://www.capterra.com/p/179311/Rocketbots/","https://www.crunchbase.com/organization/respondio","https://builtin.com/company/respondio","https://respond-io.en.softonic.com/web-apps","https://my.jobstreet.com/companies/respondio-168558101085004","https://brandfetch.com/respond.io","https://webcatalog.io/en/apps/respond-io"],"knowsAbout":["WhatsApp API","WhatsApp Business API","WhatsApp CRM","WhatsApp automation","omnichannel communication platform","WhatsApp Business Multiple Users","WhatsApp BSP","WhatsApp Business Solution Provider","WhatsApp automation tool","WhatsApp team inbox","WhatsApp AI agent","WhatsApp Business AI chatbot","WhatsApp marketing software","conversational sales platform","WhatsApp appointment booking"]},{"@type":"WebPage","@id":"https://respond.io/help/retain-customers/send-csat-and-save-data#webpage","url":"https://respond.io/help/retain-customers/send-csat-and-save-data","name":"How to Send CSAT to Customer and Save Data in Google Sheets or CRMs","description":"Use a Workflow Template to automatically send CSAT surveys to customers with closed conversations and save data in Google Sheets, CRMs or other data warehouse.","isPartOf":{"@id":"https://respond.io/#website"},"primaryImageOfPage":{"@type":"ImageObject","url":"https://assets1-proxy.respond.io/api/v1/image/assets%2F11f7a662b80a4675973850b067c01fa5%2F3f43c48b21b24f4e8b02b100c0c8fab0"},"breadcrumb":{"@id":"https://respond.io/help/retain-customers/send-csat-and-save-data#breadcrumb"}},{"@type":"WebSite","@id":"https://respond.io/#website","name":"Respond.io","url":"https://respond.io/","potentialAction":{"@type":"SearchAction","query-input":"required name=search_term_string","target":"https://respond.io/search?query={search_term_string}"},"publisher":{"@id":"https://respond.io/#organization"}}]} ```