Javascript for Google Sheet to contact with OpenAI API

Job ID: 36431906

Budget: €8 – €30 EUR

I am looking for a Javascript developer who can create a script to automate data entry on Google Sheets. The script needs to communicate with the OpenAI API. The script needs to be highly customized, as it needs to fit specific requirements.

Ideal Skills and Experience:
- Proficient in Javascript
- Experience with Google Sheets API
- Familiarity with OpenAI API and specifically with the Davinci Codex endpoint
- Ability to customize the script to fit specific requirements
- Attention to detail and ability to ensure accuracy of data entry.

The main job of the Script will be the following:
1) read the content of the first collumn cells*
2) read a prompt that exists on the cell "C1"
3) send the content to OpenAI
4) get the responce and save it on the second collumn cells.
*the content of each cell is an html piece of code. The format of the html must not be changed. The reply that will be saved should have identical structure. If the content of the cell is too big and openAI can't reply (more than 4000 tokens), the content should be split into smaller pieces ( probably depending on <p>) and then merge the multiple replies back into one before it will be saved to the new cell.
Related categories: JavaScript Google Sheets OpenAI