1.Triggers on new spreadsheet rows
Integrate Google Sheets and spreadsheet monitoring tools to watch for new rows and trigger CRM lead intake updates.
Create CRM lead and email owners from new sheet rows
Automatically monitor new spreadsheet rows across Google Sheets to feed lead creation workflows in Pipedrive. Get instant routing outcomes when owner selection runs, person records match, and deals get createdβso you can notify owners, build CRM context, and avoid manual follow-up.
How this automation assigns owners to new CRM leads
When new intake rows appear, delays can leave leads unassigned and follow-ups unsent. This automation builds CRM people, creates deals, and sends owner emailsβso your team can respond at the peak of intent.
Google Sheetsor swap with your favorite app
2.Selects an owner from a pool
Integrate Formatter by Zapier and routing rules templates to pick an owner id and output owner assignment for CRM creation.
Formatter by Zapieror swap with your favorite app
3.Finds or creates the person
Integrate Pipedrive and CRM contact matching tools to search by email and create person records when no match exists.
Pipedriveor swap with your favorite app
4.Creates a linked deal
Integrate Pipedrive and pipeline data to create deals, link the person, and set owner id from the assignment output.
5.Sends the owner notification email
Integrate Gmail and email templating tools to send notification emails with row context and a link back to the source row.
Gmailor swap with your favorite app
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, Filter by Zapier, LeadConnectorSwap with your favorite apps.
Add abandoned call contacts to follow-up list for outreach
Your abandoned-call spreadsheet rows leave prospects untracked and delay outreach for campaign coordinators. Get contacts added to your follow-up list so coordinators can engage the same day.
- Apps: immedio Box, Google SheetsSwap with your favorite apps.
Add abandoned demo leads to follow-up tracking sheet
Abandoned demo leads arrive without owner or context, leaving campaign coordinators unable to prioritize outreach. Leads are logged into a follow-up sheet so coordinators can assign outreach same day.
- Apps: ClickFunnels Classic, Delay by Zapier, Filter by Zapier, LeadConnectorSwap with your favorite apps.
Add abandoned funnel contacts to targeted nurture list
Your sales page abandonments arrive without buyer info, leaving ad spend wasted and reps unsure which leads to prioritize. Capture and tag those contacts for prioritized nurture and same-day outreach.
- Apps: HeyReach, Filter by Zapier, Breakcold, Clay, SlackSwap with your favorite apps.
Add accepted connections to pre-sales lists with alerts
Accepted outreach connections arrive un-enriched and unrouted, leaving campaign managers without follow-up context. Leads are enriched and routed to pre-sales lists with a team alert same day.
- Apps: Tally, Zapier Tables, Filter by Zapier, GmailSwap with your favorite apps.
Add accepted form leads and notify assigned broker
Your accepted form responses become untracked leads or duplicates when assignment isn't recorded. It assigns and logs accepted leads, then emails the assigned broker contact details within minutes.
- Apps: Webhooks by Zapier, Google Sheets, Filter by Zapier, MyphonerSwap with your favorite apps.
Add accepted registrants as calling leads to lists
Accepted requests with phone details arrive unvalidated, causing missed callbacks and extra dialing time. Add validated contacts to calling lists so campaign managers can start outreach same day.
- Apps: Salesforce, Filter by Zapier, Webhooks by ZapierSwap with your favorite apps.
Add acquisition record to marketing list and post webhook
Your acquisition qualification records often lack attribution, leaving campaign managers unsure and delaying outreach. It sends attributed lead data to marketing intake so teams can act same day.
- Apps: Facebook Lead Ads, Formatter by Zapier, Sub-Zap by ZapierSwap with your favorite apps.
Add ad form contacts to CRM intake queue
Your ad lead form submissions often miss context and contact details, so reps canβt prioritize. Capture contacts into a centralized intake queue for prompt qualification within minutes.
- Apps: Facebook Lead Ads, Formatter by Zapier, Sub-Zap by Zapier, SlackSwap with your favorite apps.
Add ad form contacts to franchisee lead queue
Your ad form leads arrive with inconsistent contact data, leaving franchise account managers unable to start outreach. Leads are normalized and routed for same-day follow-up.
- Apps: Facebook Lead Ads, Sub-Zap by ZapierSwap with your favorite apps.
Add ad form contacts to marketing queue for follow-up
Your ad-form submissions arrive untracked, causing delayed qualification and missed outreach windows. Get standardized, routed lead records to campaign managers and SDRs for same-day outreach.
- Apps: Jotform, LeadConnectorSwap with your favorite apps.
Add ad form contacts to nurture list instantly
Your ad form signups come with mixed consent and inconsistent tags, leaving campaign managers unsure which contacts to email. Add consenting contacts to your nurture list and tag their consent path so outreach starts same day.
- Apps: Facebook Lead Ads, Filter by Zapier, Formatter by Zapier, Webhooks by ZapierSwap with your favorite apps.
Add ad form enrollments to lead intake list
Your ad form enrollments arrive untriaged, causing missed confirmations and scheduling delays for training batches. They get routed to intake so coordinators can confirm attendees same day.
- View all
Explore all lead routing automations
Accelerate lead response with automated assignment rules, owner alerts, and CRM updates
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.