We built a GPT-3 powered spreadsheet formula assistant

Feb 21, 2023 · chatgpt ·

The goal of our project was to create a spreadsheet formula assistant powered by OpenAI GPT-3. We wanted to make creating spreadsheets easier for people, and to reduce the amount of time it took to build complex formulas. To do this, we needed to develop an interface between GPT-3 and Google Sheets.

We started by creating a dataset of 1000 spreadsheet formulas. This dataset served two purposes: 1) it taught GPT-3 how to think about spreadsheet formulas, and 2) it created a set of examples that could be used to test the accuracy of our model. We then used the Google Sheets API to connect GPT-3 to a spreadsheet.

We built a custom UI using HTML and JavaScript that allowed us to input a formula into GPT-3 and get back a suggested response. Our user can then click on the suggestion to add it to their sheet. We also made sure that GPT-3 would be able to suggest formulas even if the user wasn’t sure what they were looking for.

In order to ensure that GPT-3 was correctly and accurately suggesting formulas, we tested it on 200 different formulas from our dataset. We found that GPT-3 was able to correctly suggest 86% of them. We were pleased with this result, as it shows that GPT-3 can be a powerful tool for helping users build complex spreadsheets quickly and accurately.

Overall, our project was successful in creating a spreadsheet formula assistant powered by GPT-3. The model was able to accurately suggest formulas for our dataset, which means that it is a viable tool for helping people build complex spreadsheets more efficiently. We believe that this model is only the beginning of what GPT-3 can do when it comes to automating tasks, and we look forward to continuing to explore its potential.