Option 10: Set up Google Sheet as Data Destination for Google Forms

Video Walkthrough

Getting Started:  

• Go to Datahash Studio.
• Enter your credentials to log in.
• Navigate to the Files category under the Destinations list.
• Click on the Google Sheets connector tile.

Authenticate Google Account  

• Sign in with the Google account you want to integrate.
• Grant the required permissions.

Select Source  

• Choose Google Forms as the source type.

Connection Name & Spreadsheet Details  

• Select the Google Forms connection you want to integrate.
• Provide a name for this connection (must match the source connector).
• Enter a Spreadsheet Name.
• Select the Google Drive folder where you want the file to be stored.
• Click Validate Credentials to proceed.

Folder & File Creation  

• A new folder named Datahash will be created in the selected location (or directly in your Google Drive if no folder was chosen).
• Inside the Datahash folder, another subfolder will be created using the connection name.
• Your data spreadsheet will be stored in this subfolder.
• As new data arrives, it will be automatically appended to the existing spreadsheet for the chosen Google Forms connection.

Finish Setup  

• Once validation is successful, click Finish to complete the setup.

• The connected instance will now be visible in the dashboard under Google Sheets destinations.
• You can see the connected instance in the dashboard.

Managing Instances  

Adding a New Instance  

• Repeat the setup steps above.

• Provide a new Spreadsheet Name and select a folder.

• Click Validate Credentials.

• Click Finish to complete the setup.

• The new instance (e.g., Ads connection 2) will appear in the Manage Connections table.

Editing an Existing Instance  

• In Destinations, go to the Google Sheets category.

• Select the connection you want to update

• Click the Edit icon (top-right) to enable edit mode.
• Update the field values (e.g., spreadsheet name, folder).

• Click Validate Credentials.
  • If you click Cancel, the existing configuration will remain active.
  • Updates are only applied when you click Finish.
• Click Finish to save the changes.