Get HubSpot company info from a list of email addresses in Google Sheets

Bardeen's workflow automation effectively synchronizes business data between Google Sheets and HubSpot, ensuring your sales team has access to the latest company information without manual data entry. This playbook specifically targets sales prospecting by enhancing your Google Sheets data with HubSpot's rich company insights, allowing for more informed outreach and engagement strategies.

Here's how this workflow retrieves HubSpot company information for a list of email addresses in Google Sheets:

• Step 1: Get data from Google Sheets - Bardeen retrieves the entire table from a specified Google Sheet and tab, allowing us to process the list of email addresses contained within.
• Step 2: Extract email addresses - It converts a column from the retrieved table into an array to isolate the email addresses that we will use to look up company information in HubSpot.
• Step 3: Prepare domain search - Here, we split each email address at the "@" symbol to derive the domain name, which is crucial for the HubSpot company search.
• Step 4: Get company info from HubSpot - With the domain name, Bardeen queries HubSpot for matching company records.
• Step 5: Prepare data for Google Sheets - The company information obtained from HubSpot is converted into a table format suitable for updating the corresponding rows in Google Sheets.
• Step 6: Update Google Sheets with company info - Finally, the Google Sheet is updated with the new HubSpot company information, ensuring that your sales data is rich and up-to-date.