Build a Python Automation for Processing Customer Inquiries with OpenAI
Worldwide
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- IntermediateExperience Level
- Remote Job
- One-time projectProject Type
Skills and Expertise
Activity on this job
- Proposals:50+
- Interviewing:0
- Invites sent:0
- Unanswered invites:0
About the client
- United StatesBoca Raton11:35 PM
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers 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