Get sentiment analysis from Youtube comments and save to Google Sheets

Say goodbye to drowning in a sea of comments and struggling to make sense of them. This automation is here to save the day. It effortlessly scrapes comments from the currently opened YouTube video, runs a sentiment analysis, and saves the results to a Google Sheets spreadsheet.

Managing YouTube comments can be a real headache, but this automation simplifies everything. Imagine analyzing comment sentiments with just a few clicks. Whether you're a content creator, social media manager, or researcher, it has got you covered.

You can use it for research, competitor analysis, or tracking your own performance. You can even sort through feedback and turn positive comments into glowing testimonials. 

Supercharge your YouTube experience with this automation that integrates YouTube, sentiment analysis, and Google Sheets. Get ready to save time, gain insights, and dominate the YouTube game like a pro.

Let’s set it up!

Step 1: Pin the playbook and integrate Google Sheets and YouTube

First, click the “Pin it” button at the top of this page to save this automation. You will be redirected to install the browser extension when you run it for the first time. Bardeen will also prompt you to integrate Google Sheets.

Activate Bardeen (or hit OPTION + B on your keyboard) and click to run the playbook. The setup flow will start.  Bardeen will ask you to specify the maximum number of comments to extract and to specify a Google Sheets spreadsheet to save the information. You can choose an existing spreadsheet or create a new one from scratch.

Click on “Save Input” and checkmark Google Sheets. You can edit Inputs later by hovering over the playbook. 

Step 2: Run the playbook to analyze Youtube comments and save to Google Sheets

Whenever you want to run a sentiment analysis -on your or your competitors' videos, navigate to the video’s comment section, activate Bardeen (or hit OPTION + B) and run this playbook. It will capture all the comments, run a sentiment analysis and save the information to your Google Sheets spreadsheet.

This automation is fantastic if you want to conduct in-depth research by analyzing the sentiment of YouTube comments related to specific topics or trends. You can also dive into competitor analysis by comparing the sentiment of comments on your videos versus those of your rivals and perform performance analysis by tracking sentiment trends over time to see how your content resonates with your audience.

Additionally, you can use this automation as a powerful tool for sorting through feedback. Quickly identify positive or negative sentiments to gain insights into what your audience loves or areas that need improvement. You can even leverage positive sentiment comments as testimonials to showcase the impact of your content or products.

You can also edit the playbook and add your next action to further customize the automation.

Find more Google Sheets integrations, YouTube integrations, and Google Sheets and YouTube integrations.

You can also find more about  how to increase your personal productivity and automate your data sourcing and research process. Or explore adding AI to your Google Sheets.