Pari Agarwal's Work | ContraWork by Pari AgarwalPari Agarwal
Workflow automation expert
Inbound Lead Intelligence & CRM Enrichment System
Problem Statement
Delayed Response Times: Sales teams spend valuable hours reading unstructured client project notes and calculating fit manually.
Inconsistent Lead Qualification: Different team members interpret lead urgency and budget alignment differently, leading to missed high-value opportunities.
Manual Data Entry Bottlenecks: Transferring notes, determining follow-up actions, and keeping CRM sheets updated manually creates operational drag.
.Monitors the Inbound Leads Tracker for new or unreviewed lead submissions containing client contact info, service required, budget range, and project requirements.
Passes the unstructured project notes, requested service, and budget to Google Gemini with a prompt designed to:
Evaluate client urgency and budget alignment.
Assign a standardized AI Score (Hot, Warm, Cold).
Generate a concise 1–2 sentence AI Summary of the client’s core requirement.
Provide a concrete Suggested Action (e.g., "Schedule a discovery call to discuss integration details and provide a tailored solution").
90%+ Reduction in Lead Triage Time: Instantaneous processing replaces hours of manual screening.
Faster Speed-to-Lead: High-intent leads marked as "Hot" can be contacted within minutes, significantly improving lead-to-opportunity conversion rates.
Consistent Qualification Criteria: Eliminates subjective bias by anchoring qualification to unified budget and intent rubrics. Lead Validation & Instant Auto-Responder
Operational Challenge
Unmonitored spreadsheets lead to cold prospects. In addition, raw lead rows frequently contain corrupt entries (e.g., mailer-daemon bounce loops) that crash automated mailing pipelines with validation faults.
Engineered Pipeline
Poller: Watches new rows on Google Sheets in real-time.
Pre-Execution Filter: Validates address syntax before Gmail call.
Dispatcher: Injects dynamic parameters into HTML template. Inbound Email Lead Parser to Google Sheets
Business Problem
service inquiries sent directly to business email inboxes were previously processed manually. Manual copying produced a 6–12 hour latency in lead acknowledgment, data entry typos in emails, and misplaced opportunities.
Architecture & Data Flow
Trigger: Gmail Watch Emails listening for incoming messages.
Extractor: Maps sender name, sender email, and timestamp variables.
Storage: Google Sheets Add a Row writes structured record. I designed and built an automated financial pipeline integrating Xero Accounting with Notion using Make.com (http://Make.com).
The automation instantly captures incoming invoices, maps key accounting fields (including Invoice Number, Amount Due, and relevant dates), and creates structured records directly inside a centralized Notion database.
Key Highlights:
End-to-End Automation: Configured dynamic data payloads and webhooks to trigger seamless, real-time record synchronization.
Schema Validation & Error Handling: Resolved API data type constraints and property-key casing to ensure error-free execution.
Impact: Eliminated manual data entry, removed reconciliation discrepancies, and provided instant visibility into accounts receivable and cash flow.