Python OpenAI API Bulk Prompt Request Script

Project Budget: $125
Project Level: Standard
Project Overview:

Simple Python script with a HTML front end to allow a user to upload a CSV list of “prompts” and have each one sent as a request to the OpenAI API.

There will be multiple prompts on each row. The script will need to move through each column, retrieve the output from OpenAI API, before moving onto the next row.

The script should insert the result/text output from each column/prompt/request into a prompt output column of the CSV, then over onto the next row & then automatically download the updated CSV file for the user.

Technical Requirements

- Server Type: Ubuntu 22.04
- Script Type: Python
- Front End Type: HTML
- Front End Functionality:
- Input API Key into a text field
- Upload CSV File - CSV file template will be provided
- View Script Progress
- Success / Failed Message once script has finished
- Max Number of Records Limit for CSV: 2000
- Max Number of Concurrent Requests: 7
- Suitable Retry Logic Required: Yes


Process Flow


- Validate Input
- Check CSV is in the correct format
- Check CSV has no more than 2000 records
- Make Request to OpenAI API
- Return OpenAI API Response & insert into CSV