1. In your Zoho Forms account, click Control Panel in the left panel.
   
2. Under Developer Space, click Connections.
   
   
   
   
   
3. Click Create Connection.
   
   
   
   
4. From the list of services, choose Zoho Sheet.
   
   
   
   
5. Enter a Connection Name (ZohoSheet).
   
   
   
   
6. Under Scope, select ZohoSheet.data.API.READ. This allows Zoho Forms to read data from Zoho Sheet.
   
   
   
   
7. Click Create and Connect. Grant permission when prompted, allowing Zoho Forms to access data from Zoho Sheet.
   
   
   
   
8. Once connected, you can view the connection summary.
   
   
   
   
9. Open your form builder, go to Settings > Form Settings > Prefill > Dynamic Prefill - Webhook.
   
   
   
10. Click 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).
   
   
   
   
2. Webhook URL:
   
1. Copy the Zoho Sheet API base URL from Zoho Sheet API documentation.
   
   
   
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
   
   
   

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

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

   Parameter	Description	Input
   criteria	This 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_name	Specifies the worksheet in your Zoho Sheet that contains the data.	Copy the name of your worksheet from the Zoho Sheet.
   method	Instructs Zoho Forms to fetch records from the sheet.	Type: worksheet.records.fetch
   render_option	Ensures data is displayed in the same format as in Zoho Sheet.	Enter custom input as formatted

​

​

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

​