How to use OpenAI's ChatGPT for sentiment analysis

About Rows

Rows is the easiest way to import, transform, and share data in a spreadsheet. It combines a spreadsheet editor, +50 integrations with the tools you use every day, a powerful AI Analyst✨, and a sharing experience to instantly turn any spreadsheet into a web app, a form, or a dashboard.

Connect the OpenAI integration

To connect the integration, open a new spreadsheet, and select the OpenAI integration on the welcome side panel. Alternatively, you can search for the integration inside the Data actions panel.

Inside the actions panel, search for "Sentiment analysis" and select the action.

Finally, Connect the integration to get started.

The Free plan includes 20 free uses of the OpenAI integration. Users on the Plus or Pro plans have unlimited access to OpenAI and can use their API key to access any OpenAI model, including fined-tuned models. By default, the OpenAI integrations use the "gpt-3.5-turbo" model.

Use the Sentiment Analysis action

Once the integration is connected, you can start using OpenAI in Rows to perform sentiment analysis on any piece of text.

Alternatively, you can use the Sentiment analysis function directly in the spreadsheet. Type =SENTIMENT_ANALYSIS_OPENAI to see the autocomplete.

All OpenAI functions need to be configured through mandatory and optional parameters, depending on their purpose. Let's go through them.

Text

The Sentiment Analysis function only requires one parameter, the text. This is simply the text you want to run sentiment analysis on.

You can write the text directly inside the text field in the action wizard, or reference any cell in the table by pointing to it on the editor.

The action will automatically classify the sentiment between: Very positive, Positive, Neutral, Negative or Very Negative.

The remaining parameters are all optional and commonly used for advanced use cases. Learn more about them in the Sentiment analysis function documentation.

Examples

There are several ways to use OpenAI for sentiment analysis:

• Classify sentiment in social media comments: Determine the overall sentiment on comments on your (or competitors') social media profiles.
• Rate sentiment from customer feedback: Determine the customer sentiment on product reviews, or feedback survey responses.

Classify sentiment in social media comments or customer feedback

Goal

Analyze comments from social media accounts or any piece of content, and extract the sentiment from the text.

Example:

1=SENTIMENT_ANALYSIS_OPENAI(A2)

Details:

Add the social comment to be analyzed as the first argument (here, cell A2).

💡 Use our Zapier or Make connector to automatically add a new row in the spreadsheet for a new comment to your social media profiles, customer support emails to your ticketing tool or replies to a feedback form.