Sentiment Analysis on Google Sheets with VADER using Python and Google Cloud Functions

A Cloud Functions recipe for sentiment analysis

TLDR

We will be discussing how to set up a basic workflow to perform simple sentiment analysis on text in Google Sheets. Specifically, we will be:

1. Using Python and the Google Sheets API to read comments data in a spreadsheet
2. Applying VADER (Hutto & Gilbert, 2014), an open-source sentiment analyser from the nltk package to perform sentiment analysis
3. Writing the results to another tab in your Google Spreadsheet …

analysis cloud data engineering data science google google cloud google cloud platform python sentiment sentiment analysis vader