Track candidate status changes in Clockwork Recruiting by creating spreadsheet rows in Google Sheets
Easily streamline your recruitment tracking process with this automated workflow. When the status of a candidate changes within Clockwork Recruiting software, it creates a new row in a designated Google Sheets spreadsheet, keeping all your data organized and up to date. This seamless flow of information saves you precious time and ensures you're always on top of your recruitment efforts.
Easily streamline your recruitment tracking process with this automated workflow. When the status of a candidate changes within Clockwork Recruiting software, it creates a new row in a designated Google Sheets spreadsheet, keeping all your data organized and up to date. This seamless flow of information saves you precious time and ensures you're always on top of your recruitment efforts.
- When this happens...  Candidate Status Change Candidate Status ChangeTriggers when a candidate's status changes. TriggerInstantThis event starts a Zap instantly.
- automatically do this!  Create Spreadsheet Row 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
- Project IDRequired 
- Color Category 
- Status Name 
- Stoplight Status 
- Person IDRequired 
- Status ID 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Assistant Name 
- Biography 
- Do Not Contact 
- Name of the Person 
- Nick Name 
- No Relocation 
- Skype Name 
- Tag Ids 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Attachment TypeRequired 
- S3 KeyRequired 
- Person IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Degree 
- End Year 
- Start Year 
- School Name 
- School ID 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Linkedin URLRequired 
- Preferred 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- DigitsRequired 
- Extension 
- Preferred 
- Location Type 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Tag IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- NameRequired 
- Description 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Project IDRequired 
- Candidate IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Person Address IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Person Compensation IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Person Email IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Person Note IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Position IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Person Tag IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Tag IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Person Address IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Person Compensation IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Person Email IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Person Note IDRequired 
- Include 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Position IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Project IDRequired 
- Include 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
 - Get Firm Fields- Get Firm Fields from your Database ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Company IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Limit 
- Offset 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Project IDRequired 
- Limit 
- Offset 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Project IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Project IDRequired 
- Limit 
- Offset 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Limit 
- Offset 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Limit 
- Offset 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
 - Get Note Categories- Get Note Categories from your Database ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Project IDRequired 
- Candidate IDRequired 
- Color Category 
- Status Name 
- Stoplight Status 
- Person ID 
- Status ID 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- City 
- Country 
- Postal Code 
- Location 
- Preferred 
- Region Name 
- State 
- Street 
- Street 2 
- Region ID 
- Person IDRequired 
- Person Address IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Person Education IDRequired 
- Degree 
- End Year 
- Start Year 
- School Name 
- School ID 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Person Linkedin URL IDRequired 
- Linkedin URL 
- Preferred 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Phone Number IDRequired 
- Digits 
- Extension 
- Preferred 
- Location Type 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Person Website IDRequired 
- Url 
- Location Type 
- Preferred 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Tag IDRequired 
- Name 
- Description 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Person IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Project IDRequired 
- Project Client IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Project IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Tag IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Dont Change Sheet Structure 
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
 Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
- Dont Change Sheet Structure 
- No Team Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- Trigger column 
 Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- Column NameRequired 
- Index 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- Frozen Rows Count 
- Frozen Columns Count 
- Sheet Position 
- Hide Sheet 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- Source RangeRequired 
- Destination RangeRequired 
- Paste Type 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Drive 
- TitleRequired 
- Spreadsheet to Copy 
- Headers 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Info 
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- Row(s)Required 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Info 
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- Row(s)Required 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- RowRequired 
- Background Color 
- Text Color 
- Bold 
- Italic 
- Strikethrough 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- Cell RangeRequired 
- Validation TypeRequired 
- Input Message 
- Strict Validation 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- RowRequired 
- Background Color 
- Text Color 
- Bold 
- Italic 
- Strikethrough 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Stop on errorRequired 
- HTTP MethodRequired 
- URLRequired 
- Query string parameters 
- Additional request headers 
- Body 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Drive 
- SpreadsheetRequired 
- TitleRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- ColumnsRequired 
- Row countRequired 
- Output format 
- First row 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Spreadsheet IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Drive 
- SpreadsheetRequired 
- TitleRequired 
- Overwrite existing worksheet with the same title 
- Headers 
 ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
