This is a submission for the Runner H "AI Agent Prompting" Challenge
🚀 What I Built
I created an Autonomous Sales Intelligence Agent that transforms raw customer emails into structured sales data and automated responses - completely hands-free. This AI-powered system eliminates the manual grunt work of processing customer inquiries by automatically:
🔍 Detecting sales opportunities from incoming emails
📊 Extracting structured data (customer info, products, quantities, pricing)
📋 Generating order records in Google Sheets with unique tracking IDs
📧 Sending personalized confirmation emails to customers
🔔 Notifying sales teams via Slack in real-time
📈 Providing predictive analytics for inventory planning
The system solves the critical problem of sales lead leakage 🚨 - where potential customers slip through the cracks due to delayed responses or missed emails in busy inboxes.
🎥 Demo
🔍 Key Workflow Components Covered:
The Autonomous Sales Intelligence Agent operates through a sophisticated multi-stage workflow that transforms customer emails into actionable business intelligence.
🚀 Initial Setup:
Store credentials and operational mode selection
OAuth integrations for Gmail, Google Sheets, and Slack
📧 Email Processing Pipeline:
Mock data generation for testing
Zapier integration for automatic email capture
DataHub sheet population
🤖 Intelligent Analysis:
Purchase intent detection
Structured data extraction
Unique order ID generation (KB-RunnerH-XXXXXX format)
📊 Multi-Channel Output:
Google Sheets order tracking
Real-time Slack notifications
Automated customer confirmations
🛠️ Advanced Modes:
System Maintenance for data integrity
Predictive analytics for inventory planning
💡 Business Value:
Zero-touch automation
Human-like communication
Seconds vs. hours response time
⚙️ How I Used Runner H
My prompt:
You are my autonomous Sales Intelligence Agent.
Your role is to transform every email into structured sales data and automated customer responses using Gmail, Google Sheets and Slack.
The task involves setting up a sales intelligence system using Zapier, Google Sheets, Gmail, and Slack.
The task is complex as it involves multiple integrations and setup processes.
I need zero-hallucination, data-driven sales automation.
🚀 Initial Setup:
Step 0 :
1. Prompt the user for his **Store name** and **email address**.
2. Obtain OAuth approval to **manage Google Sheet**, **send Gmail** and **send slack message** on his behalf.
3. ask the user to select one of the following operational modes:
- Batch Email Analysis Mode
- System Maintenance Mode
- Predictive Mode
Step 1 : Preparing mock data
send 5 mails to **email address** where u acte as a customer that wanna make a purchase on his store , the mail should include name of products , there quantity and contact info like physical address , mails should humanitize
Step 2 : Zapier Action processing
ask the user to confirm that zapier has complete his job .it tools about 2min. the Zapier action will add the new mails in the"Sales Intelligence Master" spreadsheet "DataHub" sheet otherwise the sheet will be empty
Step 3:according to the selected mode process one of the following operational modes:
mode 1 : "Batch Email Analysis Mode" :
step 1 : 🔍Mail Scraping :
read "Sales Intelligence Master" (ID : 1gENZ9isErDgNGzDP_NMs0thX0zB-O9TqXadEvkrwdUk ) spreadsheet "DataHub" sheet rows especially the content column to detect potential customers mails where they request products the mail addrees of the customer is included in the "Customer" column
📊 Simple Output Format:
📈 After Each Email Processed:
✅ NEW LEAD DETECTED:
Customer: John Smith (john@company.com)
Product: Industrial Printer (5 units needed)
Total Price: $2000
step 2: 📋 Fill the "Sales Intelligence Master" spreadsheet "Orders" sheet :
if there is no column header in the sheet put this list of headers OrderId, Customer, Price, DTCreation,DTShipping, DTDelivery, ContactInfo, Details
extract data for each mail content and insert it in the sheet ;
- generate an order ID in this format 'KB-RunnerH-DDDDDD', the D is for Digets,
- ContactInfo should include the customer mail adress which is equivalent to the "Customer" column in "DataHub" sheet and any relevant data the customer mentioned in his mail "Content" without halucination! sensitive data,
-the detail column sheet contains the list of product the customer ask for and its quantity.
respect the format of the "Orders" sheet it is as follow : OrderId, Customer, Price, DTCreation,DTShipping, DTDelivery, ContactInfo, Details
Return to the "DataHub" sheet and set the "Status" to "PROCESSED" for each well processed entry
step 3: 📊 Interact with Slack:
add a message to the slack channel #sales-deals, the message is in this format 'order ID', 'dateCreation','details'; u can update the msg fomat in a better format if needed.
step 4: send a response mail to the customers using this template at there mail ; the address is in the "DataHub" sheet "Customer" column :
Subject: Re: Order Confirmation - **OrderID**
Hi [Customer_Name],
Thank you for your purchase from **Store name** ! We're thrilled to confirm your order details as follows:
- Order ID: **Order ID**
- Products :**Details**
- Total Price: **Price**
Your order will be shipped to the address you provided: **ContactInfo**.
Should you have any questions or need assistance, feel free to reach out.
Warm regards,
[Store name] Customer Support
the mail should be sent to the same value in the "DataHub" sheet Customer column
step 5: confirm with the user if he want start a new mode
mode 3 : 🛠️ System Maintenance Mode:
step 1 :Clean duplicate entries in Google Sheets
step 2 :Validate data accuracy and completeness
step 3 : Generate system health reports
step 4: send the report to slack channel #sales-deals
mode : 🛠️ Predictive Mode:
where u predict the sales of the folloqing 3 weeks based on the orders tracking in the googlr sheet so the user could prepare his stock and u can add any relevant prediction u find
Always be proactive: after each response, ask the user of which mode to execute unless he write exit
The core innovation lies in the multi-modal operational system powered by Runner H's advanced prompting capabilities:
- 🧠 Intelligent Email Analysis
Uses natural language processing to identify purchase intent
Extracts structured data without hallucination
Maintains data integrity across multiple touchpoints
- 🎯 Multi-Mode Operations
📊 Batch Email Analysis Mode: Processes multiple emails simultaneously
🛠️ System Maintenance Mode: Cleans data and validates accuracy
🔮 Predictive Mode: Forecasts sales trends for inventory planning
- 🤖 Automated Workflows
Dynamic order ID generation (KB-RunnerH-XXXXXX format)
Template-based customer communication
Real-time team notifications
💼 Use Case & Impact
🎯 Primary Beneficiaries:
🛒 E-commerce Store Owners: Eliminate manual order processing
🏢 Small Business Owners: Scale customer service without hiring
💰 Sales Teams: Focus on closing deals, not data entry
📞 Customer Service Reps: Reduce response times from hours to minutes
📈 Business Impact:
⚡ 95% reduction in manual email processing time
🕐 24/7 automated customer response system
🎯 Zero sales lead loss through systematic tracking
📊 Predictive inventory management prevents stockouts
😊 Improved customer satisfaction with instant confirmations
💡 Innovation Differentiators:
🎯 Zero-hallucination data extraction ensures accuracy
🔄 Multi-modal operations adapt to different business needs
🔮 Predictive analytics provide strategic insights
🔗 Seamless integration with existing business tools
🌍 Real-World Applications:
📦 Dropshipping businesses managing high email volumes
🏭 B2B suppliers processing bulk order inquiries
🔧 Service providers converting emails to project requests
🏪 Retail stores automating customer order confirmations
This solution transforms the traditional reactive email management into a proactive sales intelligence system 🔄, turning every customer email into a structured business opportunity while maintaining the human touch through personalized automated responses.
🎯 Conclusion
The Autonomous Sales Intelligence Agent represents a paradigm shift from reactive email management to proactive sales intelligence. By seamlessly integrating AI-powered email analysis with real-time automation across Gmail, Google Sheets, and Slack, this system doesn't just process emails—it transforms every customer interaction into a structured business opportunity.
Happy reading!📚✨
Top comments (0)