How to Import Event Leads from Google Sheets to HubSpot with Pipedream

Pipedream > Workflows > New

Create new Pipedream workflow

Go to pipedream.com and click New Workflow. You'll see a blank canvas with a trigger section at the top. This is where you'll configure the Google Sheets monitoring. Pipedream will check your sheet every 15 minutes by default.

1. 1Click the blue New Workflow button
2. 2Select 'Build your own' from the options
3. 3Name your workflow 'Event Lead Import'
4. 4Click Create Workflow

Trigger > Select App > Google Sheets

Add Google Sheets trigger

Click the trigger step and search for Google Sheets. Select 'New Row Added' as your trigger type. This will monitor your specific sheet for new rows and fire the workflow when leads are pasted. You'll need to authenticate with your Google account that has access to the sheet.

1. 1Click 'Select an app' in the trigger
2. 2Search for 'Google Sheets' and select it
3. 3Choose 'New Row Added' trigger
4. 4Connect your Google account

Trigger Configuration > Spreadsheet Settings

Configure sheet and range

Select your Event Leads spreadsheet from the dropdown. Choose the specific worksheet tab where you paste leads. Set the range to include all columns you need - typically A:H for name, email, company, phone, title, notes, and source. Leave the header row option enabled if row 1 contains column names.

1. 1Select your spreadsheet from the Spreadsheet dropdown
2. 2Choose the correct worksheet tab
3. 3Set Range to 'A:H' or your column range
4. 4Enable 'Worksheet contains headers'

Trigger > Test

Test the Google Sheets trigger

Add a test row to your sheet with sample lead data. Come back to Pipedream and click Test Trigger. Pipedream will fetch the new row and show you the data structure. You need this data to map fields in the next step.

1. 1Add a sample lead row to your Google Sheet
2. 2Click 'Test trigger' in Pipedream
3. 3Wait for the data to appear
4. 4Review the field names and values

Steps > Add Step > HubSpot

Add HubSpot step

Click the + button below your trigger to add a new step. Search for HubSpot and select 'Create Contact' action. This will create a new contact record for each lead row. You'll authenticate with HubSpot using an account that has contact creation permissions.

1. 1Click the + button to add a step
2. 2Search for 'HubSpot' and select it
3. 3Choose 'Create Contact' action
4. 4Connect your HubSpot account

HubSpot Step > Field Mapping

Map contact fields

Map your Google Sheets columns to HubSpot contact properties. Click each HubSpot field and select the corresponding data from your trigger. Email is required - HubSpot will reject records without it. Map firstname, lastname, company, phone, and jobtitle at minimum for useful contact records.

1. 1Click the Email field and select your email column
2. 2Map firstname to your first name column
3. 3Map lastname to your last name column
4. 4Map company and phone fields
5. 5Set jobtitle if you collect titles

HubSpot Step > Additional Properties

Add event source tag

Scroll down to find the 'hs_lead_status' or custom tag fields in the HubSpot step. Set a fixed value like 'Event Lead - Trade Show 2024' so you can filter these contacts later. You can also map a dynamic tag if your sheet includes a source column with different event names.

1. 1Scroll to additional properties section
2. 2Find 'Lead Status' or tag fields
3. 3Enter your event name as a fixed value
4. 4Or map to a source column from your sheet

Steps > Add Step > Code

Add duplicate prevention

Add a Node.js code step before HubSpot to check for existing contacts. Pipedream's HubSpot integration doesn't prevent duplicates by default. Use the HubSpot API to search by email first, then only create if no match is found. This prevents duplicate contacts from repeat imports.

1. 1Click + to add a step before HubSpot
2. 2Select 'Code' and choose Node.js
3. 3Paste the duplicate-check code
4. 4Update the HubSpot step to use conditional logic

Workflow > Test

Test the complete workflow

Add another test row to your sheet with different lead data. Click Test Workflow to run all steps. Check that the contact appears in HubSpot with correct field values and your event tag. Verify the duplicate check works by running the same data twice.

1. 1Add a new test lead to your sheet
2. 2Click 'Test workflow' button
3. 3Review each step's output
4. 4Check HubSpot for the new contact
5. 5Test duplicate prevention with same email

Workflow > Deploy

Deploy and set schedule

Click Deploy to activate your workflow. The trigger will check for new sheet rows every 15 minutes by default. You can change this to every 5 minutes if you need faster imports, but it will use more credits. The workflow will now run automatically whenever new leads are pasted.

1. 1Click the Deploy button in the top right
2. 2Confirm the deployment
3. 3Check the trigger schedule setting
4. 4Adjust timing if needed

Add this Node.js code step before the HubSpot step to prevent duplicate contacts and handle empty fields gracefully. Paste it in a new code step and adjust the email field reference to match your trigger data.

import axios from 'axios'
export default defineComponent({
  async run({ steps, $ }) {

import axios from 'axios'

export default defineComponent({
  async run({ steps, $ }) {
    const email = steps.trigger.event.email
    const hubspotToken = process.env.HUBSPOT_TOKEN
    
    // Check for existing contact
    try {
      const searchResponse = await axios.get(
        `https://api.hubapi.com/contacts/v1/contact/email/${email}/profile`,
        { headers: { 'Authorization': `Bearer ${hubspotToken}` } }
      )
      
      if (searchResponse.status === 200) {
        console.log(`Contact ${email} already exists, skipping creation`)
        return { skip_creation: true, existing_contact: searchResponse.data }
      }
    } catch (error) {
      if (error.response?.status !== 404) {
        throw error
      }
    }
    
    // Clean and prepare contact data
    const contactData = {
      email: email,
      firstname: steps.trigger.event.first_name || '',
      lastname: steps.trigger.event.last_name || '',
      company: steps.trigger.event.company || 'Not provided',
      phone: steps.trigger.event.phone || null,
      jobtitle: steps.trigger.event.title || null,
      hs_lead_status: steps.trigger.event.source || 'Event Lead'
    }
    
    // Remove null values
    Object.keys(contactData).forEach(key => {
      if (contactData[key] === null || contactData[key] === '') {
        delete contactData[key]
      }
    })
    
    return { skip_creation: false, contact_data: contactData }
  }
})