CODEWITHSUNDEEP
google-sheetsgoogle-cloud-nl
Kevin Deenanauth
Kevin Deenanauth

Reputation: 936

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?

Upvotes: 1

Views: 1302

Answers (1)

Kevin Deenanauth
Kevin Deenanauth

Reputation: 936

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).

Upvotes: 5

Related Questions