Automate Gmail Reference Parsing with Easybits & Google Sheets

Streamline Gmail Reference Parsing with Easybits & Google Sheets

Unleash the power of automation with our n8n workflow designed to handle your reference-check emails efficiently. Automatically monitor your Gmail for reference letters, extract key information, analyze sentiment, and effortlessly log these insights in Google Sheets—all without missing a beat.

What this workflow does

• Triggers every minute to monitor a specific Gmail label for incoming reference-check emails and downloads the attachments.
• Filters through attachments to retain only essential files (PDF/JPG/PNG/TIFF) and discards non-relevant logos or signatures.
• Sends worthy attachments to the easybits Extractor, which pulls crucial structured fields like candidate name, strengths, weaknesses, and rehire potential.
• Normalizes the extracted data into a consistent format and calculates a precise 0–100 sentiment score, categorizing it into high, mid, or low tiers.
• Adds a new row in a designated Google Sheets “References” tab, complete with the processed data, sentiment score, and timestamp for easy tracking.
• Efficiently relabels the processed email in Gmail to ensure that double-processing is never a concern.

Use cases

• Human Resources Departments: Automate the tedious task of gathering and analyzing reference checks, allowing HR professionals to focus on strategic initiatives.
• Recruitment Agencies: Quickly and accurately process multiple candidate references, ensuring that you select the best talent.
• SaaS Operations: Use consistent datasets to drive automated reporting and decision-making processes.

Technical details

• Integrations: Gmail, Google Sheets, easybits Extractor
• Nodes used: Code, Gmail, Filter, Sticky Note, Gmail Trigger, Google Sheets

This workflow is tailored for n8n users, automation engineers, and SaaS operators looking to enhance their Gmail and Google Sheets automation processes. Experience a seamless integration that optimizes your reference processing tasks and boosts your operational efficiency.