How to Connect Google Sites Buttons to Google Sheets for Upvoting
In this video, you'll learn how to create interactive buttons on Google Sites that connect to Google Sheets, enabling functionalities like upvoting, voting on topics, and collecting NPS scores. The tutorial covers creating and deploying a Google Apps Script web app to handle button clicks and update the spreadsheet dynamically. Step-by-step instructions include setting up the Google Site, writing the script, deploying it as a web app, and testing it to ensure accurate data collection.
00:00 Introduction to Google Sites and Sheets Integration
00:41 Setting Up Google Sites and Creating Buttons
02:11 Deploying the Web App
04:04 Testing and Validating the Integration
05:18 Adding Thumbs Up and Thumbs Down Functionality
07:44 Final Adjustments and Troubleshooting
09:04 Conclusion and Final Thoughts