This template starts when Deputy saves a timesheet, maps employee, date, hours, and location in JavaScript, and appends a row in Google Sheets.
Use it so payroll and team hours live in a sheet without exporting from Deputy. Connect Deputy and Google Sheets. Watch new timesheets on the workplace you connect.
Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.
Full pricing — how CPU seconds work →Workflow preview
The scenario starts when Deputy saves a timesheet in the workplace you connect.
JavaScript reads employee name, date, hours, and location from the Deputy payload.
Google Sheets adds a row with those fields for payroll or team metrics.
Add a Deputy connection with access to the workplace. Add a trigger for new timesheets saved.
Add a Google Sheets connection. Use a sheet with columns for employee, date, hours, location, and timesheet id.
In JavaScript, flatten the Deputy payload into those columns, then append a Google Sheets row. Include the timesheet id so later reviews can match the Deputy record. Save a test timesheet and confirm the row.
FAQ
More templates
This template watches a Notion database for new pages, reads the title and properties, and creates a Google Doc from that text. Use it when a database row should become a shareable document. Connect Notion and Google Docs, then point the trigger at the database you want to watch.
This template starts on a new Google Form response, then creates a Google Doc from the template you pick and replaces placeholders with the answers. Use it for intake letters, briefs, or certificates that should match each submission. Connect Google Forms and Google Docs, then point the trigger at the form and the Docs step at the template.
This template receives Kartra calendar bookings on a Latenode webhook, maps name, email, and slot time in JavaScript, and appends a row in Google Sheets. Paste the webhook URL into Kartra. If the payload is only an id, use that JavaScript node to call the Kartra API and put the Kartra API key in that node. Connect Google Sheets and point add-row at the spreadsheet that stores leads.
