Google Forms

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

Option 9: Set up MySQL as Data Destination for Google Forms

Video Walkthrough

Description  :

MySQL is an open-source relational database management system (RDBMS) widely used for managing and storing data. It uses Structured Query Language (SQL) to access and manipulate data, making it a popular choice for web applications, data warehousing, and enterprise-level data management.

Prerequisites:  

You will need the following details to complete the setup:

  • MySQL Hostname
  • Port
  • MySQL Username
  • MySQL Password
  • Database Name
  • Table Name

Getting Started:  

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

Select Source  

  • Choose Google Forms as the source type.

Connection Name  

  • Select the Google Forms connection you want to integrate.
  • Provide a name for this connection (this should match the Google Forms Source connector).
  • Click Next to proceed.

Enter MySQL Credentials  

Provide the following MySQL access details:

  • MySQL Hostname – Hostname of your MySQL server.
  • Port – The port number of your MySQL instance.
  • MySQL Username – A user with read/write access to the database.
  • Password – Password for the MySQL username.
  • Database Name – The database where data should be stored.
  • Table Name – The table where data should be pushed.
  • Click Validate Credentials to confirm access.

Field Mapping  

  • Map your Google Forms fields with the corresponding MySQL table columns.
  •  Important: The Lead ID (or ID field) from Google Forms must be mapped to a MySQL column.
  • You can map additional fields as needed.

Test & Finish  

  • Click Test Connection to ensure the mapping and credentials are correct.
  • Click Finish to complete the setup.
  • The connected instance will now be visible on the dashboard under MySQL destinations.

Managing Instances  

Adding a New Instance  

  • Follow the same steps as above.
  • Enter MySQL credentials and validate them.
  • Perform field mapping (ensure Lead ID is mapped).
  • Click Test Connection, then Finish.
  • 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 or mappings.
  • Click Next, then Test Connection.
  • Click Finish to apply changes.
    • If you click Cancel, the previous configuration will remain active until you confirm updates with Finish.

How can we help?