Avaza + Google Sheets

Avaza + Google Sheets integrations

Create spreadsheet rows in Google Sheets for new timesheet entries in Avaza

Organize your work hours more efficiently with this workflow. As soon as a new timesheet entry is submitted in Avaza, a corresponding row is generated in Google Sheets. This automation eliminates the manual data entry task, saving you valuable time, and keeping your spreadsheet updated seamlessly. It's remarkably efficient for teams to streamline their time tracking process.

When this happens...
New Timesheet EntryTrigger when a new timesheet entry 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 Avaza and Google Sheets

Discover other triggers and actions you can use with Avaza and Google Sheets

New Bill Created
Triggers when a new bill is created.
Trigger
Instant
Try It
Company Deleted
Triggers when a company is deleted.
Trigger
Instant
Try It
Contact Deleted
Triggers when a contact is deleted.
Trigger
Instant
Try It
New Estimate Created
Triggers when a new estimate is created.
Trigger
Instant
Try It
Estimate Updated
Triggers when an estimate is updated.
Trigger
Instant
Try It

Expense Deleted
Triggers when an expense is deleted.
Trigger
Instant
Try It
New Invoice Created
Triggers when a new invoice is created.
Trigger
Instant
Try It

Invoice Sent
Triggers when a new Invoice is sent.
Trigger
Instant
Try It
New Company
Triggers when a new contact Company is created.
Trigger
Instant
Try It
New Project
Triggers when a new Project is created.
Trigger
Instant
Try It
New Timesheet Entry
Trigger when a new timesheet entry is created
Trigger
Instant
Try It
Project Updated
Triggers when a new Project is updated.
Trigger
Instant
Try It
Schedule Series Deleted
Triggers when a schedule series record is deleted.
Trigger
Instant
Try It
Task Deleted
Triggers when a task is deleted.
Trigger
Instant
Try It
Timesheet Entry Deleted
Triggers when an timesheet entry is deleted.
Trigger
Instant
Try It
- Quantity
  Required
- Unit Price
  Required
- Inventory Item IDFK
- Inventory Item Name
- Description
- Tax IDFK
- Tax Name
- Tax Percent
- Discount
- Estimate Prefix
- Estimate Number
- CompanyIDFK
- Company Name
- First Name
- Last Name
- Email
- Currency Code
- Exchange Rate
- Invoice Template IDFK
- Subject
- Customer PO Number
- Date Issued
- Estimate Tax Config Code
- Due Date
- Notes
Action
Write
- Project
  Required
- Section
  Required
- Task Type
- Title
  Required
- Description
- Assigned To
- Task Priority
- Start Date
- Date Due
- Estimated Effort
- Name
- Color
Action
Write
- Amount
- Payment Number
- Date Issued
- Transaction Prefix
- Company ID
- Exchange Rate
- Transaction Reference
- Notes
- Payment Provider Code
- Currency Code
- Bill Transaction ID
- Allocation Amount
- Allocation Date
Action
Write
- Expense Date
  Required
- UserID
- User Email
- Expense CategoryID
- Expense Category Name
- is Chargeable
- is Reimbursable
- Quantity
- CustomerID
- CustomerName
- ProjectID
- Project Name
- TaskID
- CurrencyCode
- Exchange Rate
- Amount
- TaxID
- Tax Name
- Transaction Tax Config Code
- Group Trip Name
- Expense Payment MethodID
- Merchant
- Merchant Tax Number
- Notes
- File Attachment IDs
- Verify And Save
Action
Write
- Timesheet Allowed
- Timesheet Approver
- Expense Approver
- Timesheet Approval Required
- Can Create Tasks
- Can Delete Tasks
- Can Comment On Tasks
- Can Update Tasks
- Project ID
- User ID
- Cost Amount
- Rate Amount
- Budget Amount
Action
Write
- UserIDFK
- Hours Per Day
- Total Duration
- Duration Type
- Schedule On Days Off
- ProjectIDFK
- CategoryIDFK
- TaskIDFK
- Notes
- Start Date
- End Date
- Start Time
Action
Write
- Project ID
- Title
- Start Date UTC
- End Date UTC
Action
Write
- Expense ID
  Required
Action
Write
- Section ID
  Required
Action
Write
- Timesheet Timer ID
  Required
Action
Write
- Expense Name
  Required
- Is Enabled
  Required
Action
Write
- Email
- Company ID
- Roles
- Tags
- Current User Only
Action
Write
- Quantity
  Required
- Unit Price
  Required
