Google Sheets + Pipedrive
New row in Google Sheet creates Person and Deal in Pipedrive
Keep your Pipedrive customers and deals up to date by automatically creating them whenever a new row is added to a Google Sheet. Note: Your Google Sheet will need to include the information Pipedrive requires to create a person or a deal.
Keep your Pipedrive customers and deals up to date by automatically creating them whenever a new row is added to a Google Sheet. Note: Your Google Sheet will need to include the information Pipedrive requires to create a person or a deal.
- When this happens...
TriggerScheduledZapier checks for new data every 15 min on the Free plan - automatically do this!
Create DealCreates a new deal.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
New Activity
Triggers when a new activity is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Deal
Triggers when a new deal is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Lead
Triggers when a lead is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Organization
Triggers when a new organization is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Person
Triggers when a new person is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Project
Triggers when a new project is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planFilter By
Field to Watch for Changes On
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.DealRequired
ProductRequired
PriceRequired
QuantityRequired
Discount
Discount Type
Comments
Enable product
Tax Method
Tax Percentage
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Creation Date
Status
Stage
Stage Warning
Pipeline
Owner
Organization
Person
Probability
Expected Close Date
Value
Currency
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FollowerRequired
What to add follower to?Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ContentRequired
Deal
Pin note on specified deal?
Person
Pin note on specified person?
Organization
Pin note on specified organization?
Lead
Pin note on specified lead?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Owner
Organization
Email
Phone
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Project Template
Project BoardRequired
Project PhaseRequired
Description
Status
Owner
Start Date
End Date
Deals
Organization
Person
Labels
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ActivityRequired
Subject
Organization
Assign To
Person
Deal
Lead
Is Done?
Type
Use combined date and time field?
Duration
Free/Busy
Note
Public Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LeadRequired
Title
Owner
Organization
Person
Label
Expected Close Date
Lead Value
Lead Value Currency
Source Channel
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PersonRequired
Name
Owner
Organization
Email
Phone
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TaskRequired
Title
Project
Description
Done
Due Date
Assignee
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SubjectRequired
Search Type
Assigned To
Type
Filter
Status
ActionThis is an event a Zap performs.SearchFind existing data in your appField to Search By
Term to search forRequired
Search for an Exact Match?
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch for an Exact Match?
ActionThis is an event a Zap performs.SearchFind existing data in your appNote IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch for an Exact Match?
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch termRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appField to Search ByRequired
Search TermRequired
Exact Match
ActionThis is an event a Zap performs.SearchFind existing data in your appField to search byRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch for an Exact Match?
TitleRequired
Creation Date
Status
Stage
Stage Warning
Pipeline
Owner
Organization
Person
Probability
Expected Close Date
Value
Currency
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch for an Exact Match?
TitleRequired
Person
Organization
Owner
Note
Pin Note to Lead?
Label
Expected Close Date
Lead Value
Lead Value Currency
Source Channel
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch for exact match
NameRequired
Owner
Organization
Email
Phone
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundField to Search ByRequired
Search TermRequired
Exact Match
TitleRequired
Project Template
Project BoardRequired
Project PhaseRequired
Description
Status
Owner
Start Date
End Date
Deals
Organization
Person
Labels
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New Note
Triggers when a new note is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Organization
Triggers when an existing organization is updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planPersonRequired
LabelRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SubjectRequired
Organization
Assign To
Person
Deal
Lead
Mark as done
Type
Use combined date and time field?
Duration
Free or Busy
Note
Public description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
File NameRequired
Deal
Person
Organization
Product
Activity ID
Note ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Person
Organization
Owner
Note
Pin Note to Lead?
Label
Expected Close Date
Lead Value
Lead Value Currency
Source Channel
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Owner
Address
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Code
Unit
Tax percentage
Is active?
Owner
Currency
Price
Cost
Overhead Cost
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
ProjectRequired
Description
Done
Due Date
Assignee
Parent Task
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DealRequired
Title
Status
Stage
Owner
Organization
Person
Value
Currency
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Owner
Name
Address
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ProjectRequired
Title
Project Board
Project Phase
Description
Status
Owner
Start Date
End Date
Deals
Organization
Person
Labels
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search for an Exact Match?
ActionThis is an event a Zap performs.SearchFind existing data in your appPerson
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch for an Exact Match?
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch for exact match
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Product(s)
Finds a product or products by name, ID, or product code (with line item support).
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch TermRequired
Exact Match?
Assignee
Project
Status
ActionThis is an event a Zap performs.SearchFind existing data in your appSubjectRequired
Search Type
Assign To
Type
Filter
Mark as done
Organization
Person
Deal
Lead
Use combined date and time field?
Duration
Free or Busy
Note
Public description
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundField to Search By
Term to search forRequired
Search for an Exact Match?
TitleRequired
Creation Date
Status
Stage
Stage Warning
Pipeline
Owner
Organization
Person
Probability
Expected Close Date
Value
Currency
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch for an Exact Match?
NameRequired
Owner
Address
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch termRequired
NameRequired
Code
Unit
Tax percentage
Is active?
Owner
Currency
Price
Cost
Overhead Cost
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
About Pipedrive
Pipedrive is sales pipeline and CRM software for deal makers. Get super-organized. Close deals in less time. iOS and Android apps let you take your pipeline with you anywhere.
Related categories
Related Zap Templates
- Create Pipedrive deals from new Facebook Lead Ads leads
- Add new Unbounce form submissions to Pipedrive as deals
- Add new Pipedrive deals to Google Sheets rows
- Send funnel events to Facebook Conversions from Pipedrive
- Send offline conversions in Google Ads when new deals match filters in Pipedrive
- Add new Pipedrive people to Mailchimp as subscribers
- Add new Pipedrive people to Google Ads Custom Lists
- Send Offline Conversion to Google Ads for Updated Deal Stage in Pipedrive
- Create persons on Pipedrive with new Perspective leads information
- Create Pipedrive deals from new invitees in Calendly
- Create Pipedrive Persons from new TikTok Lead Generations leads
- Send Slack messages for new Pipedrive deals
- Send messages to chats in TimelinesAI with new updates to deal stages in Pipedrive
- Create new Pipedrive deals from new Facebook Lead Ads leads
- Add new Pipedrive contacts as Brevo subscribers
- Record new Calendly events as contact activities in Pipedrive
- Add new Webflow form submissions as Pipedrive leads
- Add new leads from Facebook Lead Ads to Pipedrive
- Create Pipedrive deals from new Gravity Forms submissions
- Add new Typeform entries to Pipedrive as deals
- Create Pipedrive deal for new Calendly event invitees
- Add new Purchased Barks to Pipedrive
- Create Pipedrive deals with new incoming emails
- Create offline conversions in Google Ads with updated Pipedrive deals
- Create Pipedrive persons for new Apollo contacts
- Add offline conversions in Google Ads for new Pipedrive deals
- Create Pipedrive deals from new Squarespace form submissions
- Add new Pipedrive activities to Todoist as tasks
- Create Pipedrive deals for new emails on Gmail
- Add new Pipedrive deals to Excel spreadsheets
- Add new Pipedrive deals reaching certain stages to Google Sheets rows
- Create Pipedrive leads from new inbound emails in Email by Zapier
- Add or update Pipedrive people for new Calendly invitees
- Share new updates from Pipedrive as funnel events to Facebook Conversions
- Send emails in Gmail when new deals are added to a stage on Pipedrive
- Add new Pipedrive contacts to Google Contacts
- Save new rows in Google Sheets as deals in Pipedrive
- Add new companies from Crunchbase saved search to Pipedrive
- Post messages to Slack channels when new deals are added to a stage on Pipedrive
- Add new Leadpages form submissions as Pipedrive deals
- Create Pipedrive leads from new form submissions in Leadpages
- Update Pipedrive deals when new PandaDoc documents are completed
- Create Trello cards when new Pipedrive deals are added to a stage
- Create Xero invoices when new Pipedrive deals reach certain stages
- Send Offline Conversion to Google Ads for New Deal in Pipedrive
- Add contacts to a Google Ads customer list for new deals on Pipedrive
- Add new Calendly invitees as Pipedrive leads
- Create Wave customers from new Pipedrive deals
- Add items to monday.com for new deals in a pipeline stage on Pipedrive
- Add new Pipedrive activities to Asana as tasks
- Create Google Ads conversions from new Pipedrive leads
- Send offline conversions in Google Ads when new deals match filters in Pipedrive
- Update opportunity statuses in Ramsey Pro Portal for newly updated deal stages in Pipedrive
- Create Pipedrive deals from new Quotient quotes
- Send Offline Conversion to Google Ads for New Lead in Pipedrive
- Update opportunity statuses in Ramsey Pro Portal for new updated deals in Pipedrive
- Add new Pipedrive persons to Mailchimp
- Send emails via Gmail when new Pipedrive deals reach certain stages
- Add new Pipedrive activities to Pipedrive deals reaching certain stages
- Create Pipedrive people for new invitee created events in Calendly
- Create Pipedrive leads from new form submissions in Squarespace
- Create deals on Pipedrive for new submissions on Ninja Forms
- Create tasks in Sunsama for new activities in Pipedrive
- Create Deals in Pipedrive When New Events Occur in Instantly
- Add new GetResponse contacts as Pipedrive leads
- Create new Pipedrive persons from new Wix forms
- Create Pipedrive activities every month
- Relay offline conversions in Google Ads with new updates to Pipedrive deal stages
- Create Pipedrive deals with new emails parsed by Zapier Email Parser
- Create deals on Pipedrive for new calls on CallRail
- Create Pipedrive deals from new Google Forms responses
- Add Pipedrive leads from new Google Sheets rows
- Create deals in Pipedrive with newly-caught webhooks
- Create Pipedrive deals from new WooCommerce orders
- Create people on Pipedrive for new LinkedIn Lead Gen Form leads
- Add products and deals to Pipedrive from new Leadpages form submissions
- Add new Bind ERP prospects to Pipedrive as people
- Find or create Pipedrive organizations when new companies are added to Crunchbase lists
- Add new Mailchimp subscribers to Pipedrive as deals
- Add new Pipedrive leads as Klaviyo subscribers
- Create organizations in Pipedrive from new Apollo accounts
- Add Contact to Customer List With Email in Google Ads for Deal Matching Filter in Pipedrive
- Add new Facebook Lead Ads leads as Pipedrive leads
- Create Pipedrive workflows from new Gravity Forms submissions
- Add new Pipedrive leads to Google Ads customer list as contacts with email
- Create Pipedrive deals from new emails parsed by mailparser.io
- Add new form submissions in Unbounce as Pipedrive leads
- Add new Wufoo entries to Pipedrive as deals
- Add deals to Pipedrive from new Paperform submissions
- Add new Mailchimp subscribers to Pipedrive as people
- Create Pipefy cards for new Pipedrive deals added to stages
- Create Pipeline activities for invitee created events in Calendly
- Create People contacts in Pipedrive from new Squarespace form submissions
- Add new Gravity Forms submissions to Pipedrive
- Add new respond.io contacts as Pipedrive people
- Add new deals in Pipedrive when a tawk.to chat ends
- Create Pipedrive deals from new form entries in WPForms
- Create ClickUp tasks from new Pipedrive leads
- Create Pipedrive deals from newly-updated rows on Google Sheets
- Create Pipedrive people when new Instantly events occur
Related Zap Templates
- Create Pipedrive deals from new Facebook Lead Ads leads
- Send funnel events to Facebook Conversions from Pipedrive
- Add new Pipedrive people to Google Ads Custom Lists
- Create Pipedrive deals from new invitees in Calendly
- Send messages to chats in TimelinesAI with new updates to deal stages in Pipedrive
- Record new Calendly events as contact activities in Pipedrive
- Create Pipedrive deals from new Gravity Forms submissions
- Add new Purchased Barks to Pipedrive
- Create Pipedrive persons for new Apollo contacts
- Add new Pipedrive activities to Todoist as tasks
- Add new Pipedrive deals reaching certain stages to Google Sheets rows
- Share new updates from Pipedrive as funnel events to Facebook Conversions
- Save new rows in Google Sheets as deals in Pipedrive
- Add new Leadpages form submissions as Pipedrive deals
- Create Trello cards when new Pipedrive deals are added to a stage
- Add contacts to a Google Ads customer list for new deals on Pipedrive
- Add items to monday.com for new deals in a pipeline stage on Pipedrive
- Send offline conversions in Google Ads when new deals match filters in Pipedrive
- Send Offline Conversion to Google Ads for New Lead in Pipedrive
- Send emails via Gmail when new Pipedrive deals reach certain stages
- Create Pipedrive leads from new form submissions in Squarespace
- Create Deals in Pipedrive When New Events Occur in Instantly
- Create Pipedrive activities every month
- Create deals on Pipedrive for new calls on CallRail
- Create deals in Pipedrive with newly-caught webhooks
- Add products and deals to Pipedrive from new Leadpages form submissions
- Add new Mailchimp subscribers to Pipedrive as deals
- Add Contact to Customer List With Email in Google Ads for Deal Matching Filter in Pipedrive
- Add new Pipedrive leads to Google Ads customer list as contacts with email
- Add new Wufoo entries to Pipedrive as deals
- Create Pipefy cards for new Pipedrive deals added to stages
- Add new Gravity Forms submissions to Pipedrive
- Create Pipedrive deals from new form entries in WPForms
- Create Pipedrive people when new Instantly events occur
- Add new Unbounce form submissions to Pipedrive as deals
- Send offline conversions in Google Ads when new deals match filters in Pipedrive
- Send Offline Conversion to Google Ads for Updated Deal Stage in Pipedrive
- Create Pipedrive Persons from new TikTok Lead Generations leads
- Create new Pipedrive deals from new Facebook Lead Ads leads
- Add new Webflow form submissions as Pipedrive leads
- Add new Typeform entries to Pipedrive as deals
- Create Pipedrive deals with new incoming emails
- Add offline conversions in Google Ads for new Pipedrive deals
- Create Pipedrive deals for new emails on Gmail
- Create Pipedrive leads from new inbound emails in Email by Zapier
- Send emails in Gmail when new deals are added to a stage on Pipedrive
- Add new companies from Crunchbase saved search to Pipedrive
- Create Pipedrive leads from new form submissions in Leadpages
- Create Xero invoices when new Pipedrive deals reach certain stages
- Add new Calendly invitees as Pipedrive leads
- Add new Pipedrive activities to Asana as tasks
- Update opportunity statuses in Ramsey Pro Portal for newly updated deal stages in Pipedrive
- Update opportunity statuses in Ramsey Pro Portal for new updated deals in Pipedrive
- Add new Pipedrive activities to Pipedrive deals reaching certain stages
- Create deals on Pipedrive for new submissions on Ninja Forms
- Add new GetResponse contacts as Pipedrive leads
- Relay offline conversions in Google Ads with new updates to Pipedrive deal stages
- Create Pipedrive deals from new Google Forms responses
- Create Pipedrive deals from new WooCommerce orders
- Add new Bind ERP prospects to Pipedrive as people
- Add new Pipedrive leads as Klaviyo subscribers
- Add new Facebook Lead Ads leads as Pipedrive leads
- Create Pipedrive deals from new emails parsed by mailparser.io
- Add deals to Pipedrive from new Paperform submissions
- Create Pipeline activities for invitee created events in Calendly
- Add new respond.io contacts as Pipedrive people
- Create ClickUp tasks from new Pipedrive leads
- Add new Pipedrive deals to Google Sheets rows
- Add new Pipedrive people to Mailchimp as subscribers
- Create persons on Pipedrive with new Perspective leads information
- Send Slack messages for new Pipedrive deals
- Add new Pipedrive contacts as Brevo subscribers
- Add new leads from Facebook Lead Ads to Pipedrive
- Create Pipedrive deal for new Calendly event invitees
- Create offline conversions in Google Ads with updated Pipedrive deals
- Create Pipedrive deals from new Squarespace form submissions
- Add new Pipedrive deals to Excel spreadsheets
- Add or update Pipedrive people for new Calendly invitees
- Add new Pipedrive contacts to Google Contacts
- Post messages to Slack channels when new deals are added to a stage on Pipedrive
- Update Pipedrive deals when new PandaDoc documents are completed
- Send Offline Conversion to Google Ads for New Deal in Pipedrive
- Create Wave customers from new Pipedrive deals
- Create Google Ads conversions from new Pipedrive leads
- Create Pipedrive deals from new Quotient quotes
- Add new Pipedrive persons to Mailchimp
- Create Pipedrive people for new invitee created events in Calendly
- Create tasks in Sunsama for new activities in Pipedrive
- Create new Pipedrive persons from new Wix forms
- Create Pipedrive deals with new emails parsed by Zapier Email Parser
- Add Pipedrive leads from new Google Sheets rows
- Create people on Pipedrive for new LinkedIn Lead Gen Form leads
- Find or create Pipedrive organizations when new companies are added to Crunchbase lists
- Create organizations in Pipedrive from new Apollo accounts
- Create Pipedrive workflows from new Gravity Forms submissions
- Add new form submissions in Unbounce as Pipedrive leads
- Add new Mailchimp subscribers to Pipedrive as people
- Create People contacts in Pipedrive from new Squarespace form submissions
- Add new deals in Pipedrive when a tawk.to chat ends
- Create Pipedrive deals from newly-updated rows on Google Sheets