Zapier Integration Guide

Every time a buyer completes a purchase on SendOwl, this Zap automatically creates a new order record in your Admin Dashboard so you can see all sales in real time — no manual entry needed.

1. 1
   Create a new Zap in Zapier

   Go to zapier.com/app/zaps → Click "+ Create Zap" (top left).

2. 2
   Set the Trigger — SendOwl "New Order"

   • Search for SendOwl in the app search box
   • Select Event: "New Order"
   • Click Connect SendOwl → Enter your SendOwl API Key and Secret
   • Click Test Trigger — Zapier will pull your most recent SendOwl order as sample data
   • Confirm you can see fields like buyer_name, buyer_email, order_total, product_name
3. 3
   Set the Action — Webhooks by Zapier "POST"

   • Click "+" to add an action → Search for "Webhooks by Zapier"
   • Select Event: "POST"
   • In the URL field, paste exactly:

   https://www.wisdomspeeksmusic.com/tables/orders Copy

   • Set Payload Type to json
   • Under Data, add the following key-value pairs (map from SendOwl fields):
4. 4
   Map these fields (SendOwl → Your Dashboard)

   Key (type this)	Value (select from SendOwl)	Notes
   customer_name	Buyer Name	Buyer's full name
   customer_email	Buyer Email	Buyer's email address
   product_name	Product Name	e.g., "MP3 Digital Download"
   product_type	Product Name (or type manually)	Type: mp3, wav, or bundle
   amount	Order Total	Sale amount in USD
   currency	USD	Type "USD" manually
   status	completed	Type "completed" manually
   sendowl_order_id	Order ID	SendOwl's order reference number
   order_date	Created At	Timestamp of the purchase
   source	zapier_sendowl	Type "zapier_sendowl" manually

5. 5
   Test & Publish

   • Click Test Action — Zapier will POST a test order to your dashboard
   • Open your Admin Dashboard → Orders tab to confirm the test order appears
   • Click Publish Zap and name it "SendOwl → Admin Dashboard"

   ✅ From now on, every SendOwl purchase will automatically appear in your Admin Dashboard within seconds.

When a buyer completes a purchase on SendOwl, this Zap automatically adds them to your Mailchimp audience — no manual export/import needed. Perfect for sending follow-up emails, exclusive content, and future release announcements.

1. 1
   Create a new Zap

   Click "+ Create Zap" in Zapier.

2. 2
   Trigger — SendOwl "New Order"

   • Same as Zap 1: Search SendOwl → Event "New Order"
   • Select your connected SendOwl account (it should already be saved)
   • Click Test Trigger to load sample data
3. 3
   Action — Mailchimp "Add/Update Subscriber"

   • Click "+" → Search Mailchimp
   • Select Event: "Add/Update Subscriber"
   • Connect your Mailchimp account → Authorize access
   • Select your Audience (your main Wisdom Speeks mailing list)
4. 4
   Map fields (SendOwl → Mailchimp)

   Mailchimp Field	SendOwl Value	Notes
   Email Address	Buyer Email	Required
   First Name	Buyer Name	Use "First Name" if available
   Status	subscribed	Type "subscribed" manually
   Tags (optional)	buyer, wisdom-speeks	Helps segment your audience

   Pro Tip: Create a tag for each product type. Add a Filter step before Mailchimp to tag Bundle buyers as "founding-supporter", WAV buyers as "wav-buyer", and MP3 buyers as "mp3-buyer". This lets you send targeted campaigns.
5. 5
   Test & Publish

   • Click Test Action — Zapier adds the sample buyer email to your Mailchimp list
   • Verify in Mailchimp → Audience → Contacts that the test contact appears
   • Click Publish Zap → Name it "SendOwl → Mailchimp Subscribers"

   ✅ Every buyer is now automatically added to your Mailchimp list — ready for your next email campaign.

When you approve an affiliate commission in your Admin Dashboard, this Zap automatically sends a PayPal payout to the affiliate's registered PayPal email — eliminating manual payout steps.

1. 1
   Create a new Zap

   Click "+ Create Zap" in Zapier.

