Configure and enable OpenAI in Zoho Sheet
Get AI assistance for your spreadsheet tasks inside Zoho Sheet
- Zoho AI
- OpenAI
How to configure Zoho AI
How to configure OpenAI's ChatGPT integration
- The first step to start using the OpenAI in Zoho Sheet is to enter the secret API key from OpenAI. Learn how to get your secret key.
- Organization ID: The Organization ID is the unique ID for your organization.
- Secret API key: The API key is a unique key that allows you to access ChatGPT.
- Navigate to Admin Panel > Configuration and paste the Secret API key under OpenAI integration and click Enable.
How to use OpenAI/Zoho AI in Zoho Sheet
- Click the Zia icon in the right pane.
- Switch to the Ask Zia tab.
- Click the dropdown at the right and select either OpenAI or Zoho AI.
- Enter the prompt and watch Zia generate answers.
How to use Zia to import data
- Navigate to File > Import > Desktop/URL > Ask Zia.
- Enter the prompt to fetch a sample data set. You can also select one from the sample prompts given below.
- Click on Next. Select the preferred option to import the data, then click Import.
How to use Zia to create and explain VBA macro codes
VBA macros allows you automate tasks by creating and running macro codes. Using the Ask Zia option, you can easily generate a VBA code or get explanation to any VBA code:
Navigate to Tools > View VBA Editor >
.
Select Generate VBA Code or Explain VBA Code from the drop-down and type in your query.
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:
Zoho FSM Video Tutorials
All-in-one knowledge management and training platform for your employees and customers.
Create. Review. Publish.
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.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
Workflows in Zoho Sheet
Workflows in Zoho Sheet streamline the way your spreadsheet files move through different stages like review, approval, and finalizing without manually tracking the progress. Let's say you are working on a quarterly budget report and want it to be ...Using shapes in Zoho Sheet
Shapes in Zoho Sheet let you create visual elements like simple diagrams, drawings, and flowcharts in your spreadsheet. They help you illustrate data and deliver complex ideas effectively. How to insert a shape Go to Insert > Shape. A pop-up window ...How to connect external apps to Zoho Sheet via data connection
Zoho Sheet allows you to securely connect with Zoho apps, third-party apps, and import data via data connection. Click here to learn how to create a connection to import data from Zoho apps, URLs and Feeds, and manage them. List of external apps ...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 ...