Home
Help
How to Connect Google Lead Form with MySQL

How to Connect Google Lead Form with MySQL

How to Connect Google Lead Form with MySQL

The integration will allow you to get new leads from Google Lead Form and transfer them to MySQL. This allows you to efficiently automate workflows and save a lot of time by not having to manually add each row to the table.

Let's go through the entire Google Lead Form with MySQL setup steps together!

Navigation:
1. What will integration Google Lead Form with MySQL do?
2. How to connect Google Lead Form account?
3. How to connect MySQL account?
4. How to set up data transfer from Google Lead Form to MySQL?
5. An example of the data that will be sent to your MySQL.
6. Auto-update.

To start setup click "Create Connection".

How to Connect Google Lead Form with MySQL | Create connection

Select a system as the Data Source. In this case, you must specify Google Lead Form.

How to Connect Google Lead Form with MySQL | Data Source system selection

Next, you need to specify the system to which the data from the Google Lead Form will be transmitted. In this case, you must specify MySQL.

How to Connect Google Lead Form with MySQL | Data Destination system selection

The next step is to select the Google Lead Form account from which SaveMyLeads will get the data.

If there is no account connected to the system, click "Connect account".  

If desired, you can change its name or simply click "Continue".  

How to Connect Google Lead Form with MySQL | Data Source account
How to Connect Google Lead Form with MySQL | Data Source account connection

When the connected account is displayed in the "active accounts" list, select it.

Attention! If your account is in the "inactive accounts" list, check your access to this account!

How to Connect Google Lead Form with MySQL | Data Source account selection

Next, copy the "URL for receiving data", click "Continue" and go to your Google Lead Form account.

How to Connect Google Lead Form with MySQL | Data Source account connection

In the account, you need to select the lead form you need.

How to Connect Google Lead Form with MySQL | Data Source account connection

Now you need to do the following:

1 - Paste the copied URL into the Webhook URL.

2 - Insert the end of the URL link into the Key.

3 - Click on the "Send test data".   

4 - Save changes.

How to Connect Google Lead Form with MySQL | Data Source account connection

The next step is to select a MySQL account to which leads will be sent.

If there are no accounts connected to the system, click "Connect account".  

How to Connect Google Lead Form with MySQL | Data Destination account connection

Before you start set up, you need:

  1. Verify that MySQL accepts external connections over TCP/IP.
  2. Find the port on which deamon listens.
  3. Verify sure that this port is availabler in both directions for the SaveMyLeads IP server from which you are connectinh:
    * u1 - 104.131.61.128
    * h1 - 159.203.143.246
  4. Verify that the user has access right from the IP or host of the SaveMyLeads server from which the connector is coming.  

Fill the fields with the relevant data where:

- Host - your MySQL domain name specified without additional https:/, /, etc.

- Login - login to MySQL system.

- Password - password in MySQL system.

- Database - the name of the database to which our system will refer.

- Port - port to which we will connect.

You cannot use root, toor, admin, administrator system names to improve security.

How to Connect Google Lead Form with MySQL | Data Destination account connection

When the connected account is displayed in the "active accounts" list, select it.

Attention! If your account is in the "inactive accounts" list, check your access to this account!

How to Connect Google Lead Form with MySQL | Data Destination account selection

Select the table where the data will be transferred.

Now you need to assign variables from the Data Source system to the columns of the table you need.

In this section, the fields will be assigned according to the template. You can completely change it or leave it as is. To add a variable, click on the column field and select the desired variable from the drop-down list. Please note that you can use not only Data Source variables, but also manually entered data.  

Click "Continue" when you're done with assigning fields.

How to Connect Google Lead Form with MySQL | Table selection
How to Connect Google Lead Form with MySQL | Assigning fields
How to Connect Google Lead Form with MySQL | Assigning fields
How to Connect Google Lead Form with MySQL | Assigning fields

Now you see the test data to send to MySQL.

Click "Send test data to MySQL" and go to your MySQL to check the result.

In order for data from Google Lead Form to be transferred multi-venously to MySQL, click "Finish setup".

How to Connect Google Lead Form with MySQL | Test data

On the main screen, click on the gear icon to select the name of the connection and select a group for it, if necessary.

How to Connect Google Lead Form with MySQL | Name and group connection

When the slider is in the position shown in the picture - auto-update works. If you want to disable communication, click this slider.

How to Connect Google Lead Form with MySQL | Enable auto-update

This completes the integration setup between Google Lead Form with MySQL! See how easy it is!?

Now you don't have to worry, SaveMyLeads will do everything on its own!