Daylite + Google Sheets
Create Google Sheets rows for new Daylite opportunities
Stay on top of your business opportunities with this streamlined workflow. Whenever a new opportunity is identified in the Daylite app, it will instantly add a new row to your chosen Google Sheets spreadsheet. This real-time update helps to keep your team in the loop and empowers you to manage opportunities more effectively. Take the legwork out of tracking and organizing your business prospects with this efficient automation.
Stay on top of your business opportunities with this streamlined workflow. Whenever a new opportunity is identified in the Daylite app, it will instantly add a new row to your chosen Google Sheets spreadsheet. This real-time update helps to keep your team in the loop and empowers you to manage opportunities more effectively. Take the legwork out of tracking and organizing your business prospects with this efficient automation.
- When this happens...
New OpportunityTriggers when a new opportunity is created in Daylite.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Deleted Appointment
Triggers when a Daylite appointment is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Deleted Person
Triggers when a Daylite person is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Deleted Opportunity
Triggers when a Daylite opportunity is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Deleted Task
Triggers when a Daylite task is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Company
Triggers when a new company is created in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Form
Triggers when a new form is created in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Opportunity
Triggers when a new opportunity is created in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Task
Triggers when a new task is created in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Trashed Person
Triggers when a person is sent to the Trash in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Company Updated
Triggers when a company is updated in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Opportunity Updated
Triggers when an opportunity is updated in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Task Updated
Triggers 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 appText 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 appText 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 appText Field
Text Field Value
Date Field
Date Field Value
ActionThis is an event a Zap performs.SearchFind existing data in your appTypeRequired
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 foundText 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 foundText 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 foundText 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 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
Deleted Company
Triggers when a Daylite company is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Deleted Form
Triggers when a Daylite form is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Deleted Project
Triggers when a Daylite project is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Person
Triggers when a new person is created in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Note
Triggers when a new note is created in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Project
Triggers when a new project is created in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Trashed Appointment
Triggers when an appointment is sent to the Trash in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Appointment Updated
Triggers when an appointment is updated in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Person Updated
Triggers when a person is updated in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Note
Triggers when a note is updated in Daylite.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Project Updated
Triggers 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 appText 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 appText Field
Text Field Value
Date Field
Date Field Value
ActionThis is an event a Zap performs.SearchFind existing data in your appText 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 appReference ID
ActionThis is an event a Zap performs.SearchFind existing data in your appText 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 foundText 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 foundText 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 foundText 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 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 Daylite
Related categories
About Google Sheets
Related categories
Related Zap Templates
- 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 spreadsheet rows in Google Sheets for new projects in Daylite
- 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