Automate Interview Document Creation with Google Workspace
detail.loadingPreview
Streamline your hiring process by automatically creating and naming new interview documents. This workflow triggers when a new interview is scheduled in Google Calendar, finds a template in Google Drive, and duplicates it with a name based on the interview details.
About This Workflow
This n8n workflow revolutionizes your interview process by automating the creation of essential documents. It starts by monitoring your Google Calendar for new events containing "Interview with." Once detected, it filters for specific events to ensure accuracy. The workflow then intelligently searches your Google Drive for a designated "Screening" folder and a specific "Template screening" file. Finally, it duplicates this template, renaming the new file dynamically using information from the calendar event, such as the candidate's name and interview title. This ensures all necessary documentation is ready for each new candidate, saving valuable time and reducing manual errors in your hiring pipeline.
Key Features
- Automated Trigger: Initiates workflow upon new interview scheduling in Google Calendar.
- Intelligent Filtering: Accurately identifies relevant interview events based on customizable criteria.
- Dynamic Document Creation: Duplicates a pre-defined Google Doc template for each interview.
- Customizable Renaming: Automatically names new documents based on event details (e.g., candidate name, interview type).
- Seamless Google Drive Integration: Leverages Google Calendar and Google Drive for a unified workflow.
How To Use
- Set up Credentials: Connect your Google Calendar and Google Drive accounts to n8n.
- Configure Google Calendar Trigger: Set the trigger to monitor for new events, and specify a
matchTermlike "Interview with" to capture relevant events. - Define Event Filtering: Use the 'Filter specific event' node to refine which calendar events should trigger the workflow. You can filter by creator email and source URL, or adapt it to match other event properties like title or attendees.
- Locate Screening Folder: Use the 'Search folder' node in Google Drive to find the specific folder where your interview documents are stored.
- Identify Template File: Employ the 'Search file to duplicate' node to locate your base interview template file within Google Drive. Adjust the
queryStringto match your template's name. - Create and Rename Document: Configure the 'Create and rename Google File' node. Set the
nameparameter to dynamically rename the duplicated file using variables from the Google Calendar event (e.g.,={{ $('Filter specific event').item.json.source.title }}). Ensure thefileIdcorrectly points to the template found in the previous step. - Customize as Needed: Utilize the 'Sticky Note' nodes to understand the workflow's setup and customization options, such as exchanging the Google Calendar trigger with other scheduling tools or refining filtering criteria.
Apps Used
Workflow JSON
{
"id": "e41dd370-e338-4d24-a278-873c5b1d5625",
"name": "Automate Interview Document Creation with Google Workspace",
"nodes": 8,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: e41dd370-e338...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.