BQE CORE + Google Sheets
Create Google Sheet rows for new BQE CORE expenses
When you have new expenses in your accounting tool, you may want the details organized in a spreadsheet. This integration helps by automatically creating a row in a Google Sheets spreadsheet with details from a new expense in BQE CORE. It's never been easier to organize your expense details.
When you have new expenses in your accounting tool, you may want the details organized in a spreadsheet. This integration helps by automatically creating a row in a Google Sheets spreadsheet with details from a new expense in BQE CORE. It's never been easier to organize your expense details.
- When this happens...
New Record CreatedTriggers when a new record is created.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Property NameRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Property NameRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Employee Updated - Terminated Status
Triggers when an Employee is terminated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Expense Entry Updated - Approved Status
Triggers when an expense entry is approved.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Property NameRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Property NameRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Select Custom FieldRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Select ModuleRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Select ModuleRequired
Work Flow Action
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Property NameRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Property NameRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Property NameRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.DateRequired
Account IDRequired
Payee
Number
Amount
Use Integration ID
Pay AmountRequired
Discount Account
Credit
Discount
PayeeRequired
Vendor Bill NumberRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Display NameRequired
Client Manager
Payment Terms
Main Expense Tax
Main Service Tax
Memo
Use Integration ID
Street 1
Street 2
City
State
Country
ZIP
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact NameRequired
Company
First Name
Last Name
Department
Title
PrimaryContact
Use Integration ID
Title
Street1
Street 2
City
State
Country
ZIP
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.AccountRequired
DateRequired
Use Integration ID
AccountRequired
AmountRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Expense CodeRequired
DescriptionRequired
Expense Sub Code
Item is Billable?
Item is Reimbursable?
Cost Rate
Memo
Use Integration ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DateRequired
Reference Number
Use Integration ID
AccountRequired
AmountRequired
Is Debit entry?
Class
Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DateRequired
DescriptionRequired
Master EntityRequired
Note CategoryRequired
Note StatusRequired
Use Integration ID
Created By
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project ID
Project CodeRequired
Project NameRequired
ClientRequired
Project ManagerRequired
Project TypeRequired
Main Service Tax
Main Expense Tax
Start Date
Project Due Date
Expense Account
Income Account
Currency
Memo
Project Originator
Use Integration ID
Street 1
Street 2
City
State
Country
ZIP
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Assigned ToRequired
DescriptionRequired
Start Date
End Date
Memo
Use Integration ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DateRequired
Bill NumberRequired
VendorRequired
Reference Number
Use Integration ID
Project
Item
Description
Units/Hrs
Cost Rate
Bill Rate
Markup
Purchase Tax
Is Billable?
Memo
Item Type
AccountID
Expense Amount
Class
Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ID
Name
First Name
Last Name
Bill Rate
Cost Rate
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
Project ID
Project Name
Contract Amount
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
Start Date
End Date
% Complete
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ValueRequired
DateRequired
Account IDRequired
Payee
Number
Amount
Use Integration ID
Pay AmountRequired
Discount Account
Credit
Discount
PayeeRequired
Vendor Bill NumberRequired
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 ValueRequired
DateRequired
Account IDRequired
Number
Use Integration ID
PayeeRequired
Line Item
Item Type
Project
Rate
Units
AccountID
Expense Amount
Class
Memo
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 ValueRequired
Account NumberRequired
Account NameRequired
Description
Is Active?
Use Integration ID
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 ValueRequired
AccountRequired
DateRequired
Use Integration ID
AccountRequired
AmountRequired
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 ValueRequired
Expense CodeRequired
DescriptionRequired
Expense Sub Code
Item is Billable?
Item is Reimbursable?
Cost Rate
Memo
Use Integration ID
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 ValueRequired
DateRequired
Invoice NumberRequired
Invoice AmountRequired
ProjectRequired
Client
Due Date
Is Draft?
Main Service Tax
Main Expense Tax
Late Fee
Use Integration ID
Item
DescriptionRequired
UnitsRequired
RateRequired
Amount
Is Expense?
Tax%
Charge Amount
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 ValueRequired
DateRequired
DescriptionRequired
Master EntityRequired
Note CategoryRequired
Note StatusRequired
Use Integration ID
Created By
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 ValueRequired
DateRequired
ResourceRequired
ProjectRequired
ActivityRequired
DescriptionRequired
HoursRequired
Client Hours
Is Billable?
Cost Rate
Bill Rate
Compensation Time
Extra
Tax1
Tax2
Tax3
Memo
Use Integration ID
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 ValueRequired
First NameRequired
Last NameRequired
Display NameRequired
Company Name
1099 Compliant
Memo
Use Integration ID
Title
Street 1
Street 2
City
State
Country
ZIP
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier 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.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
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.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
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
Property NameRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Property NameRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Select ModuleRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Select Custom FieldRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Select ModuleRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Project Updated – Completed Status
Triggers when a Project is marked as completed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Property NameRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Time Entry Updated - Approved Status
Triggers when a Time entry is approved.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Select Custom FieldRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.To-Do Updated - Completed Status
Triggers when a Todo is marked completed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Property NameRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Activity CodeRequired
Activity DescriptionRequired
Activity Sub Code
Item is Billable?
Cost Rate
Bill Rate
Status
Tax1
Tax2
Memo
Use Integration ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DateRequired
Account IDRequired
Number
Use Integration ID
PayeeRequired
Line Item
Item Type
Project
Rate
Units
AccountID
Expense Amount
Class
Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Account NumberRequired
Account NameRequired
Description
Is Active?
Use Integration ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DateRequired
Account IDRequired
AmountRequired
PayeeRequired
Use Integration ID
Item ID
Type
Project ID
Rate
Units
AccountID
Expense Amount
Class
Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First NameRequired
Last NameRequired
Display NameRequired
Cost RateRequired
Bill RateRequired
Gender
Memo
Use Integration ID
Title
Street 1
Street 2
City
State
Country
ZIP
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DateRequired
ResourceRequired
ProjectRequired
ExpenseRequired
DescriptionRequired
Units
Is Billable?
Cost Rate
Extra
Markup
Reimbursable
Tax1
Tax2
Tax3
Purchase Tax
Memo
Charge Amount
Use Integration ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DateRequired
Invoice NumberRequired
Invoice AmountRequired
ProjectRequired
Client
Due Date
Is Draft?
Main Service Tax
Main Expense Tax
Late Fee
Use Integration ID
Item
DescriptionRequired
UnitsRequired
RateRequired
Amount
Is Expense?
Tax%
Charge Amount
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DateRequired
ClientRequired
AmountRequired
Project
Memo
Reference Number
Retainer Payment
Use Integration ID
Invoice IDRequired
Line AmountRequired
Invoice detail
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DateRequired
ResourceRequired
ProjectRequired
ActivityRequired
DescriptionRequired
HoursRequired
Client Hours
Is Billable?
Cost Rate
Bill Rate
Compensation Time
Extra
Tax1
Tax2
Tax3
Memo
Use Integration ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First NameRequired
Last NameRequired
Display NameRequired
Company Name
1099 Compliant
Memo
Use Integration ID
Title
Street 1
Street 2
City
State
Country
ZIP
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ID
Name
Company Name
Client Manager
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ID
ProjectRequired
ExpenseRequired
DescriptionRequired
ResourceRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ID
Resource
Date
Project
Activity
Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ID
Vendor Name
First Name
Last Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ValueRequired
Activity CodeRequired
Activity DescriptionRequired
Activity Sub Code
Item is Billable?
Cost Rate
Bill Rate
Status
Tax1
Tax2
Memo
Use Integration ID
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 ValueRequired
DateRequired
ClientRequired
AmountRequired
Project
Memo
Reference Number
Retainer Payment
Use Integration ID
Invoice IDRequired
Line AmountRequired
Invoice detail
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 ValueRequired
Display NameRequired
Client Manager
Payment Terms
Main Expense Tax
Main Service Tax
Memo
Use Integration ID
Street 1
Street 2
City
State
Country
ZIP
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 ValueRequired
DateRequired
Account IDRequired
AmountRequired
PayeeRequired
Use Integration ID
Item ID
Type
Project ID
Rate
Units
AccountID
Expense Amount
Class
Memo
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 ValueRequired
First NameRequired
Last NameRequired
Display NameRequired
Cost RateRequired
Bill RateRequired
Gender
Memo
Use Integration ID
Title
Street 1
Street 2
City
State
Country
ZIP
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 ValueRequired
DateRequired
ResourceRequired
ProjectRequired
ExpenseRequired
DescriptionRequired
Units
Is Billable?
Cost Rate
Extra
Markup
Reimbursable
Tax1
Tax2
Tax3
Purchase Tax
Memo
Charge Amount
Use Integration ID
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 ValueRequired
DateRequired
Reference Number
Use Integration ID
AccountRequired
AmountRequired
Is Debit entry?
Class
Memo
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 ValueRequired
Project ID
Project CodeRequired
Project NameRequired
ClientRequired
Project ManagerRequired
Project TypeRequired
Main Service Tax
Main Expense Tax
Start Date
Project Due Date
Expense Account
Income Account
Currency
Memo
Project Originator
Use Integration ID
Street 1
Street 2
City
State
Country
ZIP
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 ValueRequired
Assigned ToRequired
DescriptionRequired
Start Date
End Date
Memo
Use Integration ID
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 ValueRequired
DateRequired
Bill NumberRequired
VendorRequired
Reference Number
Use Integration ID
Project
Item
Description
Units/Hrs
Cost Rate
Bill Rate
Markup
Purchase Tax
Is Billable?
Memo
Item Type
AccountID
Expense Amount
Class
Memo
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo 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 ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
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
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Row count
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
Row count
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 BQE CORE
Related categories
