Data Enrichment using ChatGPT

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.

  1. 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. 
  2. ChatGPT doesn't respond to prompts about personal information.

Data Enrichment powered by OpenAI ChatGPT API

1.Create a workspace or open an existing workspace. Click here  if you're new to creating workspaces in Zoho DataPrep.

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 and a dataset will be created.

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.

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.

6. You can also use the Reload data from source option to refresh or reload data again from ChatGPT. Click here to know more about reloading data in your dataset.

Note: Reloading data could add new data and columns and also modify the dataset model since data is re-fetched from ChatGPT which usually gives new data.


    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 CRM Training
      Redefine the way you work
      with Zoho Workplace

        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 CRM Training

          Create, share, and deliver

          beautiful slides from anywhere.

          Get Started Now

            Zoho Sign now offers specialized one-on-one training for both administrators and developers.

            BOOK A SESSION

                                      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.

                                          Manage your brands on social media

                                            Zoho Desk Resources

                                            • Desk Community Learning Series

                                            • Digest

                                            • Functions

                                            • Meetups

                                            • Kbase

                                            • Resources

                                            • Glossary

                                            • Desk Marketplace

                                            • MVP Corner

                                            • Word of the Day

                                              Zoho Marketing Automation

                                                Zoho Sheet Resources


                                                    Zoho Forms Resources

                                                      Secure your business
                                                      communication with Zoho Mail

                                                      Mail on the move with
                                                      Zoho Mail mobile application

                                                        Stay on top of your schedule
                                                        at all times

                                                        Carry your calendar with you
                                                        Anytime, anywhere

                                                              Zoho Sign Resources

                                                                Sign, Paperless!

                                                                Sign and send business documents on the go!

                                                                Get Started Now

                                                                        Zoho TeamInbox Resources

                                                                                Zoho DataPrep Resources

                                                                                  Zoho DataPrep Demo

                                                                                  Get a personalized demo or POC

                                                                                  REGISTER NOW

                                                                                    Design. Discuss. Deliver.

                                                                                    Create visually engaging stories with Zoho Show.

                                                                                    Get Started Now

                                                                                                        • Related Articles

                                                                                                        • 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. Click the Transform ...
                                                                                                        • Target Matching

                                                                                                          Target matching allows you to set a target and align the source dataset to match with your target before exporting data. You can attach a target dataset to match the column structure, formats, and the data types in the existing source dataset. This ...
                                                                                                          Wherever you are is as good as
                                                                                                          your workplace



                                                                                                            Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.


                                                                                                            Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.


                                                                                                            Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.

                                                                                                            CRM Tips

                                                                                                            Make the most of Zoho CRM with these useful tips.

                                                                                                              Zoho Show Resources