Create new BoondManager candidates from new or updated rows in Google Sheets
This workflow starts when there's a new or updated row in your Google Sheets. Once triggered, it swiftly creates a candidate in your BoondManager system, keeping your recruitment process on track. By bridging the gap between your spreadsheet updates and your talent acquisition efforts, this automation streamlines your hiring process, ensuring you never miss out on potential candidates.
This workflow starts when there's a new or updated row in your Google Sheets. Once triggered, it swiftly creates a candidate in your BoondManager system, keeping your recruitment process on track. By bridging the gap between your spreadsheet updates and your talent acquisition efforts, this automation streamlines your hiring process, ensuring you never miss out on potential candidates.
- When this happens...New or Updated Spreadsheet Row
Triggers when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!Create a Candidate
Creates a Candidate
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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 foundNew Company
ADMIN ONLY: Triggers when a new company is created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Company Updated
ADMIN ONLY: Triggers when a company is updated
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Invoice Updated
ADMIN ONLY: Triggers when a invoice is updated
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Contact
ADMIN ONLY: Triggers when a new contact is created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Opportunity
ADMIN ONLY: Triggers when a new opportunity is created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Resource
ADMIN ONLY: Triggers when a new resource is created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Opportunity Updated
ADMIN ONLY: Triggers when a opportunity is updated
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Resource Updated
ADMIN ONLY: Triggers when a resource is updated
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Contact idRequired
Action typeOf
Action textRequired
Start date
Id responsable action
Dictionary Language
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
State
Website
Phone1
Fax
Address
Postcode
town
Country
Number
Origin (Type)
Origin (detail)
Expertise area
Information comments
Vat Number
Registration number
Legal status
Registered office
APE code
Social Network - Facebook URL
Social Network - viadeo URL
Social Network - Linkedin URL
Social Network - Twitter URL
Staff
Dictionary Language
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact id
Contact Company id
TitleRequired
Description
Criteria
Reference
State
Type of
Origin typeOf
Origin detail
Expertise area
Activity Areas
Place
Duration
Estimated Budget
Turnover Estimated Excluding Tax
Weighting
Start Date
Dictionary Language
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Parent IDRequired
Parent typeRequired
File URL
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Candidate IdRequired
First name
Last name
Civility
State
Email1
Phone1
Address
Postcode
City
Country
Title
Skills
Availability
Date of availability
Date of birth
Place of birth
Nationality
Current salary
Desired salary - Low range
Desired salary - High range
Desired contract type
Experience
Education
Social Network - Facebook URL
Social Network - Viadeo URL
Social Network - Linkedin URL
Social Network - Twitter URL
Dictionary Language
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact idRequired
Company id
Civility
First NameRequired
Last NameRequired
State
Email1
Phone1
Fax
Address
Postcode
Town
Country
Origine TypeOf
Origin detail
Activity areas
Information comments
Tools
Department
Function
Dictionary Language
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Resource idRequired
Civility
First nameRequired
Last nameRequired
Type of
Title
State
Email1Required
Email2
Email3
Phone1
Phone2
Phone3
Address
Postcode
Town
Country
Date of birth
Mobility areas
Average daily price excluding tax
Availability
Date of availability
Information comments
Dictionary Language
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company id
Company Name
ActionThis is an event a Zap performs.SearchFind existing data in your appLog idRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCandidate email
First nameRequired
Last nameRequired
Civility
State
Email
Phone
Address
Postcode
City
Country
Source (Type)
Source (detail)
Title
Skills
Availability
Date of availability
Date of birth
Place of birth
Nationality
Current salary
Desired salary - Low range
Desired salary - High range
Desired contract type
Experience
Education
Social Network - Facebook URL
Social Network - Viadeo URL
Social Network - Linkedin URL
Social Network - Twitter URL
Dictionary Language
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundContact Email
Company idRequired
Civility
First NameRequired
Last NameRequired
State
Email1
Phone1
Fax
Address
Postcode
Town
Country
Origine TypeOf
Origin detail
Activity areas
Information comments
Tools
Department
Function
Social Network - Facebook URL
Social Network - Viadeo URL
Social Network - Linkedin URL
Social Network - Twitter URL
Dictionary Language
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
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 foundCandidate Updated
ADMIN ONLY: Triggers when a candidate is updated
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Contact Updated
ADMIN ONLY: Triggers when a contact is updated
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Candidate
ADMIN ONLY: Triggers when a new candidate is created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Invoice
ADMIN ONLY: Triggers when a new invoice is created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Project
ADMIN ONLY: Triggers when a new project is created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Action or Action Updated
ADMIN ONLY: Triggers when a new action is created, or when an action is updated
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Project Updated
ADMIN ONLY: Triggers when a project is updated
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Candidate idRequired
Action typeOfRequired
Action text
Start dateRequired
Id responsable action
Dictionary Language
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First nameRequired
Last nameRequired
Civility
State
Email
Phone
Address
Postcode
City
Country
Source (Type)
Source (detail)
Title
Skills
Availability
Date of availability
Date of birth
Place of birth
Nationality
Current salary
Desired salary - Low range
Desired salary - High range
Desired contract type
Experience
Education
Social Network - Facebook URL
Social Network - Viadeo URL
Social Network - Linkedin URL
Social Network - Twitter URL
Dictionary Language
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company idRequired
Civility
First NameRequired
Last NameRequired
State
Email1
Phone1
Fax
Address
Postcode
Town
Country
Origine TypeOf
Origin detail
Activity areas
Information comments
Tools
Department
Function
Social Network - Facebook URL
Social Network - Viadeo URL
Social Network - Linkedin URL
Social Network - Twitter URL
Dictionary Language
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Civility
First nameRequired
Last nameRequired
Type of
Title
State
Email1Required
Email2
Email3
Phone1
Phone2
Phone3
Address
Postcode
Town
Country
Date of birth
Mobility areas
Average daily price excluding tax
Availability
Information comments
Facebook URL
Viadeo URL
Linkedin URL
Twitter URL
Main manager id
HR manager id
Agency id
Contract typeOf
Employee category
Classification
Contract start date
Contract end date
Contract probation end date
Contract renewal probation end date
Monthly salary
Average Daily Cost
Contract information comments
Dictionary Language
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.API EndpointRequired
HTTP MethodRequired
Request Body (JSON)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.company idRequired
NameRequired
State
Website
Phone1
Fax
Address
Postcode
town
Country
Number
Origin (Type)
Origin (Detail)
Expertise area
Information comments
Vat Number
Registration number
Legal status
Registered office
APE code
Staff
Dictionary Language
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Opportunity idRequired
TitleRequired
Description
Criteria
Reference
State
Type of
Origin typeOf
Origin detail
Expertise area
Activity Areas
Place
Duration
Estimated Budget
Turnover Estimated Excluding Tax
Weighting
Start Date
Dictionary Language
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Candidate email
ActionThis is an event a Zap performs.SearchFind existing data in your appContact Email
ActionThis is an event a Zap performs.SearchFind existing data in your appResource email
ActionThis is an event a Zap performs.SearchFind existing data in your appCompany id
Company Name
NameRequired
State
Website
Phone1
Fax
Address
Postcode
town
Country
Number
Origin (Type)
Origin (detail)
Expertise area
Information comments
Vat Number
Registration number
Legal status
Registered office
APE code
Social Network - Facebook URL
Social Network - viadeo URL
Social Network - Linkedin URL
Social Network - Twitter URL
Staff
Dictionary Language
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