Zoho DataPrep integration with OpenAI (beta)

Zoho DataPrep integration with OpenAI (beta)

We are thrilled to announce Zoho DataPrep's integration with OpenAI. The public beta roll-out opens up three features. Users who configure their OpenAI Organizational ID and ChatGPT API key (Find out how) will be able access the features. The features help save time, overcome complexities in data wrangling and improve overall quality of data preparation.



Transform by Example: This feature enables users to transform data in a given column based on desired output examples. Essentially, users can provide a few sample outputs, and Zia will automatically perform the necessary transformations on the data in the column to generate the desired outputs. This can include operations like text extractions, date formatting, and arithmetic calculations, depending on the type of data being transformed.


Generate formula from chat: The AI-enabled formula builder allows users to generate complex formulas for data wrangling by simply narrating the logic of the transformation to be performed. For example, in a help desk data set, users can ask the builder to calculate the difference between the first response date and the ticket creation date to reveal the first response duration for each ticket. The formula generated can also be customized, giving users maximum control over how data is transformed in their data sets.


Find new data sets using ChatGPT: Users can ask ChatGPT to bring in new data. This data can be used for experimentation or augmenting available data sets. Keep in mind, ChatGPT generates data based on the available data sets Open AI is trained upon.


We invite you to try these features and share your feedback with us.

    Zoho Developer Community

                              Zoho Desk Resources

                              • Desk Community Learning Series

                              • Digest

                              • Functions

                              • Meetups

                              • Kbase

                              • Resources

                              • Glossary

                              • Desk Marketplace

                              • MVP Corner

                              • Word of the Day

                                  Zoho Marketing Automation
                                          • Sticky Posts

                                          • Announcing DataPrep 2.0 Beta!

                                            Being data-driven is an important end goal for all organizations, because when businesses can manage, analyze, and make actionable decisions based on data, they have a competitive advantage. With that said, how confident are you in making business decisions
                                          • Zoho CRM connector's export functionality enables end-to-end CRM data pipeline

                                            We're thrilled to announce an update to our Zoho CRM connector that will enable you to create data pipelines to Zoho CRM. The public beta of "export to Zoho CRM" is now available, and can be enabled for users requesting it via email. Using the feature,
                                          • Zoho DataPrep is now launched!

                                            We are excited to announce the launch of Zoho DataPrep – An advanced self-service data preparation and data pipeline service.  Introducing Zoho DataPrep Zoho DataPrep helps organizations prepare data by automatically identifying errors, discovering data

                                          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 WorkDrive Resources

                                                                    Zoho Campaigns Resources

                                                                      Zoho CRM Resources

                                                                      • CRM Community Learning Series

                                                                        CRM Community Learning Series

                                                                      • Tips


                                                                      • Functions


                                                                      • Meetups


                                                                      • Kbase


                                                                      • Resources


                                                                      • Digest


                                                                      • CRM Marketplace

                                                                        CRM Marketplace

                                                                      • MVP Corner

                                                                        MVP Corner

                                                                          Design. Discuss. Deliver.

                                                                          Create visually engaging stories with Zoho Show.

                                                                          Get Started Now