Icon

Google_​Calendar_​Interview_​Scheduling

Google Calendar Interview Scheduling
3-Read the excel workbook and combine them into a unique tableYou must fill in real email addresses in the data file when you first execute the workflow!The regular expression for the email addresses can be adjusted depending on the context. 1-One-shoot set-up!You need to grant authorisation only once. Those nodes must not be reset. Creates google calendar events for scheduled interviews.Customises the calendar events with a description, names and colouring.Sends invites to unscheduled interviews.Applies formatting to the Excel workbook according to valid email addresses.For more information, see the workflow metadata. Find it here: View -> Description. 2-Input parameters and Access token refreshing 4-Decide if an interview is already scheduled or unscheduled.Add a google calendar event for each unscheduled interview using the customisable information. 5-Save and apply formating to the Excel output. Loop over each rowConcate incommingrowstop: Invite sent: falsebottom: Invite sent: trueConfigure if switchCheck if aninvite is sendalreadyCatch error ifpost request failsStart error handlingCheck if postrequest failedand return errormessageCreate JSON bodyfor calendar eventRead names ofexcel sheetsRead excel sheetAppend allsheetsLoop oversheet namesRemove unnecessarycolumnsConcatenateprocessed interviewswith invalid interviewsChoose outputbehaviourApply changes to xls fileInput your Client IDand Client Secretfrom your GoogleCloud projectDouble-click the component to open the configurationNeed to be manually refreshed (reset) every 60 minCopy-paste the code from the browserafter granting authorisation.Double-click the componentand copy-paste the codeAdds red colorto invalid emailsCopy-paste yourCalendar Id.https://docs.simplecalendar.io/find-google-calendar-id/How to find the calendar id explained above Chunk Loop Start Loop End IF Switch Table Rowto Variable Rule Engine Catch Errors(Data Ports) Try (VariablePorts) End IF Breakpoint Create JSON body Read ExcelSheet Names Excel Reader Loop End (ColumnAppend) Group Loop Start Column Filter Concatenate Single SelectionConfiguration Combine sheets andvalidate emails XLS Formatter(apply) Google AuthenticationCalendar API Access Token Generate RefreshAccess Token Add googlecalendar event Save changes andformat the excel file KNIME Workflow DataArea Connector KNIME Workflow DataArea Connector Calendar Id 3-Read the excel workbook and combine them into a unique tableYou must fill in real email addresses in the data file when you first execute the workflow!The regular expression for the email addresses can be adjusted depending on the context. 1-One-shoot set-up!You need to grant authorisation only once. Those nodes must not be reset. Creates google calendar events for scheduled interviews.Customises the calendar events with a description, names and colouring.Sends invites to unscheduled interviews.Applies formatting to the Excel workbook according to valid email addresses.For more information, see the workflow metadata. Find it here: View -> Description. 2-Input parameters and Access token refreshing 4-Decide if an interview is already scheduled or unscheduled.Add a google calendar event for each unscheduled interview using the customisable information. 5-Save and apply formating to the Excel output. Loop over each rowConcate incommingrowstop: Invite sent: falsebottom: Invite sent: trueConfigure if switchCheck if aninvite is sendalreadyCatch error ifpost request failsStart error handlingCheck if postrequest failedand return errormessageCreate JSON bodyfor calendar eventRead names ofexcel sheetsRead excel sheetAppend allsheetsLoop oversheet namesRemove unnecessarycolumnsConcatenateprocessed interviewswith invalid interviewsChoose outputbehaviourApply changes to xls fileInput your Client IDand Client Secretfrom your GoogleCloud projectDouble-click the component to open the configurationNeed to be manually refreshed (reset) every 60 minCopy-paste the code from the browserafter granting authorisation.Double-click the componentand copy-paste the codeAdds red colorto invalid emailsCopy-paste yourCalendar Id.https://docs.simplecalendar.io/find-google-calendar-id/How to find the calendar id explained above Chunk Loop Start Loop End IF Switch Table Rowto Variable Rule Engine Catch Errors(Data Ports) Try (VariablePorts) End IF Breakpoint Create JSON body Read ExcelSheet Names Excel Reader Loop End (ColumnAppend) Group Loop Start Column Filter Concatenate Single SelectionConfiguration Combine sheets andvalidate emails XLS Formatter(apply) Google AuthenticationCalendar API Access Token Generate RefreshAccess Token Add googlecalendar event Save changes andformat the excel file KNIME Workflow DataArea Connector KNIME Workflow DataArea Connector Calendar Id

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: diego.rodriguez
Created at: 2022-10-13
On NodePit since: 2022-10-24
Last update: 2024-04-26
Created with KNIME version: v4.6.3
Tags: Google Calendar EventExcel_to_KNIMEExcelHRExcel Formatting

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!