How to prefill Zoho Forms with data from Zoho Sheet using webhooks

How to prefill Zoho Forms with data from Zoho Sheet using webhooks

Zoho Forms allows you to dynamically prefill form fields with data fetched from external sources. One popular use case is pulling customer data stored in a Zoho Sheet and pre-populating your forms when the user opens them. This feature is especially useful when you already have existing records, such as employee detail, stored in Zoho Sheet, and you want to prefill forms based on a unique identifier. You want employees to simply enter their Employee ID in a Zoho Form, and have the rest of their information like name, email, and department—automatically filled in from the Zoho Sheet.

Check out a quick video on how to configure this.


Lets assume you have a Zoho Sheet with the employee data below.


  1. In your Zoho Forms account, click Control Panel in the left panel.
  2. Under Developer Space, click Connections.

    Click Connections

  3. Click Create Connection.

    Create Connection

  4. From the list of services, choose Zoho Sheet.

    Choose Zoho Sheet

  5. Enter a Connection Name (ZohoSheet).

    Enter a Connection Name

  6. Under Scope, select ZohoSheet.data.API.READ. This allows Zoho Forms to read data from Zoho Sheet.

    Choose Scope

  7. Click Create and Connect. Grant permission when prompted, allowing Zoho Forms to access data from Zoho Sheet.

    Grant permissions

  8. Once connected, you can view the connection summary.

    Connection Summary

  9. Open your form builder, go to Settings > Form Settings > Prefill > Dynamic Prefill - Webhook.

    Go to Dynamic Prefill - Webhook
  10. Click Configure.

    Configure

  11. Under Webhook Settings:
    1. Search Field: Select the field that will be used to look up the record in your Zoho Sheet (for example, Employee ID).

      Pick your Search Field

    2. Webhook URL:
      1. Copy the Zoho Sheet API base URL from Zoho Sheet API documentation.

        Copy the API URL
      2. In your webhook configuration, paste this URL (https://sheet.zoho.com/api/v2/) in the Webhook URL field.



      3. Go to your Zoho Sheet, copy the Sheet ID from the URL, and append it at the end of the above link as https://sheet.zoho.com/api/v2/<sheetID>



        For example, if your Sheet ID is abcd1234efgh5678, the final URL will be: https://sheet.zoho.com/api/v2/abcd1234efgh5678

        Webhook URL
    3. Under Authorization Type, select Connection. From the list, choose the connection you created earlier for Zoho Sheet.

      Choose the connection you created

    4.  Add the following URL parameters that define how Zoho Forms should fetch and render your data.


      Parameter
      DescriptionInput
      criteriaThis tells Zoho Forms which column to search in your Zoho Sheet.
      In the Choose Field section, click Add Input Manually and type the column name (as in your Zoho Sheet) within quotes.
      For example, if your Zoho Sheet column is named
      ID, enter: "ID"=Then, choose the form field where the Employee ID is entered.
      worksheet_nameSpecifies the worksheet in your Zoho Sheet that contains the data.Copy the name of your worksheet from the Zoho Sheet. 
      methodInstructs Zoho Forms to fetch records from the sheet.
      Type:
      worksheet.records.fetch
      render_optionEnsures data is displayed in the same format as in Zoho Sheet.
      Enter custom input as formatted
​URL Parameters

Test the webhook with search field value like 1001 and check if the received response is valid.
​
Test the webhook

Once the webhook test is successful, map each field from the JSON response to the corresponding form field. Click Save.

Map form fields to prefill​

Now, when a respondent opens the form, enters their Employee ID and clicks the search icon, the form will call the Zoho Sheet, fetch details, and prefill the form automatically.

Employee enters the Employee ID

Form fields are prefilled





        Create. Review. Publish.

        Write, edit, collaborate on, and publish documents to different content management platforms.

        Get Started Now


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







                                Quick LinksWorkflow AutomationData Collection
                                Web FormsEnterpriseOnline Data Collection Tool
                                Embeddable FormsBankingBegin Data Collection
                                Interactive FormsWorkplaceData Collection App
                                CRM FormsCustomer ServiceAccessible Forms
                                Digital FormsMarketingForms for Small Business
                                HTML FormsEducationForms for Enterprise
                                Contact FormsE-commerceForms for any business
                                Lead Generation FormsHealthcareForms for Startups
                                Wordpress FormsCustomer onboardingForms for Small Business
                                No Code FormsConstructionRSVP tool for holidays
                                Free FormsTravelFeatures for Order Forms
                                Prefill FormsNon-Profit

                                Intake FormsLegal
                                Mobile App
                                Form DesignerHR
                                Mobile Forms
                                Card FormsFoodOffline Forms
                                Assign FormsPhotographyMobile Forms Features
                                Translate FormsReal EstateKiosk in Mobile Forms
                                Electronic Forms
                                Drag & drop form builder

                                Notification Emails for FormsAlternativesSecurity & Compliance
                                Holiday FormsGoogle Forms alternative GDPR
                                Form to PDFJotform alternativeHIPAA Forms
                                Email FormsFormstack alternativeEncrypted Forms

                                Wufoo alternativeSecure Forms

                                TypeformWCAG

                                  Zoho FSM Video Tutorials


                                        All-in-one knowledge management and training platform for your employees and customers.

                                                  Create. Review. Publish.

                                                  Write, edit, collaborate on, and publish documents to different content management platforms.

                                                  Get Started Now




                                                                    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


                                                                          • Desk Community Learning Series


                                                                          • Digest


                                                                          • Functions


                                                                          • Meetups


                                                                          • Kbase


                                                                          • Resources


                                                                          • Glossary


                                                                          • Desk Marketplace


                                                                          • MVP Corner


                                                                          • Word of the Day


                                                                          • Ask the Experts


                                                                            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 Demo

                                                                                                              Get a personalized demo or POC

                                                                                                              REGISTER NOW


                                                                                                                Design. Discuss. Deliver.

                                                                                                                Create visually engaging stories with Zoho Show.

                                                                                                                Get Started Now








                                                                                                                                    • Related Articles

                                                                                                                                    • How to prefill Zoho Forms with data from Google Sheets using webhooks

                                                                                                                                      Zoho Forms allows you to dynamically prefill form fields with data fetched from external sources. One popular use case is pulling customer data stored in a Google Sheet and pre-populating your forms when the user opens them. This saves time, reduces ...
                                                                                                                                    • How to prefill forms with data from Zoho Sheet using webhooks

                                                                                                                                    • Prefill-Zoho Sheet

                                                                                                                                      Table of contents Overview Configuring Prefill-Zoho Sheet Field Configuration Sheet Settings Zoho Sheet Details Test & Verify Prefill Mapping Field Properties Prefill Configuration Prefill Configuration Summary Edit Prefill Configuration Search Icon ...
                                                                                                                                    • Best Practices for Zoho Forms - Zoho CRM integration

                                                                                                                                      1‌. Check if changing the properties of a field integrated in Zoho CRM will affect the integration For example, if a mapped field is marked mandatory in Zoho CRM, ensure that the corresponding form field is marked mandatory in Zoho Forms so that the ...
                                                                                                                                    • Automation features in Zoho Forms that can save your time

                                                                                                                                      In today's time-constrained online world, manual processes may cause you to move slowly, directly affecting your business. Zoho Forms offers you with key automation features to handle your business's needs and deliver a seamless user experience. With ...
                                                                                                                                      Wherever you are is as good as
                                                                                                                                      your workplace

                                                                                                                                        Resources

                                                                                                                                        Videos

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



                                                                                                                                        eBooks

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



                                                                                                                                        Webinars

                                                                                                                                        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