Build a Python Automation for Processing Customer Inquiries with OpenAI

Posted last week

Worldwide

Summary

I need a small Python automation that processes customer inquiries submitted through a website form using the OpenAI API. When a new inquiry is received, the Python script should: Read the customer’s name, email address, and message. Use the OpenAI API to generate a short summary of the inquiry. Classify the inquiry into one of several categories:Sales Technical Support Billing General Question Determine its priority: Low, Medium, or High. Save the original inquiry and AI-generated results to Google Sheets. Send a formatted notification to a Telegram chat. Technical Requirements Python 3.10 or newer OpenAI API integration Google Sheets API integration Telegram Bot API integration API keys must be stored in environment variables and not hardcoded Basic error handling and logging Duplicate submissions should not be processed twice AI output should use a structured JSON format Deliverables Complete Python source code requirements.txt file .env.example file without real credentials Setup and usage instructions in a README.md A short demonstration using test data Acceptance Criteria The script successfully processes a test inquiry. OpenAI returns a summary, category, and priority in a structured format. The result is added to Google Sheets. A Telegram notification is sent successfully. Invalid or incomplete submissions are handled without crashing. No credentials are included in the source code.

  • $50.00

    Fixed-price
  • Intermediate
    Experience Level
  • Remote Job
  • One-time project
    Project Type
Skills and Expertise
Mandatory skills
API Integration
Automation
Activity on this job
  • Proposals:50+
  • Interviewing:
    0
  • Invites sent:
    0
  • Unanswered invites:
    0
About the client
Member since Aug 16, 2026
  • United States
    Boca Raton11:35 PM

Explore similar jobs on Upwork

O2C Technical Implementation SpecialistHourly‐ Posted 4 weeks ago
System Configuration
Data Migration
API Integration
CRM Automation
WhatsApp
Zoho CRM
Lead Generation

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo