Bulk Sentiment Analysis

Without all the busy work

One of the best sources of qualitative info about your product is probably on a Product review site like Capterra or G2 crowd. However, finding actionable trends or sentiments can be tedious work.

So let’s do it supa fast with ChatGPT and Google Sheets.

Use these prompts

Themes

This will help ChatGPT the sentiment.

Summarize into 3 phrases

⁠

Copy Prompt to Clipboard

⁠

Sentiment Score

Weigh the sentiment of the message numerically on a scale of 0 to 100. Start at a score of 50. The more positive the sentiment the higher the score. The more negative the sentiment the lower the score. If in doubt you should weigh sentiment slightly negatively. Don't write any words or explanations. Just the numerical score.

⁠

Copy Prompt to Clipboard

⁠

Why make themes?

I found that the sentiment scores were more accurate when I did.

How your google Sheet will look:

How your google Sheet will look:

Reviews 😜

Themes

Sentiment Score

I had a pleasant experience at this taco shop. The tacos were good, with fresh ingredients that made them flavorful. The service was alright, with the staff being friendly and attentive. I liked the variety of tacos that were available, as there were a few different options to choose from. I would recommend this taco shop to anyone looking for a decent meal.

Pleasant taco shop experience, flavorful tacos, friendly staff.

I had a fine experience. The tacos weren't great, with stale and unappetizing ingredients. The service was lackluster, with the staff being rude and unhelpful. I disliked the lack of variety in the tacos, as there were only a few different options to choose from. I would not recommend this taco shop to anyone.

Unsatisfactory taco shop, poor service, limited variety.

I hate this place with every fiber of my being. It's a horrible place and I wouldn't wish it on my worst enemy. I don't even think I can adequately describe how much I loathe it. To make matters worse, I had the misfortune of eating at the taco stand in this place, and it was definitely the worst meal I have ever had. I would much rather take my chances with death than eat there again. I'm not exaggerating. I would never step foot in that place again for as long as I live.

Hates the place; Worst meal ever; Never returning.

There are no rows in this table

⁠

More GPT for Sheets Prompts

I got hella prompts for PM’s.

⁠

ChatGPT for Sheets Prompts GPT for Sheets is legendary⁠

⁠

You got Product Prompts?

Share your product AI prompt.

⁠

Submit Your Prompt⁠

⁠

Follow me on Tik Tok

I make videos of how to use all these prompts on tik tok: @productbarf

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.