How to Automate Quarterly Earnings Trend Reports to Google Docs?
Description
Make resume screening fast and consistent. When a new PDF resume lands in a Google Drive folder, the system reads it, compares it to your job description, and makes a clear decision. It files the resume, updates your tracker, and sends an email, so hiring moves without delays.
Here is how it works. A Google Drive event checks a specific folder for new files every hour. The resume is downloaded and the text is extracted. The job description is pulled from a Google Docs link. An AI Agent using a Groq model compares both and decides Rejected, Keep in View, or Shortlisted. Based on that choice, the agent moves the file to the right folder, updates a Google Sheets tracker with status and score, and sends a Gmail message created by the AI.
Setup needs Google Drive, Google Docs, Google Sheets, Gmail, and a Groq API key. You point the nodes to your folders, doc URL, and tracker sheet. Teams can expect major time savings, faster replies to candidates, and consistent scoring for high volume roles like internships, support, or engineering hires.
Tools Required
What this workflow does?
- Google Drive trigger watches an Unfiltered folder and runs every hour when a new file appears.
- Downloads the resume and extracts text from PDF for analysis.
- Fetches the job description from a specific Google Docs URL.
- AI Agent powered by a Groq model compares resume and job needs and picks Rejected, KIV, or Shortlisted.
- Moves the resume into the correct folder based on the AI decision.
- Updates a Google Sheets tracker with status, score, and notes.
- Sends a Gmail notification with an AI generated subject and message.
- Adjustable prompt so you can tune scoring and decision rules.
What are the benefits?
- Reduce manual screening from 60 minutes to about 2 minutes per resume
- Automate around 90 percent of sorting, tracking, and emails
- Improve tracker accuracy by reducing data entry errors by 95 percent
- Handle up to 10 times more resumes with the same team
- Connect Google Drive, Google Docs, Google Sheets, Gmail, and AI in one flow
- Speed up candidate replies with same day notifications
How to set this up?
- Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
- You'll need accounts with Google Drive, Google Docs, Google Sheets, Gmail and Groq. See the Tools Required section above for links to create accounts with these services.
- Create four Google Drive folders: Unfiltered, Shortlisted, KIV, and Rejected. Copy each folder ID from the URL and keep them handy.
- Open the Google Drive trigger node. Set it to watch the Unfiltered folder ID and confirm the polling time is every hour. Save the node.
- Open the Google Docs node and paste your job description document URL. Make sure the doc is shared so the connected account can read it.
- Connect credentials: double click each Google node and in the Credential to connect with dropdown click Create new credential. Pick the correct service (Google Drive OAuth2, Google Docs OAuth2, Google Sheets OAuth2, Gmail OAuth2) and follow the on screen steps. Name them clearly, for example HR Drive Prod.
- Set up the Google Sheets tool node. Choose your tracker spreadsheet and sheet. Map fields like candidate name, email, role, status, score, and notes to the columns you use.
- Open each Move to folder node and paste the correct destination folder ID for Shortlisted, KIV, and Rejected.
- Connect Groq: double click the Groq language model node. In the credentials dropdown click Create new credential. Visit the Groq website API page, create an API key, and paste it into n8n. Save.
- Review the AI Agent system prompt. Adjust scoring rules, keywords, and decision thresholds to fit your role and seniority level.
- Run a test: upload a sample PDF resume into the Unfiltered folder. Wait for the poll or click Execute workflow. Check that the file moved, the sheet updated, and an email was sent.
- Validate access: if files do not move, confirm the connected Google account has edit rights on the folders. If the sheet does not update, verify sheet sharing and column names.
- Troubleshoot parsing: if text is empty, ensure the resume is a readable PDF. Try exporting the file again or enable OCR in your PDF tool before upload.
- Adjust cadence: if you need faster intake, reduce the polling interval in the Google Drive trigger while watching API limits.
Need help or want to customize this?
Ask in the Futurise Pro Community.
Similar Templates
These templates were sourced from publicly available materials across the web, including n8n’s official website, YouTube and public GitHub repositories. We have consolidated and categorized them for easy search and filtering, and supplemented them with links to integrations, step-by-step setup instructions, and personalized support in the Futurise community. Content in this library is provided for education, evaluation and internal use. Users are responsible for checking and complying with the license terms with the author of the templates before commercial use or redistribution.Where an original author was identified, attribution has been provided. Some templates did not include author information. If you know who created this template, please let us know so we can add the appropriate credit and reference link. If you are the author and would like this template removed from the library, email us at info@futurise.com and we will remove it promptly.
