You can easily download and run the workflow directly in your KNIME installation. We recommend that you use the latest version of the KNIME Analytics Platform for optimal performance.
As you may notice, the workflow nodes are currently not executed (indicated by the red light) because first, you must create an OAuth2 Client ID and enable the Calendar API in the Google Cloud Platform.
Next, in the "Credentials Configuration" node, input the Client ID and Client Secret from your Google Cloud Platform account. These credentials will be passed as a flow variable in the "OAuth2 Authenticator" node.
In the "OAuth2 Authenticator" node, set the Service type as 'Google' and choose "Confidential" as the Client/App type. Then, select the previously generated credentials and define the API call Scope. You can find a list of Google scopes in the 'External resources' section. After this, click the login button to authorize the application to perform actions based on the defined scope on behalf of the login user.
You need the calendar ID in the URL to create the calendar event. We use the String Manipulation (Variable) node to inject the calendar ID into the request URL.
Finally, in the lower branch we create the JSON request body for the calendar event. Set details such as the interviewer and candidate emails, meeting duration (45 minutes), etc. Our example is set up to create a calendar event that spans from the present time to 45 minutes later.
To complete the process in the POST Request node configuration window:
1. Connect the OAuth2 Authenticator port with the POST Request node for authentication.
2. In the first tab, "Connection", configure the request URL.
3. In the "Request body" tab of the POST Request node, pass the JSON request body as a column.
The component contains a Table view that shows the link to the calendar event and other meeting details. You can copy and paste the link to your browser.
This workflow can be expanded to become a more complex data application that helps the company's HR department better manage the interview flow of candidates.
Workflow
Create Google Calendar Event Using OAuth2 Nodes
External resources
Used extensions & nodes
Created with KNIME Analytics Platform version 5.1.0
Legal
By using or downloading the workflow, you agree to our terms and conditions.