Google Sheets + Timely Time Tracking
Create Timely Time Tracker projects from new spreadsheet rows in Google Sheets
Do you keep track of all your projects in Google Sheets, but want to be able to log time to them in Timely? Then this automation helps. Every time you create new spreadsheet rows in Google Sheets, projects are created in Timely Time Tracker. No more double work!
Do you keep track of all your projects in Google Sheets, but want to be able to log time to them in Timely? Then this automation helps. Every time you create new spreadsheet rows in Google Sheets, projects are created in Timely Time Tracker. No more double work!
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create ProjectCreates a project.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
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
New Workspace
Triggers when a workspace is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planWorkspaceRequired
Entry typesRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.WorkspaceRequired
NameRequired
External ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
NameRequired
Client Identification Preference
Client IdentificationRequired
Project Description
ColorRequired
External ID
Require a note to be added to each hour logged for this projectRequired
User Identification Preference
User Identification (Not Required for All Users)
Hour Rate Type
Hour Rate
Budget Type
Budget Amount
Recurring Budget
Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
NameRequired
EmailRequired
RoleRequired
Add person to all projects
Projects
Default billable rate
Cost rate
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
Search Term CategoryRequired
Search TermRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appWorkspaceRequired
ClientRequired
Search Term CategoryRequired
Search TermRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appWorkspaceRequired
Search Term CategoryRequired
Search TermRequired
NameRequired
External 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 foundWorkspaceRequired
Search Term CategoryRequired
Search TermRequired
NameRequired
EmailRequired
RoleRequired
Add person to all projects
Projects
Default billable rate
Cost rate
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 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 foundWorkspaceRequired
Log time for another user
DateRequired
Note
ProjectRequired
Logged duration (in hours)Required
Logged Duration (in minutes)Required
Timestamp (Start)
Timestamp (End)
Planned duration (in hours)
Planned duration (in minutes)
Tags
External ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
TitleRequired
Description
ProjectRequired
Tags
User
Estimated effort of the task in minutesRequired
Start dateRequired
End dateRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
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.WorkspaceRequired
Tag List NameRequired
Tag Name
ActionThis is an event a Zap performs.SearchFind existing data in your appWorkspaceRequired
Search Term CategoryRequired
Search TermRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appWorkspaceRequired
Client IdentificationRequired
Search Term CategoryRequired
Search TermRequired
NameRequired
Client Identification Preference
Project Description
ColorRequired
External ID
Require a note to be added to each hour logged for this projectRequired
User Identification Preference
User Identification (Not Required for All Users)
Hour Rate Type
Hour Rate
Budget Type
Budget Amount
Recurring Budget
Tags
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
About Timely Time Tracking
Related categories
Related Zap Templates
- Create new rows in Google Sheets for new time entries in Timely
- Log time entries in Timely Time Tracking for new Google Sheets rows
- Create projects in Timely Time Tracking from new or updated rows in Google Sheets
- Log new or updated time entries in Timely Time Tracking as rows in Google Sheets
- Create multiple Google Sheets rows from new or updated Timely Time Tracking time entries