Using Zia in Zoho Sheet data to research the internet and return answer to a cell in Zoho Sheet

Using Zia in Zoho Sheet data to research the internet and return answer to a cell in Zoho Sheet

I'm trying to see if Zia (connected with OpenAI key) can take data parameters stored in a Zoho Sheet to conduct research out on the internet then return an answer into the same Sheet.  I'm trying to do the equivalent of using something like the =AI() function in Google.  

In the attached image you see I invoked Zia with my instruction and Zia said it would perform the task, but it has never returned an answer.  I confirmed the account is connected properly to OpenAI with sufficient funds to credit for the search.  Is what I'm trying to do even possible?  I was hoping to avoid making this more complex by using Zoho Flow or other connectors - seems like Zia should be able to work directly in Sheet.  @Zoho or anyone else have thoughts?

    Access your files securely from anywhere


            Zoho Developer Community





                                      • Desk Community Learning Series


                                      • Digest


                                      • Functions


                                      • Meetups


                                      • Kbase


                                      • Resources


                                      • Glossary


                                      • Desk Marketplace


                                      • MVP Corner


                                      • Word of the Day


                                      • Ask the Experts



                                          Zoho Marketing Automation
                                                  • Sticky Posts

                                                  • Create and save user-specific filter views with Zoho Sheet

                                                    The filters in Zoho Sheet have become even more collaboration-friendly. Previously, whenever you filtered any data, the filtered view will be updated for all the spreadsheet collaborators. This disturbed the data for others working on the same file. With this new update, you can apply data filters without altering the view for other collaborators in the file.   Collaborate with user specific filters   Let us say you are working on a sales report spreadsheet in real time with two remote colleagues. If
                                                  • Revamped Print in Zoho Sheet—customized for paper

                                                    The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper.   Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.
                                                  • Slicers are now available in Zoho Sheet—filter your data interactively

                                                    At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,
                                                  • Check out the new Checkbox in Zoho Sheet

                                                    Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the Format
                                                  • Format and analyze spreadsheet data with Zoho Sheet's Table

                                                    While a spreadsheet helps you compile data for easy analysis, formatting helps make your data more comprehensible. We are happy to announce the release of Table, a crucial tool for improving data formatting in Zoho Sheet. More than a formatting tool,


                                                  Manage your brands on social media



                                                        Zoho TeamInbox Resources

                                                          Zoho DataPrep Resources



                                                            Zoho CRM Plus Resources

                                                              Zoho Books Resources


                                                                Zoho Subscriptions Resources

                                                                  Zoho Projects Resources


                                                                    Zoho Sprints Resources


                                                                      Qntrl Resources


                                                                        Zoho Creator Resources



                                                                            Zoho CRM Resources

                                                                            • CRM Community Learning Series

                                                                              CRM Community Learning Series


                                                                            • Kaizen

                                                                              Kaizen

                                                                            • Functions

                                                                              Functions

                                                                            • Meetups

                                                                              Meetups

                                                                            • Kbase

                                                                              Kbase

                                                                            • Resources

                                                                              Resources

                                                                            • Digest

                                                                              Digest

                                                                            • CRM Marketplace

                                                                              CRM Marketplace

                                                                            • MVP Corner

                                                                              MVP Corner





                                                                                Design. Discuss. Deliver.

                                                                                Create visually engaging stories with Zoho Show.

                                                                                Get Started Now


                                                                                  Zoho Show Resources


                                                                                    Zoho Writer Writer

                                                                                    Get Started. Write Away!

                                                                                    Writer is a powerful online word processor, designed for collaborative work.

                                                                                      Zoho CRM コンテンツ






                                                                                        Nederlandse Hulpbronnen


                                                                                            ご検討中の方





                                                                                                  • Recent Topics

                                                                                                  • Error 550 - receiving email

                                                                                                    Hi, We've been getting messages from three different customers that our email address was bouncing. Our email address is hello[at]meteoorbooks.com. This was the error message they received: The response from the remote server was: 550 5.0.1 Recipient
                                                                                                  • solicitud cambio de dominio

                                                                                                    buenas tardes por favor me pueden ayudar con un cambio de dominio es que al crear un correo corporativo manual y agregue un dominio inscribí el mío pero le anexe letras de mas y no pude seguir con el proceso y no se como hacer para seguir con la configuración
                                                                                                  • Multi Select Between Modules

                                                                                                    Hi, I'm not sure if this is possible, but I want to "import" or "mirror" the multi select options from one module to another. For example... I have Module "Clients" with a Multi Select Field of "Enrolled Services" I also have a Module "Services" with
                                                                                                  • Zoho Desk's ASAP announcement | Time to embrace the enhanced JWT Authentication Mechanism for ASAP | Dec'23

                                                                                                    Hi All, We are eager to introduce the enhanced JWT authentication mechanism for accessing your ASAP add-ons. Effective December 25th, 2023, the ASAP's old JWT authentication mechanism will be deprecated. This means that the option to switch to the new
                                                                                                  • Payroll Chart of Accounts Config for Dummies

                                                                                                    USA What should my COA look like for one employee, paid via a service (Gusto), no benefits. I pay her wage, associated taxes, and the Gusto monthly fee. I'd like to know the COA account type, any sub accounts, what goes where, any payment splits, etc.
                                                                                                  • Attach Subform images from Zoho Creator to CRM Module

                                                                                                    Good afternoon eveyone. I am having a difficult time trying to find a way to attach a subform image from a creator app to a CRM module. I have tried so many ways that I don't even know which way was on the right track because none of them worked. If anyone
                                                                                                  • Receipt for Transaction ID2005635324115

                                                                                                    Please share Receipt for Transaction ID2005635324115 towards bashir.salih@wood-man.ae
                                                                                                  • Zoho FSM Extension for Zoho Desk: For Enhanced On-Site Assistance and Unified Customer Support

                                                                                                    We are stoked to present to you Zoho FSM for Zoho Desk, an extension that will help you convert Zoho Desk tickets that require on-site assistance into field service requests in Zoho FSM, ensuring a smooth hand-off from the help desk to field technicians.
                                                                                                  • Not able to send or receive emails

                                                                                                    Hello, I have not been having problems sending and receiving email accounts for about 2 weeks now. I have clean out my folders for storage and it is still not working. Thanks Ward
                                                                                                  • Need Assistance with New Account and DNS Update

                                                                                                    I've created a Zoho Mail account for my Website https://apkqad.com but forgot which Gmail account I used to sign up. Can I setup a new Zoho Mail account and update the DNS records accordingly?
                                                                                                  • Which WhatsApp API works seamlessly with Zoho CRM?

                                                                                                    I’m exploring WhatsApp API solutions that integrate seamlessly with Zoho CRM for customer communication, lead nurturing, and automation. I would love to hear insights from those who have successfully implemented WhatsApp within Zoho CRM. My Requirements:
                                                                                                  • Zoho Desk app update - Reply via email option for IM tickets

                                                                                                    Hello, everyone! We're excited to introduce the 'Reply via Email' option for IM tickets, in the latest version of the Zoho Desk Android(v2.7.4) and iOS(2.9.5) app update. You can now respond to IM-based tickets via email within the mobile app. This feature
                                                                                                  • Importing into Multiselect Picklist

                                                                                                    Hi, We just completed a trade show and one of the bits of information we collect is tool style. The application supplied by the show set this up as individual questions. For example, if the customer used Thick Turret and Trumpf style but not Thin Turret,
                                                                                                  • Zoho Meeting Android app update - v2.4.0

                                                                                                    Hello everyone! We are excited to announce that we have brought in support for the following features in the latest version of the Zoho Meeting Android app(v2.4.0): 1. Start Personal Meeting Rooms 2. Revamp of the schedule meeting screen and meeting details
                                                                                                  • Upload and embed a video into an article?

                                                                                                    How can we upload a video and embed it into an article? It is possible for images but this only supports image files. And don't say it has to be uploaded to YouTube, Vimeo or DailyMotion in order to embed it. We're trying to create company documentation
                                                                                                  • Zoho Recruit in 2025

                                                                                                    Hi Zoho team, Is it possible to disclose what is on the roadmap for Recruit in 2025? In comparsion to other ATS options available, Recruit is falling behind. Within the community there are endless request and suggestions from users on feature which would
                                                                                                  • Mass Update Status of Job Openings

                                                                                                    It'd be incredibly useful to be able to mass update the statuses of job openings. I've just been told six jobs are on hold with the same client, so at the moment I need to update all of them individually. Cheers
                                                                                                  • Canvas View in Zoho Recruit

                                                                                                    Is it possible or would it be possible to have the new 'Canvas View' in Zoho Recruit?
                                                                                                  • This mobile number has been marked spam. Please contact support.

                                                                                                    I am having problem of adding my mobile phone number to my account, while enabling the Zoho mail service. I have tried my personal number, working number, and even my parents number and still got the same error "This mobile number has been marked spam.
                                                                                                  • Create Ticket ignores a list of "secondaryContacts"

                                                                                                    Hi, we're trying to create a ticket, with a contact to be a CC. According to the documentation, it should be a list of IDs in "secondaryContacts". But when the ticket is created, it returns an empty array. Has someone tried it? Thanks for any hint. BTW
                                                                                                  • Error when trying to categorize bank transactions

                                                                                                    I am trying to categorize my bank transactions. It was going fine, I categorized 50 or so transaction and suddenly I started getting an error that reads: "Transactions cannot be matched as the account you are trying to match it to, is different.". I select
                                                                                                  • Why there is "Failure" after the "Answer bot" card

                                                                                                    Hi, I'm building a Chat bot for my company. I implement the card "Answer bot" and after this card there is the word "Failure", then if I add another card, this card doesn't work. In this case I add the "End" card. Can you explain how to do to avoid this
                                                                                                  • Kaizen #177: Duplicate Check Preferences API vs. Upsert API

                                                                                                    Hello all!!! Welcome back to another week of Kaizen. Last week, we discussed Optimizing the Use of Record ID Variables in Zoho CRM Queries. This week, we will explore two important APIs for managing duplicate records in Zoho CRM - Duplicate Check Preferences
                                                                                                  • How to block a WhatsApp user for sending spam

                                                                                                    Is there a way to block those whatsapp users that just come to play and annoy our service, they also spam us. We have a waba service with sales iq
                                                                                                  • Sales receipt drop down

                                                                                                    Is the option for Sales receipt only in a paid subscription? If it is which subscription, if it is not how do I get it up on my drop down sales tab.
                                                                                                  • Restrict SalesIQ Account Notifications to Admins

                                                                                                    Dear Zoho SalesIQ Team, We appreciate the continuous improvements in SalesIQ. However, we have noticed that all users, including employees who do not have admin privileges, receive certain account-related notifications—such as the recent splash screen
                                                                                                  • 5 powerful ways to boost e-commerce customer engagement with Zobot

                                                                                                    E-commerce has been a game changer for the past decade. It has drastically influenced the way people purchase. This pandemic broke all the existing rules by embracing automation and making the customer experience more personalized. Chatbots play a crucial
                                                                                                  • Access Sales Order line Items in Deluge

                                                                                                    Does anyone have a Deluge snippet that shows how to access an Order_Items from a Sales_Order? Thanks in advance! Brenedn
                                                                                                  • Progressive Discounts

                                                                                                    We need to be able to apply more than one discount after the sub total. How would we go about doing that in zoho books and zoho inventory?
                                                                                                  • How to select alternate invoice email notification template

                                                                                                    When we reissue an invoice, we want to send a different notification email. I am able to set up the alternate email body using Email Notifications/Invoice Notification settings, but I can't figure out how to attach that template to a specific invoice.
                                                                                                  • Create/Update Query Tables through API

                                                                                                    We need an API to edit the query tables. Currently if columns are added/removed from a normal table, we have to edit the query tables made on top of that table manually to reflect the changes. We want to automate this task to automatically update the
                                                                                                  • Is there a way to programmatically open the zoho business chat?

                                                                                                    I'm integrating business chat into my website. Is there a way to programmatically trigger opening the chat?
                                                                                                  • Mass Change Start Date in Recurring Invoice

                                                                                                    Need a way to update start date for large number of recurring invoices. Either bulk update option for that field or an import function with the ability to set "duplicate handling logic" (like when importing customers) so that one (or more) field can be
                                                                                                  • How Do I Refund a Customer Directly to Their Credit Card?

                                                                                                    Hi, I use books to auto-charge my customers credit card. But when I create a credit note there doesn't seem to be a way to directly refund the amount back to their credit card. Is the only way to refund a credit note by doing it "offline" - or manually-
                                                                                                  • Zoho Books Invoices Templates

                                                                                                    It would be really helpful to have more advanced features to customise the invoice templates in Zoho Books. Especially I´m thinking of the spacing of the different parts of the invoice (Address line etc.). If you have a sender and receiver address in
                                                                                                  • Backup & Restore

                                                                                                    We need a better tool for comprehensive data back-up and restore.  We are investing in Zoho Books as a tool to run our business and the data we input into the system is vital so having comprehensive and regular backups is not only key but a fundamental requirement for any responsible business.  The current backup system does not provide complete data backup and the process to import the data is also flawed. Exported files size are larger than the allowable import size Some exported files have different
                                                                                                  • Zoho Books Custom Views do not allow "Empty" and "Not Empty" to be evaluated in criteria

                                                                                                    In Zoho Books, we can create a custom view for most modules (like Invoices and Bills), and we can try to specify a criteria. However, we cannot evaluate in criteria whether a field is empty or not. This is very bizarre! Every type of criteria across all
                                                                                                  • Allow Option to Modify Check Voucher. Need Additional Columns from Bill

                                                                                                    We really want to add a custom field/value from a Bill to the check Voucher. Is this possible? If not, why is there such a restriction? We are having an admin hand write information on all the vouchers, even though the information already exists on the
                                                                                                  • Restrict Payment Methods

                                                                                                    Allow us to restrict certain payment methods specific for each customer.
                                                                                                  • Zeptomail Support

                                                                                                    My zeptomail was blocked and i was notified to contact support. I have opened five tickets and no one is responding to my queries. I went through possibilities of the block and discovered the issue was due to suspicious mails sent through one of the mailagents.
                                                                                                  • Next Page