- Name 
- Description 
- Exchange 
- Ticker Symbol 
- Do Not Contact 
- Do Not Contact End Date 
- Subtitle 
- No StemmingRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- City 
- Country 
- Postal Code 
- Location 
- Preferred 
- Region Name 
- State 
- Street 
- Street 2 
- Region ID 
- Person IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Bonus 
- Bonus Type 
- Currency Name 
- Dates 
- Description 
- End Year 
- Equity 
- Equity Type 
- Salary 
- Start Year 
- Currency ID 
- Person IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Email Address 
- Location Type 
- Preferred 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Category Name 
- ContentRequired 
- Mime Type 
- Stoplight Status 
- Category ID 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Title 
- Start Month 
- Start Year 
- End Month 
- End Year 
- Company Name 
- Company ID 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- URLRequired 
- Location Type 
- Preferred 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- NameRequired 
- Description 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Person Attachment IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Person Education IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Person Linkedin URL IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Phone Number IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Person Website IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Project IDRequired 
- Candidacy IDRequired 
- Include 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Person Attachment IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Person Education IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Person Linkedin URL IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Phone Number IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Person Website IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Project IDRequired 
- Project User IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Limit 
- Offset 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Limit 
- Offset 
- Sort 
- Include 
- LinkedIn URL 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Include 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Limit 
- Offset 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Project IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Project IDRequired 
- Firm Field Id 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Project IDRequired 
- Limit 
- Offset 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Limit 
- Offset 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Limit 
- Offset 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Limit 
- Offset 
- Sort 
- q 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Name of the Person 
- Assistant Name 
- Biography 
- Do Not Contact 
- Nick Name 
- No Relocation 
- Skype Name 
- Tag Ids 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Company IDRequired 
- Name 
- Description 
- Exchange 
- Ticker Symbol 
- Do Not Contact 
- Do Not Contact End Date 
- Subtitle 
- No Stemming 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Bonus 
- Bonus Type 
- Currency Name 
- Dates 
- Description 
- End Year 
- Equity 
- Equity Type 
- Salary 
- Start Year 
- Currency ID 
- Person IDRequired 
- Person Compensation IDRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Person Email IDRequired 
- Email Address 
- Location Type 
- Preferred 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Person Note IDRequired 
- Category Name 
- Content 
- Mime Type 
- Stoplight Status 
- Category ID 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Position IDRequired 
- Title 
- Start Month 
- Start Year 
- End Month 
- End Year 
- Company Name 
- Company ID 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- School IDRequired 
- Name 
- Description 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Person IDRequired 
- Include 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Person IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Project IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Project IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- School IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Limit 
- Offset 
- q 
- Sort 
- Begin Time 
- End Time 
- LinkedIn Url 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Dont Change Sheet Structure 
- No Team Drive 
- SpreadsheetRequired 
- WorksheetRequired 
 Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
- Dont Change Sheet Structure 
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- Trigger column 
 Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- Use Timezone set up on the spreadsheet to format date values? 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- Cell RangeRequired 
- Condition TypeRequired 
- Background Color 
- Text Color 
- Bold Text 
- Italic Text 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Drive 
- Spreadsheet Containing the Worksheet to CopyRequired 
- Worksheet to CopyRequired 
- Copy Worksheet Destination 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Drive 
- SpreadsheetRequired 
- TitleRequired 
- Overwrite existing worksheet with the same title 
- Headers 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- Confirm DeletionRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- Cell RangeRequired 
- Format TypeRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- SpreadsheetRequired 
- WorksheetRequired 
- New Sheet NameRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- Cell RangeRequired 
- Sort by ColumnRequired 
- Sort OrderRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
 ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- Lookup columnRequired 
- Lookup valueRequired 
- Supporting lookup column 
- Supporting lookup value 
- Search from last row 
- Row count 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- A1 RangeRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- Row IDRequired 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- Lookup columnRequired 
- Lookup valueRequired 
- Supporting lookup column 
- Supporting lookup value 
- Search from last row 
- Row count 
 ActionThis is an event a Zap performs.SearchFind existing data in your app
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- Lookup columnRequired 
- Lookup valueRequired 
- Supporting lookup column 
- Supporting lookup value 
- Search from last row 
- Row count 
 ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found






