Float + Google Sheets
Create Float allocations from new or updated rows in Google Sheets
Easily manage your resources with this workflow. When there's a new or updated row in your Google Sheets, this workflow creates an allocation in Float. No more manual entry or lost data, it ensures your resource planning is kept up-to-date with every change in your spreadsheet. Ideal for project management, this workflow streamlines the process and keeps your team organized.
Easily manage your resources with this workflow. When there's a new or updated row in your Google Sheets, this workflow creates an allocation in Float. No more manual entry or lost data, it ensures your resource planning is kept up-to-date with every change in your spreadsheet. Ideal for project management, this workflow streamlines the process and keeps your team organized.
- When this happens...
New or Updated Spreadsheet RowTriggers when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create AllocationCreates a new allocation.
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.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.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
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
ColumnsRequired
Row countRequired
First row
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 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 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
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.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Apply standard error handling?Required
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
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNew 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 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