Google Forms

⌘K
  2. Home
  4. Docs
  6. Google Forms
  8. Step 2: Set up Data Desti...
  10. Option 11: Set up MS Excel as Data Destination for Google Forms

Option 11: Set up MS Excel as Data Destination for Google Forms

Video Walkthrough

Description  :

Microsoft Excel is a spreadsheet program from Microsoft and a part of its Office suite. It enables users to format, organize, and calculate data efficiently in spreadsheets.

Prerequisites:  

Microsoft Account

Getting Started:  

  • Go to Datahash Studio.
  • Enter your credentials to log in.
  • Navigate to the Files category under the Destinations list.
  • Click on the Microsoft Excel connector tile.
  • Sign in
    • Sign in with the Microsoft account you’d like to integrate.
  • Grant the required permissions.

Select Source

  • Choose Google Forms as the source type.
  • Connection Name
    • Select the connection name you want to integrate.
    • Provide a name for the connection (same as the Google Forms source connection).
  • Spreadsheet Configuration
    • Provide a name for the spreadsheet.
    • Select the folder where you want the file to be stored.
    • Click Validate Credentials.
    • The file path will be displayed showing where the spreadsheet will be created.
  • Folder Structure
    • During setup, a new folder named Datahash will be created.
    • This folder will be placed in the selected location (or root drive if no folder is chosen).
    • Inside Datahash, a subfolder will be created with the name of your Google Forms connection.
    • All incoming data will automatically be appended to the spreadsheet in this folder, ensuring data stays organized and easy to analyze.
  • Finish Setup
  • Once verified, click Finish to complete the setup.
  • The connected instance will now appear on the dashboard.

Managing Instances  

Adding a New Instance  

  • Follow the same setup steps as above.

Managing Instances  

Adding a New Instance  

  • Follow the same setup steps as above.
  • Provide a spreadsheet name and select the desired folder.
  • Click Validate Credentials.
  • Once verified, the file path will be displayed.
  • Click Finish to complete setup.
  • The new instance (e.g., Ads connection 2) will appear in the Manage Connections table.

Editing an Existing Instance  

  • In the Manage Connections table, click the connection name.
  • Click the Edit icon (top-right corner) to enable edit mode.
  • Update the required fields.
  • Click Validate Credentials.
  • Click Finish to save changes.
  • If you click Cancel, the previous configuration will remain active, and updates will only apply once you click Finish.

How can we help?