CV Scanning
Screen, summarize, and score job applicants automatically as applications arrive.
When a Google Forms response is submitted, downloads the attached CV PDF from Google Drive, extracts its text, and summarizes it with AI. OpenAI scores the candidate from 0 to 10 against a Senior Java Developer job description. The name, email, summary, and score are recorded in a Google Sheet, and the CV file is filed into a Rejected or Potential candidates Google Drive folder based on the score.
- Google Forms submission trigger
- PDF text extraction from the uploaded CV
- AI structured summary of the CV
- AI candidate scoring against a job description
- Results logged to Google Sheets
- Condition-based file sorting into Google Drive folders
- Google Forms connection
- Google Drive connection with the Rejected and Potential candidate folders
- OpenAI API key
- Google Sheets connection with the target spreadsheet
Recruiters and hiring teams that want to pre-screen and triage incoming job applications automatically.
- Trigger: a Google Forms response is submitted.
- Download the candidate's CV PDF from Google Drive.
- Extract text from the PDF.
- Summarize the CV text with AI.
- Score the candidate from 0 to 10 against the job description with OpenAI.
- Record the name, email, summary, and score in a Google Sheet.
- Condition: if the score is 0, file the CV in Rejected Candidates; otherwise in Potential Candidates.
MoreAITemplates
Polls Gmail for new emails and uses OpenAI to classify each one into a single department label (Sales, Support, Finance, Operations, HR, or URGENT). The matching Gmail label is applied, the department's recipient address is stored, and the original email is forwarded to the correct team.
Lists all files in a local documentation directory recursively, then loops over each file, reads its contents, and loads it into a Pinecone vector database as a Markdown document, building a searchable knowledge base for retrieval-augmented generation.
This workflow prompts OpenAI for an inspirational quote on weekdays and a joke on the weekends. The quote is enriched with some context. Afterwards, the joke or the quote is sent via email.