- Inventory Item IDFK
- Inventory Item Name
- Description
- Tax IDFK
- Tax Name
- Tax Percent
- Discount
- Transaction Prefix
- Invoice Number
- CompanyIDFK
- Company Name
- First Name
- Last Name
- Email
- Currency Code
- Exchange Rate
- Invoice Template IDFK
- Subject
- Date Issued
- Payment Terms
- Due Date
- Transaction Tax Config Code
- Notes
Action
Write
- Task ID
  Required
- Page Size
- Start Item
Action
Write
- Updated After
- Project ID
- Task ID
- is Invoiced
- Sort
Action
Write
- Updated After
- Page Size
- Page Number
- Sort
- Timesheet User ID
- Company ID
- Project Category ID
- Project Owner User ID
- Project Status Code
- Project Billable Type Code
- Project Budget Type Code
- Date Created From
- Date Created To
- Include Archived
Action
Write
- Project
- Is Complete
- Assigned To Users
- Task Status Code
- Task Priority Code
- Due Date From
- Due Date To
- Sort
- Page Size
- Page Number
Action
Write
- Project ID
  Required
- Search
- Hide Completed
- Page Size
- Page Number
Action
Write
- CompanyID
- Company Name
- Billing Address Line
- Billing Address City
- Billing Address State
- Billing Address Post Code
- Billing Country Code
- Billing Address
- Phone
- Fax
- website
- TaxNumber
- Comments
Action
Write
- Transaction ID
  Required
- Customer PO Number
- Date Issued
- Payment Terms
- Due Date
- Subject
- Notes
- Transaction Tax Config Code
- Exchange Rate
- Invoice Template ID
- Invoice Number
- Transaction Line Item ID
- Inventory Item ID
- Description
- Quantity
- Unit Price
- Tax ID
- Discount
- Project ID
Action
Write
- Timesheet Allowed
- Timesheet Approver
- Expense Approver
- Timesheet Approval Required
- Can Create Tasks
- Can Delete Tasks
- Can Comment On Tasks
- Can Update Tasks
- Project ID
  Required
- User ID
  Required
- Cost Amount
- Rate Amount
- Budget Amount
Action
Write
- Schedule Series ID
- User ID
- Hours Per Day
- Total Duration
- Duration Type
- Schedule on Days Off
- Project ID
- Category ID
- Task ID
- Notes
- Start Date
- End Date
- Start Time
Action
Write
- TimeSheet Entry ID
  Required
- Project ID
  Required
- Timesheet Category ID
- Task ID
- Duration
- Entry Date
- Has Start End Time
- Notes
- Custom Metadata
Action
Write
- Search
  Required
Action
Search
- 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
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
- First row
- Row count
Action
Search
- 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 Name
  Required
- Search Type
- Spreadsheet to Copy
- Headers
Action
Search or 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 or write

Bill Updated
Triggers when a bill is updated.
Trigger
Instant
Try It
Company Updated
Triggers when a company is updated.
Trigger
Instant
Try It
Contact Updated
Triggers when a contact is updated.
Trigger
Instant
Try It
Estimate Deleted
Triggers when an estimate is deleted.
Trigger
Instant
Try It
New Expense Created
Triggers when a new expense is created.
Trigger
Instant
Try It
Expense Updated
Triggers when an expense is updated.
Trigger
Instant
Try It
Invoice Deleted
Triggers when a invoice is deleted.
Trigger
Instant
Try It
Invoice Update
Triggers when a invoice is updated.
Trigger
Instant
Try It
New Contact
Triggered when a new company contact is created.
Trigger
Instant
Try It
New Task Created
Trigger when a new task is created.
Trigger
Instant
Try It
Project Deleted
Triggers when a project is deleted.
Trigger
Instant
Try It
New Schedule Series Created
Triggers when a new schedule series record is created.
Trigger
Instant
Try It
Schedule Series Updated
Triggers when a schedule series record is updated.
Trigger
Instant
Try It
Task Updated
Trigger when a task is updated.
Trigger
Instant
Try It
Timesheet Entry Updated
Trigger when a timesheet entry is updated.
Trigger
Instant
Try It
- Project Title
  Required
- Company ID
- Company Name
- Currency Code
- Project Notes
- Timesheet Approval Required by Default
- Populate Default Project Members
- Is Task Required On Timesheet
- Start Date
- EndDate
- Budget Amount
- Budget Hours
- Project Status Code
- Project Category IDFK
Action
Write
- Transaction Prefix
- Bill Number
- Company ID
- Company Name
- First Name
- Last Name
- Email
- Currency Code
- Exchange Rate
- Bill Template ID
- Subject
- Supplier PO Number
- Date Issued
- Payment Terms
- Due Date
- Transaction Tax Config Code
- Notes
- Inventory Item ID
- Inventory Item Name
- Description
- Quantity
- Unit Price
- Tax ID
- Tax Name
- Tax Percent
- Discount
- Project ID
Action
Write
- Company Name
  Required
