Remarketing Master

Built by John Rippy | johnrippy.link

🏆 2025 Zapier Automation Hero of the Year — Project Phoenix: A 95-step AI sales pipeline cutting development time by 50%. Read more →

Multi-Platform Audience Builder - Import, Hash & Distribute Leads to Ad Platforms

Import leads from multiple sources, validate, normalize, hash PII for compliance, segment by criteria, and distribute to any ad platform via webhooks. Build custom audiences for Facebook, Google, LinkedIn, TikTok, and more.

Features

Lead Import

• import_from_sheet - Import leads from Google Sheets
• import_from_csv - Import leads from CSV URL
• process_webhook_payload - Process incoming webhook payloads

Lead Processing

• validate_leads - Validate email and phone formats
• normalize_leads - Standardize data formats (lowercase emails, format phones)
• hash_leads - SHA256 hash PII for platform compliance
• deduplicate_leads - Remove duplicate leads by email/phone

Lead Segmentation

• segment_leads - Segment by field value (source, tier, etc.)
• filter_leads - Filter by custom expression
• merge_lead_lists - Combine multiple lead lists

Output & Distribution

• export_to_webhook - Send to Zapier, Make, n8n, or custom webhooks
• export_to_sheet - Append results to Google Sheets
• preview_lead_data - Preview processed data before export
• get_processing_stats - Get statistics on processed leads

Use Cases

• Facebook Custom Audiences - Hash emails/phones, send via Zapier to FB
• Google Customer Match - Format and hash for Google Ads
• LinkedIn Matched Audiences - Prepare B2B leads for LinkedIn
• Multi-Platform Sync - Same leads to multiple platforms
• Lead Scoring Segments - Segment high-value customers
• Retargeting Lists - Build audiences from purchasers, cart abandoners

Platform Requirements

Each ad platform has specific formatting requirements:

Platform	Email	Phone	Name	Hashing
Facebook	Lowercase, SHA256	E.164 format, SHA256	Lowercase, SHA256	Required
Google	Lowercase, SHA256	E.164 format, SHA256	Optional	Required
LinkedIn	Lowercase, SHA256	Not supported	Not used	Required
TikTok	Lowercase, SHA256	E.164 format, SHA256	Optional	Required

Workflow Example

1. Import from Google Sheet
   ↓
2. Validate leads (remove invalid emails/phones)
   ↓
3. Normalize (lowercase, format phones)
   ↓
4. Deduplicate by email
   ↓
5. Segment by "customer_value" field
   ↓
6. Hash PII (SHA256)
   ↓
7. Export to webhook → Zapier → Facebook Custom Audience

Input Formats

Google Sheets

Must be published to web or shared with "Anyone with link". Expected columns:

• email, phone, first_name, last_name, country (configurable)

CSV

Standard CSV with header row. Same columns as above.

Webhook Payload

JSON array of lead objects:

[
  {"email": "john@example.com", "phone": "+15551234567", "first_name": "John"},
  {"email": "jane@example.com", "phone": "+15559876543", "first_name": "Jane"}
]

Output Format

Generic Format

{
  "audience": {
    "name": "High Value Customers",
    "description": "Customers with LTV > $500",
    "created_at": "2024-01-20T14:30:00Z"
  },
  "stats": {
    "total_input": 1000,
    "valid": 950,
    "invalid": 50,
    "duplicates_removed": 25,
    "final_count": 925
  },
  "leads": [
    {
      "email_hash": "abc123...",
      "phone_hash": "def456...",
      "fn_hash": "ghi789...",
      "country": "US"
    }
  ]
}

Facebook Format

{
  "schema": ["EMAIL", "PHONE", "FN", "LN", "COUNTRY"],
  "data": [
    ["abc123...", "def456...", "ghi789...", "jkl012...", "us"]
  ]
}

Hashing Compliance

All major ad platforms require PII to be hashed before upload:

1. Normalize - Lowercase, trim whitespace
2. Hash - SHA256 (lowercase hex output)

Example:

• Input: John@Example.com
• Normalized: john@example.com
• Hashed: 836f82db99121b3481011f16b49dfa5fbc714a0d1b1b9f784a1ebbbf5b39577f

Pricing

$0.01 per query (all tasks)

Integration Examples

Zapier

1. Run actor with export_to_webhook task
2. Set webhook URL to your Zapier webhook
3. Zapier receives leads and pushes to Facebook/Google/LinkedIn

Make (Integromat)

1. Create Make scenario with webhook trigger
2. Use webhook URL as output destination
3. Connect to Facebook Custom Audiences module

n8n

1. Create n8n workflow with webhook node
2. Connect to Facebook/Google/LinkedIn nodes
3. Run actor with your n8n webhook URL

Rate Limits

• Webhook batches: Configurable (default 100 leads/batch)
• Google Sheets: Subject to Google API limits
• No internal rate limits on processing