Sync new Adobe Commerce shoppers to HubSpot contacts

Every hour, sync newly registered Adobe Commerce shoppers into HubSpot as contacts. This is a deterministic one-way sync with no reasoning required, so build it as a code workflow.

Trigger: cron every hour. Keep a persisted watermark for the last successful run timestamp. On the first run, seed the watermark with the workflow start time so we do not backfill the entire customer base.

Step 1: Call Adobe Commerce Search Customers with searchCriteria filtering created_at greater-than-or-equal to the last-run watermark (condition_type=gteq), sort by created_at ascending, pageSize 100, and page through by incrementing currentPage until the accumulated items reach total_count.

Step 2: For each Adobe Commerce customer, build a HubSpot contact properties payload: email from email, firstname from firstname, lastname from lastname, phone from the default billing address telephone (look up the address in the customer.addresses array whose id equals customer.default_billing), city from that address city, state from that address region.region, country from that address country_id. Also set two custom properties: adobe_commerce_customer_id (from customer.id) and store_view_code (from customer.store_id, resolved to the store view code via GET /store/storeViews if the property expects the code rather than the numeric id). Skip any customer without an email.

Step 3: Chunk the payloads into batches of 100 and call HubSpot Batch Upsert Contacts with idProperty set to "email" so existing HubSpot contacts are updated in place instead of duplicated. Handle 429 responses by respecting the Retry-After header.

Step 4: After the run completes, persist the highest created_at from the successfully upserted batch as the new watermark. If a batch fails, only advance the watermark past the last successfully processed customer so a partial failure does not skip records on the next run.