<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>Forem: Deivis Matheus</title>
    <description>The latest articles on Forem by Deivis Matheus (@dmatheusccs).</description>
    <link>https://forem.com/dmatheusccs</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3269433%2F96c76be8-c9f8-42d4-834f-79fdf6e4312c.jpg</url>
      <title>Forem: Deivis Matheus</title>
      <link>https://forem.com/dmatheusccs</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://forem.com/feed/dmatheusccs"/>
    <language>en</language>
    <item>
      <title>Customer Complaint Analyzer</title>
      <dc:creator>Deivis Matheus</dc:creator>
      <pubDate>Sat, 05 Jul 2025 19:41:22 +0000</pubDate>
      <link>https://forem.com/dmatheusccs/customer-complaint-analyzer-3aa3</link>
      <guid>https://forem.com/dmatheusccs/customer-complaint-analyzer-3aa3</guid>
      <description>&lt;p&gt;This is a submission for the &lt;a href="https://dev.to/challenges/runnerh"&gt;Runner H "AI Agent Prompting" Challenge&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  💬 Customer Complaint Analyzer – End-to-End AI Workflow
&lt;/h2&gt;

&lt;h2&gt;
  
  
  What I Built
&lt;/h2&gt;

&lt;p&gt;I created an autonomous AI workflow that reads customer complaints from a Google Sheet, analyzes their sentiment and issue type, and simulates full follow-up actions across documentation, email, messaging, and scheduling.&lt;/p&gt;

&lt;p&gt;The agent helps streamline customer support tasks, enabling fast triage of issues without any manual filtering or writing code.&lt;/p&gt;

&lt;h2&gt;
  
  
  Demo
&lt;/h2&gt;

&lt;p&gt;🎥 Watch the demo here:&lt;br&gt;&lt;br&gt;
👉 [&lt;a href="https://drive.google.com/file/d/1-RS9cO3BEkJSWFdKoGpC19qAPJRw470h/view?usp=sharing" rel="noopener noreferrer"&gt;https://drive.google.com/file/d/1-RS9cO3BEkJSWFdKoGpC19qAPJRw470h/view?usp=sharing&lt;/a&gt;]&lt;/p&gt;

&lt;h3&gt;
  
  
  Resources
&lt;/h3&gt;

&lt;blockquote&gt;
&lt;p&gt;If the video doesn't load, you can also check the attached PDF summary generated by Runner H. &lt;br&gt;
(RunnerH Output):&lt;br&gt;
&lt;a href="https://drive.google.com/file/d/1DYAt5pKtZsy12NxBLVk-LvUJrvg0MSIB/view?usp=sharing" rel="noopener noreferrer"&gt;https://drive.google.com/file/d/1DYAt5pKtZsy12NxBLVk-LvUJrvg0MSIB/view?usp=sharing&lt;/a&gt;&lt;br&gt;
Customer_Complaints_Example_file:&lt;br&gt;
&lt;a href="https://docs.google.com/spreadsheets/d/1we19oHz7ALnspENcOxFqdDjLaFF3rsmK/edit?usp=sharing&amp;amp;ouid=113936526163083910773&amp;amp;rtpof=true&amp;amp;sd=true" rel="noopener noreferrer"&gt;https://docs.google.com/spreadsheets/d/1we19oHz7ALnspENcOxFqdDjLaFF3rsmK/edit?usp=sharing&amp;amp;ouid=113936526163083910773&amp;amp;rtpof=true&amp;amp;sd=true&lt;/a&gt;&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;Prompt File:&lt;br&gt;
&lt;a href="https://drive.google.com/file/d/1SKp19IwMrUGgePE5snIp2A0G9GxYe9TY/view?usp=sharing" rel="noopener noreferrer"&gt;https://drive.google.com/file/d/1SKp19IwMrUGgePE5snIp2A0G9GxYe9TY/view?usp=sharing&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  How I Used Runner H
&lt;/h2&gt;

&lt;p&gt;I used Runner H to perform the following steps in a single prompt:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Open and read data from a live Google Sheet containing 10 customer complaints.&lt;/li&gt;
&lt;li&gt;Analyze each complaint’s sentiment (Positive, Neutral, Negative).&lt;/li&gt;
&lt;li&gt;Classify the complaint into categories (e.g., Delivery, Product Issue, Payment, Website).&lt;/li&gt;
&lt;li&gt;Update the sheet with new “Sentiment” and “Category” columns and mark rows as “Processed”.&lt;/li&gt;
&lt;li&gt;Simulate creating a summary report in Google Docs with totals by sentiment and category.&lt;/li&gt;
&lt;li&gt;Simulate sending a summary email and posting the results in Slack.&lt;/li&gt;
&lt;li&gt;Simulate scheduling a meeting in Google Calendar if ≥3 negative complaints were found.&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  🔁 Workflow: Complaint Processing &amp;amp; Reporting
&lt;/h2&gt;

&lt;p&gt;For each row:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Detect sentiment&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;Options: Positive, Neutral, or Negative&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Classify complaint type&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;Options: Delivery, Payment, Product Issue, Website, Other&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Add two new columns&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;Sentiment&lt;br&gt;
Category&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Mark row as "Processed"&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;After processing all rows:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Generate a Google Doc report&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;Include totals by Sentiment and Category&lt;br&gt;
Add a list of Urgent Issues (Negative + Product Issue)&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;If there is at least one negative complaint:&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;Schedule a 15-minute meeting with the QA/CX team via Google Calendar&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Send an email&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;To: &lt;a href="mailto:qa-support@example.com"&gt;qa-support@example.com&lt;/a&gt;&lt;br&gt;
Content: Summary and link to the report&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Post a Slack message&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;Include sentiment/category counts&lt;br&gt;
Attach link to the report&lt;/p&gt;

&lt;p&gt;All actions were executed or simulated from a single prompt, showing the power of Runner H as a no-code task delegate.&lt;/p&gt;

&lt;h2&gt;
  
  
  Use Case &amp;amp; Impact
&lt;/h2&gt;

&lt;p&gt;This type of automation is valuable for QA teams, CX leads, and small businesses dealing with user feedback.&lt;/p&gt;

&lt;p&gt;Instead of manually checking each support message, this agent can sort, report, and trigger next steps in minutes—improving team response times, customer satisfaction, and operational efficiency.&lt;/p&gt;

&lt;p&gt;Even in simulation mode, this workflow proves that everyday business processes can be handled autonomously with AI agents.&lt;/p&gt;




&lt;h3&gt;
  
  
  Social Love
&lt;/h3&gt;

&lt;p&gt;(&lt;a href="http://www.linkedin.com/in/deivismatheusdccs1234" rel="noopener noreferrer"&gt;www.linkedin.com/in/deivismatheusdccs1234&lt;/a&gt;)&lt;/p&gt;




&lt;p&gt;RunnerH made it incredibly easy to automate what would normally take hours of scripting or manual work. This challenge proves how accessible AI agents can be for solving real-world workflows, no coding required.&lt;/p&gt;

&lt;p&gt;Thanks again to the Runner H team for organizing this challenge and inspiring creative agent design...&lt;/p&gt;

</description>
      <category>devchallenge</category>
      <category>runnerhchallenge</category>
      <category>ai</category>
      <category>machinelearning</category>
    </item>
  </channel>
</rss>
