Add new Pipedrive deals to Google Sheets rows
How this automation works
Create a new customer for each new deal
If
New deal
Trigger ingredients
DealTitle
DealId
OrgName
OrgId
StageName
StageId
Status
FormattedValue
Value
Currency
ExpectedCloseDate
PersonName
PersonEmail
PersonPhone
PersonId
OwnerName
OwnerId
CreatedAt
Then
Create customer
Action fields
display_name
company
customer_type
email
phone
address_line_1
address_line_2
city
state
zip
website
notes
fax
bill_with_parent
job_parent_customer
Services used in this Applet
You might also like...
-
10
-
-
When I create an invoice in Quickbooks, add invoice information to Google Sheets
6
-
-
Add new Pipedrive activities to Todoist as tasks
5
-
Related services
Create your own QuickBooks Online and Pipedrive workflow
Create custom workflows effortlessly by selecting triggers, queries, and actions. With IFTTT, it's simple: “If this” trigger happens, “then that” action follows. Streamline tasks and save time with automated workflows that work for you.
12 triggers, queries, and actions
New activity
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when there is a new activity.
New customer
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when there is a new customer.
New deal
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when there is a new deal.
New deal matching filter
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when there is a new deal which matches a Pipedrive filter.
New invoice
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new invoice is created.
New payment
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new payment is created.
Find customer
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns Quickbooks Online customers.
Create activity
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create an activity.
Create customer
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a customer.
Create deal
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a new deal.
Create invoice
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a Quickbooks Online invoice.
Create sales receipt
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a sales receipt.
Create activity
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create an activity.
Create customer
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a customer.
Create deal
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a new deal.
Create invoice
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a Quickbooks Online invoice.
Create sales receipt
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a sales receipt.
Find customer
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns Quickbooks Online customers.
New activity
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when there is a new activity.
New customer
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when there is a new customer.
New deal
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when there is a new deal.
New deal matching filter
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when there is a new deal which matches a Pipedrive filter.
New invoice
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new invoice is created.
New payment
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new payment is created.
Build an automation in seconds!
If
Select a trigger the automation will use
Then
Select an action the automation will perform
You can add delays, queries, and more actions in the next step!
More on QuickBooks Online and Pipedrive
About QuickBooks Online
Take control of your business by saving time on bookkeeping and paperwork with QuickBooks Online.
QuickBooks Online is designed to help you manage your business finances with ease. Grow your business effortlessly with our all-in-one online business software.
Take control of your business by saving time on bookkeeping and paperwork with QuickBooks Online.
QuickBooks Online is designed to help you manage your business finances with ease. Grow your business effortlessly with our all-in-one online business software.
About Pipedrive
Pipedrive is the easy-to-use, #1 user-rated Sales CRM and pipeline management software that enables businesses to plan their sales activities and close deals in less time. Do more to grow your business with Pipedrive and IFTTT.
Pipedrive is the easy-to-use, #1 user-rated Sales CRM and pipeline management software that enables businesses to plan their sales activities and close deals in less time. Do more to grow your business with Pipedrive and IFTTT.