Google Sheets + Trackabi
Add new time entries in Trackabi to Google Sheets rows
When one or more new time log entries are added in Trackabi, corresponding rows will be added to a chosen Google Sheets spreadsheet.
When one or more new time log entries are added in Trackabi, corresponding rows will be added to a chosen Google Sheets spreadsheet.
- When this happens...
New Time EntryTriggers when there's a new timesheet entry.
TriggerPollingZapier checks for new data every 15 min on the Free plan - 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
New Client
Triggers when there's a new client.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planStart date (today, if empty)
End date (Start date + 365 days, if empty)
Own only
Reverse
Order by
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Task
Triggers when there's a new task.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Time Type
Triggers when new time type appears.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNameRequired
Client IdRequired
Short Name
Description
Start Date
End Date
Hourly Rate
Cost Hourly Rate
Currency code
Not Billable
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Member id
Member email
Client id
Client name
Project id
Project name
Task id
Task name
Date
Description
Logged time
Billable time
Time type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Client IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Time Entry IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IdRequired
NameRequired
Client Id
Short Name
Description
Start Date
End Date
Hourly Rate
Cost Hourly Rate
Currency Code
Not Billable
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Time entry idRequired
Member id
Email
Client id
Client name
Project id
Project name
Task id
Task name
Date logged
Description
Logged time
Billable time
Time type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Dont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
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
New Member
Triggers when there's a new member.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Project
Triggers when there's a new project.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planStart date (the current day if empty)
End date (the current day if empty)
Client id
Client name
Project id
Project name
Email
Member id
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planClient full nameRequired
Client short name
Contact person
Address
Email
Phone nr.
Notes
Currency code
Hourly rate
Cost hourly rate
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IdRequired
NameRequired
Description
Parent task id
Estimated time
Start date
End date
Not billable
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IdRequired
Member idRequired
Role idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Get Current Company
Retrieves the company details.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Client IdRequired
Name
Short name
Contact person
Address
Email
Phone
Notes
Currency
Hourly rate
Cost hourly rate
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task idRequired
NameRequired
Description
Parent task id
Estimated time
Start date
End date
Not billable
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No 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.Drive
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
About Google Sheets
Related categories
