Airtable + Deputy

Create Deputy employees from new Airtable records

Manage your team operations more efficiently with this workflow. Whenever there's a new record in your Airtable app, it will immediately create an employee in Deputy. This means you save valuable time and reduce repetitive tasks, ensuring your workforce information is always accurate and up-to-date.

When this happens...
New Record
Triggers when a new record is created. Optionally: triggers when any record (new or existing) is first added to a selected view.
TriggerScheduled
automatically do this!
Create Employee
Creates a new staff member.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

- BaseRequired
- TableRequired
- Limit to View
- Include file contents?
Trigger
Scheduled
Try It
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- Lookup FieldRequired
- Secondary Lookup Field
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
Action
Search

- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
Action
Search or write
New Area/Department
Triggers when there is a new area or department created.
Trigger
Scheduled
Try It

New My Schedule
Triggers when there is a new schedule for me.
Trigger
Scheduled
Try It
New Area
Triggers when there is a new area in the Deputy install.
Trigger
Scheduled
Try It
New Location
Triggers when there is a new location or company.
Trigger
Scheduled
Try It
Forgot to End Shift (Timesheet Incomplete)
Triggers when a timesheet needs to be completed, because an employee has forgotten to end their shift.
Trigger
Scheduled
Try It
New Leave
Triggers when a new Leave request is submitted
Trigger
Scheduled
Try It
New Role
Triggers when New Role/Persmission set.
Trigger
Scheduled
Try It
Get New Timesheets
Lists all the new timesheets
Trigger
Scheduled
Try It
- Workplace NameRequired
- Workplace Code
- Location AddressRequired
- Address Notes
- Payroll Export code
- Timezone
Action
Write
- LocationRequired
- NameRequired
- Payroll Export Code
Action
Write
- Start of UnavailabilityRequired
- End of UnavailabilityRequired
- Comment about Unavailability
Action
Write
- Area/DepartmentRequired
- Time of the saleRequired
- Sales ReferenceRequired
- Sales QuantityRequired
- Sales Type
- Sales AmountRequired
- Employee
Action
Write
- Work AreaRequired
- EmployeeRequired
Action
Write

- BaseRequired
- TableRequired
- Help Text
- Which timestamp field should this Zap use to check for updates?Required
- Limit to View
- Include file contents?
Trigger
Scheduled
Try It
- Cache Copy
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
- Include file contents?
Action
Search
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
- Include file contents?
Action
Search or write
New Colleague
Triggers when a new individual is added to your workplace, you can see them here. This is subject to you have workplace visibility.
Trigger
Scheduled
Try It
New Post
Triggers when a new newsfeed post arrives.
Trigger
Scheduled
Try It
New My Timesheet
Triggers when there is a new timesheet that has been saved for me.
Trigger
Scheduled
Try It
- EventRequired
Trigger
Scheduled
Try It
New Employee
Triggers when there is a new employee created.
Trigger
Scheduled
Try It
New Late Employee
Triggers when someone is late to start their shift.
Trigger
Scheduled
Try It
New Notification
Triggers when there is a new notification for you.
Trigger
Scheduled
Try It
New Schedule
Triggers when there is a new schedule
Trigger
Scheduled
Try It
- Role
- CompanyRequired
- First NameRequired
- Last NameRequired
- Email AddressRequired
- Mobile Phone
- Whether to send an inviteRequired
Action
Write
- Location
- Employees
- MessageRequired
Action
Write
- Start TimestampRequired
- End TimestampRequired
- Employee ID
- Publish
- Meal Break Minutes
- Name of the area/department that this is for
- Force Overwrite
- Open
- Comment
- Confirm Status
Action
Write
- Who
- QuestionRequired
- Comment
- Due Date
Action
Write
- TimesheetRequired
- Mealbreak Minutes
Action
Write

About Airtable

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.

Learn more Help

Related categories

Databases

Similar apps

Quickbase

Databases

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

About Deputy

Deputy is an all-in-one employee scheduling, timesheets, tasking and communication platform. Used by thousands of businesses around the world it will improve profitability, staff culture and operational accountability.

Learn more Help

Related categories

Scheduling & Booking

Similar apps

ServiceM8

Scheduling & Booking

Teem

Scheduling & Booking

Streamtime

Project Management

PRODUCTS

CAPABILITIES

By team

Airtable + Deputy

Create Deputy employees from new Airtable records

New Record

TableRequired

Limit to View

Include file contents?

Create Record

BaseRequired

TableRequired

Create or Update Record

BaseRequired

TableRequired

Lookup FieldRequired

Secondary Lookup Field

API Request (Beta)

Api Docs Info

HTTP MethodRequired

URLRequired

Query String Parameters

Headers

Additional Request Headers

Body

Find Record

BaseRequired

TableRequired

Search by Field

Search Value

Search for Exact Match?

Search Formula

Limit to View

Find or Create Record

BaseRequired

TableRequired

Search by Field

Search Value

Search for Exact Match?

Search Formula

Limit to View

New Area/Department

New My Schedule

New Area

New Location

Forgot to End Shift (Timesheet Incomplete)

New Leave

New Role

Get New Timesheets

Create Location

Workplace NameRequired

Workplace Code

Location AddressRequired

Address Notes

Payroll Export code

Timezone

Create Area/Department

LocationRequired

NameRequired

Payroll Export Code

Create My Unavailability

Start of UnavailabilityRequired

End of UnavailabilityRequired

Comment about Unavailability

Create Sales Data

Area/DepartmentRequired

Time of the saleRequired

Sales ReferenceRequired

Sales QuantityRequired

Sales Type

Sales AmountRequired

Employee

Start Shift

Work AreaRequired

EmployeeRequired

New or Updated Record

BaseRequired

TableRequired

Help Text

Which timestamp field should this Zap use to check for updates?Required