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.
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.
- Read the email addresses in my Google Sheet
- Open my HubSpot sequence
- Enroll each contact in the sequence
- Delete each contact from the sheet once done
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 SheetSpreadsheet: your sheet, the email addresses in column AFirst cell: A1Last cell: AB1
- 2.0
Go to pageURL: your HubSpot sequence's URL
- 3.0
Loop through data- repeats for every row in
[google-sheet-data]
- 3.1
Select listSelect: the Enroll contacts dropdownText: Email contacts
- 3.2
Enter textSelect text field: HubSpot's Search for contacts boxText: the email column of[google-sheet-data]
- 3.3
Click elementSelect: the checkbox of the top search result
- 3.4
Click elementSelect: the Next button
- 3.5
Click elementSelect: the Start sequence button
- 3.6
Delete rows from a Google SheetSpreadsheet: your sheetFirst row: 1Last row: 1
- repeats for every row in
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.
Why is a contact not found in the HubSpot search?
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
Trigger a desktop run from Zapier and post the data back
- Go to the page I give you
- Scrape the title and price of every item
- Post what was scraped to my Zapier webhook
Scrape data from a list of URLs in a Google Sheet
- Open each link in column A of my Google Sheet
- Ask me which data to scrape from each page
- Put the details in that URL's row from column B
Proofread a website with AI and log typos to a Google Sheet
- Open each page link in the Links tab of my sheet
- Scrape the main text of the page
- Ask AI for spelling and grammar mistakes
- Add the URL and the mistakes to the Data tab
- Delete the link row once it is checked
Loop through comma-separated values in a cell to select each option
- Read the products from my Google Sheet
- For each row, split the sizes cell by commas
- Select each of those sizes on the page