BQE CORE + Google Sheets

BQE CORE + Google Sheets integrations

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 this happens...
New Record CreatedTriggers when a new record is created.
TriggerInstant
automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with BQE CORE and Google Sheets

Discover other triggers and actions you can use with BQE CORE and Google Sheets

- Property Name
  Required
Trigger
Instant
Try It
- Property Name
  Required
Trigger
Instant
Try It
Employee Updated - Terminated Status
Triggers when an Employee is terminated.
Trigger
Instant
Try It
Expense Entry Updated - Approved Status
Triggers when an expense entry is approved.
Trigger
Instant
Try It
- Property Name
  Required
Trigger
Instant
Try It

- Property Name
  Required
Trigger
Instant
Try It
- Select Custom Field
  Required
Trigger
Instant
Try It

- Select Module
  Required
Trigger
Instant
Try It
- Select Module
  Required
- Work Flow Action
Trigger
Instant
Try It
- Property Name
  Required
Trigger
Instant
Try It
- Property Name
  Required
Trigger
Instant
Try It
- Property Name
  Required
Trigger
Instant
Try It
- Date
  Required
- Account ID
  Required
- Payee
- Number
- Amount
- Use Integration ID
- Pay Amount
  Required
- Discount Account
- Credit
- Discount
- Payee
  Required
- Vendor Bill Number
  Required
Action
Write
- Display Name
  Required
- Client Manager
- Payment Terms
- Main Expense Tax
- Main Service Tax
- Memo
- Use Integration ID
- Street 1
- Street 2
- City
- State
- Country
- ZIP
Action
Write
- Contact Name
  Required
- Company
- First Name
- Last Name
- Department
- Title
- PrimaryContact
- Use Integration ID
- Title
- Street1
- Street 2
- City
- State
- Country
- ZIP
Action
Write
- Account
  Required
- Date
  Required
- Use Integration ID
- Account
  Required
- Amount
  Required
Action
Write
- Expense Code
  Required
- Description
  Required
- Expense Sub Code
- Item is Billable?
- Item is Reimbursable?
- Cost Rate
- Memo
- Use Integration ID
Action
Write
- Date
  Required
- Reference Number
- Use Integration ID
- Account
  Required
- Amount
  Required
- Is Debit entry?
- Class
- Memo
Action
Write
- Date
  Required
- Description
  Required
- Master Entity
  Required
- Note Category
  Required
- Note Status
  Required
- Use Integration ID
- Created By
Action
Write
- Project ID
- Project Code
  Required
- Project Name
  Required
- Client
  Required
- Project Manager
  Required
- Project Type
  Required
- 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
Action
Write
- Assigned To
  Required
- Description
  Required
- Start Date
- End Date
- Memo
- Use Integration ID
Action
Write
- Date
  Required
- Bill Number
  Required
- Vendor
  Required
- 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
Action
Write
- ID
- Name
- First Name
- Last Name
- Bill Rate
- Cost Rate
Action
Write
- ID
  Required
- Project ID
- Project Name
- Contract Amount
Action
Write
- ID
  Required
- Start Date
- End Date
- % Complete
Action
Write
- Search Value
  Required
Action
Search
- Search Value
  Required
Action
Search
- Search Value
  Required
Action
Search
- Search Value
  Required
Action
Search
- Search Value
  Required
Action
Search
- Search Value
  Required
Action
Search
- Search Value
  Required
Action
Search
- Search Value
  Required
Action
Search
- Search Value
  Required
Action
Search
- Search Value
  Required
Action
Search
- Search Value
  Required
- Date
  Required
- Account ID
  Required
- Payee
- Number
- Amount
- Use Integration ID
- Pay Amount
  Required
- Discount Account
- Credit
- Discount
- Payee
  Required
- Vendor Bill Number
  Required
Action
Search or write
- Search Value
  Required
- Date
  Required
- Account ID
  Required
- Number
- Use Integration ID
- Payee
  Required
- Line Item
- Item Type
- Project
- Rate
- Units
- AccountID
- Expense Amount
- Class
- Memo
Action
Search or write
- Search Value
  Required
- Account Number
  Required
- Account Name
  Required
- Description
- Is Active?
- Use Integration ID
Action
Search or write
- Search Value
  Required
- Account
  Required
- Date
  Required
- Use Integration ID
- Account
  Required
- Amount
  Required
Action
Search or write
- Search Value
  Required
- Expense Code
  Required
- Description
  Required
- Expense Sub Code
- Item is Billable?
- Item is Reimbursable?
- Cost Rate
- Memo
- Use Integration ID
Action
Search or write
- Search Value
  Required
