US English (US)
ES Spanish

Submit Article Requests

Do you have a suggestion for an article you would like to see created?
Feel free to submit this form and add your suggestions to our document board.

Please fill out the contact form below and we will reply as soon as possible.

  • Appcues Certifications & Training
  • Integration Hub
  • Contact Us
English (US)
US English (US)
ES Spanish
  • Docs home
  • Integrations
  • Use Cases

Send NPS Submissions to Google Sheets using Zapier

Automatically send NPS customer responses to a Google Sheets spreadsheet, quickly and easily using Zapier.

Updated at May 6th, 2025

Submit Article Requests

Do you have a suggestion for an article you would like to see created?
Feel free to submit this form and add your suggestions to our document board.

Please fill out the contact form with the details about the help content you'd like to see.

  • Home

  • Installation & Developers

    • Web Experiences

      • Mobile Experiences

        • Workflows

          • Analytics & Data

            • Account Management

              • Best Practices

                • Integrations

                  Table of Contents

                  Zap Trigger Step 1: Select Appcues Trigger Step 2: Select “NPS Submission” Event Step 3: Connect your Appcues Account Step 4: Test Trigger Step 5: Select the nps_score Sample Event Zap Action Step 1: Select Google Sheets Action Step 2: Select “Lookup Spreadsheet Row” Action Step 3: Connect your Google Sheets Account Step 4: Connect to Specific Google Sheet Step 5: Choose the Lookup Column and Value Step 6: Create Google Sheets Spreadsheet Row if it doesn’t exist Step 7: Test the Action Step 8: Create Update Spreadsheet Row in Google Sheets Action Step 9: Connect Action to Google Sheets Step 10: Select Row to Update Step 11: Choose Fields to Update in your Google Sheet Step 12: Test the Action Publish Your Zap!

                  NPS is one of the most important metrics your team can measure. Send all NPS submissions directly to Google Sheets, so that your team can follow along and take action on feedback submissions in real-time!

                  Note: This Zap requires a paid Zapier plan.

                   

                  Before creating the Zap, you will want to create a Google Sheet spreadsheet that contains columns for each property that you would like to track. In this guide, we will have columns for:

                  • User ID
                  • Timestamp
                  • NPS Score
                  • NPS Feedback

                  Feel free to add any other columns that are relevant to your team!

                   

                  Zap Trigger

                  Step 1: Select Appcues Trigger

                  Step 2: Select “NPS Submission” Event

                  Step 3: Connect your Appcues Account

                  Check out our Using Appcues and Zapier article for more information on connecting to your Appcues account.

                   

                  Step 4: Test Trigger

                  There are two corresponding events for the NPS Submission Trigger. Your test should return two sample events, one for NPS Score and one for NPS Feedback.

                  If the test does not return two events, you may need to trigger these events in your application. 

                  Step 5: Select the nps_score Sample Event

                  Zap Action

                  Step 1: Select Google Sheets Action

                  Step 2: Select “Lookup Spreadsheet Row” Action 

                  Step 3: Connect your Google Sheets Account

                  Step 4: Connect to Specific Google Sheet

                  1. Choose Google Sheets Drive.
                  2. Choose Google Sheets Spreadsheet.
                  3. Choose Google Sheets Worksheet to send your data to.

                  Step 5: Choose the Lookup Column and Value

                  1. Lookup Column: select the name of the column that should hold a unique identifier for your users (eg: User ID). 
                     

                  2. Lookup Value: select the field in the sample event that holds the unique identifier. 

                  Step 6: Create Google Sheets Spreadsheet Row if it doesn’t exist

                  1. Check the “Create Google Sheets Spreadsheet Row if it doesn’t exist” box.

                  2. Select the field in the sample event that corresponds with the unique identifier, timestamp, and NPS score columns. 

                  3. Remove extra fields.

                  4. Return back to the Zap trigger,  select the nps_feedback sample event, and click “Continue with selected record”.

                  5. Return to Lookup Spreadsheet Row in Google Sheets Action and select the field in the sample event that corresponds with the NPS feedback column.

                  Step 7: Test the Action

                  Step 8: Create Update Spreadsheet Row in Google Sheets Action

                  Step 9: Connect Action to Google Sheets

                  Using the inputs in step 4, connect to your Google Sheet.

                  Step 10: Select Row to Update

                  After the Lookup action is completed, if the row already existed in your spreadsheet before the Zap ran, the Update Spreadsheet Row action will use that row ID to update the existing row. Here's how to select the row ID:

                  1. Select “Custom” in the Row dropdown menu.
                  2. Click “Lookup Spreadsheet Row in Google Sheets”.
                  3. Choose ID. 

                  Read more about this step here. 

                   

                  Step 11: Choose Fields to Update in your Google Sheet

                  Using the “NPS Submitted in Appcues” event, select all corresponding fields to be updated in your Google Sheet.

                  Step 12: Test the Action

                  Publish Your Zap!

                  Congrats on creating your Zap!

                  Now that your Zap is published when a user submits an NPS score or feedback in Appcues Zapier will look for a row that exists for that user, create the row if it does not exist, and update an existing row with NPS data. 

                  google sheets nps submission send nps to google sheets zapier

                  Was this article helpful?

                  Yes
                  No
                  Give feedback about this article

                  Related Articles

                  • Events Broadcaster
                  • Personalize onboarding for Facebook generated leads with Zapier
                  • Calculate NPS by account with Salesforce
                  Appcues logo

                  Product

                  Why Appcues How it works Integrations Security Pricing What's new

                  Use cases

                  Appcues Integration Hub User Onboarding Software Feature Adoption Software NPS & Surveys Announcements Insights Mobile Adoption

                  Company

                  About
                  Careers

                  Support

                  Developer Docs Contact

                  Resources

                  The Appcues Blog Product Adoption Academy GoodUX Case studies Webinar Series Made with Appcues Appcues University

                  Follow us

                  Facebook icon Twitter icon grey Linkedin icon Instagram icon
                  © 2022 Appcues. All rights reserved.
                  Security Terms of Service Privacy Policy

                  Knowledge Base Software powered by Helpjuice

                  Expand