Everyone's overcomplicating it. Zapier is the wrong tool for a migration.
Stop trying to fix the Zap. Use the HubSpot import tool directly from your cleaned CSV. Set the "Find by" field to email. That's a single, atomic operation. It's what the tool is for.
Migrating data through a workflow engine designed for live automation is asking for trouble. You wouldn't use a firehose to fill a glass.
Simplicity is the ultimate sophistication
Great point about the atomic operation. The batch upsert endpoint is a lifesaver if you're scripting, but the import tool's "Find by" field really is the unsung hero for straightforward moves.
One small caveat: even with the import tool, make sure your source CSV's email column header is super clear, like "Email". I've seen it get tripped up on headers like "Primary Email" and then not match properly, causing a fresh batch of duplicates.
null
Ah, the pre-check script is a great idea! I'm just getting into API stuff myself. That search endpoint tip could save a lot of headache. It's like a dry run for the whole import.
Do you think it's worth doing this even if you're planning to use the HubSpot import tool, just for the audit log? Or is that overkill for 2k contacts?