Add contacts to a HubSpot sequence from a Google Sheet


How to add contacts to a HubSpot sequence from a Google Sheet: install the Chrome extension, click Build from description, tell the agent what you want, and follow its prompts. A working bot is built and tested in minutes.

Here is how the automation works. To add contacts to a HubSpot sequence automatically, read their email addresses from a Google Sheet with Read data from a Google Sheet, open the sequence with Go to page, and, for each contact in a Loop through data step, choose Enroll contacts, search for the email address, tick the contact and click Start sequence. Each enrolled contact is then deleted from the sheet.

Author
Alex Barlow
Published

Build the HubSpot sequence enroller from a description


Describe it and click the button: the agent builds and tests the enroller in your Chrome extension. HubSpot has to be logged in in Chrome, and the agent asks you for the sequence's URL.

  1. Read the email addresses in my Google Sheet
  2. Open my HubSpot sequence
  3. Enroll each contact in the sequence
  4. Delete each contact from the sheet once done
Click to launch the Chrome extension. Not installed? You can create an account and try it free.Opens the Chrome extension. Free account to try.

You need a Google Sheet with one contact email address per row in column A and no header row. Leave it as it is while the run deletes each enrolled contact from the top.

Build the HubSpot sequence enroller step by step


The steps the agent builds, as the Builder shows them: each step by its name, with the fields to set under it. Add them yourself in this order in the step-by-step builder, or open the agent's result there to adjust it.

  • 1.0 Read data from a Google Sheet
    • Spreadsheet: your sheet, the email addresses in column A
    • First cell: A1
    • Last cell: AB1
  • 2.0 Go to page
    • URL: your HubSpot sequence's URL
  • 3.0 Loop through data
    • repeats for every row in [google-sheet-data]
    • 3.1 Select list
      • Select: the Enroll contacts dropdown
      • Text: Email contacts
    • 3.2 Enter text
      • Select text field: HubSpot's Search for contacts box
      • Text: the email column of [google-sheet-data]
    • 3.3 Click element
      • Select: the checkbox of the top search result
    • 3.4 Click element
      • Select: the Next button
    • 3.5 Click element
      • Select: the Start sequence button
    • 3.6 Delete rows from a Google Sheet
      • Spreadsheet: your sheet
      • First row: 1
      • Last row: 1

Common questions about adding contacts to a HubSpot sequence


Why does the HubSpot automation click the wrong button or none?

HubSpot's page changed, or the selector picked a different element. Click Select again on the step and reselect the button or checkbox. When a run fails, hand it to the agent and it repairs the step.

The email address in the sheet does not belong to a HubSpot contact, or has a typo. HubSpot can only enroll contacts it already holds, so add the contact to HubSpot first or correct the address in the sheet.

How do I add more than one contact to the HubSpot sequence in a run?

Raise Last cell in Read data from a Google Sheet, for example from AB1 to AB50. The loop then enrolls every contact in that range, and each is deleted from the sheet as it is done.

Can I add contacts to a HubSpot sequence without code?

Yes. The automation fills HubSpot's own enrollment dialog in your browser, step by step, so it needs no HubSpot API key or script, and the agent builds it from the lines above.

Can I run the HubSpot enrollment on a schedule?

Yes. Save the automation and set a schedule; each run enrolls the contacts at the top of the sheet and deletes them, so new addresses added to the sheet are picked up by the next run.

Can I automate other HubSpot actions the same way?

Yes. Clicking, choosing from dropdowns and typing cover most of HubSpot, so the same steps automate marketing, CRM, content and reporting tasks in the browser. See browser actions for the steps that click and type on a page.

Where do I get help?

Get in touch with support, or ask in the axiom.ai community.

Related guides