1.Schedule daily at 06:00
Integrate Schedule by Zapier and scheduling tools to trigger the daily candidate pull to run the referral pipeline.
Add daily referral candidates to your marketing list
Automatically pull referral candidate rows across Google BigQuery and Zapier Scheduler. Add daily candidates to Klaviyo lists when scheduled run starts, daily batch arrives, or the morning window beginsβso you can map profiles, filter emails, and include subscribers without manual list building.
How this automation refreshes your referral audience lists
When daily referral candidate batches are due, delays can cause missed campaign eligibility. This automation runs a BigQuery query, loops and filters rows, then creates subscribers and adds them to your configured Klaviyo listβso your team can ship segments on time.
Schedule by Zapieror swap with your favorite app
2.Runs configured referral SQL query
Integrate Google BigQuery and data warehouse tools to execute the configured SQL to return referral candidate rows.
Google BigQueryor swap with your favorite app
3.Iterates rows and maps fields
Integrate Looping by Zapier and field mapping tools to iterate each returned row to map source fields to subscriber fields.
Looping by Zapieror swap with your favorite app
4.Filters to rows with valid email
Integrate Filter by Zapier and email validation tools to continue only when a valid email is present to skip empty emails and duplicates.
Filter by Zapieror swap with your favorite app
5.Finds or creates subscriber profile
Integrate Klaviyo and customer profile tools to find or create a subscriber to capture the profile id.
Klaviyoor swap with your favorite app
6.Adds subscriber to configured list
Integrate Klaviyo and marketing list tools to add the profile id to a configured list to ensure inclusion for campaign sends.
Automate your work, your way
Build custom automations across your tools in minutes. Describe what you need, connect your apps, and create workflows without the manual effort.
Trusted by 3.4 million companies
Related automations
- Apps: Webhooks by Zapier, Zapier Tables, Code by ZapierSwap with your favorite apps.
Add adviser referral submissions to your contacts table
Your adviser referrals arrive via webhook and sit untracked, causing manual lookups and delayed outreach. Capture them into a contacts table so marketing ops can begin outreach same day.
- Apps: Squarespace Forms, Kit, Delay by Zapier, GmailSwap with your favorite apps.
Add affiliate form applicants to onboarding list and email
Your affiliate form submissions arrive untracked, forcing program coordinators to add applicants manually and delaying onboarding. New applicants are added to your affiliate audience and get a welcome email same day.
- Apps: Kartra, Filter by Zapier, Google SheetsSwap with your favorite apps.
Add affiliate form responses to centralized intake tracker
Your affiliate questionnaire responses stay siloed in forms and emails, slowing partner qualification and campaign reporting. Centralizing submissions gives coordinators instant visibility same day.
- Apps: Webflow, Filter by Zapier, Webhooks by ZapierSwap with your favorite apps.
Add affiliate partner applicants to partner program audience
Your partner application form funnels affiliate submissions into a manual intake, delaying outreach and onboarding. Add qualifying applicants to the partner audience so outreach starts same day.
- Apps: Webhooks by Zapier, Filter by Zapier, SendlaneSwap with your favorite apps.
Add affiliate signups to your email marketing list
Your JV signup webhook submissions often go unprocessed, delaying partner outreach. It adds each contact to your affiliate mailing list so partners get segmented nurture the same day.
- Apps: Webhooks by Zapier, Delay by Zapier, Stripe, Google SheetsSwap with your favorite apps.
Add affiliate trial signups to recruitment tracking sheet
Your affiliate trial signups arrive without payment or attribution context, leaving marketing ops unable to prioritize quality referrals. It logs signups with payment context for same-day follow-up.
- Apps: Webhooks by Zapier, Filter by Zapier, LeadConnectorSwap with your favorite apps.
Add and update referral contacts from incoming webhooks
Your referral webhooks arrive without sponsor or upline context, causing outreach errors. It creates or updates contact records with upline details so coordinators can follow up same day.
- Apps: Webhooks by Zapier, Delay by Zapier, Tapfiliate, Perfit, Google Sheets, SlackSwap with your favorite apps.
Add approved partners and affiliates to mailing lists
Your partner and affiliate approvals arrive without a central list or log, slowing onboarding and outreach. Add contacts to segmented lists and a shared approval log so outreach starts same day.
- Apps: Salesforce, Formatter by Zapier, Filter by Zapier, BrevoSwap with your favorite apps.
Add billing and manager emails to referral nurture list
Billing contacts and property records can stay out of marketing lists after first invoice, delaying referral outreach. Add them to the referral list so campaign managers can start outreach the same day.
- Apps: Cal.com, Formatter by Zapier, Filter by Zapier, ActiveCampaignSwap with your favorite apps.
Add booked contacts to referral lists for targeted outreach
Your bookings arrive without referral tags, causing missed channel-specific nurture and extra manual list work. Get contacts routed into the right marketing lists for tailored outreach same day.
- Apps: OnceHub, Formatter by Zapier, Google Sheets, ActiveCampaignSwap with your favorite apps.
Add booked referral leads to nurture list and sheet
Your referral bookings sometimes miss contact capture, leaving campaign managers without context. It logs bookings to your sheet and marketing list, enabling nurture within minutes.
- Apps: Calendly, Formatter by Zapier, Circle, LeadConnector, HubSpot, SlackSwap with your favorite apps.
Add booked referral partner to community and pipeline
Your partner bookings miss community invites, pipeline updates, forcing manual outreach and delaying onboarding. Get automatic community invites and CRM updates so coordinators can prep same day.
- View all
Explore all referral program management automations
Scale referral program growth with automated referral tracking, reward routing, and advocate notifications
Set up in minutes
Zapier connects your tools, triggers actions from real-time data, and streamlines workflows so your team can focus on what matters most.
Step 1
Connect your tools
Bring your apps together so information can move automatically between the tools your team already uses.
Step 2
Define the trigger
Choose the events that should start your workflow, like a new submission, updated record, completed task, or customer action.
Step 3
Automate and measure
Let your workflow handle follow-ups, updates, notifications, and reporting so your team can track progress and act faster.
See how teams are automating with Zapier (and loving it!)
Without Zapier, we would have needed well over 100 employees today just to do what we're doing. We would have been out of business by now.
David Laderberg, VP of Sales
Without having automation, we would have to at least be double our size. Doubling is a bit of a euphemism β I think we would have died or fallen back into oblivion.
Marcelo Lebre, Co-Founder
Zapier helps us close far above 50% more deals than we would without it. It is a key element of our overall strategy and, therefore, of our sales pitch.
Raphael Bochner, Founder and CIO
Zapier gives us unlimited flexibility and creativity. With Zapier, you're like an artist with a blank canvas. I don't know what we'd do without it.
Rishi Shah, CEO and Co-Founder
We don't just want to patch holes; we want to build scalable, future-proof systems. Zapier is helping us do that.
Allen Lai, Head of Customer Experience
We've been able to scale our operations while staying lean. Zapier lets us do more without needing more people.
Jacob Sirrs, Marketing Operations Specialist
Ready to automate your workflow securely?
Streamline processes, uncover new opportunities, and respond faster to change. Empower your team to get more done, without the manual work.