Use OpenAI with Google Spreadsheets

This article explains how you can integrate OpenAI GPT-3 with Google Spreadsheets. This allows you to complete spreadsheet tasks with the use of AI.

Pre-requisites

• Google Spreadsheet
• Script to connect with OpenAI API
• OpenAI account with free credits/ paid subscription

Guidelines to complete integration

OpenAI API Key Generation

• Go to https://beta.openai.com/account/api-keys
• Click on the 'Create new secret key' button
• Copy and save somewhere the generated key. This is shown onetime only, and you cannot view the full key later. Or you will have to generate a new key, if you forgot the existing key.

API function used to connect to OpenAI

• Click on the below link and save it or copy the script.

Tip: Make sure to subscribe to above Gist since all future revisions with improvements will be made to this file. Then you can refer to this file later and update your functions.

Creating a Spreadsheet and connect the API function

• Go to https://docs.google.com/spreadsheets and create or use an existing Spreadsheet.
• Using the menu bar, go to Extensions > Apps Script. This will open a new tab.
• You can use the macros.gs file or use + button to add a new Script file.
• Copy and paste the API function?mentioned in previous topic.
• Now click 'Save' button. You will notice an error. It's because, you have to replace ENTER YOUR SECRET KEY HERE TAKEN FROM OPEN_AI with your generated API Secret Key.

Example code after modification:

const SECRET_KEY = "sk-c0rXVe6m5UaT7Bd7hwcZT0BlbkFJMnBRSwgOat40SVstiJA1";
	        

• Now try saving the project again. You will not see any errors. Now you can close this tab since functions are ready to be used.

Note: When there are revisions to functions in the Gist file we discussed above, this is the same place you need to update the new revised code as well.

Use the OpenAI for Spreadsheet taks

Now that you have connected the OpenAI and Spreadsheet, you can start using below functions. (New functions will be updated in the Gist in future)

OPEN_AI(prompt, precision, model, max_tokens)        

OPEN_AI_CATEGORIZE(category_list, category_value_list, input, rules = [])        

Video tutorial

Follow Nimesh Ekanayake ?on LinkedIn

#OpenAI?#AI?#ArtificialIntelligence?#DeepLearning?#MachineLearning?#NaturalLanguageProcessing?#Robotics?#NeuralNetworks?#Tech?#Innovation?#FutureTech?#AIresearch?#OpenAIresearch?#GPT3 #LanguageModel #NaturalLanguageProcessing #NLP #DeepLearning #AIchatbot #AIassistant #AItechnology #AIinnovation