1.Detect new spreadsheet row
Integrate Google Sheets and spreadsheet tools to process the new row data so you can extract the email column.
Add booked not travelled contacts to remarketing list
Automatically monitor new spreadsheet rows for booked-not-travelled contacts across Google Sheets, Formatter by Zapier, and Google Ads. Create and update when tracking rows are added, qualifying status changes, or emails appearβso you can clean contacts, add them to customer lists, and log audit rows without manual list updates.
How this automation protects your recovery audience
When new booked-not-travelled rows appear in your spreadsheet, delayed processing can leave recovery campaigns underfilled. This automation cleans contact emails, adds them to Google Ads customer lists, and creates an audit rowβso your team can build retargeting audiences without manual list work.
Google Sheetsor swap with your favorite app
2.Clean and format email
Integrate Formatter by Zapier and data cleaning tools to transform the email to lowercase and trim whitespace for matching.
Formatter by Zapieror swap with your favorite app
3.Add email to customer list
Integrate Google Ads and audience list tools to add the cleaned email to a configured customer list for recovery campaigns.
Google Adsor swap with your favorite app
4.Write audit worksheet row
Integrate Google Sheets and reporting tools to create an audit row that records processed entries and results.
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: Google Sheets, Formatter by Zapier, Facebook Custom AudiencesSwap with your favorite apps.
Add 3-month exclusion contacts to paid ad audience
Your exclusion sheet rows can still be retargeted, wasting ad spend. Add them to your exclusion audience so campaign managers stop wasting budget before the next campaign.
- Apps: Shopify, Formatter by Zapier, Google AdsSwap with your favorite apps.
Add abandoned cart shoppers to remarketing audience list
Your abandoned cart shoppers aren't captured, letting near-complete orders go unrecovered. Add them to a remarketing list so your marketing team can retarget and recover sales fast.
- Apps: Klaviyo, Microsoft AdvertisingSwap with your favorite apps.
Add abandoned checkout contacts to remarketing audience list
Your abandoned checkout contacts aren't added to your ad audience, causing remarketing gaps and wasted ad spend. Add those contacts to a targeted audience so campaign managers can retarget within 24 hours.
- Apps: Webhooks by Zapier, Filter by Zapier, Formatter by Zapier, Google AdsSwap with your favorite apps.
Add abandoned registrants to ad audience and conversions
Your abandoned event signups miss ad attribution and drop out of remarketing lists. Add them to the ad list and register offline conversions so campaign managers can retarget within minutes.
- Apps: Intercom, Delay by Zapier, Filter by Zapier, Facebook Custom AudiencesSwap with your favorite apps.
Add abandoned trial starters to retargeting audience list
Your trial starters who don't finish signups miss ad retargeting, wasting acquisition spend. Add them to a retargeting audience and alert campaign owners so ads can run within minutes.
- Apps: Webhooks by Zapier, Formatter by Zapier, LinkedIn AdsSwap with your favorite apps.
Add account leads to paid audience for retargeting
Account-level leads from deals aren't reaching ad audiences, causing missed retargeting. Add them to your paid audience for immediate nurture and retargeting same day.
- Apps: Google Sheets, Filter by Zapier, Formatter by Zapier, Google AdsSwap with your favorite apps.
Add activated customer emails to your ad audiences
Your service activation rows in the sheet often aren't added to ad audiences, leaving newly active customers untargeted. This sends those emails to your audience so campaigns reach them same day.
- Apps: Pipedrive, Facebook Custom AudiencesSwap with your favorite apps.
Add active basic plan contacts to ad audience
Your CRM filter of active basic plan deals leaves eligible contacts out of ad audiences, causing missed retargeting. Add those contacts to your ad audience for timely retargeting before campaign sends.
- Apps: ActiveCampaign, Formatter by Zapier, Google AdsSwap with your favorite apps.
Add active client contacts to remarketing audience list
Your active client contacts aren't added to ad audiences, causing missed retargeting and wasted spend. Keep audiences current so campaign managers can reach new clients within minutes.
- Apps: HubSpot, Formatter by Zapier, LinkedIn AdsSwap with your favorite apps.
Add active customer contacts to paid remarketing audience
Your marketing list of active customers is added to paid audiences, causing overlap that wastes ad spend. Stop customer targeting so campaign managers preserve budget before launch.
- Apps: Klaviyo, Formatter by Zapier, Filter by Zapier, Microsoft AdvertisingSwap with your favorite apps.
Add active customers to paid search audience list
Your active customer list in email marketing isn't mirrored to paid search audiences, causing stale retargeting. Add contacts to ad audiences so campaign managers can retarget the same day.
- Apps: Webhooks by Zapier, Filter by Zapier, Facebook Custom AudiencesSwap with your favorite apps.
Add ad lead emails to custom audience list
Your social ad lead emails arrive via webhook inconsistently, leaving audiences incomplete. Add and deduplicate emails into your custom audience so campaign managers contact prospects same day.
- View all
Explore all retargeting audience management automations
Optimize retargeting audience management with automated audience updates, list routing, and suppression rules
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.