Add new Pipedrive deals to Google Sheets rows
by
About this Applet
Automatically create a new QuickBooks Online customer whenever a new deal is added in Pipedrive. This ensures your sales and accounting data stay synchronized without manual entry. For example, when a sales rep logs a new opportunity, the corresponding customer profile is instantly created in QuickBooks Online for accurate invoicing and tracking.
If
Trigger ingredients
DealTitle
DealId
OrgName
OrgId
StageName
StageId
Status
FormattedValue
Value
Currency
ExpectedCloseDate
PersonName
PersonEmail
PersonPhone
PersonId
OwnerName
OwnerId
CreatedAt
Then
Action fields
Display Name
Company Name
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...
-
11
-
-
Add new QuickBooks Online invoices to Google Sheetsby
11
-
-
Add new Pipedrive activities to Todoist as tasksby
10
-
Related services
-
-
App store rating
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 hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
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 hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
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 hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
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 hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
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 hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
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 hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
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 hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
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 hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
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 hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
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 hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
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 hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
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 hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when a new payment is created.
Build an automation in seconds!
If
Select a trigger the automation will use
New activity
New customer
New deal
New deal matching filter
New invoice
New payment
Then
Select an action the automation will perform
Create activity
Create customer
Create deal
Create invoice
Create sales receipt
You can add delays, queries, and more actions in the chat.
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.
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.