google-sheetsgoogle-cloud-nl

Google Sheets Sentiment Analysis

How can I utilize the Google Cloud Natural Language API to perform sentiment analysis for text in a Google Sheet?

Is there an integration available or is there a proper way to integrate their REST API?

Solution

  • I was able to hack something together using Google Apps Script.

    You can make a copy of: https://docs.google.com/spreadsheets/d/1VPOckCelGrjMoF8llnpE6IEM-UybwT6wrYb5BxVERIw/edit?usp=sharing

    Be sure to go into the script editor (Toolsā‡’Script Editor...) and specify your GOOGLE_CLOUD_API_KEY via Script Properties (Fileā‡’Project Properties, Script Properties).