- Free forever for core features
- 14 day trial for premium features & apps
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 planDont 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 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 Client
Triggers when a New Client Creates.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New Expense Sheet
Triggers when a New Expense sheet is submitted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New Task
Triggers when a New Task Created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New User/Employee
Triggers when a New User/Employee Created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Department CodeRequired
Department NameRequired
CustomField 1
CustomField 2
CustomField 3
CustomField 4
CustomField 5
CustomField 6
CustomField 7
CustomField 8
CustomField 9
CustomField 10
CustomField 11
CustomField 12
CustomField 13
CustomField 14
CustomField 15
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task NameRequired
Project IdRequired
Start Date
Deadline Date
Task Description
Parent Task
Task Status Id
Account Task Type Id
Duration
For All Employees
Billable
Task Code
For All Project Task
Completed Percent
Estimated Time Spent Unit
Estimated Time Spent
Estimated Cost
Fixed Cost
Account Billing Rate Id
Account Project Milestone Id
Account Priority Id
Estimated Currency Id
Duration Unit
Completed
CustomField 1
CustomField 2
CustomField 3
CustomField 4
CustomField 5
CustomField 6
CustomField 7
CustomField 8
CustomField 9
CustomField 10
CustomField 11
CustomField 12
CustomField 13
CustomField 14
CustomField 15
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
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 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
New Department
Triggers when a new department is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New Project
Triggers when a New Project Created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New Timesheet
Triggers when a New Time sheet is submitted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Client Code
Client NameRequired
EMail Address
CountryId
Address1
Address2
Telephone1
Telephone2
Fax
Zip Code
City
State
Website
Default Billing Rate
Notes
Fixed Cost
Fixed Bid Billing Mode
CustomField 1
CustomField 2
CustomField 3
CustomField 4
CustomField 5
CustomField 6
CustomField 7
CustomField 8
CustomField 9
CustomField 10
CustomField 11
CustomField 12
CustomField 13
CustomField 14
CustomField 15
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project NameRequired
Client IdRequired
Start Date
Deadline Date
Billing Type Id
For All Client Project
Estimated Time
Estimated Duration
Estimated Duration Unit
Default Billing Rate
TimeSheet Approval Type Id
Expense Approval Type Id
Account Project Template Id
Client Contact Id
Client Department Id
Project Prefix
Project Estimated Cost
Fixed Cost
ProjectCode
Project Description
Project Type Id
Template
Is Project
Completed
Project Status
Project Manager
Project Leader
Billing Rate Type
CustomField 1
CustomField 2
CustomField 3
CustomField 4
CustomField 5
CustomField 6
CustomField 7
CustomField 8
CustomField 9
CustomField 10
CustomField 11
CustomField 12
CustomField 13
CustomField 14
CustomField 15
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First NameRequired
Last NameRequired
Email AddressRequired
Mobile Phone No
Termination Date
Allowed Access From IP
Employee Code
Job Title
Hired Date
UserInterfaceLanguage
Billing Rate
Employee Rate
Start Date
End Date
Account Department Id
Account Role Id
Account Location Id
Billing Type Id
Status Id
Employee Manager Id
Employee Pay Type Id
Account Work Type Id
Billing Rate Currency Id
Employee Rate Currency Id
Country Id
Time Zone Id
Account Working Day Type Id
Account Holiday Type Id
Account TimeOff Policy Id
TimeOff Approval Type Id
Middle Name
Notes
Address Line1
Address Line 2
State
City
Zip
Home Phone No
Work Phone No
CustomField 1
CustomField 2
CustomField 3
CustomField 4
CustomField 5
CustomField 6
CustomField 7
CustomField 8
CustomField 9
CustomField 10
CustomField 11
CustomField 12
CustomField 13
CustomField 14
CustomField 15
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.




