Create integrations between Clockwork Recruiting and Google Sheets to automate any workflow
WHEN THIS HAPPENS
Candidate Status ChangeAUTOMATICALLY DO THIS
Create Multiple Spreadsheet RowsEndless possibilities
Top companies trust Zapier to automate work that solves their unique business problems—no coding required.
How Zapier works
Zapier lets you build automated workflows between two or more apps—no code necessary. These workflows are called Zaps, and this is how they work.
A trigger is where automation begins
A trigger is an event that starts your Zap. Say you want to receive an email every time someone fills in a Facebook form—the trigger would be "new Facebook lead.
Now it's time for action
An action is the event an automation performs after it is triggered. Say you want to send a Slack message any time you receive a Facebook lead—the action would be "send a Slack message.
And that's it! You've just created a Zap.
A Zap is an automated workflow—consisting of a trigger and one or more actions—that connects your apps.
Connect Clockwork Recruiting and Google Sheets to integrate crucial parts of your business
With Zapier, you can integrate everything from basic data entry to end-to-end processes. Here are some of the business-critical workflows that people automate with Zapier.
Automate your lead management and improve conversions
With Zapier, you can automate every part of your lead funnel and give yourself the best chance at converting leads. Automate everything from lead capture to outreach to reporting—and close more deals as a result.
Connect your tools and unlock the power of automation
With Zapier's 6,000 integrations, you can unify your tools within a connected system to improve your team's efficiency and deepen their impact.
Choose a Trigger
Start here
Start here
Choose an Action
Supported triggers and actions
Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.
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 appPerson IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProject IDRequired
Project Client IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProject IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appTag IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier 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.TitleRequired
Spreadsheet to Copy
Headers
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.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
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
Bottom-Up
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
Bottom-Up
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 appPerson IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProject IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProject IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSchool IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appLimit
Offset
q
Sort
Begin Time
End Time
LinkedIn Url
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 ZapScheduledZapier checks for new data every 15 min on the Free planDrive
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 To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
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
Text Bold
Text Italic
Text 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
Bottom-Up
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
Headers
Overwrite?
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
Zapier's blog offers the low-down on automating Google Sheets
Related categories
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.