LinkedIn Outreach Batch Personalization — Clay or Apollo Export to Draft Messages

Trigger: New row added to a Google Sheet from Clay, Apollo, or LinkedIn Sales Navigator export.

What this automates: Writing individualized LinkedIn messages at scale. Each prospect gets a unique connection request and follow-up DM.

  1. Prospect data exported to Google Sheet (rep action)
  2. Zapier triggers on new Google Sheet rows
  3. Claude API writes connection request and follow-up DM
  4. Draft messages written back to Google Sheet