Log new Float time entries to create Google Sheets spreadsheet rows
Effortlessly track your team's logged hours in Float with this efficient workflow that saves your data into a Google Sheets spreadsheet. When new logged time is added in Float, a new row will be instantly created in your designated Google Sheets document, ensuring all the data is compiled in one place for easy analysis and reporting. Stay organized and keep track of your team's progress without manual data entry or time-consuming updates.
- When this happens...

New Logged TimeTriggers when a new logged time is created.TriggerPolling - automatically do this!

Create Spreadsheet RowCreate a new row in a specific spreadsheet.ActionWrite
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with Float and Google Sheets
Discover other triggers and actions you can use with Float and Google Sheets
New ClientTriggers when a new client is added.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New PersonTriggers when a new person is added.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New ProjectTriggers when a new project is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New AllocationTriggers when a new allocation is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Updated ProjectTriggers when a project is modified.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Updated AllocationTriggers when an allocation is modified.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- TemplateRequired
- Project CodeRequired
- Start DateRequired
- Name
- Overrides_divider
- All PMs Have Edit Rights
- Billable
- Status
- Stage
- Color
- Notes
- Client ID
- Project Owner
- Locked Task List
- Budget Type
- Budget Total
- Budget Priority
- Same rate for everyone
- Rate Card
- Currency Code
- FX Rate
- Tags
- End Date
- Active State
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- DateRequired
- HoursRequired
- Person IDRequired
- Project IDRequired
- Allocation ID
- Task Name
- Notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- NameRequired
- People Type
- People Code
- Email
- Role Name
- Department ID
- Notes
- Employee Type
- Default Hourly Rate
- Tag Names
- Start Date
- End Date
- Active State
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- NameRequired
- Project Code
- All PMs Have Edit Rights
- Billable
- Tentative
- Status
- Stage
- Color
- Notes
- Client ID
- Project Owner
- Locked Task List
- Budget Type
- Budget Total
- Budget Priority
- Same rate for everyone
- Rate Card
- Currency Code
- FX Rate
- Tags
- Start Date
- End Date
- Active State
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Project IDRequired
- People IDsRequired
- Status
- HoursRequired
- Start DateRequired
- End DateRequired
- Name
- Notes
- Repeat State
- Repeat End Date
- Start Time
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Project IDRequired
- Logged Time IDRequired
- Date
- HoursRequired
- Person ID
- Task Name
- Notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Person IDRequired
- Name
- People Type
- People Code
- Email
- Role Name
- Department ID
- Notes
- Employee Type
- Default Hourly Rate
- Tag Names
- Start Date
- End Date
- Active State
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Project IDRequired
- Name
- Project Code
- All PMs Have Edit Rights
- Billable
- Tentative
- Status
- Stage
- Color
- Notes
- Client ID
- Project Owner
- Locked Task List
- Budget Type
- Budget Total
- Budget Priority
- Same rate for everyone
- Rate Card
- Currency Code
- FX Rate
- Tags
- Start Date
- End Date
- Active State
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Allocation IDRequired
- Project ID
- People IDs
- Status
- HoursRequired
- Start Date
- End Date
- Name
- Notes
- Repeat State
- Repeat End Date
- Start Time
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Person ID (priority over people code, email and tags)
- People Code (priority over email and tags)
- Email (priority over tags)
- Tag Names
- Active
ActionThis is an event a Zap performs.SearchFind existing data in your app- Project ID (priority over project_code and tags)
- Project Code (priority over tags)
- Tags
- Active
- Include Phases
- Include Expenses
- Include Project Tasks
- Include Project Team
ActionThis is an event a Zap performs.SearchFind existing data in your app- Allocation IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Person ID (priority over people code, email and tags)
- People Code
- Email
- Tag Names
- Active State
- NameRequired
- People Type
- Role Name
- Department ID
- Notes
- Employee Type
- Default Hourly Rate
- Start Date
- End Date
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- Project ID (priority over project_code and tags)
- Project Code
- Tags
- Active State
- Include Phases
- Include Expenses
- Include Project Tasks
- Include Project Team
- NameRequired
- All PMs Have Edit Rights
- Billable
- Tentative
- Status
- Stage
- Color
- Notes
- Client ID
- Project Owner
- Locked Task List
- Budget Type
- Budget Total
- Budget Priority
- Same rate for everyone
- Rate Card
- Currency Code
- FX Rate
- Start Date
- End Date
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- 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 plan- Dont_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
- 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
- First row
- Row count
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
ActionThis is an event a Zap performs.SearchFind existing data in your app- Spreadsheet IDRequired
- Include Grid Data
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- Spreadsheet NameRequired
- Search Type
- Spreadsheet to Copy
- 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- 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.Search or writeFind existing data in your app, or create a new record if no data is found
New DepartmentTriggers when a new department is added.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New MilestoneTriggers when a new milestone is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New PhaseTriggers when a new phase is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New Project TaskTriggers when a new project task is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New Time OffTriggers when a new time off is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Updated PhaseTriggers when a phase is modified.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Updated Project TaskTriggers when a project task is modified.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- NameRequired
- Project IDRequired
- DateRequired
- End Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Project IDRequired
- NameRequired
- Start DateRequired
- End DateRequired
- Color
- Notes
- Budget Total
- Default Hourly Rate
- Billable
- Status
- Active State
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Project IDRequired
- NameRequired
- Billable
- Budget
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- People IDsRequired
- Time Off Type IDRequired
- Start DateRequired
- End DateRequired
- Hours
- Full Day
- Additional notes about the time off
- Status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Milestone IDRequired
- NameRequired
- Project IDRequired
- DateRequired
- End Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Project IDRequired
- NameRequired
- Start DateRequired
- End DateRequired
- Color
- Notes
- Budget Total
- Default Hourly Rate
- Billable
- Status
- Active State
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Project Task IDRequired
- Project IDRequired
- NameRequired
- Billable
- Budget
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Person IDRequired
- Project IDRequired
- Logged Time IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Phase ID (priority over Project ID)
- Project ID
- Active
- Include Phase Tasks
- Include Phase Team
ActionThis is an event a Zap performs.SearchFind existing data in your app- Active
- Client
- Currency Code
- Include Roles
- Include Project Count
ActionThis is an event a Zap performs.SearchFind existing data in your app- Person IDRequired
- Project IDRequired
- Logged Time IDRequired
- DateRequired
- HoursRequired
- Allocation ID
- Task Name
- Notes
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- Phase ID (priority over Project ID)
- Project IDRequired
- Active State
- Include Phase Tasks
- Include Phase Team
- NameRequired
- Start DateRequired
- End DateRequired
- Color
- Notes
- Budget Total
- Default Hourly Rate
- Billable
- Status
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- Allocation IDRequired
- Project IDRequired
- People IDsRequired
- Status
- HoursRequired
- Start DateRequired
- End DateRequired
- Name
- Notes
- Repeat State
- Repeat End Date
- Start Time
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- 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 plan- Dont_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
- Overwrite All Columns
- 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.- 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.- Drive
- Spreadsheet NameRequired
- Search Type
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data 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 app- Drive
- 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