- Date
  Required
- Invoice Number
  Required
- Invoice Amount
  Required
- Project
  Required
- Client
- Due Date
- Is Draft?
- Main Service Tax
- Main Expense Tax
- Late Fee
- Use Integration ID
- Item
- Description
  Required
- Units
  Required
- Rate
  Required
- Amount
- Is Expense?
- Tax%
- Charge Amount
Action
Search or write
- Search Value
  Required
- Date
  Required
- Description
  Required
- Master Entity
  Required
- Note Category
  Required
- Note Status
  Required
- Use Integration ID
- Created By
Action
Search or write
- Search Value
  Required
- Date
  Required
- Resource
  Required
- Project
  Required
- Activity
  Required
- Description
  Required
- Hours
  Required
- Client Hours
- Is Billable?
- Cost Rate
- Bill Rate
- Compensation Time
- Extra
- Tax1
- Tax2
- Tax3
- Memo
- Use Integration ID
Action
Search or write
- Search Value
  Required
- First Name
  Required
- Last Name
  Required
- Display Name
  Required
- Company Name
- 1099 Compliant
- Memo
- Use Integration ID
- Title
- Street 1
- Street 2
- City
- State
- Country
- ZIP
Action
Search or write
- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Instant
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Column_name
  Required
- Index
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Source Range
  Required
- Destination Range
  Required
- Paste Type
Action
Write
- Drive
- Title
  Required
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Validation Type
  Required
- Input Message
- Strict Validation
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Columns
  Required
- Row count
  Required
- Output format
- First row
Action
Search
- Spreadsheet ID
  Required
- Include Grid Data
Action
Search
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write

- Property Name
  Required
Trigger
Instant
Try It
- Property Name
  Required
Trigger
Instant
Try It
- Select Module
  Required
Trigger
Instant
Try It
- Select Custom Field
  Required
Trigger
Instant
Try It
- Select Module
  Required
Trigger
Instant
Try It
Project Updated – Completed Status
Triggers when a Project is marked as completed.
Trigger
Instant
Try It
- Property Name
  Required
Trigger
Instant
Try It
Time Entry Updated - Approved Status
Triggers when a Time entry is approved.
Trigger
Instant
Try It
- Select Custom Field
  Required
Trigger
Instant
Try It
To-Do Updated - Completed Status
Triggers when a Todo is marked completed.
Trigger
Instant
Try It
- Property Name
  Required
Trigger
Instant
Try It
- Activity Code
  Required
- Activity Description
  Required
- Activity Sub Code
- Item is Billable?
- Cost Rate
- Bill Rate
- Status
- Tax1
- Tax2
- Memo
- Use Integration ID
Action
Write
- Date
  Required
- Account ID
  Required
- Number
- Use Integration ID
- Payee
  Required
- Line Item
- Item Type
- Project
- Rate
- Units
- AccountID
- Expense Amount
- Class
- Memo
Action
Write
- Account Number
  Required
- Account Name
  Required
- Description
- Is Active?
- Use Integration ID
Action
Write
- Date
  Required
- Account ID
  Required
- Amount
  Required
- Payee
  Required
- Use Integration ID
- Item ID
- Type
- Project ID
- Rate
- Units
- AccountID
- Expense Amount
- Class
- Memo
Action
Write
- First Name
  Required
- Last Name
  Required
- Display Name
  Required
- Cost Rate
  Required
- Bill Rate
  Required
- Gender
- Memo
- Use Integration ID
- Title
- Street 1
- Street 2
- City
- State
- Country
- ZIP
Action
Write
- Date
  Required
- Resource
  Required
- Project
  Required
- Expense
  Required
- Description
  Required
- Units
- Is Billable?
- Cost Rate
- Extra
- Markup
- Reimbursable
- Tax1
- Tax2
- Tax3
- Purchase Tax
- Memo
- Charge Amount
- Use Integration ID
Action
Write
- Date
  Required
- Invoice Number
  Required
- Invoice Amount
  Required
- Project
  Required
- Client
- Due Date
- Is Draft?
- Main Service Tax
- Main Expense Tax
- Late Fee
- Use Integration ID
- Item
- Description
  Required
- Units
  Required
- Rate
  Required
- Amount
- Is Expense?
- Tax%
- Charge Amount
Action
Write
- Date
  Required
- Client
  Required
- Amount
  Required
- Project
- Memo
- Reference Number
- Retainer Payment
- Use Integration ID
- Invoice ID
  Required
- Line Amount
  Required
- Invoice detail
Action
Write
- Date
  Required
