Float + Google Sheets
Create multiple rows in Google Sheets for every new project task in Float
Simplify your project management by leveraging this workflow. Once a new task is added in your Float app, it directly creates multiple related rows in your Google Sheets. This automation not only enhances your efficiency but also ensures all the necessary details are captured and organized in one place, directly from the moment the task is initiated.
Simplify your project management by leveraging this workflow. Once a new task is added in your Float app, it directly creates multiple related rows in your Google Sheets. This automation not only enhances your efficiency but also ensures all the necessary details are captured and organized in one place, directly from the moment the task is initiated.
- When this happens...
New Project TaskTriggers when a new project task is created.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Multiple Spreadsheet RowsCreate one or more new rows in a specific spreadsheet (with line item support).
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 a new client is added.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Person
Triggers when a new person is added.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Project
Triggers when a new project is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Allocation
Triggers when a new allocation is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planUpdated Project
Triggers when a project is modified.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planUpdated Allocation
Triggers when an allocation is modified.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNameRequired
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
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
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 appProject ID (priority over project_code and tags)
Project Code (priority over tags)
Tags
ActionThis is an event a Zap performs.SearchFind existing data in your appPerson 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 foundProject ID (priority over project_code and tags)
Project Code
Tags
NameRequired
All PMs Have Edit Rights
Billable
Tentative
Status
Color
Notes
Client ID
Budget Type
Budget Total
Budget Priority
Locked Task List
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 foundDrive
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 Department
Triggers when a new department is added.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Milestone
Triggers when a new milestone is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Phase
Triggers when a new phase is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Project Task
Triggers 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 planNew Time Off
Triggers 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 planUpdated Phase
Triggers when a phase is modified.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planUpdated Project Task
Triggers when a project task is modified.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNameRequired
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
Email
Role Name
Department ID
Notes
Employee Type
Default Hourly Rate
Tag Names
Start Date
End Date
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
Color
Notes
Client ID
Budget Type
Budget Total
Budget Priority
Locked Task List
Default Hourly Rate
Tags
Start Date
End Date
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
NameRequired
People Type
Email
Role Name
Department ID
Notes
Employee Type
Default Hourly Rate
Tag Names
Start Date
End Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
NameRequired
Project Code
All PMs Have Edit Rights
Billable
Tentative
Status
Color
Notes
Client ID
Budget Type
Budget Total
Budget Priority
Locked Task List
Default Hourly Rate
Tags
Start Date
End Date
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 email and tags)
Email (priority over tags)
Tag Names
ActionThis is an event a Zap performs.SearchFind existing data in your appAllocation IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appPerson ID (priority over email and tags)
Email
Tag Names
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 foundAllocation 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 foundNo 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 found
About Float
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Create spreadsheet rows in Google Sheets for new projects in Float
- Log new Float time entries to create Google Sheets spreadsheet rows
- Create new Float projects from new or updated rows in Google Sheets
- Create multiple rows in Google Sheets for new tasks in Float
- Create Float projects from new Google Sheets worksheets