How to use OpenAI GPT-3 on to Create Formulas using AI

Editor Ratings:
User Ratings:
[Total: 0 Average: 0] is a new and unique all-in-one Spreadsheet for Teams that pools people, projects and data for creating and working with project management solutions without compromising on the traditional spreadsheet features that are already known to us. It resembles any conventional spreadsheet solution, but is powered with a new range of capabilities that enable users to generate spreadsheets as powerful as apps.

Just recently, launched a new feature namely, integration of OpenAI with With one single Formula (function) you can now leverage the AI generative models used in ChatGPT to create content, provide responses etc using the existing data in your spreadsheet.  Examples of the content can range from social media posts, SEO phrases and keywords to creative writing, job descriptions and much more.

In this article we will understand How to use the OpenAI function in and understand the endless possibilities that if offers.

How it Works:

  1. Login to your account and open the sheet where you want to use the OpenAI function. Click here to register for a free account if you do not have one.
  2. Double click on any cell in the spreadsheet where you wish to insert the function and use the syntax as depicted in the examples below. You will require to paste an Open API key to use this function in If you do not have one, you can click on the link provided in the popup box to create a free Open API key for you.

Input Open API key

Open AI Function Syntax

1. Draft Social Media posts: This will use OpenAI to write a post for the Social Media platform given in Cell B10, about the Topic mentioned in the cell A10 as per the Tone stated in the Cell C10.

=OPENAI_COMPLETE(CONCATENATE(“Write a “,B2,” post about “,A2,” with a “,C2,” tone.”))

Social Media Posts

2. Generate product descriptions: This will draft a Product Description about the item mentioned in the cell A2 and will use the keywords that have been provided in the cell B2

=OPENAI_COMPLETE(CONCATENATE(“Write an SEO-optimized product description for a “,A2,” using these keywords: “,B2))

Product Description

3. Write job postings: This function will generate a job description for the Position provided in the cell A7 using the keywords mentioned in the cell B7

=OPENAI_COMPLETE(CONCATENATE(“Write a short job description for a “,A2,” position using these keywords: “,B2))

Job Postings

4. Historical stock data: This will get the peak price of the stock mentioned in the cell A9 after the date given in the cell B9

=OPENAI_COMPLETE(CONCATENATE(“What was the peak price of “,A2,” after “,B2,”? Return a single dollar value only.”))

Historical Stock Data

5. Correction of grammar and spelling errors: This will perform error correction of the text appended in the cell C5

=OPENAI_COMPLETE(CONCATENATE(“Correct the errors in this text: “,A2))

Grammar and Spelling Error correction

6. Text translation: This command will translate the text given the cell A2 into Arabic language.

=OPENAI_COMPLETE(CONCATENATE(“Translate this passage (“,A2,”) into Arabic.”))

Text Translation

Click here for more examples of the usage of the OpenAI_Complete function in

Closing Thoughts:

The native integration of OpenAI in renders it very easy for anyone to generate content such as social media posts, travel plans, creative writing and more in spreadsheets. The function also enables you to perform a range of automated tasks like spelling and grammatical error correction, text translation, cleaning up of messy data and a wide variety of data analysis.

The free account of  You will be limited in the number of rows you can create in each workbook by your plan (see Pricing). You will also be limited in the number of OPENAI_COMPLETE calls you make based on the number of tokens available in your OpenAI plan (see OpenAI Pricing).

Editor Ratings:
User Ratings:
[Total: 0 Average: 0]
Free/Paid: Free

Leave A Reply


Get 100 GB FREE

Provide details to get this offer