Create spreadsheet rows in Google Sheets for new projects in Daylite
Manage your new projects in Daylite more efficiently with this workflow. Once set up, every time you start a new project in Daylite, a row will be added in your Google Sheets, saving you the hassle of manual data entry. Streamline your project tracking and keep all your project data organized with this automation.
- When this happens...

New ProjectTriggers when a new project is created in Daylite.TriggerInstant - 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 Daylite and Google Sheets
Discover other triggers and actions you can use with Daylite and Google Sheets
Deleted AppointmentTriggers when a Daylite appointment is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Deleted PersonTriggers when a Daylite person is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Deleted OpportunityTriggers when a Daylite opportunity is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Deleted TaskTriggers when a Daylite task is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New CompanyTriggers when a new company is created in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New FormTriggers when a new form is created in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New OpportunityTriggers when a new opportunity is created in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New TaskTriggers when a new task is created in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Trashed PersonTriggers when a person is sent to the Trash in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Company UpdatedTriggers when a company is updated in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Opportunity UpdatedTriggers when an opportunity is updated in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Task UpdatedTriggers when a task is updated in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- SubjectRequired
- Details
- TimezoneRequired
- Start DateRequired
- End DateRequired
- Show As
- Category
- Keywords
- Resources
- Location
- Type
- Status
- All Day
- Note
- Group
- Source Import ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- First NameRequired
- Middle Name
- Last NameRequired
- Prefix
- Suffix
- Nickname
- Category
- Keywords
- Details
- Birthday
- Anniversary
- Label
- Email Address
- Ordering
- Format
- Label
- Phone Number
- Ordering
- Label
- Street
- City
- Postal Code
- State
- Country
- Ordering
- Company Name
- Company Website
- Role
- Job Title
- Department
- Relationship Type (Recipient)
- Relationship Type (Source)
- Contact
- Company
- Company Role
- Company Department
- Company Title
- Opportunity
- Opportunity Role
- Opportunity Title
- Project
- Project Role
- Project Title
- Note
- Task
- Appointment
- Group
- Extra Field 1
- Extra Field 2
- Extra Field 3
- Extra Field 4
- Extra Field 5
- Extra Field 6
- Extra Field 7
- Extra Field 8
- Extra Field 9
- Extra Field 10
- Extra Field 11
- Extra Field 12
- Extra Date 1
- Extra Date 2
- Extra Date 3
- Extra Date 4
- Source Import ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Form TemplateRequired
- Linked Person
- Linked Company
- Linked Opportunity
- Linked Project
- Linked Note
- Linked Task
- Linked Appointment
- Owner
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- NameRequired
- Category
- Keywords
- Details
- StateRequired
- Probability
- Forecasted Date
- End Date
- Start Date
- Company
- Contact
- Note
- Task
- Appointment
- Extra Field 1
- Extra Field 2
- Extra Field 3
- Extra Field 4
- Extra Field 5
- Extra Field 6
- Extra Field 7
- Extra Field 8
- Extra Field 9
- Extra Field 10
- Extra Field 11
- Extra Field 12
- Extra Date 1
- Extra Date 2
- Extra Date 3
- Extra Date 4
- Source Import ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- NameRequired
- Category
- Keywords
- Details
- Owner
- StatusRequired
- Priority
- Start Date
- End Date
- Due Date
- Linked Person
- Person Role
- Linked Company
- Company Role
- Note
- Task
- Appointment
- Group
- Extra Field 1
- Extra Field 2
- Extra Field 3
- Extra Field 4
- Extra Field 5
- Extra Field 6
- Extra Field 7
- Extra Field 8
- Extra Field 9
- Extra Field 10
- Extra Field 11
- Extra Field 12
- Extra Date 1
- Extra Date 2
- Extra Date 3
- Extra Date 4
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Reference ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Reference
- Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ReferenceRequired
- Company Name
- Type
- Region
- Industry
- Category
- Edit Mode
- Keywords
- Email Address Edit Mode
- Label
- Email Address
- Ordering
- Phone Number Edit Mode
- Format
- Label
- Phone Number
- Ordering
- Person Title
- Linked Person Edit Mode
- Person
- Person Role
- Address Edit Mode
- Label
- Street
- City
- Postal Code
- State
- Country
- Ordering
- Number of Employees
- Relationship Type (Source)
- Relationship Type (Recipient)
- Linked Company Edit Mode
- Company
- Linked Opportunity Edit Mode
- Opportunity
- Opportunity Role
- Opportunity Title
- Linked Project Edit Mode
- Project
- Project Role
- Project Title
- Linked Note Edit Mode
- Linked Note
- Linked Task Edit Mode
- Linked Task
- Linked Appointment Edit Mode
- Linked Appointment
- Linked Group Edit Mode
- Linked Group
- Extra Field 1
- Extra Field 2
- Extra Field 3
- Extra Field 4
- Extra Field 5
- Extra Field 6
- Extra Field 7
- Extra Field 8
- Extra Field 9
- Extra Field 10
- Extra Field 11
- Extra Field 12
- Extra Date 1
- Extra Date 2
- Extra Date 3
- Extra Date 4
- Owner
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ReferenceRequired
- Opportunity Name
- State
- Probability
- Start Date
- End Date
- Forecasted Date
- Edit Mode
- Keywords
- Category
- Linked Contact Edit Mode
- Contacts
- Linked Company Edit Mode
- Company
- Linked Opportunity Edit Mode
- Opportunity
- Linked Note Edit Mode
- Linked Note
- Linked Task Edit Mode
- Linked Task
- Linked Appointment Edit Mode
- Linked Appointment
- Linked Group Edit Mode
- Linked Group
- Extra Field 1
- Extra Field 2
- Extra Field 3
- Extra Field 4
- Extra Field 5
- Extra Field 6
- Extra Field 7
- Extra Field 8
- Extra Field 9
- Extra Field 10
- Extra Field 11
- Extra Field 12
- Extra Date 1
- Extra Date 2
- Extra Date 3
- Extra Date 4
- Owner
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ReferenceRequired
- Title
- Details
- Priority
- Due Date
- Start Date
- End Date
- Category
- Edit Mode
- Keywords
- Estimated Time
- Location
- Type
- Status
- All Day
- Owner
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Text Field
- Text Field Value
- Date Field
- Date Field Value
ActionThis is an event a Zap performs.SearchFind existing data in your app- Text Field
- Text Field Value
- Date Field
- Date Field Value
- Custom Field
- Custom Field Value
ActionThis is an event a Zap performs.SearchFind existing data in your app- Text Field
- Text Field Value
- Date Field
- Date Field Value
- Custom Field
- Custom Field Value
ActionThis is an event a Zap performs.SearchFind existing data in your app- Text Field
- Text Field Value
- Date Field
- Date Field Value
ActionThis is an event a Zap performs.SearchFind existing data in your app- TypeRequired
- BodyRequired
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- Text Field
- Text Field Value
- Date Field
- Date Field Value
- Custom Field
- Custom Field Value
- NameRequired
- Category
- Keywords
- Details
- Company Type
- Region
- Industry
- Label
- Website Address
- Label
- Email Address
- Ordering
- Format
- Label
- Phone Number
- Ordering
- Label
- Street
- City
- State
- Country
- Postal Code
- Ordering
- Number of Employees
- Person
- Person Role
- Person Title
- Person Department
- Companies
- Opportunity
- Opportunity Role
- Opportunity Title
- Project
- Project Role
- Project Title
- Note
- Task
- Appointment
- Group
- Extra Field 1
- Extra Field 2
- Extra Field 3
- Extra Field 4
- Extra Field 5
- Extra Field 6
- Extra Field 7
- Extra Field 8
- Extra Field 9
- Extra Field 10
- Extra Field 11
- Extra Field 12
- Extra Date 1
- Extra Date 2
- Extra Date 3
- Extra Date 4
- Source Import 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 found- Text Field
- Text Field Value
- Date Field
- Date Field Value
- TitleRequired
- DetailsRequired
- Category
- Keywords
- Owner
- Contact
- Company
- Opportunity
- Project
- Task
- Appointment
- Source Import 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 found- Text Field
- Text Field Value
- Date Field
- Date Field Value
- Custom Field
- Custom Field Value
- NameRequired
- Category
- Keywords
- Details
- Owner
- StatusRequired
- Priority
- Start Date
- End Date
- Due Date
- Linked Person
- Person Role
- Linked Company
- Company Role
- Note
- Task
- Appointment
- Group
- Extra Field 1
- Extra Field 2
- Extra Field 3
- Extra Field 4
- Extra Field 5
- Extra Field 6
- Extra Field 7
- Extra Field 8
- Extra Field 9
- Extra Field 10
- Extra Field 11
- Extra Field 12
- Extra Date 1
- Extra Date 2
- Extra Date 3
- Extra Date 4
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
- 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 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
- 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
Deleted CompanyTriggers when a Daylite company is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Deleted FormTriggers when a Daylite form is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Deleted ProjectTriggers when a Daylite project is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New PersonTriggers when a new person is created in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New NoteTriggers when a new note is created in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New ProjectTriggers when a new project is created in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Trashed AppointmentTriggers when an appointment is sent to the Trash in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Appointment UpdatedTriggers when an appointment is updated in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Person UpdatedTriggers when a person is updated in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated NoteTriggers when a note is updated in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Project UpdatedTriggers when a project is updated in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Type
- Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- NameRequired
- Category
- Keywords
- Details
- Company Type
- Region
- Industry
- Label
- Website Address
- Label
- Email Address
- Ordering
- Format
- Label
- Phone Number
- Ordering
- Label
- Street
- City
- State
- Country
- Postal Code
- Ordering
- Number of Employees
- Person
- Person Role
- Person Title
- Person Department
- Companies
- Opportunity
- Opportunity Role
- Opportunity Title
- Project
- Project Role
- Project Title
- Note
- Task
- Appointment
- Group
- Extra Field 1
- Extra Field 2
- Extra Field 3
- Extra Field 4
- Extra Field 5
- Extra Field 6
- Extra Field 7
- Extra Field 8
- Extra Field 9
- Extra Field 10
- Extra Field 11
- Extra Field 12
- Extra Date 1
- Extra Date 2
- Extra Date 3
- Extra Date 4
- Source Import ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- SubjectRequired
- Message IDRequired
- FromRequired
- ToRequired
- HTML Email BodyRequired
- DateRequired
- Category
- Keywords
- Contact
- Company
- Opportunity
- Project
- Task
- Appointment
- Source Import ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- TitleRequired
- DetailsRequired
- Category
- Keywords
- Owner
- Contact
- Company
- Opportunity
- Project
- Task
- Appointment
- Source Import ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Opportunity NameRequired
- Category
- Keywords
- Details
- First NameRequired
- Last NameRequired
- Email Address
- Phone Number
- Company Name
- Company Website
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Owner
- Keywords
- Category
- TitleRequired
- Details
- Location
- Type
- Status
- Priority
- Estimated Time
- Start Date
- Due Date
- End Date
- Person
- Company
- Note
- Opportunity
- Project
- Source Import ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Primary Object ReferenceRequired
- Linked Object ReferencesRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ReferenceRequired
- Subject
- Details
- Show As
- Timezone
- Start Date
- End Date
- Category
- Edit Mode
- Keywords
- Resources
- Location
- Type
- Status
- All Day
- Owner
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ReferenceRequired
- First Name
- Middle Name
- Last Name
- Prefix
- Suffix
- Nickname
- Category
- Edit Mode
- Keywords
- Birthday
- Anniversary
- Email Address Edit Mode
- Label
- Email Address
- Ordering
- Phone Number Edit Mode
- Format
- Label
- Phone Number
- Ordering
- Address Edit Mode
- Label
- Street
- City
- Postal Code
- State
- Country
- Ordering
- Group Edit Mode
- Linked Group
- Linked Contact Edit Mode
- Relationship Type (Recipient)
- Relationship Type (Source)
- Contacts
- Linked Company Edit Mode
- Company
- Company Role
- Project Edit Mode
- Project
- Project Role
- Project Title
- Linked Opportunity Edit Mode
- Opportunity
- Opportunity Role
- Opportunity Title
- Linked Note Edit Mode
- Linked Note
- Linked Task Edit Mode
- Linked Task
- Linked Appointment Edit Mode
- Linked Appointment
- Extra Field 1
- Extra Field 2
- Extra Field 3
- Extra Field 4
- Extra Field 5
- Extra Field 6
- Extra Field 7
- Extra Field 8
- Extra Field 9
- Extra Field 10
- Extra Field 11
- Extra Field 12
- Extra Date 1
- Extra Date 2
- Extra Date 3
- Extra Date 4
- Owner
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ReferenceRequired
- Status
- Priority
- Name
- Start Date
- End Date
- Due Date
- Category
- Edit Mode
- Keywords
- Linked Contact Edit Mode
- Contacts
- Linked Company Edit Mode
- Company
- Linked Opportunity Edit Mode
- Opportunity
- Linked Task Edit Mode
- Linked Task
- Linked Note Edit Mode
- Linked Note
- Linked Appointment Edit Mode
- Linked Appointment
- Linked Group Edit Mode
- Linked Group
- Extra Field 1
- Extra Field 2
- Extra Field 3
- Extra Field 4
- Extra Field 5
- Extra Field 6
- Extra Field 7
- Extra Field 8
- Extra Field 9
- Extra Field 10
- Extra Field 11
- Extra Field 12
- Extra Date 1
- Extra Date 2
- Extra Date 3
- Extra Date 4
- Owner
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Object TypeRequired
- Search BodyRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Text Field
- Text Field Value
- Date Field
- Date Field Value
- Custom Field
- Custom Field Value
ActionThis is an event a Zap performs.SearchFind existing data in your app- Text Field
- Text Field Value
- Date Field
- Date Field Value
ActionThis is an event a Zap performs.SearchFind existing data in your app- Text Field
- Text Field Value
- Date Field
- Date Field Value
- Custom Field
- Custom Field Value
ActionThis is an event a Zap performs.SearchFind existing data in your app- Reference ID
ActionThis is an event a Zap performs.SearchFind existing data in your app- Text Field
- Text Field Value
- Date Field
- Date Field Value
- SubjectRequired
- Details
- TimezoneRequired
- Start DateRequired
- End DateRequired
- Show As
- Category
- Keywords
- Resources
- Location
- Type
- Status
- All Day
- Note
- Group
- Source Import 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 found- Text Field
- Text Field Value
- Date Field
- Date Field Value
- Custom Field
- Custom Field Value
- First NameRequired
- Middle Name
- Last NameRequired
- Prefix
- Suffix
- Nickname
- Category
- Keywords
- Details
- Birthday
- Anniversary
- Label
- Email Address
- Ordering
- Format
- Label
- Phone Number
- Ordering
- Label
- Street
- City
- Postal Code
- State
- Country
- Ordering
- Company Name
- Company Website
- Role
- Job Title
- Department
- Relationship Type (Recipient)
- Relationship Type (Source)
- Contact
- Company
- Company Role
- Company Department
- Company Title
- Opportunity
- Opportunity Role
- Opportunity Title
- Project
- Project Role
- Project Title
- Note
- Task
- Appointment
- Group
- Extra Field 1
- Extra Field 2
- Extra Field 3
- Extra Field 4
- Extra Field 5
- Extra Field 6
- Extra Field 7
- Extra Field 8
- Extra Field 9
- Extra Field 10
- Extra Field 11
- Extra Field 12
- Extra Date 1
- Extra Date 2
- Extra Date 3
- Extra Date 4
- Source Import 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 found- Text Field
- Text Field Value
- Date Field
- Date Field Value
- Custom Field
- Custom Field Value
- NameRequired
- Category
- Keywords
- Details
- StateRequired
- Probability
- Forecasted Date
- End Date
- Start Date
- Company
- Contact
- Note
- Task
- Appointment
- Extra Field 1
- Extra Field 2
- Extra Field 3
- Extra Field 4
- Extra Field 5
- Extra Field 6
- Extra Field 7
- Extra Field 8
- Extra Field 9
- Extra Field 10
- Extra Field 11
- Extra Field 12
- Extra Date 1
- Extra Date 2
- Extra Date 3
- Extra Date 4
- Source Import 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 found- Text Field
- Text Field Value
- Date Field
- Date Field Value
- Owner
- Keywords
- Category
- TitleRequired
- Details
- Location
- Type
- Status
- Priority
- Estimated Time
- Start Date
- Due Date
- End Date
- Person
- Company
- Note
- Opportunity
- Project
- Source Import 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 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- 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
- Row count
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
- 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
Related Zap Templates
- Create Google Sheets rows for new Daylite opportunities
- Log new Daylite tasks to a Google Sheet
- Create new people in Daylite from new rows in Google Sheets
- Create rows in Google Sheets for new forms in Daylite
- Create Daylite opportunities for persons from new or updated Google Sheets rows
- Create spreadsheet rows in Google Sheets for new appointments in Daylite
- Update Google Sheets rows when Daylite appointments are updated
- Create new Daylite tasks from new Google Sheets rows
- Create multiple rows in Google Sheets for new persons in Daylite
- Update Daylite projects with new or updated Google Sheets rows
- Update Google Sheets with newly updated persons from Daylite







