This article demonstrates how to store the contact details of a person from HubSpot to a spreadsheet using Quickwork. 

What you'll need:

Skill level: Easy

Time required: 5 minutes

• Trigger:
  1. 1.  HubSpot - New contact created: To trigger the journey
• Action:
  1. 1. Google Sheets - Add row (new version): To store the contact details in a spreadsheet

Prerequisite

Create a spreadsheet in Google Sheets named HubSpot contact's list with the following headers:

1. Firstname
2. Lastname
3. Email address
4. Phone number

Configuring the trigger

1. Under the Event section, choose the HubSpot app from the drop-down menu in the Apps list present right below the New Trigger button.
2. Select the trigger event, New contact created, from the drop-down menu in the Triggers list.
3. Click the Link an account button to connect to a HubSpot account.
   
4. The Property mode field will open. Select Value only as the input:

Configuring the action

1. Under the Steps section, click on the Simple Action button and choose the Google Sheets app from the drop-down menu in the Apps list.
2. Select the action, Add row (new version), from the drop-down menu in the Actions list.
3. Click the Link an account button. The Google Sheets app requires authorization to connect with Quickwork. Simply log in to your Google account and allow the permissions. 
   
   Note: Ensure you connect the Google account that has the HubSpot contact's list spreadsheet created. If you connect a Google account with no corresponding spreadsheet, the header names that we defined previously won't get populated in Quickwork.
      
4. Upon successful connection, the input fields will open. Select HubSpot contact's list as an input from the Spreadsheet drop-down menu.
5. Select Sheet1 as an input from the Sheet name drop-down field:
   
   
   
   
6. The column headers will open. Now, search for the following data pills from the HubSpot | New contact created Trigger under Data Tree Output:
   1. 1. First Name
      2. Last Name
      3. Email
      4. Phone Number
7. Drag and drop these to the respective input fields as shown here:
   
   
   
   
8. Now, save the journey change and click the Save & Start button.

Executing the journey

Go to your HubSpot account and create a new contact. Select the Contacts tab from the top navigation bar and click the Create contact button located on the top-right corner of the screen. A window will prompt from the right-hand side: 

Fill in the contact details and click the Create contact button. Wait for a few seconds since New contact created is a pooling trigger. It takes 1 minute to listen to incoming data. 

Check your spreadsheet. The contact details are automatically replicated: