How to integrate of Google Sheets-HubSpot bundle using Zapier?

Easily integrate new Google Sheets rows into HubSpot contacts automatically. Follow our straightforward guide to streamline your contact management and enhance productivity.

Adding new contacts to HubSpot when a new row is added to Google Sheets

 How the integration works: 

• A new row is created in a specific Google Sheets sheet;
•  Zapier creates a new contact in HubSpot.

1.  Creating a Zap. On the “Home” tab, click the “Create” button:

2. Select “Zaps” from the drop-down menu.

Setting up the trigger event

3. Choose the trigger event. This is the event that occurs in the trigger application that signals Zapier to start the Zap.

4. Select the trigger event service.

5. From the drop-down list, select “New Spreadsheet Row” and click “Continue”, the trigger will fire when a new row appears in the table.

6. Next, you need to specify the “Google Sheets” account and click the “Continue” button.

7. Next, you need to specify the settings for the trigger by specifying the name of the table and the sheet, and click “Continue”.

8. Then you need to test the trigger by clicking the “Test trigger” button.

9. The next step is for the system to find the record and display all the information that is available. Click the “Continue with selected record” button.

This is how the data sent to the Google table looks

Setting up an action in the “HubSpot” service

10.  Choose the action service.

11. In the next window, you need to specify the action that will be performed when a new row appears. From the drop-down list, select “Create Contact” and click “Continue”.

12. Next, you need to specify the “HubSpot” account and click the “Continue” button.

13. Next, you need to set up the connection between the “Google Sheets” and “HubSpot” applications. Fill in the required fields and the fields into which the data should be imported, substituting variables from the drop-down list. After filling in all the required fields, click the “Continue” button.

14. You need to test the “Google Sheets” – “HubSpot” connection.

15. Test data sent to “HubSpot”

.

16. Check the test data in the “HubSpot” application.

17. After a successful test, click the “Publish” button.

18. The Zap is created, configured, and activated.