Spreadsheet.com is shutting down on May 31st. Read more ...
OpenAI is an artificial intelligence (AI) research laboratory dedicated to AI technology. Most famously, OpenAI has developed the ChatGPT AI chatbot on top of its OpenAI API to automatically generate human-like text and image content in response to user input.
The OpenAI API is a set of tools and services that allow developers to build applications powered by AI. It provides access to a range of AI services, including natural language processing, computer vision, and more.
With our native OpenAI integration, you have fast and easy access to the power of OpenAI’s models inside your spreadsheets. This allows you to write simple formulas to accomplish a virtually endless number of possible tasks.
Spreadsheet.com supports the OpenAI method Completion, which returns information when given a prompt. The completion method can be accessed via the OPENAI_COMPLETE integration function.
In this Guide, we’ll take a look at ten different ways you can use OpenAI completions in your Spreadsheet.com workbooks. See our companion guide “5 Tips & Tricks for Working with OpenAI in Spreadsheet.com”.
OpenAI integration can be accessed through the integration function OPENAI_COMPLETE. Integration functions, like all other functions, can be used in any workbook cell or with the Column formula data type.
OPENAI_COMPLETE has one required argument – a prompt, or the instruction you give OpenAI – with additional optional arguments. When you use the function in a workbook for the first time, you’ll be prompted to connect your workbook with your OpenAI account.
Spin up a social media content pipeline in no time by letting OpenAI write your posts for you. Give OpenAI a topic – and even a tone to write with – and have it generate a post in seconds.
In the example above, note how we’re using the CONCATENATE function to create a complex request with multiple cell references in a single prompt argument.
Give OpenAI a product name and some keywords, and ask it to write a product description for you.
Once you generate a list of product descriptions, try translating them into another language or optimizing their SEO performance with another OPENAI_COMPLETE function.
Use OpenAI to take a list of job titles and keywords or requirements, and write ready-to-post job descriptions.
Need to manage a hiring pipeline end-to-end? Take a look at Spreadsheet.com’s Human Resources templates to get a head start on applicant tracking, hiring budgets, interview management, and more.
Give your web presence a boost by asking OpenAI to generate SEO-optimized keywords for topics in your content marketing pipeline. List a topic and ask OpenAI to return a list of keywords to target in titles and meta text.
Try combining OpenAI integration functions with a Spreadsheet.com template like a Content Calendar, Blog Editorial Calendar, or Content Brief organizer to further improve your content marketing strategy.
If you’re using Spreadsheet.com to manage and identify investment opportunities, you can use OpenAI to quickly gather historical stock price data. Give OpenAI a ticker symbol and a date, and ask it to return the close price from that date.
Try adjusting your OpenAI request to get more information about a stock, like the market cap, year-over-year change, historical highs and lows, current price, and more.
Note: OpenAI does not always return accurate financial information. We do not recommend relying on OpenAI for investment decisions or financial advice.
Use OpenAI to write personalized emails to customers. Include information like the customer’s name and the product they purchased in your OpenAI query. You can even ask OpenAI to include personal anecdotes, like a fun fact about the city that the customer lives in.
Adjust your OpenAI prompt until the function returns an email that you’re satisfied with. Try specifying a tone to write with or asking OpenAI to include different types of personal anecdotes.
If you’re working with long text passages – or just a lot of rows of text – it can be tedious to comb through them and identify and correct misspelled words. OpenAI can complete this task with a simple request to correct textual errors.
Try using OpenAI to correct other mistakes like improper capitalization and bad grammar.
Data doesn’t always start with carefully formatted and standardized entries, especially if you’re working with data that’s been submitted from external sources through a Form View or a third-party import. With OpenAI, you can automatically format information in a standardized way, as well as extract specific pieces of information from it.
In Column A, we have a list of addresses that are all formatted differently. In Column B, we’re using the OPENAI_COMPLETE function to standardize the appearance of all of the addresses. Then, in Columns C through E, we’re using the OPENAI_COMPLETE function to extract specific pieces of information – cities, states, and zip codes – from each address.
If you’re creating open job listings for bilingual positions or localizing an e-commerce business in multiple countries, you probably need to translate text into different languages. Instead of copying and pasting each passage into a translation service, use OpenAI to translate text without leaving your Spreadsheet.com workbooks.
Use the OPENAI_COMPLETE function to reference a cell with text and instruct OpenAI to translate it to any other language.
With just a few inputs and an OpenAI function, you can write an entire story in seconds. Give OpenAI details like a genre, character, and character traits, and let it generate a creative story for you.
Take a look at the OPENAI_COMPLETE function documentation to learn more about the additional parameters like temperature and max tokens that are used in the example above.
With Spreadsheet.com’s OpenAI integration functions, the ways in which you can use OpenAI to enhance your workbooks are endless. Take a closer look at how to work with OpenAI in our Help Center, or visit the documentation for the OPENAI_COMPLETE function.