Configure and enable OpenAI in Zoho Sheet
ChatGPT by OpenAI is a generative artificial intelligence tool that processes the given queries and provides detailed responses. Zoho Sheet's integration with OpenAI will enhance the way you analyze your spreadsheet data with advanced AI features.
Secret API key configuration settings:
The first step to start using the OpenAI in Zoho Sheet is to enter the secret API key from OpenAI. Click here to know how to get your secret key.
Secret API key: The API key is a unique key that allows you to access ChatGPT.
Configure and enable OpenAI in Zoho Sheet:
Only the organization admin(s) will have the access to configure the OpenAI integration and enable it for their organization users.
From Zia Panel:
- Go to Tools > Zia > Ask Zia.
- In the OpenAI Configuration dialog, enter the secret key and click on Save.
- Once you've saved the secret key, you can enable and use the following options.
AI Bot: Responds to any general questions.
Generate Table: Generates a data table for the given requirement.
Generate Formula: Generates formula based on your requirement. You can insert the formula in the cell location you wish and generate the result.
Explain Formula: Explains how the given formula functions. You can also copy and paste the desired formulas from the sheet into the formula explainer and get the explanation.
From Import Dialog:
With the Ask Zia option in the Import dialog, you can create templates or get started with sample data sets.
- Go to File > Import > Desktop/URL > Ask Zia
- Perform the OpenAI configuration.
- Once done, enter your requirement to fetch a sample data set. You can also select one from the sample prompts.
- Once done, click on Next.
- Select the preferred option to import the data and click Import.
From VBA Editor:
VBA macros allows you automate tasks by creating and running macro codes. To generate VBA code or get explanation to any VBA code:
- Go to Tools > VBA Macros > View VBA Editor
- Perform OpenAI configuration.
- Once done, select Generate VBA Code or Explain VBA Code from the drop-down and type in your query.
To enable the ChatGPT integration for your organization users, move the OpenAI configuration in Zia toggle in the OpenAI Configuration dialog.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
About Zoho Sheet
Zoho Sheet is a cloud-based spreadsheet application. It allows you to create, share, and work together on spreadsheets online, in real time. You can analyze, visualize and publish data using Zoho Sheet across multiple devices and browsers. Zoho Sheet supported browsers
Zoho Sheet supports the following browsers: Mozilla Firefox - Version 55+ Chrome - Version 55+ Safari - Version 9+ Opera - Version 50+ Edge - Version 12+ Incase you're trying to access Zoho Sheet via an unsupported browser or version, you'll face an ...Working with Zoho Sheet
Here are a few things that we'd like for you to know about Zoho Sheet as you get started: Maximum file size allowed for import 50 MB Maximum number of rows 262144 Maximum number of columns 1024 Maximum number of cells 10 Million Maximum number of ...HIPAA compliance in Zoho Sheet
The Health Insurance Portability and Accountability Act (including the Privacy Rule, Security Rule, Breach notification Rule, and Health Information Technology for Economic and Clinical Health Act) ("HIPAA"), requires Covered Entities and Business ...Apply conditional formatting to your cells
What is conditional formatting? With conditional formatting, you can predefine the format that you want your cells to have, based on a few criteria. Zoho Sheet lets you format your cells with four different types of conditional formatting. They are, ...
New to Zoho LandingPage?
Zoho LandingPage Resources