Ask Zia – AI Assistant for Pipeline Builder
Zoho DataPrep helps you import, transform, export and automate your data based on prompts to Ask Zia in Natural Language. Using this feature, you can enter the required prompt, and the rest of the output will be auto-generated for you by Zia. The Ask Zia feature is powered by ChatGPT API, a generative artificial intelligence developed by OpenAI. To enable this feature in your DataPrep organization, click the Ask Zia icon, OpenAI configuration tab will open when you try to enable it for the first time or go to the OpenAI Integration tab in the Settings page. Click here to know more about enabling OpenAI integrated features in the settings page.
Data Privacy Notice : Zoho DataPrep utilises OpenAI's ChatGPT API, an external service based in the USA, subject to OpenAI's Terms of Use . Please be aware that the information sent to OpenAI depends on the access provided by you, the user. The data shared with ChatGPT is based on the features you enable. Details such as column names and/or selected cell data will be shared based on each feature. You can choose to enable or disable each feature based on the level of data you want to share. Therefore, exercise caution while using this service and ensure that the data you provide does not contain confidential or personal information.
Go to OpenAI Integration in the Settings page to learn more about configuring this integration.
Notes :
1. Ask Zia - Chat DataPrep is optimised for GPT-4 (not compatible with older versions).
2. The generative response is coming in from ChatGPT's training data. Accuracy, consistency, and relevance of the response are subjective to the type of prompts and the data available in its training set.
3. ChatGPT doesn't respond to prompts about personal information.
To configure and enable OpenAI's ChatGPT integration
2. Provide the API Key and Organization ID of your OpenAI organization to configure OpenAI integration in your DataPrep organization.
Note : The key will be encrypted and securely stored in Zoho DataPrep. Learn how to get the Organization ID and the API key from OpenAIOrganization ID and API key in OpenAI
Build pipeline and automate using Ask Zia
1. Click the Ask Zia icon from the top right corner of the Pipeline Builder.
2. Provide a hint to import, transform, or export your data in Natural language in the Command Prompt section. For example, connect to amazons3 and import WebLeads.csv from the / folder in the leads2025 bucket.
You can also easily schedule your pipeline using a simple prompt in Ask-Zia.
4. Click Apply Transform to apply the transform to the entire data.
Info:
1. When you close the Ask Zia window, the chat entries, including all prompts and interpretations will be cleared off the memory.
2. Each prompt is treated independently. Unlike ChatGPT, where context from previous prompt is used, here with Ask Zia, you will have to provide prompts from scratch each time. Conversation threads aren't maintained with Ask Zia - Chat DataPrep feature.
Here are some sample prompts for you
Prompt: Connect to amazons3 and import WebLeads.csv from the / folder in the leads2025 bucket.
1. List the available google drive connections.
Prompt: Join all the datasets using leadID column.
Prompt: Export the pivoted dataset to Zoho Analytics under the Sales workspace in the Zylker organization. Below is a snapshot of the prompts and the confirmation of the export.
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:
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
Create a new pipeline
Pipelines are fundamental entities that allow users to create ETL pipelines / data flows in DataPrep, with multiple data stages and using various flow‑level transforms. You can create a new pipeline from scratch (for your data integration and data ...Pipeline builder page
Pipeline builder is a place that allows the users to create data flows in DataPrep, with multiple data stages and various flow level transforms. Whenever a new pipeline is created, the pipeline builder page opens into view. The pipeline builder page ...Pipeline
Pipelines are fundamental entities that allow users to create data flows in DataPrep, with multiple data stages and various flow-level transforms. To view the list of pipelines, you can click the Pipeline tab from the top bar. The Pipelines tab shows ...Ask Zia - AI assistant to prepare data
Zoho DataPrep helps you clean and transform your data based on prompts to Ask Zia in Natural Language. Using this feature, you can enter the required prompt, and the rest of the output will be auto-generated for you by Zia. The Ask Zia feature is ...Import pipeline from .zdpt file
Using this option, you can create a pipeline by importing a saved pipeline template from a file(.zdpt). You can reuse these files as and when needed. Before learning to import pipeline, let's see how to save and download a pipeline template first. To ...