Create absences in Out of Office Assistant for Jira from new Google Sheets rows
Do you keep track of your team's vacation on a shared Google Sheets spreadsheet? This Zapier template will create absences in Jira, sending out of office messages to your collaborators and appointing a coverer for all your incoming issues. Enjoy your time off!
Do you keep track of your team's vacation on a shared Google Sheets spreadsheet? This Zapier template will create absences in Jira, sending out of office messages to your collaborators and appointing a coverer for all your incoming issues. Enjoy your time off!
- When this happens...New Spreadsheet Row (Team Drive)
Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.
- automatically do this!Add or Update Absence
Adds a Jira Out of Office Rule, defining when the current user is out of office and (optional) auto assign one or more coverers.
- 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?