Deputy + Smartsheet

Deputy + Smartsheet integrations

Add new timesheets from Deputy to rows in Smartsheet

Save time and stay organized by using this workflow to manage your Deputy timesheets and Smartsheet records. Whenever new timesheets are created in Deputy, this automation instantly adds a new row to your specified Smartsheet sheet with the timesheet information. This streamlined process helps you keep accurate records and effortlessly track work hours in one place.

When this happens...
Get New TimesheetsLists all the new timesheets
TriggerPolling
automatically do this!
Add Row to SheetAdd a row to a sheet.
ActionWrite

Start free with email

Start free with Google

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

More things you can do with Deputy and Smartsheet

Discover other triggers and actions you can use with Deputy and Smartsheet

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
Polling
Try It
New Post
Triggers when a new newsfeed post arrives.
Trigger
Polling
Try It
New My Timesheet
Triggers when there is a new timesheet that has been saved for me.
Trigger
Polling
Try It
New Location
Triggers when there is a new location or company.
Trigger
Polling
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
Polling
Try It

New Leave
Triggers when a new Leave request is submitted
Trigger
Polling
Try It
New Role
Triggers when New Role/Persmission set.
Trigger
Polling
Try It

Get New Timesheets
Lists all the new timesheets
Trigger
Polling
Try It
- Workplace Name
  Required
- Workplace Code
- Location Address
  Required
- Address Notes
- Payroll Export code
- Timezone
Action
Write
- Location
  Required
- Name
  Required
- Payroll Export Code
Action
Write
- Start of Unavailability
  Required
- End of Unavailability
  Required
- Comment about Unavailability
Action
Write
- Area/Department
  Required
- Time of the sale
  Required
- Sales Reference
  Required
- Sales Quantity
  Required
- Sales Type
- Sales Amount
  Required
- Employee
Action
Write
- Work Area
  Required
- Employee
  Required
Action
Write
- Choose a Sheet
  Required
Trigger
Polling
Try It
- Choose a Sheet
  Required
Trigger
Polling
Try It
Updated Row
Triggers when cells in a row are updated or created (based on your settings).
Trigger
Instant
Try It
- Sheet
  Required
- Row
  Required
- File Attachment
  Required
Action
Write
- Choose a Sheet
  Required
- Add Row to Top or Bottom
Action
Write
- Choose Source Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Sheet
  Required
- Column
  Required
- Parent Row
Action
Write
- Destination
  Required
- Sheet to Copy
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write
- Choose a Sheet
  Required
- Row ID
  Required
Action
Write
- Choose a Sheet
  Required
- Email Address(es)
  Required
- Format
  Required
- Email Subject
- Message
- CC Me?
- Paper Size
Action
Write
- Choose a Workspace
  Required
- Email Address(es) to Share To
  Required
- Access Level
  Required
- Notify via Email?
  Required
- Email Subject
- Message
- CC Me?
Action
Write
Find sheet Row (Legacy)
Find a row in a specified sheet using a query.
Action
Write
- Sheet ID
  Required
- Query
  Required
Action
Search

New Area/Department
Triggers when there is a new area or department created.
Trigger
Polling
Try It
New My Schedule
Triggers when there is a new schedule for me.
Trigger
Polling
Try It
- Event
  Required
Trigger
Polling
Try It
New Employee
Triggers when there is a new employee created.
Trigger
Polling
Try It
New Late Employee
Triggers when someone is late to start their shift.
Trigger
Polling
Try It
New Notification
Triggers when there is a new notification for you.
Trigger
Polling
Try It
New Schedule
Triggers when there is a new schedule
Trigger
Polling
Try It
- Role
- Company
  Required
- First Name
  Required
- Last Name
  Required
- Email Address
  Required
- Mobile Phone
- Employee Payroll ID/Number
Action
Write
- Location
- Employees
- Message
  Required
Action
Write
- Start Timestamp
  Required
- End Timestamp
  Required
- Employee ID
- Publish
- Meal Break Minutes
- Name of the area/department that this is for
- Force Overwrite
- Open
- Comment
- Confirm Status
Action
Write
- Who
- Question
  Required
- Comment
- Due Date
Action
Write
- Timesheet
  Required
- Mealbreak Minutes
Action
Write
Get Reports
[PRIVATE] Generates report list for dropdown.
Trigger
Polling
Try It
- Choose a Sheet
  Required
Trigger
Polling
Try It
- Select a Report
  Required
Trigger
Polling
Try It
- Workspace Name
  Required
Action
Write
- Choose a Sheet
  Required
- Row
  Required
- Title
  Required
- Comment
  Required
Action
Write
- Source Folder
  Required
- Destination Folder
  Required
- New Folder Name
  Required
Action
Write
- Workspace
  Required
- New Name
  Required
- What to Include?
- Skip Remap
Action
Write
- Choose Source Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Destination
  Required
- Template
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write
- Choose a Sheet
  Required
- Email Address(es)
  Required
- Choose Row
  Required
- Email Subject
- Message
- CC Me?
- Include Attachments ?
- Include Discussions ?
Action
Write
- Choose a Sheet
  Required
- Email Address(es) to Share To
  Required
- Access Level
  Required
- Notify via Email?
  Required
- Email Subject
- Message
- CC Me?
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Sheet ID
  Required
- Row ID
  Required
Action
Search

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 moreLearn moreHelpHelp

Related categories

Scheduling & Booking

Similar apps

ServiceM8

CRM (Customer Relationship Management)

Teem

Scheduling & Booking

Streamtime

Project Management

About Smartsheet

Smartsheet is a leading cloud-based platform for work execution, enabling teams and organizations to plan, capture, manage, automate, and report on work at scale, resulting in more efficient processes and better business outcomes.

HelpHelp

Related categories

Spreadsheets

Similar apps

MySQL

Databases

Zoho Creator

App Builder, Zoho

Knack

Databases

Related Zap Templates

Add new Deputy schedules to Smartsheet as rows instantly

Related Zap Templates

Add new Deputy schedules to Smartsheet as rows instantly