Turn Fireflies meeting transcripts into ClickUp tasks, Sheets logs, Gmail and Slack alerts with OpenAI

Description

Quick overview
This workflow collects freelancer applications via an n8n Form, uses OpenAI to extract structured signals and generate a hiring recommendation, calculates a deterministic suitability score, logs each submission to Google Sheets, and sends the appropriate Gmail responses to the applicant and your hiring team.

How it works
Receives a freelancer submission through an n8n Form with contact details, role, experience, skills, portfolio/work samples, pitch, and optional rate.
Uses OpenAI to extract structured assessment data such as matched/missing required skills, numeric years of experience, portfolio score, red flags, strengths, and notes.
Calculates a deterministic suitability score and tier from the extracted skills match, portfolio score, experience, and red-flag penalty.
Uses OpenAI again to turn the score and extracted data into a recommendation (Shortlist, Trial Project, or Decline) with reasoning, next step, and confidence.
Appends the full application record (scores, tier, and recommendation) to a Google Sheets “Applications” tab.
If the recommendation is Shortlist, sends an interview invite to the applicant via Gmail; otherwise, emails your hiring team a review summary and sends the applicant a status update.

Setup
Add an OpenAI API credential and connect it to the two OpenAI chat model nodes.
Create a Google Sheet with a tab named “Applications” and add Google Sheets OAuth2 credentials, then set the Sheet ID in the configuration values.
Add Gmail OAuth2 credentials for sending emails and set your hiring team email, company name, sender name, role title, and required skills in the configuration values.
Activate the workflow and share the n8n Form URL so applicants can submit applications.