Classifying E-Commerce User Feedback Tutorial For Sheets

	A	B	C	D	E	F
1	Model:GPT-4o	Product Feedback	Feedback Category	Sentiment	Follow Up Required? Y/N	To try this exercise for yourself: 1. Start GPT for Sheets from the Extensions Menu. 2. Ensure functions aren't paused, and spending is on. 3. Change the model to gpt-4o if it isn't already set. GPT for Excel Home Bar >{model name} >gpt-4o 4. Navigate to the Classify/Categorize bulk tool Bulk tools>Classify/Categorize 5. Target column B 6. Copy & paste the category list in C2 into the category field in the GPT for Excel Word sidebar 7. Put the results in column C 8. Run three rows and check for errors 9. if there are no errors, run all rows 10. Repeat steps 6-9, changing the categories to match the respective columns. 11. For the Follow Up column, make sure to set the classification instructions and custom instructions as per cell E2
2	Function/Tool:Classify bulk tool	Prompt/Categories ->	Into one of these categories:Product Quality, Shipping Issues, Customer Service, Payment Problems, Product Description Accuracy, Return and Refund, Usage, Value for Money, Website Bug, MISC	Into one of these categories:Very Positive, Positive, Neutral, Negative, Very Negative	Into one of these categories: Yes, No, Unsure Add Classification Instructions:Analyze customer feedback to determine if further customer service support or follow-up is needed. Each feedback entry relates to user experiences with various products they bought from an e-commerce store. Consider whether the feedback indicates unresolved issues, dissatisfaction, or requests for assistance. Settings-> Custom Instructions-> Set as Customer Support Agent
3	Product Name	Product Feedback	Feedback Category	Sentiment	Follow Up Required? Y/N
4	Philips Hue Smart Bulbs	"The bulbs are great when they work, but they keep disconnecting from the app. It's so frustrating to keep resetting them."
5	Walker Edison TV Stand	"Worst TV stand I've ever owned. The material feels cheap and it started wobbling after a week. Totally unacceptable."
6	Canon EOS Rebel T7	"Using the Canon EOS Rebel T7 has been a breeze. The camera is very user-friendly, and the quality of the photos is fantastic. I'm really happy with this purchase."			#NAME?
7	Apple MacBook Pro	"The Apple MacBook Pro has excellent build quality. It feels solid and premium. However, the keyboard could be better."
8	Fitbit Charge 4	"The Fitbit Charge 4 is great, but syncing it with my phone was a bit tricky. Once set up, it works perfectly."
9	KitchenAid Stand Mixer	"Setting up the KitchenAid Stand Mixer was straightforward. It’s a bit heavy, but it works wonderfully for all my baking needs."
10	Dyson V11 Vacuum	"The Dyson V11 Vacuum is powerful and easy to maneuver. Cleaning my house has never been easier. The battery life is also impressive."
11	Instant Pot Duo	"The Instant Pot Duo is super easy to use. The instructions were clear, and I was cooking meals in no time. Highly recommend it!"
12	Patagonia Down Jacket	"The Patagonia Down Jacket is extremely warm and well-made. It’s perfect for winter. A bit pricey, but worth it for the quality."
13	Samsung Galaxy S21	"The Samsung Galaxy S21 is a top-notch phone. The screen is beautiful, and the performance is lightning fast. I haven't encountered any issues so far."
14	Bose SoundLink Speaker	"The sound quality of the Bose SoundLink Speaker is outstanding. It delivers clear and rich audio. Very pleased with this purchase."
15	Herman Miller Aeron Chair	"The Herman Miller Aeron Chair is incredibly comfortable and well-built. It has really improved my home office setup. Worth every penny."
16	Roomba i7+	"The Roomba i7+ is quite efficient in cleaning, but it often gets stuck under furniture. It's a good product, but not perfect."
17	Sony WH-1000XM4 Headphones	"The sound quality of the Sony WH-1000XM4 headphones is great, but they are a bit tight on the ears. Overall, not bad."
18	Anker PowerCore 10000	"The Anker PowerCore 10000 is a reliable portable charger. It does the job, but nothing exceptional."
19	Dell XPS 13	"The Dell XPS 13 has a beautiful screen and great performance. However, it gets a bit warm during heavy use. Still, a solid laptop."
20	GoPro HERO9	"Using the GoPro HERO9 for my outdoor adventures has been amazing. The video quality is top-notch, and it's very durable."
21	Graco All In One Car Seat	"I got the mauve/pink colour and found it a bit more purple than I expected from photos. It’s very well built and solid, a bit on the heavier side but I feel like my baby is safe in it. We purchased as our second car seat and I’m happy that my daughter will be able to sit rear facing for quite a bit longer and that this car seat will grow with her! We got it on sale and found it cheaper on Amazon than from babies r us or Canadian tire or Walmart. Shipping was quick and I was able to do the Amazon payment plan to break it up so it wasn’t such a big expense in one go. It was a little tricky for my to install but once it’s in it seems very secure. It seems very comfortable but the only thing is that for my daughter who is 18 months, rear facing, it’s a bit of recline, once she is strapped in she can’t reach the cup holders. Once she’s bigger and or forward facing I’m sure it won’t be an issue but it’s a bit of an inconvenience at this stage. The fabric seems to be a bit sensitive to staining, minor spills seems to discolour the fabric and for this reason I wish I got black instead. It reminds me of those old microsuede couches that seem stained even if you spill water, just not quite as bad. Again it seems very comfortable with nice padding and the mauve colour is really cute! It just requires a bit more upkeep and wiping it clean than a darker colour would if you care about that. Will update with a photo when I pop out to my car next. This is my third baby and I wish I would’ve just purchased this car seat with all 3!"
22	Crate & Barrel Dining Chairs	"The dining chairs are very comfortable and look stunning with my dining table. Highly recommend!"
23	Bose SoundLink Revolve	"This portable speaker has great sound quality and is very portable. Battery life could be a bit longer."
24	West Elm Velvet Curtains	"The curtains are beautiful and add a touch of elegance to my room. However, they arrived with a small stain."
25	Tumi Alpha 3 Carry-On	"This suitcase is durable and spacious. Fits perfectly in the overhead bin, but it’s a bit heavy."
26	Winsome Wood Dining Table	"This dining table is perfect for my small apartment. It's sturdy, looks great, and was easy to assemble. Very satisfied."
27	Whirlpool Washing Machine	"Received excellent help from customer service when I had a question about my Whirlpool washing machine order. They were very responsive and resolved my issue quickly. I appreciate the great service and will definitely shop here again."
28	IKEA Markus Chair	"My product' didn’t arrive in time, I do not like this service!! I was expecting the chair much sooner and have been left very disappointed. This has been a very bad experience for me."
29	HP Envy Printer	"Returning the broken HP Envy printer was a pain. Still waiting on refund. The whole process has been incredibly slow and frustrating. I’m very unhappy with how this has been handled."
30	PlayStation 5	"The app keeps crashing every time I try to place an order for a consoel. It's very frustrating and I've already tried reinstalling it. Please fix this issue!"
31	Samsung Galaxy Tab	"The payment didn't go through for my Samsung Galaxy Tab, but my card was still charged. Now I have to deal with getting my money back. Fix this! This is very frustrating and has caused me a lot of unnecessary stress."
32	Dell Inspiron Laptop	"I got charged three times for my Dell Inspiron laptop order. I contacted customer service, but they said it would take up to 10 days to resolve. So annoying and inconvenient. I don't understand how this even happened. Not happy at all."
33	Samsung QLED TV	"Customer support was amazing! They helped me resolve my issue with the Samsung QLED TV quickly and were so polite throughout the whole process. I was really impressed with how efficiently they handled everything. Definitely five-star service!"
34	Nike Air Max Shoes	"I tried contacting customer support about the missing parts for my Nike Air Max shoes, but they were no help at all. Very disappointed with how unhelpful and rude they were."
35	Sony Headphones	"Refund took over a month for my Sony headphones. Very slow process and very frustrating. I had to keep following up, and it just took way too long. Not happy with the experience."
36	Bose QuietComfort Headphones	"Charged extra fees that weren't mentioned for the new Bose QuietComfort headphones I bought. Not cool. I feel like I was misled about the total cost. This has really put me off from buying here again. Very unhappy."
37	Amazon Echo Dot	"Item was missing parts. How do I get replacements for my Amazon Echo Dot? I can’t use it without the missing pieces, and I need this resolved quickly. Very frustrating experience."
38	Adidas Running Shoes	"The Adidas running shoes fell apart after a week. Very disappointed with the quality. I expected them to last much longer. This has been a very disappointing purchase."
39	Apple iPhone 13	"The customer service rep was very patient and helped me track down my Apple iPhone 13 package. It was delayed but at least I know where it is now. Great service!"
40	Ninja Blender	"Had to return the faulty Ninja blender, and the refund process was a nightmare. It took weeks to get my money back, and I had to constantly follow up with customer service. This has been such a frustrating experience."
41	LG Refrigerator	"Customer service kept me on hold for hours. Ridiculous! I just had a simple question about my LG refrigerator order, and it took forever to get through to someone. Very poor customer service experience."
42	Cuisinart Chef's Knife	"The Cuisinart Chef's Knife has quickly become an essential tool in my kitchen. Its sharpness is impressive, allowing me to slice through vegetables and meats with ease. The handle is comfortable and provides a good grip, even when my hands are wet. However, I've noticed that the blade tends to dull faster than expected, requiring frequent sharpening. Despite this minor inconvenience, the knife's performance is generally excellent, making prep work much faster and more enjoyable. I would highly recommend this knife to both amateur cooks and professional chefs alike."
43	OXO Good Grips Can Opener	"The OXO Good Grips Can Opener is so easy to use. It cuts smoothly and the handles are very comfortable. Highly recommended!"
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100