Dataset Finder powered by ChatGPT API
Zoho DataPrep helps you enrich your data by enabling you to find new datasets based on your requirement using ChatGPT API integration, a generative artificial intelligence developed by OpenAI. You can use these datasets for data enrichment purposes. To enable this feature in your DataPrep organization, go to the OpenAI Integration tab in the Settings page. Click here to know more about enabling OpenAI integrated features.
Here's a quick video on ChatGPT API integration with Zoho DataPrep.
Here's a quick demo on the features powered by OpenAI in Zoho DataPrep.
Data Privacy Notice : Zoho DataPrep utilizes 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 :
- The generative response are 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.
- ChatGPT doesn't respond to prompts about personal information.
Data Enrichment powered by OpenAI ChatGPT API
1. Create a pipeline or open an existing pipeline from the Home Page, Pipelines tab or Workspaces tab and click the Add data option. You can also click the Import data option under the Workspaces tab to import data.
Info: You can also click the Import data 
icon at the top of the pipeline builder and bring data from multiple sources into the pipeline.
2. Choose the Zoho Apps category from the left pane and click Find new dataset with ChatGPT. You can also directly search the option in the search box.
3. Provide a hint about the type of data you are looking for in the Instruction prompt. For example, create a dataset for salesforce CRM instagram "Liked" list. You can also insert one of the prompts from the Insert hints section.
4. Click Fetch data and you will see a preview of the data generated by ChatGPT.
5. Click the Import button to import data. Once you import data successfully, it will take you to the Pipeline builder page where you can start applying transforms. You can also right-click the stage and choose the Prepare data option to prepare your data in the DataPrep Studio page. Click here to know about transforms.
Note: The datasets generated can be used for data enrichment purposes by blending or merging the generated data with other datasets using append or join transforms.6. Once you are done creating your data flow and applying necessary transforms in your stages, you can right-click a stage and add a destination to complete your data flow.
Here are some sample prompts for you to try out
a. Create a dataset of sales tax rates by state in the US.
b. Create a dataset for places with the highest average temperature in the US.
c. Create a dataset of average electricity prices by state.
SEE ALSO
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 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?
Zoho DataPrep Resources
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
Import configuration for Dataset finder using ChatGPT
While configuring the Schedule, Manual reload, Backfill, Webhooks, or Zoho Flow, the import configuration needs to be mandatorily setup for all the sources. Without setting up the import configuration, the run cannot be saved. You can configure how ...Dataset transforms
Dataset transform consists of combining and transforming datasets to suit your needs. You can apply the following transforms in a dataset. Deduplicate Row-wise Column-wise Join Append Pivot Unpivot Calculated columns Derive dataset Mark as personal ...Transform by Example powered by OpenAI ChatGPT API
Zoho DataPrep helps you transform columns based on example inputs using integration with ChatGPT API, a generative artificial intelligence developed by OpenAI. To enable this feature in your DataPrep organization, go to the OpenAI Integration tab in ...Add formula
You can create new columns and customize them using the Formula column transform. Zoho DataPrep offers a variety of functions to suit your needs. Click here to know more about the functions. To create a formula column 1. Click on the Transform menu ...Derive dataset
The Derive dataset transform allows you to create a branch of your dataset from the last applied transform in your dataset. The new dataset will have the most recent state of your data with an empty ruleset. To derive dataset 1. In the DataPrep ...
New to Zoho LandingPage?
Zoho LandingPage Resources