Factorial + Google Sheets
Update Google Sheets rows with new Factorial employee invitations
With this Zap in place, every time a new employee is invited to Factorial, their information is automatically added to a new row in a Google Sheets spreadsheet of your choosing. Manage new employee data without slowing down for copy-and-paste tasks.
With this Zap in place, every time a new employee is invited to Factorial, their information is automatically added to a new row in a Google Sheets spreadsheet of your choosing. Manage new employee data without slowing down for copy-and-paste tasks.
- When this happens...
TriggerPollingZapier checks for new data every 15 min on the Free plan - 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
Type of the webhook subscription - [subscription_type]Required
URL where the webhook payload will be sent - [target_url]Required
Name of the webhook subscription - [name]
String to verify the subscription - [challenge]
Company identifier of the webhook subscription - [company_id]Required
Boolean to enable/disable the subscription - [enabled]
API version of the webhook subscription that determines the schema of the payload - [api_version]
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planIdentifier of the webhook subscription - [id]Required
URL where the webhook payload will be sent - [target_url]
Type of the webhook subscription - [subscription_type]
Name of the webhook subscription - [name]
String to verify the subscription - [challenge]
Boolean to enable/disable the subscription - [enabled]
API version of the webhook subscription that determines the schema of the payload - [api_version]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company id of the application - [company_id]
Application first name - [first_name]Required
Application last name - [last_name]Required
Application job posting id - [ats_job_posting_id]Required
Application candidate email - [email]Required
Application candidate phone - [phone]
Application source - [source]
Application medium - [medium]
Application cover letter - [cover_letter]
gender of the candidate. - [gender]
Application consent talent pool - [consent_to_talent_pool]
Answers One
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Application author id - [author_id]
Application author type - [author_type]
Application id - [id]Required
Application is qualified - [qualified]
Application phase id - [ats_application_phase_id]
Application disqualified reason - [disqualified_reason]
Application candidate phone - [phone]
Application rejection reason id - [ats_rejection_reason_id]
Application source - [source]
Application source id - [source_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.identifier of the candidate.Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.first name of the candidate. - [first_name]Required
last name of the candidate. - [last_name]Required
email of the candidate. - [email]
company identifier, refers to /core/me endpoint. - [company_id]Required
is the candidate part of talent pool? - [talent_pool]
date when the consent was given. - [consent_given_at]
source of the candidate. - [source]
specifies additional details related to the source of the candidate, such as the referrer name for example if the source is referred. - [medium]
phone number of the candidate. - [phone_number]
personal web resource from the candidate. - [personal_url]
gender of the candidate. - [gender]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.identifier of the feedbackRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.the ID of the candidate to whom the new feedback will be associated. - [ats_candidate_id]Required
the overall rating from 1 to 5 to be given to the candidate's application. - [rating]
the ID of the application related to the feedback. - [ats_application_id]
the ID of the phase within the application related to the feedback. - [ats_application_phase_id]
a string describing the feedback provided. - [description]
the IDs of the accesses for sending notifications if they have it enabled. They must have permissions to see the assosiated application. - [mention_ids]
IDs of the form to which the feedback belongs if the evaluation forms feature is active. - [ats_evaluation_forms_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.identifier of the job postingRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[title]Required
[description]
[contract_type]
[workplace_type]
[status]Required
[schedule_type]
[team_id]
[location_id]
[salary_format]
[salary_from_amount_in_cents]
[salary_to_amount_in_cents]
[cv_requirement]Required
[cover_letter_requirement]Required
[phone_requirement]Required
[photo_requirement]Required
[salary_period]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Id of the break configuration - [id]Required
Status of the break configuration if enabled or not - [enabled]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.identifierRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[employee_id]Required
[request_type]Required
[reason]
[date]
[clock_in]
[clock_out]
[workable]
[attendance_shift_id]
[reference_date]
[time_settings_break_configuration_id]
[location_type]
[observations]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[date]Required
[description]
[hours_amount]
[employee_id]Required
[author_id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Ids of the employees to be autofilled - [employee_ids]Required
Date to start autofilling - [start_on]Required
Date to end autofilling - [end_on]Required
Source of the shift creation - [source]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Employee id of the break - [employee_id]
Current time of the break - [now]Required
Observations of the break - [observations]
Time settings configuration id of the break - [time_settings_break_configuration_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Employee identifier - [employee_id]
Clock out time - [now]Required
Latitude from where user clocked in - [latitude]
Longitude from where user clocked in - [longitude]
Location accuracy - [accuracy]
Notes on the shift record - [observations]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Id of the shift - [id]Required
Time of the clock in - [clock_in]
Time of the clock out - [clock_out]
Date of the shift - [date]
reference date of the shift - [reference_date]
Comments added to the shift - [observations]
Type of the location - [location_type]
Id of the location related - [workplace_id]
Id of the break configuration - [time_settings_break_configuration_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Employee identifier - [employee_id]Required
Clock in or out Timestamp - [clock_time]Required
Place where user has clocked in - [location_type]
Notes on the shift record - [observations]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[contract_version_id]Required
[contracts_taxonomy_id]Required
[description]
[compensation_type]
[amount]
[unit]
[sync_with_supplements]
[payroll_policy_id]
[recurrence_count]
[starts_on]
[recurrence]
[first_payment_on]
[calculation]
[time_condition]
[minimum_amount_of_hours]
[minimum_amount_of_hours_in_cents]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.contract version identifier. - [id]Required
employee identifier, refers to /employees/employees endpoint. - [employee_id]
the day the specific contract starts, in case of hiring the same than starts_on. - [effective_on]
the day the employee is hired. - [starts_on]
the day the employee is terminated. - [ends_on]
the frequency of the working hours. - [working_hours_frequency]
the days of the week the employee works. - [working_week_days]
the amount of hours the employee works. - [working_hours]
the frequency of the salary payment. - [salary_frequency]
the amount of money the employee earns. - [salary_amount]
job title of the employee. - [job_title]
cotization group identifier. - [es_cotization_group]
professional category identifier. - [es_professional_category_id]
education level identifier. - [es_education_level_id]
contract type identifier. - [es_contract_type_id]
working day type identifier. - [es_working_day_type_id]
a flag that indicates if the employee has a trial period. - [has_trial_period]
when the trial period ends. - [trial_period_ends_on]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Title for option - [label]Required
Flag to make the option available - [is_active]
Custom Fields identifier - [field_id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]
[value]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Schema name - [name]Required
Company identifier where this schema belongs - [company_id]Required
Custom field identifier - [effective_at_id]
Manages visibility of the schema - [hidden]Required
Schema position within employee profile - [position]
Schema slug - [usage_group_slug]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.list of document identifiers. - [document_ids]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.list of document identifiers. - [document_ids]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company ID - [company_id]Required
Folder id - [id]Required
Folder name - [name]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.company id of the employee, you can get it in companies/legal_entities endpoint. - [company_id]Required
name of the employee. - [first_name]Required
last name of the employee. - [last_name]Required
personal email of the employee. - [email]Required
the day the specific contract starts, in case of hiring the same than contract_starts_on. - [contract_effective_on]
the day the employee is hired. - [contract_starts_on]
the day the contract ends. - [ends_on]
gender of the employee (male | female). - [gender]
national identifier number. - [identifier]
type of identifier (ex passport). - [identifier_type]
identifier expiration date. - [identifier_expiration_date]
birthday of the employee. - [birthday_on]
nationality country code of the employee (Spain ES, United Kingdom GB). - [nationality]
address of the employee. - [address_line1]
address of the employee. - [address_line_2]
postal code of the employee. - [postal_code]
city of the employee. - [city]
state/province/region of the employee. - [state]
country code of the employee (Spain ES, United Kingdom GB). - [country]
bank account number of the employee. - [bank_number]
code to identify banks and financial institutions globally. - [swift_bic]
id of manager, you can get the manager_id from employees endpoint. - [manager_id]
id of manager, you can get the manager_id from employees endpoint. - [timeoff_manager_id]
legal entity of the employee, references to companies/legal_entities. - [legal_entity_id]
identity number or string used inside a company to internally identify the employee. - [company_identifier]
team id of the employee. - [team_id]
location id of the employee, references to locations/locations. - [location_id]
social security number of the employee. - [social_security_number]
does the employee have a trial period? - [has_trial_period]
when the trial period ends. - [trial_period_ends_on]
name of the emergency contact. - [contact_name]
phone number of the emergency contact. - [contact_number]
phone number of the employee. - [phone_number]
A3Innuva employee code. - [a3_innuva_code]
A3Nom employee code. - [a3_nom_code]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.id of the unconfirmed employee - [id]Required
id of the company - [company_id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.id of the employee. - [id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[employee_id]Required
Memberships One
[company_id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.name of the location - [name]Required
country code of the location - [country]Required
whether the location is the main one - [main]
City of the location - [city]
State of the location - [state]
phone number of the location - [phone_number]
Postal code of the location - [postal_code]
Address line 1 of the location - [address_line_one]
Address line 2 of the location - [address_line_two]
latitude of the location - [latitude]
longitude of the location - [longitude]
timezone of the location - [timezone]Required
radius of the location - [radius]
company identifier - [company_id]Required
siret of the location (only for France) - [siret]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
[name]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.payroll employee identifier - [id]Required
social security number of the employee - [social_security_number]
tax id of the employee - [tax_id]
country code of the employee pt | it | de - [country]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Family situation id. - [id]Required
Employee id. - [employee_id]Required
Civil status of the employee. - [civil_status]
Number of dependants of the employee. - [number_of_dependants]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Code Value - [code]Required
Related object ID. Used together with codeable_type - [codeable_id]Required
Related object type. Used together with codeable_id - [codeable_type]Required
Integration name - [integration]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Supplement amount in cents - [amount_in_cents]Required
The employee id of the suplement - [employee_id]Required
Supplement effective on date following the format YYYY-MM-DD - [effective_on]Required
Supplement contract taxonomy id - [contracts_taxonomy_id]Required
Supplement contract compensation id - [contracts_compensation_id]
Supplement payroll policy period id - [payroll_policy_period_id]
Supplement unit - [unit]
Supplement worked days - [worked_days]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process ID - [process_id]Required
Review process target ID - [target_id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Evaluation ID - [id]Required
New reviewer access ID - [new_reviewer_access_id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review owner IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process ID - [id]Required
Reviewer strategies to remind about - [evaluation_types]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process ID - [id]Required
New deadline of the review process - [ends_at]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process ID - [id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process ID - [id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process ID - [id]Required
New name of the review process - [name]
New description of the review process - [description]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process ID - [id]Required
New deadline of the review process - [ends_at]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process ID - [id]Required
New review types to be applied - [reviewer_strategies]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process ID - [id]Required
Condition that defines the employees that will be evaluated (participants) - [target_strategy]
IDs of target strategy groups selected - [arguments]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process ID - [performance_review_process_id]Required
List of access IDs to be added as participants - [targets_access_ids]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
[evaluation_ids]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process ID - [performance_review_process_id]Required
Reviewer strategy to update the questionnaire for - [strategy]Required
Questionnaire Content One
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.identifier of the commentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.identifier of the post - [post_id]Required
Text of the comment - [text]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.identifier of the group.Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.title of the group. - [title]Required
description of the group. - [description]Required
Identifier of the company, this value can be retrieved from core/me endpoint - [company_id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.identifier of the post - [id]Required
title of the post - [title]
description of the post - [description]
group identifier of the post, references to posts/groups endpoint - [post_group_id]
allow comments and reactions on the post - [allow_comments_and_reactions]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[flexible_time_record_id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[content]Required
[flexible_time_record_id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
[imputed_minutes]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Mandatory to pass a name of the project. - [name]Required
Optional unique code for the project to be identifiable and searchable. - [code]
Optional start date for the project. If given must be in iso-8601 format (YYYY-MM-DD). - [start_date]
Optional due date for the project. If given must be in iso-8601 format (YYYY-MM-DD). - [due_date]
Project status. Can be active or closed - [status]
Optional param to define the kind of assignation the project has. Can be manual or company - [employees_assignment]
[project_admins]
[project_managers]
[is_billable]
[fixed_cost_cents]
[budget_allocation]
[legal_entity_id]
[budget_allocation_cents]
[fee_amount_cents]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[ids]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
[name]Required
[content]
[starts_on]
[follow_up]Required
[due_on]
[assignee_ids]
[project_id]Required
[subproject_id]
[files_to_add]
[files_to_remove]
[status]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.**DEPRECATED** in favor of project_ids. Please use project_ids instead - [project_id]
Set of project_ids to assign to the employees specified in the next param. - [project_ids]
Set of a employee_ids that must be **assigned** after execution. - [employee_ids]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.The id of the project to assign the employee project worker. - [project_id]Required
The id of the employee to be assigned to the project. - [employee_id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
[name]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Items One
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[project_worker_id]Required
[attendance_shift_id]Required
[subproject_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.List of shift identifiers - [ids]
Start date for the shift list - [start_at]
End date for the shift list - [end_at]
Lsit of the employee identifiers - [employee_ids]
Access identifier of the author fo the bulk delete action - [author_id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[name]
Start date of the shift - [start_at]Required
End date of the shift - [end_at]Required
Shift notes - [notes]
Employee identifier - [employee_id]Required
Location identifier - [location_id]
Location work area identifier - [work_area_id]
Company identifier - [company_id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.identifier of the task - [task_id]Required
file to attach to the task - [file]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.a list of task ids. - [ids]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[content]Required
[author_id]Required
[resource_id]Required
[company_id]Required
[mentioned_access_ids]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.id of a task. - [id]Required
name of task. - [name]Required
description of the task. - [content]
expiration date of the task. - [due_on]
employees assigned to the task, assignee_id references to employee_id. - [assignee_ids]
status of the task (todo | in_progress | done | discarded). - [status]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Membership id.Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Team id. - [team_id]Required
Employee id. - [employee_id]Required
Makes the employee a lead of the team. - [lead]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.id of the team - [id]Required
name of the team - [name]
Description of the team - [description]
Avatar of the team - [avatar]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Employee Id - [employee_id]Required
Allowance Id - [timeoff_allowance_id]Required
How many units multiplied by 100 do you want to add/substract. Can be positive or negative - [days_in_cents]Required
A free text field to add a description to the incidence - [description]
When does the incidence take effect. This is related to the allowance cycle. - [effective_on]Required
Which counter does the incidence affect. Can be "accrued" or "available" - [target_balance]Required
When set to true, it prevents notifications being sent to employee when this incidence is created - [_skip_notifications]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Only for Allowances based on worked time. It represents how many units you need to work to be granted allowance units - [accrued_denominator_in_cents]
Only for Allowances based on worked time. It represents how many units you are given per unit of time worked - [accrued_factor_in_cents]
When can the accrued units be spent. - [accrued_units_availability]Required
Sets the allowance units. Can be "days" or "hours" - [allowance_type]Required
Indicates how the allowance units are accrued. For example all_days means all allowance days are given on the first day of the cycle. - [available_days]Required
How many units can carry over between cycles multiplied by 100 - [carry_over_units_in_cents]
This setting flags if units taken during a bank holiday should be deducted or not from allowance. - [count_holiday_as_workable]Required
How many months does each allowance cycle last - [cycle_length]
When does the cycle start. - [cycle_start]Required
Indicates if the allowance is based on working on calendar days. - [days_type]Required
When does the carryover expire in months. - [expire_in_months]
Defines duration of the allowance cycles. Can be "yearly", "monthly_flexible" or "lifetime" - [frequency]
Base amount of holiday allowance units multiplied by 100 - [holiday_allowance_in_cents]Required
An array of leave type ids associated with that allowance - [leave_type_ids]Required
Maximum the allowance can reach on accrued - [maximum_amount_in_cents]
Allowance name set by the user - [name]Required
Whether the allowance allows to request more days than available. - [negative_counter_type]Required
Indicates the position in the allowance when rendering them in UI - [position]
Whether the allowance has proration enabled or not. - [proration_type]Required
Whether the allowance days are prorated or not - [pto_proratio_enabled]Required
Configures how leaves duration is handled. - [range_type]
How the accrued units of the allowance are rounded. It depends if the allowance is set in hours or days. - [rounding]Required
This field configures the type of allowance (fixed balance, based on worked time) - [source_units]Required
In case the allowance has tenure periods, when is this tenure applied. - [tenure_period_transition]
Whether the allowance has tenure periods enabled or not. - [tenure_periods_enabled]
Tenure Periods One
The Id of the policy to which the allowance belongs to - [timeoff_policy_id]Required
Flag to indicate if there is unlimited accrual. - [unlimited_accrued_hours]Required
Flag to indicate if there is unlimited carry over. - [unlimited_carry_over]Required
Boolean to flag if carryover does not expire - [unlimited_carry_over_expiration]Required
Flag to indicate that the allowance has unlimited available days - [unlimited_holidays]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
Name of the blocked period. - [name]Required
List of leave type identifiers for which employees can not request timeoff edited - [leave_type_ids]Required
Time Periods Attributes One
Type of access group - [strategy]Required
List of employees manually selected - [members]
[query]
List of team identifiers which the selected employees belong to - [team_ids]
List of locations workplace identifiers where the employees are located - [location_ids]
List of legal entity identifiers which the selected employees belong to - [legal_entity_ids]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Identifier of the Leave - [id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.The employee id of the leave - [employee_id]Required
The leave type id - [leave_type_id]
The description of the leave - [description]
The valid start date of the leave following the format YYYY-MM-DD - [start_on]Required
The valid end date of the leave following the format YYYY-MM-DD - [finish_on]
If the leave is in: [beggining_of_day, end_of_day] - [half_day]
The start time of a leave - [start_time]
The hours amount in cents of a leave - [hours_amount_in_cents]
The medical leave type - [medical_leave_type]
The effective on date of a leave following the format YYYY-MM-DD - [effective_on]
The medical discharge reason of a leave - [medical_discharge_reason]
The colegiate number of a leave - [colegiate_number]
If the leave has previous relapse - [has_previous_relapse]
The leave relapse id - [relapse_leave_id]
The leave relapse on date following the format YYYY-MM-DD - [relapse_on]
The leave accident on date following the format YYYY-MM-DD - [accident_on]
The leave paternity birth on date following the format YYYY-MM-DD - [paternity_birth_on]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Identifier of the leave type to update - [id]
Whether the leave type accrues over time - [accrues]
Whether approval is required for this leave type - [approval_required]
A unique identifier for the leave type - [identifier]
Whether an attachment is required for this leave type - [attachment]
The color associated with this leave type (hex code) - [color]
The name of the leave type - [name]
Whether the leave type is visible to employees - [visibility]
Whether the leave type is workable (can be worked on during leave) - [workable]
Whether the leave type is payable - [payable]
Whether the attachment is mandatory or a status description (boolean or string) - [is_attachment_mandatory]
Whether half-day units are enabled for this leave type - [half_days_units_enabled]
Maximum days in cents that can be taken - [max_days_in_cents]
Minimum days in cents that must be taken - [min_days_in_cents]
Whether the leave type is active - [active]
Whether endless leave is allowed - [allow_endless]
Whether the leave type is restricted - [restricted]
Description of the leave type - [description]
Whether additional details are required for the leave type - [details_required]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Id of the policy to delete.Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.The name of the policy. - [name]Required
If the policy is the main policy. - [main]
Policy description. - [description]
Company ID. - [company_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Start date of the planning version - [effective_at]Required
Type of planning tool (shift_management, work_schedules, contract_hours) - [planning_tool]Required
Amount of rest days per week if applicable (in cents) - [number_of_rest_days_in_cents]
Employee identifier - [employee_id]Required
Work schedule identifier to include if applicable - [schedule_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[name]Required
[paid]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[name]Required
[company_id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[ids]Required
[notify]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[name]Required
[training_id]Required
[description]
[training_class_id]
[starts_at]
[ends_at]
[due_date]
[duration]
[modality]
[link]
[location]
[subsidized]
[recurrent]
Reminders One
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[ids]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[ids]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name of the training - [name]Required
Code of the training - [code]
Description of the training - [description]Required
External provider of the training - [external_provider]
External training - [external]Required
[category_ids]
Competency ids of the training - [competency_ids]
The person that creates the training - [author_id]
[employee_id]
[cost]
[subsidized_cost]
[cost_decimal]
[subsidized_cost_decimal]
Year of the training - [year]Required
Company identifier of the training - [company_id]
Attachments One
The training validity period - [valid_for]
Objectives of the course - [objectives]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[overlap_period_id]Required
Day Configurations One
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[author]Required
[id]Required
[update_params]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[name]
[id]Required
[author]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.retrieve only the feedbacks that match the IDs passed in the request.Required
ActionThis is an event a Zap performs.SearchFind existing data in your appfilter by termination incidence ids.Required
ActionThis is an event a Zap performs.SearchFind existing data in your appidRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by action plan IDsRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by review process IDsRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appidRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appidRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNo 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.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
identifierRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Type of the webhook subscription - [subscription_type]Required
URL where the webhook payload will be sent - [target_url]Required
Name of the webhook subscription - [name]
String to verify the subscription - [challenge]
Company identifier of the webhook subscription - [company_id]Required
Boolean to enable/disable the subscription - [enabled]
API version of the webhook subscription that determines the schema of the payload - [api_version]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.identifier of the ApplicationRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Application author id - [author_id]
Application author type - [author_type]
Application candidate phone - [phone]
Application candidate id - [ats_candidate_id]
Application job posting id - [ats_job_posting_id]Required
Application phase id - [ats_application_phase_id]
Whether or not the candidate has given consent to be added to the talent pool - [consent_to_talent_pool]
Application cover letter - [cover_letter]
Application source - [source]
Application medium - [medium]
Answers One
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.identifier of the candidate. - [id]Required
email of the candidate. - [email]
first name of the candidate. - [first_name]
last name of the candidate. - [last_name]
is the candidate part of talent pool? - [talent_pool]
date when the consent was given. - [consent_given_at]
phone number of the candidate. - [phone_number]
personal web resource from the candidate. - [personal_url]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Id of the evaluation form to be saved as a template. - [id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.the ID of the feedback entry to be updated. - [id]
the overall rating from 1 to 5 for the candidate's application. - [rating]
the description of the feedback provided. - [description]
the ID of the phase within the application related to the feedback. - [ats_application_phase_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.The Job ID of the job posting that you want to duplicate. - [id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
[title]
[description]
[contract_type]
[workplace_type]
[status]
[schedule_type]
[team_id]
[location_id]
[salary_format]
[salary_from_amount_in_cents]
[salary_to_amount_in_cents]
[cv_requirement]
[cover_letter_requirement]
[phone_requirement]
[photo_requirement]
[salary_period]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[content]Required
[sent_by_id]Required
[sent_by_type]Required
[ats_application_id]Required
[attachments]Required
[topic]Required
[send_as_corporate_email]Required
[delayed_until]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Id of the time settings break configuration - [time_settings_break_configuration_id]Required
Id of the attendance employee setting - [attendance_employees_setting_id]Required
Status of the break configuration if enabled or not - [enabled]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[attendance_shift_id]
[clock_in]
[clock_out]
[date]
[reference_date]
[employee_id]Required
[id]Required
[location_type]
[observations]
[reason]
[time_settings_break_configuration_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
[reason]
[approver_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
[date]
[description]
[hours_amount]
[reason]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
[reason]Required
[approver_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Employee id of the break - [employee_id]
Current time of the break - [now]Required
Observations of the break - [observations]
[project_worker_id]
[subproject_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Employee identifier - [employee_id]
Clock in time - [now]Required
Latitude from where user clocked in - [latitude]
Longitude from where user clocked in - [longitude]
Location identifier - [accuracy]
Notes on the shift record - [observations]
Place where user has clocked in - [location_type]
Location identifier - [workplace_id]
Break configuration identifier - [time_settings_break_configuration_id]
Project worker identifier - [project_worker_id]
Subproject identifier - [subproject_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Id of the employee related - [employee_id]
Date of the shift - [date]Required
Reference date of the shift - [reference_date]
number of days of the shift - [day]
Time of the clock in - [clock_in]
Time of the clock out - [clock_out]
Comments added to the shift - [observations]
Boolean that indicates if the shift is a half day - [half_day]
Boolean that indicates if the shift is workable - [workable]
Type of the location - [location_type]
Source of the shift creation - [source]
Id of the break configuration - [time_settings_break_configuration_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.incidence (aka employee update) identifier to update. - [id]Required
status of the incidence (aka employee update). It can be any of 'in-preparation', 'to-do', 'doing', 'done', 'discarded' - [status]
Boolean that indicates is the incidence (aka employee update) has message - [has_message]
[message_from]
Date in which the incidence (aka employee update) was read - [read_at]
Boolean that indicate if the incidence is read - [mark_as_read]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]
[contracts_taxonomy_id]Required
[description]
[compensation_type]
[amount]
[unit]
[sync_with_supplements]
[payroll_policy_id]
[recurrence_count]
[starts_on]
[recurrence]
[first_payment_on]
[calculation]
[time_condition]
[minimum_amount_of_hours]
[minimum_amount_of_hours_in_cents]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.contract version identifier.Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.employee identifier, refers to /employees/employees endpoint. - [employee_id]Required
the day the specific contract starts, in case of hiring the same than starts_on. - [effective_on]Required
the day the employee is hired. - [starts_on]Required
the day the employee is terminated. - [ends_on]
the frequency of the working hours. - [working_hours_frequency]
the days of the week the employee works. - [working_week_days]
the amount of hours the employee works. - [working_hours]
the maximum amount of hours the employee can work in a year. - [max_legal_yearly_hours]
the maximum amount of hours the employee can work in a week. - [maximum_weekly_hours]
the frequency of the salary payment. - [salary_frequency]
the amount of money the employee earns. - [salary_amount]
job title of the employee. - [job_title]
a flag that indicates if the employee has a trial period. - [has_trial_period]
when the trial period ends. - [trial_period_ends_on]
[copy_current_contract_version]
[job_catalog_level_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company identifier where this field belongs - [company_id]Required
Group of employees that can edit the field - [editable]
Group of employees that can see the field - [visible]
Field label - [label]
[field_type]Required
Minimum value in range field type - [min_value]
Maximum value in range field type - [max_value]
Requirement to fill this field - [required]
Array of options - [options]
[position]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Schema identifier - [schema_id]Required
Company identifier - [company_id]Required
Resource field label - [label]
Type of the value for the resource field - [field_type]Required
Requirement to fill this resource field - [required]Required
Maximum value for range field type - [max_value]
Minimum value for range field type - [min_value]
Field position within schema - [position]
Group for which this field is editable - [editable]Required
Group for which this field is visible - [visible]Required
Array of options to choose from - [options]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Custom Fields identifier - [field_id]Required
Type of the object that the custom field is attached to: 'Document' | 'Employee' | 'Contracts::ContractVersion' | 'CustomResources::Value' - [valuable_type]Required
Identifier of the object that the custom field is attached to - [valuable_id]Required
Custom Fields value - [value]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Identifier of the schema this value belongs to - [schema_id]Required
[employee_id]Required
Identifier of the field this value belongs to - [field_id]Required
Value for schema custom field - [value]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.document identifiers. - [id]Required
flag to indicate if the document is public. - [public]Required
employee identifier associated to the document. - [employee_id]
folder identifier, references to documents/folders endpoint. - [folder_id]
flag to indicate if the document requires an electronic signature. - [request_esignature]Required
list of user access identifiers associated to the document, refers to /employees/employees endpoint. - [signee_ids]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.flag to indicate if the document is public. - [public]Required
document space, in case of employee_my_documents it's necessary to fill employee_id. - [space]Required
folder identifier, references to documents/folders endpoint. - [folder_id]
final name of the file, even if the file has been uploaded with a different name. - [file_filename]
flag that indicates if the document is pending assignment. - [is_pending_assignment]Required
leave identifier associated to the document, refers to /timeoff/leaves endpoint. - [leave_id]
file to upload, the binary file. - [file]Required
employee identifier associated to the document. - [employee_id]
access identifier of the author, refers to /employees/employees endpoint. - [author_id]Required
company identifier, refers to /api/me endpoint. - [company_id]Required
list of user access identifiers associated to the document, refers to /employees/employees endpoint. - [signee_ids]Required
flag to indicate if the document requires an electronic signature. - [request_esignature]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.list of document identifiers. - [ids]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company ID - [company_id]Required
Folder name - [name]Required
The space of the folder is related to the type of documents that will be stored in it. You should always use "employee_my_documents" - [space]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.id of the employee. - [id]Required
access_id of the creator. - [access_id]
gender of the employee (male | female). - [gender]
name of the employee. - [first_name]
last name of the employee. - [last_name]
national identifier number. - [identifier]
type of identifier (ex passport). - [identifier_type]
birthday of the employee. - [birthday_on]
nationality country code of the employee (Spain ES, United Kingdom GB). - [nationality]
address of the employee. - [address_line_1]
address of the employee. - [address_line_2]
postal code of the employee. - [postal_code]
city of the employee. - [city]
state/province/region of the employee. - [state]
country code of the employee (Spain ES, United Kingdom GB). - [country]
bank account number of the employee. - [bank_number]
code to identify banks and financial institutions globally. - [swift_bic]
id of manager, you can get the manager_id from employees endpoint. - [manager_id]
id of manager, you can get the manager_id from employees endpoint. - [timeoff_manager_id]
social security number of the employee. - [social_security_number]
does the employee have work permit? - [has_work_permit]
phone number of the employee. - [phone_number]
identity number or string used inside a company to internally identify the employee. - [company_identifier]
legal entity of the employee, references to companies/legal_entities. - [legal_entity_id]
location id of the employee, references to locations/locations. - [location_id]
nickname of the employee or a name that defines the employee better. - [preferred_name]
pronouns that an employee uses to define themselves. - [pronouns]
name of the employee contact. - [contact_name]
phone number of the employee contact . - [contact_number]
personal email of the employee. - [personal_email]
officially certified level of disability granted by public administration for individuals with physical or mental impairments, expressed in cents - [disability_percentage_cents]
identifier expiration date - [identifier_expiration_date]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.id of the employee. - [id]Required
when the employee will be terminated. - [terminated_on]Required
A reason for the termination. - [termination_reason]
id of manager that terminates the employee, you can get the manager_id from employees endpoint. - [termination_assigned_manager_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name of the ledger account - [name]
Number of the ledger account - [number]Required
Type of the ledger account - [type]Required
Legal entity ID of the ledger account - [legal_entity_id]
Id of the ledger account on the external system. This field is important to avoid having duplicated ledger accounts - [external_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
[name]
[code]
[description]
[company_id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[name]Required
[company_id]Required
[legal_entity_id]
[code]
[description]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.identifier of the location - [id]Required
name of the location - [name]
country code of the location - [country]
whether the location is the main one - [main]
City of the location - [city]
State of the location - [state]
phone number of the location - [phone_number]
Postal code of the location - [postal_code]
Address line 1 of the location - [address_line_one]
Address line 2 of the location - [address_line_two]
timezone of the location - [timezone]
latitude of the location - [latitude]
longitude of the location - [longitude]
radius of the location - [radius]
siret of the location (only for France) - [siret]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[name]Required
[location_id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.payroll employee identifierRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.identifier of the employee - [employee_id]Required
social security number of the employee - [social_security_number]
tax id of the employee - [tax_id]
country code of the employee pt | it | de - [country]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Employee id. - [employee_id]Required
Civil status of the employee. - [civil_status]
Number of dependants of the employee. - [number_of_dependants]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Code identifier - [id]Required
Code Value - [code]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
[status]Required
[notify_employee]Required
[employee_ids]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.The supplement id - [id]Required
The employee id of the supplement - [employee_id]
The supplement contract compensation id - [contracts_compensation_id]
The supplement contract taxonomy id - [contracts_taxonomy_id]
Supplement amount in cents - [amount_in_cents]
Supplement effective on date following the format YYYY-MM-DD - [effective_on]
Supplement unit - [unit]
Supplement payroll policy period id - [payroll_policy_period_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process ID - [process_id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
[scale_id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process ID - [review_process_id]Required
List of access IDs to be added as owners - [owner_access_ids]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process ID to duplicate - [id]Required
Access ID to be set as author of the new review process - [author_access_id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Access identifier of the author of the review process - [author_access_id]Required
Name of the review process - [name]
A brief description of the review process - [description]
Review types that will be assigned to the review process. It'll be used to create the evaluations when the process starts - [reviewer_strategies]
Condition that defines the employees that will be evaluated (participants). Calculated when the review process starts - [target_strategy]
IDs of target strategy groups selected - [arguments]
Date when the review process should end - [ends_at]
Whether the action plans are enabled or not. This will allow initializing and signing action plans for self and manager evaluations - [agreements_enabled]
Whether the review process should generate employee scores or not. This will add a mandatory question at the end of "Self" and "Manager" questionnaires to evaluate the employee's performance and generate the score. - [employee_score_enabled]
Whether the competencies assessments are enabled or not. This will allow assessing competencies for self and manager evaluations - [competencies_assessments_enabled]
Performance cycle ID - [cycle_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process ID - [id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process ID - [id]Required
Date when the review process should start - [starts_at]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process ID - [id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process ID - [id]Required
Flag to enable or disable action plans in a review process - [enabled]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process ID - [id]Required
Flag to enable or disable competencies assessments in a review process - [enabled]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process ID - [id]Required
Flag to enable or disable employee scores in a review process - [enabled]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process ID - [id]Required
Date when the review process should start - [starts_at]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process target ID - [id]Required
List of access IDs to be added as peers for the participant - [peer_access_ids]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Process Target IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process ID - [performance_review_process_id]Required
Default Rating Scale One
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Review process ID - [id]
Review process ID - [performance_review_process_id]
When enabled, employees don't have access to their results - [restrict_answers_visibility_to_reportees]Required
When enabled, managers can access the results of their reports before deadline - [early_access_to_answers_for_managers]Required
When enabled, peer evaluations are anonymous so employees don't know who reviewed them - [anonymous_peer_evaluation_for_target]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.identifier of the comment - [id]Required
identifier of the post - [post_id]Required
Text of the comment - [text]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.identifier of the group. - [id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Identifier of the group. - [id]Required
title of the group. - [title]
description of the group. - [description]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.identifier of the postRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.title of the post - [title]Required
description of the post - [description]Required
group identifier of the post, references to posts/groups endpoint - [post_group_id]Required
allow comments and reactions on the post - [allow_comments_and_reactions]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[content]Required
[flexible_time_record_id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[project_worker_id]Required
[date]Required
[imputed_minutes]Required
[subproject_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
[employees_assignment]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Id project. - [id]Required
Name of the project. - [name]Required
Code for the project to be identifiable and searchable. - [code]
Start date for the project. If given must be in iso-8601 format (YYYY-MM-DD). - [start_date]
Due date for the project. If given must be in iso-8601 format (YYYY-MM-DD). - [due_date]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project id where the tasks will be duplicated - [project_id]
Subproject id where the tasks will be duplicated - [subproject_id]
Task ids to be duplicated - [ids]Required
Set this to true if you want to exclude assignees from the duplicated tasks - [exclude_assignees]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[name]Required
[content]
[starts_on]
[follow_up]
[due_on]
[assignee_ids]
[project_id]Required
[subproject_id]
[files]
[status]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.The id of the project to assign the given employees. - [project_id]Required
The id of the employee to be assigned to the projects. - [employee_ids]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.The id of the project worker to be unassigned. - [id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[name]Required
[project_id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[date]Required
[project_worker_id]Required
[subproject_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
[project_worker_id]Required
[subproject_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.identifier of the fileRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.name of the task. - [name]Required
description of the task - [content]
expiration date of the task. - [due_on]
Employees assigned to the task, assignee_id references to employee_id. - [assignee_ids]
status of the task (todo | in_progress | done | discarded). - [status]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.id of the task. - [id]Required
name of the task - [name]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.id of the task.Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.name of the task. - [name]Required
description of the task - [content]
expiration date of the task. - [due_on]
Employees assigned to the task, assignee_id references to employee_id. - [assignee_ids]
status of the task (todo | in_progress | done | discarded). - [status]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Membership id. - [id]Required
Assign an employee as a lead for their respective team. - [lead]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.id of the teamRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name of the team. - [name]Required
Description of the team - [description]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
How many units multiplied by 100 do you want to add/substract. Can be positive or negative - [days_in_cents]
Allowance Id - [timeoff_allowance_id]
A free text field to add a description to the incidence - [description]
When does the incidence take effect. This is related to the allowance cycle. - [effective_on]
Which counter does the incidence affect. Can be "accrued" or "available" - [target_balance]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
Allowance id sent to migrate existing incidences from the deleted allowance to the alternative allowance - [alt_allowance_id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
Only for Allowances based on worked time. It represents how many units you need to work to be granted allowance units - [accrued_denominator_in_cents]
Only for Allowances based on worked time. It represents how many units you are given per unit of time worked - [accrued_factor_in_cents]
Indicates how the allowance units are accrued. For example all_days means all allowance days are given on the first day of the cycle. - [available_days]
How many units can carry over between cycles multiplied by 100 - [carry_over_units_in_cents]
This setting flags if units taken during a bank holiday should be deducted or not from allowance. - [count_holiday_as_workable]
Indicates if the allowance is based on working on calendar days. - [days_type]
When does the carryover expire in months. - [expire_in_months]
Defines duration of the allowance cycles. Can be "yearly", "monthly_flexible" or "lifetime" - [frequency]
Base amount of holiday allowance units multiplied by 100 - [holiday_allowance_in_cents]
An array of leave type ids associated with that allowance - [leave_type_ids]
Maximum the allowance can reach on accrued - [maximum_amount_in_cents]
Allowance name set by the user - [name]
Whether the allowance allows to request more days than available. - [negative_counter_type]
Indicates the position in the allowance when rendering them in UI - [position]
Whether the allowance has proration enabled or not. - [proration_type]
Whether the allowance days are prorated or not - [pto_proratio_enabled]
Configures how leaves duration is handled. - [range_type]
How the accrued units of the allowance are rounded. It depends if the allowance is set in hours or days. - [rounding]
In case the allowance has tenure periods, when is this tenure applied. - [tenure_period_transition]
Whether the allowance has tenure periods enabled or not. - [tenure_periods_enabled]
Tenure Periods One
Flag to indicate if there is unlimited accrual. - [unlimited_accrued_hours]
Flag to indicate if there is unlimited carry over. - [unlimited_carry_over]
Boolean to flag if carryover does not expire - [unlimited_carry_over_expiration]
Flag to indicate that the allowance has unlimited available days - [unlimited_holidays]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.The company id - [company_id]Required
Name of the blocked period. - [name]Required
An array of leave type identifiers for which employees can not request timeoff - [leave_type_ids]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Identifier of the Leave - [id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.The leave id - [id]Required
The employee id of the leave - [employee_id]
The leave type id - [leave_type_id]
The description of the leave - [description]
The valid start date of the leave following the format YYYY-MM-DD - [start_on]
The valid end date of the leave following the format YYYY-MM-DD - [finish_on]
If the leave is in: [beggining_of_day, end_of_day] - [half_day]
The start time of a leave - [start_time]
The hours amount in cents of a leave - [hours_amount_in_cents]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Identifier of the Leave - [id]Required
Reason for rejecting the leave - [reason]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Whether the leave type accrues over time - [accrues]Required
Whether approval is required for this leave type - [approval_required]Required
A unique identifier for the leave type - [identifier]Required
Whether an attachment is required for this leave type - [attachment]
The color associated with this leave type - [color]Required
The name of the leave type - [name]Required
Whether the leave type is visible to employees - [visibility]
Whether the leave type is workable (can be worked on during leave) - [workable]Required
Whether the leave type is payable - [payable]
Whether the attachment is mandatory - [is_attachment_mandatory]
Whether half-day units are enabled for this leave type - [half_days_units_enabled]
Maximum days in cents that can be taken - [max_days_in_cents]
Minimum days in cents that must be taken - [min_days_in_cents]
Identifier of the company associated with this leave type - [company_id]Required
Whether the leave type is editable - [editable]
Whether endless leave is allowed - [allow_endless]
Whether the leave type is restricted - [restricted]
Description of the leave type - [description]
Whether additional details are required for the leave type - [details_required]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Id of the policy to update. - [id]Required
The name of the policy. - [name]
Policy description. - [description]
If the policy is the main policy. - [main]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Start date of the planning version - [effective_at]Required
Type of planning tool (shift_management, work_schedules, contract_hours) - [planning_tool]Required
Amount of rest days per week if applicable (in cents) - [number_of_rest_days_in_cents]
List of employee identifiers - [employee_ids]Required
Work schedule identifier to include if applicable - [schedule_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Planning version identifier - [id]Required
Start date of the planning version - [effective_at]Required
Amount of rest days per week if applicable (in cents) - [number_of_rest_days_in_cents]
Type of planning tool (shift_management, work_schedules, contract_hours) - [planning_tool]Required
Work schedule identifier to include if applicable - [schedule_id]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
[name]
[paid]
[archived]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[access_ids]
[employee_ids]
[session_id]Required
[notify]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[ids]Required
[status]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
[name]Required
[starts_at]
[ends_at]
[due_date]
[duration]
[modality]
[link]
[location]
[subsidized]
[recurrent]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[access_ids]
[employee_ids]
[training_id]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Unique identifier for the training membership. Only used to identify the training membership to update. - [id]Required
This field is used to record the date a training was completed for trainings that have an expiry date. - [training_completed_at]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[ids]Required
[catalog]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
[name]Required
[code]
[description]Required
[external_provider]
[external]Required
[category_ids]
[competency_ids]
[cost]
[subsidized_cost]
[cost_decimal]
[subsidized_cost_decimal]
[year]Required
[valid_for]
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[id]Required
[status]Required
[notify]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[author]Required
[schedule_id]Required
[create_params]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.[name]Required
[schedule_type]Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.List of IDs of the evaluation forms to be fetched.Required
ActionThis is an event a Zap performs.SearchFind existing data in your appidentifierRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appidRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appThe IDs of the per diem to read.Required
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by employee score scale IDsRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appAn array of allowance ids to look forRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appidRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
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
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 found
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Create spreadsheet rows in Google Sheets for new time-attendance clocks out in Factorial
- Add rows to Google Sheets for new employee terminations in Factorial HR
- Create leaves in Factorial from new rows in Google Sheets
- Create rows in Google Sheets for new Factorial leaves
- Fetch new company leaves in Factorial and create spreadsheet rows in Google Sheets