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
  • 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

                  • System Status

                    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