Step 2: Connect HubSpot and Fetch Recent Companies

Retrieve recently created or updated companies from HubSpot.

1. Open Fetch Recent Companies and set Resource to company and Operation to getRecentlyCreatedUpdated.
2. Enable Return All by setting it to true.
3. In Additional Fields → Since, keep the expression {{ new Date(new Date($json.timestamp).getTime() - 7*24*60*60*1000) .toISOString() .slice(0,10) }} to pull the last 7 days of updates.
4. Credential Required: Connect your hubspotAppToken credentials.

Step 3: Prepare Company Data and Batch Processing

Normalize company IDs and domains, then process them in batches.

1. Open Derive Company Domain and keep the provided Function Code that extracts companyId and domain.
2. Connect Derive Company Domain to Iterate Records Batch.
3. In Iterate Records Batch, leave Options → Reset set to false.
4. Confirm Iterate Records Batch outputs to both CompanyEnrich Domain Lookup and Combine Streams as configured.

Step 4: Enrich Companies and Validate Results

Call the enrichment API, merge the results, and validate success before updates.

1. Open CompanyEnrich Domain Lookup and set URL to https://api.companyenrich.com/companies/enrich.
2. Enable Send Query and set the domain query parameter to {{ $json.domain }}.
3. Enable Send Headers, set Specify Headers to json, and keep JSON Headers as { "Authorization": "Bearer [CONFIGURE_YOUR_TOKEN]", "Accept": "application/json" } (replace the token).
4. Open Combine Streams and set Mode to combine and Combine By to combineByPosition.
5. Open Validate Enrichment Result and keep the string condition {{ $json && $json.statusCode ? String($json.statusCode) : '' }} with Operation set to isEmpty to gate successful results.

Step 5: Configure HubSpot Updates and Failure Logging

Apply enrichment data to HubSpot and route failures to a logging step.

1. Open Update HubSpot Company and set Resource to company, Operation to update, and Company ID to {{ $json.companyId }}.
2. Map update fields exactly as configured, including City {{ $json.location.city.name }}, Name {{ $json.name }}, Company Domain Name {{ $json.domain }}, and LinkedIn Company Page {{ $json.socials.linkedin_url }}.
3. Credential Required: Connect your hubspotAppToken credentials in Update HubSpot Company.
4. Ensure the false branch of Validate Enrichment Result routes to Log Failure, then back to Iterate Records Batch to continue processing.

Step 6: Test and Activate Your Workflow

Run a manual test to confirm enrichment and updates, then activate the schedule.

1. Click Execute Workflow to run the workflow manually from Scheduled Run Starter.
2. Verify that CompanyEnrich Domain Lookup returns enriched data and that Update HubSpot Company applies changes to a sample company.
3. Confirm failures route through Validate Enrichment Result to Log Failure without stopping the batch loop.
4. When successful, toggle the workflow Active so it runs on the weekly schedule.