2. 2
   Trigger — Webhooks by Zapier "Catch Hook"

   Because your Admin Dashboard uses a custom Tables API (not a standard Zapier app), you'll use Zapier's Webhook trigger to listen for commission approvals.

   • Search "Webhooks by Zapier" → Select Event: "Catch Hook"
   • Zapier generates a unique webhook URL — copy it (looks like https://hooks.zapier.com/hooks/catch/XXXXXXX/XXXXXX/)
   • Keep this Zap step open — you'll use this URL in the next step
3. 3
   Add the Webhook URL to your Admin Dashboard

   This tells your dashboard to notify Zapier whenever a commission is approved.

   • Open Admin Dashboard → Settings tab → scroll to "Zapier Integration"
   • Paste the Zapier hook URL into the "Commission Approved Webhook" field and Save
   • Go back to Zapier, click "Test Trigger" — then in Admin Dashboard, approve any commission to send a test event

   Alternative (no code change): If you prefer, skip this step and manually trigger payouts by logging into PayPal and sending money when you approve commissions. Zap 3 is the automation, but it's optional.
4. 4
   Filter Step — Only "approved" commissions

   • Click "+" → Search "Filter by Zapier"
   • Set condition: status → Text Contains → approved
   • This ensures only approved commissions trigger a PayPal payout
5. 5
   Action — PayPal "Send Payout"

   • Click "+" → Search PayPal
   • Select Event: "Send Payout"
   • Connect your PayPal Business account
   • Map the fields:

   PayPal Field	Value	Notes
   Recipient Email	affiliate_paypal_email	From commission record
   Amount	commission_amount	In USD
   Currency	USD	Type "USD" manually
   Note	Wisdom Speeks Affiliate Commission - Go Go Records	Appears in PayPal transaction

6. 6
   Test & Publish

   • Click Test Action with a small test amount ($0.01)
   • Verify the PayPal payout appears in your PayPal activity
   • Click Publish Zap → Name it "Approved Commission → PayPal Payout"

   ✅ Affiliate payouts are now fully automated — approve in dashboard, PayPal sends the money.

1. 1
   Create a $0.00 test product in SendOwl

   SendOwl Dashboard → Products → Add Product → set price to $0.00 (or use a discount code for 100% off). Complete a test purchase using your own email.

2. 2
   Check Admin Dashboard

   Open admin.html → Orders tab — the test order should appear within 10-30 seconds with status "completed".

3. 3
   Check Mailchimp

   Open Mailchimp → Audience → Contacts — your test email should be subscribed within 1-2 minutes.

4. 4
   Check Zapier Task History

   In Zapier → Zap History — confirm all 3 tasks ran with status "Success". If any failed, click on the task to see the error details.

1. Zap is not triggering

   • Make sure the Zap is turned ON (toggle in Zapier)
   • On the free Zapier plan, triggers check every 15 minutes — not instant. Upgrade to a paid plan for instant triggers.
   • Test your SendOwl connection in Zapier → make a new test order
2. Order shows in Zapier history but not in Admin Dashboard

   • Check that the Webhook POST URL is exactly: https://www.wisdomspeeksmusic.com/tables/orders
   • Make sure Payload Type is set to json (not form)
   • Verify the customer_email field is mapped (it's required by the orders schema)
3. Mailchimp subscriber not appearing

   • Check you selected the correct Audience in the Mailchimp action step
   • Verify the email address field is correctly mapped from SendOwl
   • Make sure "Status" is set to subscribed (not pending)
4. PayPal payout not sending

   • PayPal requires a Business account with Payouts enabled — check PayPal → Settings → Payments
   • Ensure the affiliate has a valid PayPal email saved in their affiliate profile
   • Check PayPal account balance — insufficient balance will fail the payout
   • Confirm the Zapier Filter step is set correctly (status = "approved")
5. Hitting the 100 task/month free limit

   Each sale uses 2 tasks (Zap 1 + Zap 2). So the free tier covers ~50 sales per month. If you're growing past that, the Starter plan at $19.99/mo gives 750 tasks — more than enough for hundreds of monthly sales.