Sending Warmly Leads to Google Sheets via Zapier

Last updated: October 3, 2025

Step 1 — Create a Google Sheet

  1. Open Google Sheets.

  2. Create a new spreadsheet.

  3. Add column headers in the first row that match the lead data you want to capture, for example:

    batch_id | generated_at | lead_id | first_name | last_name | email | company | title | linkedin_url | source | score | country | inserted_at

⚠ Important: If you plan to use Microsoft Excel instead, make sure you create a formatted Table first (Insert → Table) with the same headers.

Step 2 — Create a Zap

  1. Go to Zapier and log in.

  2. Click Create Zap.

Step 3 — Catch Webhook from Warmly

  1. For the Trigger, choose Webhooks by Zapier.

  2. Select Catch Hook.

  3. Zapier will generate a Webhook URL.

  4. Copy this URL, then go to your Warmly workspace and paste it as the destination for your webhook.

  5. Send a test event from Warmly to Zapier.

    • Zapier should show you the webhook payload, including a leads array with multiple lead objects.

Step 4 — Loop Through Leads

Warmly sends leads in an array, so we’ll need to process each lead individually.

  1. Add a step: Looping by Zapier.

  2. In Array(s) to Loop, choose the leads array from the webhook payload.

  3. This ensures Zapier will process each lead one by one.

Step 5 — (Optional) Reshape Lead Data

  1. Add a Code by Zapier (JavaScript) step inside the loop.

  2. Use the following code to add metadata (batch_id, generated_at, and inserted_at) to each lead:

    const lead = inputData.lead; // current loop itemreturn {
  batch_id: inputData.batch_id,
  generated_at: inputData.generated_at,
  lead_id: lead.lead_id,
  first_name: lead.first_name,
  last_name: lead.last_name,
  email: lead.email,
  company: lead.company,
  title: lead.title,
  linkedin_url: lead.linkedin_url,
  source: lead.source,
  score: lead.score,
  country: lead.country,
  inserted_at: new Date().toISOString()
};

Step 6 — Add Rows to Google Sheets

  1. Add a new action step: Google Sheets → Create Spreadsheet Row.

  2. Connect your Google account.

  3. Choose the spreadsheet and worksheet you created earlier.

  4. Map each field from the loop (or Code step) to the appropriate column in your sheet.

Step 7 — Test & Turn On

  1. Test the Zap with your sample webhook from Warmly.

  2. Confirm a new row is added to your Google Sheet for each lead.

  3. Once verified, click Publish Zap.

Now every time Warmly sends leads via webhook, Zapier will automatically insert them into your Google Sheet!

Best Practices

  • Deduplication: Use lead_id or email to ensure you don’t insert duplicates.

  • Timestamps: Keep both generated_at (from Warmly) and inserted_at (Zapier time) for auditing.

  • Scaling: For very large lead lists, Zapier’s Looping ensures one row per lead without hitting size limits.

👉 That’s it! You’ve now connected Warmly to Google Sheets with Zapier.