- Resource
  Required
- Project
  Required
- Activity
  Required
- Description
  Required
- Hours
  Required
- Client Hours
- Is Billable?
- Cost Rate
- Bill Rate
- Compensation Time
- Extra
- Tax1
- Tax2
- Tax3
- Memo
- Use Integration ID
Action
Write
- First Name
  Required
- Last Name
  Required
- Display Name
  Required
- Company Name
- 1099 Compliant
- Memo
- Use Integration ID
- Title
- Street 1
- Street 2
- City
- State
- Country
- ZIP
Action
Write
- ID
- Name
- Company Name
- Client Manager
Action
Write
- ID
- Project
  Required
- Expense
  Required
- Description
  Required
- Resource
  Required
Action
Write
- ID
- Resource
- Date
- Project
- Activity
- Description
Action
Write
- ID
- Vendor Name
- First Name
- Last Name
Action
Write
- Search Value
  Required
Action
Search
- Search Value
  Required
Action
Search
- Search Value
  Required
Action
Search
- Search Value
  Required
Action
Search
- Search Value
  Required
Action
Search
- Search Value
  Required
Action
Search
- Search Value
  Required
Action
Search
- Search Value
  Required
Action
Search
- Search Value
  Required
Action
Search
- Search Value
  Required
- Activity Code
  Required
- Activity Description
  Required
- Activity Sub Code
- Item is Billable?
- Cost Rate
- Bill Rate
- Status
- Tax1
- Tax2
- Memo
- Use Integration ID
Action
Search or write
- Search Value
  Required
- Date
  Required
- Client
  Required
- Amount
  Required
- Project
- Memo
- Reference Number
- Retainer Payment
- Use Integration ID
- Invoice ID
  Required
- Line Amount
  Required
- Invoice detail
Action
Search or write
- Search Value
  Required
- Display Name
  Required
- Client Manager
- Payment Terms
- Main Expense Tax
- Main Service Tax
- Memo
- Use Integration ID
- Street 1
- Street 2
- City
- State
- Country
- ZIP
Action
Search or write
- Search Value
  Required
- Date
  Required
- Account ID
  Required
- Amount
  Required
- Payee
  Required
- Use Integration ID
- Item ID
- Type
- Project ID
- Rate
- Units
- AccountID
- Expense Amount
- Class
- Memo
Action
Search or write
- Search Value
  Required
- First Name
  Required
- Last Name
  Required
- Display Name
  Required
- Cost Rate
  Required
- Bill Rate
  Required
- Gender
- Memo
- Use Integration ID
- Title
- Street 1
- Street 2
- City
- State
- Country
- ZIP
Action
Search or write
- Search Value
  Required
- Date
  Required
- Resource
  Required
- Project
  Required
- Expense
  Required
- Description
  Required
- Units
- Is Billable?
- Cost Rate
- Extra
- Markup
- Reimbursable
- Tax1
- Tax2
- Tax3
- Purchase Tax
- Memo
- Charge Amount
- Use Integration ID
Action
Search or write
- Search Value
  Required
- Date
  Required
- Reference Number
- Use Integration ID
- Account
  Required
- Amount
  Required
- Is Debit entry?
- Class
- Memo
Action
Search or write
- Search Value
  Required
- Project ID
- Project Code
  Required
- Project Name
  Required
- Client
  Required
- Project Manager
  Required
- Project Type
  Required
- 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
Action
Search or write
- Search Value
  Required
- Assigned To
  Required
- Description
  Required
- Start Date
- End Date
- Memo
- Use Integration ID
Action
Search or write
- Search Value
  Required
- Date
  Required
- Bill Number
  Required
- Vendor
  Required
- 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
Action
Search or write
- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Instant
Try It
- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Condition Type
  Required
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to Copy
  Required
- Worksheet to Copy
  Required
- Copy Worksheet Destination
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Confirm Deletion
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Format Type
  Required
Action
Write
- Spreadsheet
  Required
- Worksheet
  Required
- New Sheet Name
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Sort by Column
  Required
- Sort Order
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- A1 Range
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row ID
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write

About BQE CORE

BQE CORE is an all-in-one, easy-to-use management solution designed for Architecture, Engineering, and Professional Service Firms

HelpHelp

Related categories

Time Tracking Software

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn moreLearn moreHelpHelp

Related categories

Google

Spreadsheets

Similar apps

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Quip

Documents

Related Zap Templates

Add time entries in BQE CORE for new Google Sheets rows

Add new BQE CORE vendor bills to Google Sheets rows

Update Google Sheets rows when selected BQE CORE to-do fields are modified