To integrate your form with Google Sheet,
Navigate to the Integrations tab and click Google Sheets from the left menu.
Click Integrate.
If you have not authenticated Zoho Forms to connect with your Google account already, you will see an authentication pop-up. Click Authenticate Google.
Select the sheet to store your form responses from the below options:
New sheet: Creates a new spreadsheet to store your form responses. Give the sheet a name of your choice in Sheet Name.
Existing sheet:Stores form responses in a new spreadsheet of an existing Workbook. Select an existing workbook in Sheet Name.
Under Integration Settings, you can choose to add additional information, such as Added Email ID, Referrer Name, Payment Information, etc., under separate dedicated columns in the sheet for each form entry pushed.
You can choose to store all the file attachments and signatures received via your form in Google Drive.
Click Save.
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.