- Currency Code
- Billing Address Line
- Billing Address City
- Billing Address State
- Billing Address Post Code
- Billing Country Code
- Billing Address
- Phone
- Fax
- website
- TaxNumber
- Comments
Action
Write
- Amount
- Payment Number
- Date Issued
- Transaction Prefix
- Customer IDFK
- Exchange Rate
- Transaction Reference
- Notes
- Payment Provider Code
- Invoice Transaction IDFK
- Allocation Amount
- Allocation Date
Action
Write
- Project ID
- Timesheet Category ID
- Billable
- Payable
- Rate Amount
- Budget Hours
- Cost Amount
Action
Write
- Leave UserIDFK
- Leave Notify
- Leave Hours Per Day
- Leave Type IDFK
- Leave Notes
- Leave Start Date
- Leave End Date
- Start Time
Action
Write
- User ID
- Project ID
- Timesheet Category ID
- Task ID
- Duration
- Is Invoiced
- Entry Date
- Has Start End Time
- Notes
- Custom Metadata
Action
Write
- Schedule Series ID
  Required
Action
Write
- Task ID
  Required
Action
Write
- Timesheet Id
  Required
Action
Write
- Search
- Project Code
- Company ID
- Timesheet User ID
- Page Number
- Page Size
Action
Write
- Company Name
  Required
- Contact Email
  Required
- Firstname
  Required
- Lastname
  Required
- Currency Code
- Company Billing Address
- Position Title
- Mobile
- Phone
- Update Existing
Action
Write
- Project ID
  Required
- Project Timesheet Category
  Required
Action
Write
- Expense Date From
  Required
- Expense Date To
  Required
- User Email
- User ID
- Category Name
- Customer ID
- Project ID
- is Chargeable
- is Invoiced
- Expense Reimbursement ID
- Expense Payment Method ID
- Expense Approval Status Code
- Search
Action
Write
- Updated After
- Page Size
- Page Number
- Transaction Status Code
- Issue Date From
- Issue Date To
- Due Date From
- Due Date To
- Sort
- Company ID
Action
Write
- Schedule Date From
  Required
- Schedule Date To
  Required
- Updated After
- Schedule Series ID
- User ID
- User Email
- Page Size
- page Number
- Sort
Action
Write
- Entry Date From
  Required
- Entry Date To
  Required
- User ID
- User Email
- Category Name
- Timesheet Entry Approval Status Code
- Project ID
- Task ID
- is Billable
- is Invoiced
- is Timer Running
- include Invoice Details
- Sort
Action
Write
- Task ID
  Required
- Project
- Section
- Assigned To
- Title
- Description
- Start Date
- Date Due
- Task Priority
- Estimated Effort
- Task Status Code
- Percent Complete
- Name
- Color
Action
Write
- Expense ID
  Required
- Expense Date
- Expense CategoryID
- is Chargeable
- is Reimbursable
- Quantity
- CustomerID
- ProjectID
- TaskID
- CurrencyCode
- Exchange Rate
- Amount
- TaxID
- Transaction Tax Config Code
- Group Trip Name
- Expense Payment MethodID
- Merchant
- Merchant Tax Number
- Notes
- File Attachment IDs
- Verify And Save
Action
Write
- Project ID
  Required
- Project Title
- Project Notes
- Timesheet Approval Required by Default
- Is Task Required On Timesheet
- Start Date
- EndDate
- Budget Amount
- Budget Hours
- Project Status Code
- Project Category IDFK
- Project Billable Type Code
- Project Budget Type Code
Action
Write
- Project ID
- Timesheet Category ID
- Billable
- Payable
- Rate Amount
- Budget Hours
- Cost Amount
Action
Write
- Schedule Series ID
- Leave User ID
- Leave Hours Per Day
- Leave Type ID
- Leave Notes
- Leave Start Date
- Leave End Date
- Start Time
Action
Write
- File Name + ext.
  Required
- File
  Required
Action
Write
- Search
  Required
- Company Name
  Required
- Currency Code
- Billing Address Line
- Billing Address City
- Billing Address State
- Billing Address Post Code
- Billing Country Code
- Billing Address
- Phone
- Fax
- website
- TaxNumber
- Comments
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
- 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
- Overwrite All Columns
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- Spreadsheet Name
  Required
- Search Type
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
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write

About Avaza

Avaza is a versatile software for client-focused businesses. It offers project management, timesheets, expenses, quotes, and invoicing.

HelpHelp

Related categories

Time Tracking Software

Similar apps

Trigger

Project Management

Kantata OX

Project Management

Birdview PSA

Project Management

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

Create worksheets in Google Sheets for new projects in Avaza