Create and assign Buddy Punch department codes from new Google Sheets rows
Have you ever wanted to create department codes from an outside source? Now you can, just by creating Google Sheets rows. This integration automatically assigns all employees to the codes you create, as soon as you add a new row to a specified spreadsheet in your Google Sheets account!
Have you ever wanted to create department codes from an outside source? Now you can, just by creating Google Sheets rows. This integration automatically assigns all employees to the codes you create, as soon as you add a new row to a specified spreadsheet in your Google Sheets account!
- When this happens...New Spreadsheet Row
Triggers when a new row is added to the bottom of a spreadsheet.
- automatically do this...Create Department Code
Creates a new department code.
- then do this...Find Employee
Finds an existing employee.
- then do this!Assign Employee to Department Code
Assigns an employee to a department code.
- Free forever for core features
- 14 day trial for premium features & apps
Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItDrive
Try ItDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItDrive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
Dont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItDrive
SpreadsheetRequired
Try ItDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?