How to connect Google Sheets + Asana + QuickBooks Online
Zapier lets you send info between Google Sheets and Asana and QuickBooks Online automatically—no code required. With 7,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Google Sheets + Asana + QuickBooks Online
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Google Sheets, Asana, and QuickBooks Online. And don’t forget that you can add more apps and actions to create complex workflows.
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
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.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundWorkspaceRequired
ProjectRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Tag Created
Triggered when you create a new tag.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planWorkspaceRequired
ProjectRequired
SectionRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Workspace / OrganizationRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTask IDRequired
WorkspaceRequired
ProjectRequired
SectionRequired
Position in Section
Before/After Task ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Helptext
Workspace
Project
Tag
NameRequired
Task Fields
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Workspace / OrganizationRequired
ProjectRequired
Section NameRequired
Section to Insert After
Section to Insert Before
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
Name
Description
Is the description rich text?
Mark Task as complete?
Mark Task as liked?
Assignee
Followers
Tags
Custom Field Info
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
Team
NameRequired
NotesRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task IDRequired
Mark Task as complete?
Mark Task as liked?
Name
Assignee
Followers
Tags
Description
Is the description rich text?
Custom Field Info
WorkspaceRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Workspace
NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appWorkspaceRequired
ProjectRequired
Task NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appPremium User Help Text
WorkspaceRequired
Projects (Any)
Text
Is Subtask?
Is Completed?
Sort By
Sort Ascending?
Has Attachment?
Is Blocking?
Is Blocked?
Resource Subtype
Custom Fields Help Text
ActionThis is an event a Zap performs.SearchFind existing data in your appWorkspaceRequired
NameRequired
Team
NotesRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundTask IDRequired
WorkspaceRequired
Name
Description
Is the description rich text?
Mark Task as complete?
Mark Task as liked?
Assignee
Followers
Tags
Custom Field Info
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNew Bill
Triggers when a new bill is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Estimate
Triggers when you add a new estimate.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Bill Payment
Triggers when a new bill paid.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Deposit
Triggers when a there is a new deposit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Journal Entry
Triggers when a new journal entry is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Refund Receipt
Triggers when there is a new refund receipt.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New 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 planNew Sales Receipt
Triggers when a new sales receipt is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Credit Memo
Triggers when a credit memo is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Estimate
Triggers when an existed estimate is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Vendor
Triggers when a new vendor is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.VendorRequired
Terms
Transaction Date
Due Date
Bill Number
Department
Currency
Global Tax Calculation
Description
AmountRequired
Billable?
Customer
Class
AccountRequired
Tax Code
AP Account
Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Deposit To AccountRequired
Transaction Date
Private Note
Currency
Exchange Rate
Global Tax Calculation
Department
Transaction Source
Transaction Location Type
AmountRequired
AccountRequired
Payment Method
Description
Transaction Type
Entity
Class
Check Number
Tax Code
Tax Applicable On
Cash Back Account
Cash Back Amount
Cash Back Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Email
Send Later?
Billing Address
Credit Memo Date
Credit Memo Number
Auto Generate Credit Memo Number
Class
AmountRequired
Service Date
Product/Service
Description
Quantity
Rate
Tax
Class
Message Displayed On Credit Memo
Memo
Apply Tax After Discount?
Discount Value
Discount Percent
Sales Tax Rate
Shipping Cost
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Number
Line AmountRequired
Line Description
Line Item/Product
Line Item Quantity
Line Item Tax Code
Line Item Service Date
Rate
Tax Calculation
Transaction Date
Expiration Date
Ship Date
Message displayed on estimate
Billing Address
Billing Address City
Billing Address Country
Billing Address Postal Code
Billing Address State/Province
Shipping Address
Shipping Address City
Shipping Address Country
Shipping Address Postal Code
Shipping Address State/Province
Shipping amount
Bill Email
Send later
Discount Value
Discount Percent
Class
Sales Terms
Shipping Method
Tracking Number
Private Note
Transaction Status
Apply Tax After Discount
Print Status
Department
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TypeRequired
NameRequired
Description On Sales Forms
Sales Price/Rate
Description On Purchase Forms
Cost
SKU
Category
Is Taxable?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
CustomerRequired
Email
Cc
Bcc
Send Later?
Billing Address
Shipping Address
Terms
Invoice Date
Due Date
Ship Via
Shipping Date
Tracking Number
Invoice Number
Auto Generate Invoice Number
Service Date
Product/Service
Description
Quantity
Rate
Helptext Line Amount
Amount
Tax
Class
Add Bundle Item to invoice?
Message Displayed on Invoice
Message Displayed on Statement
Accept Payment Via Bank Transfer
Accept Payment Via Credit Card
Tax Code
Total Tax
Tax Calculation
Apply Tax After Discount?
Discount Value
Discount Percent
Shipping Tax
Shipping
Deposit
Deposit To Account
Class
Department
Location
Currency
Exchange Rate
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Total AmountRequired
Unapplied Amount
Transaction Date
Payment Method
Payment Reference Number
Deposit To Account
Line Amount
Line Linked Invoice
Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Refund FromRequired
Customer
Email
Billing Address
Refund Receipt Date
Refund Receipt Number
Transaction Class
Payment Method
Check Number
Print Later?
Product/ServiceRequired
AmountRequired
Service Date
Description
Quantity
Rate
Tax
Class
Message Displayed On Refund Receipt
Memo
Apply Tax After Discount?
Discount Value
Discount Percent
Sales Tax Rate
Shipping
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
InvoiceRequired
Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Time Activity TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Estimate IDRequired
Customer
Transaction Date
Shipping Date
Detail Type
Amount
Description
Item
Unit Price
Quantity
Discount Percent
Print Status
Email Status
Shipping Address Line 1
Shipping Address Line 2
Shipping Address City
Shipping Address State/Province
Shipping Address Postal Code
Shipping Address Country
Billing Address Line 1
Billing Address Line 2
Billing Address City
Billing Address State/Province
Billing Address Postal Code
Billing Address Country
Class
Sales Terms
Shipping Method
Tracking Number
Document Number
Accepted By
Accepted Date
Exchange Rate
Department
Apply Tax After Discount
Private Note
Customer Memo
Expiration Date
Transaction Status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ItemRequired
Name
Type
SKU
Sales Tax Included
Sales Tax Code
Class
Source
Purchase Tax Included
Description
Sub Item
Taxable
Purchase Description
Active
Purchase Cost
Unit Price
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Full NameRequired
Phone
Email
Website
Address Line 1
Address Line 2
Address City
Address State Code
Address Zip Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Account NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch FieldRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appInfo
ID
Name
ActionThis is an event a Zap performs.SearchFind existing data in your appIdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appInfo
Invoice Number
Invoice ID
Invoice Date
Due Date
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appInfo
ID
Display Name
Primary Email Address
Given NameRequired
Family NameRequired
Middle Name
Employee Phone Number
Birth Date
Billable Time
Active
Release Date
Cost Rate
Employee Mobile
Gender
Hired Date
Organization
Address Line 1
Address Line 2
Address Line 3
Address Line 4
Address Line 5
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundInfo
Product NameRequired
SKU
TypeRequired
Description On Sales Forms
Sales Price/Rate
Description On Purchase Forms
Cost
Category
Is Taxable?
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
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Text Bold
Text Italic
Text Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundWorkspaceRequired
ProjectRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.ProjectRequired
Task
Workspace
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planWorkspaceRequired
ProjectRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.WorkspaceRequired
ProjectRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.WorkspaceRequired
ProjectRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.WorkspaceRequired
ProjectRequired
Fields
Disclaimer
TriggerThis is the start of your ZapInstantThis event starts a Zap