AI Resume Parsing and Client Usage Billing Tracking

This workflow provides AI-driven resume parsing services, capable of automatically converting uploaded PDF resumes into structured JSON format, thereby enhancing data processing efficiency. At the same time, the system accurately tracks each client's token usage and associated costs in the AI service, recording this information in Google Sheets for transparent billing. It automatically summarizes client data each month and generates electronic invoices, greatly simplifying the financial management process, making it suitable for various scenarios such as human resources, recruitment, and finance teams.

Tags

Resume ParsingClient Billing

Workflow Name

AI Resume Parsing and Client Usage Billing Tracking

Key Features and Highlights

This workflow offers a comprehensive AI-driven service for uploading and parsing resume (CV) PDF files. It automatically extracts the content from uploaded resumes and structures it into JSON format for easy downstream processing. Additionally, it leverages a custom Langchain Code node to capture token usage and cost metadata for each AI call, automatically logging this data into Google Sheets. This enables precise client usage billing and cost tracking. At the end of each month, the workflow aggregates client usage data and generates electronic invoices, facilitating financial automation.

Core Problems Addressed

  • Automates conversion of resume PDFs into structured data, significantly improving manual processing efficiency.
  • Accurately tracks token consumption and corresponding costs per client, ensuring transparent multi-client billing.
  • Eliminates complex dependencies by integrating custom subnodes with Google Sheets, enabling low-barrier usage and cost monitoring.
  • Automatically summarizes and sends monthly invoices, reducing manual accounting and invoicing workload.

Use Cases

  • Automated resume data processing for HR and recruitment platforms.
  • SaaS providers offering AI data extraction APIs, implementing client usage-based billing.
  • Enterprises or teams requiring client billing based on AI call costs.
  • Multi-client systems aiming for transparent management of AI service calls and associated expenses.

Main Workflow Steps

  1. Form Submission Trigger: Clients upload resume PDFs via an n8n form and acknowledge the billing terms.
  2. PDF Parsing: Extract text content from the uploaded PDF files.
  3. Variable Assignment: Set workflow ID, execution ID, client ID, and other logging attributes.
  4. Custom LLM Subnode Invocation: Use the OpenAI GPT-4o-mini model to parse text into structured JSON while capturing token usage metadata.
  5. Resume Data Extraction: Extract detailed resume information based on a predefined JSON schema.
  6. Result Display: Return the parsed JSON data to the uploading user.
  7. Usage Data Logging: Append token usage and cost data to Google Sheets.
  8. Monthly Scheduled Trigger: At month-end, filter client usage records from Google Sheets.
  9. Data Aggregation: Summarize total tokens used and costs for the month.
  10. Automated Invoice Sending: Email detailed monthly invoices to clients via Gmail.

Systems and Services Involved

  • n8n Form Trigger: Provides file upload and user interaction interface.
  • OpenAI GPT-4o-mini Model: Language model for extracting resume information.
  • Langchain Code Node: Custom code node for tracking token usage and calculating costs.
  • Google Sheets: Storage for client usage logs and billing data.
  • Gmail: Automated dispatch of monthly client invoices.

Target Users and Value Proposition

  • AI Service Providers: Precisely track client token usage and costs to support flexible billing and cost control.
  • Recruitment Firms and HR Teams: Rapidly convert large volumes of resumes into structured data for easier screening and management.
  • Finance and Operations Teams: Automate client usage aggregation and invoice generation, reducing manual effort.
  • Technical Teams and Developers: Demonstrate how to combine n8n with Langchain code nodes for advanced AI call monitoring and billing management.

This workflow is exclusively compatible with the self-hosted version of n8n, as the Langchain Code node is a self-hosted feature. By integrating AI parsing with cloud spreadsheet storage, it achieves seamless automation of resume parsing and cost tracking, greatly enhancing operational efficiency and transparency. You are welcome to explore the example Google Sheets log here: Client Usage Log for detailed data insights.

Recommend Templates

Automated Work Attendance with Location Triggers

This workflow utilizes iPhone shortcuts and Webhooks to achieve location-based automated attendance management. Users can easily clock in and out using their phones, while the system automatically detects and creates Google Sheets documents to record check-in and check-out times, eliminating issues of missed clock-ins and cumbersome data entry. It is suitable for remote work, freelancers, and on-site staff, enhancing attendance accuracy and management efficiency, simplifying the attendance process, and providing a paperless smart office experience.

Auto AttendanceLocation Trigger

AI Agent - CV Resume - Automated Screening, Sorting, Rating and Tracker System

This workflow automates the processing of resume screening, classification, scoring, and status tracking through AI intelligent agents and automation tools. The system can parse candidates' PDF resumes in real time and match them with job descriptions, automatically archiving resumes into the corresponding folders based on scores, while also updating the candidate tracking sheet and sending email notifications. This significantly enhances recruitment efficiency, reduces manual intervention and subjective bias, making it highly suitable for the needs of human resources departments in bulk resume processing.

Smart Resume ScreeningRecruitment Automation

HR-Focused Automation Pipeline with AI

This workflow achieves comprehensive automation of the recruitment process through AI technology. Resumes submitted by candidates are automatically parsed, extracting key information such as educational background, work experience, and skills, and generating a concise candidate summary. The system intelligently matches candidate information with job requirements, providing a matching score and detailed comments. Ultimately, the results are structured and stored in Google Sheets for easy management and analysis. This process significantly enhances recruitment efficiency and reduces the error rate of manual operations.

Smart RecruitingResume Automation

HN Who is Hiring Scrape

This workflow automates the extraction of job postings from the "Who is hiring?" section on Hacker News. It precisely locates relevant posts using the Algolia Search API and retrieves detailed content through the official Hacker News API. The raw text is intelligently parsed using the OpenAI GPT-4o-mini model to generate structured job data, which is then stored in Airtable for easy management. This process significantly improves the efficiency of obtaining job information and addresses the issues of data fragmentation and inconsistent formatting, making it suitable for technical recruiters and data analysts.

Job ScrapingStructured Data

HR & IT Helpdesk Chatbot with Audio Transcription

This workflow creates an intelligent chatbot specifically designed for HR and IT service desks, supporting both text and voice interactions. It features audio transcription capabilities, converting employees' voice inquiries into text in real-time, and builds a knowledge base by analyzing internal policy documents to enable quick and accurate responses. By integrating advanced language models and vector databases, the chatbot can continuously remember the context of conversations, providing personalized support, effectively reducing the pressure on human customer service representatives, and enhancing the user experience.

Intelligent Q&ASpeech Transcription

Send Daily Birthday Reminders from Google Contacts to Slack

This workflow automatically extracts contact information for birthdays occurring on the current day from Google Contacts every day and sends birthday reminders via Slack, ensuring that important birthdays are not forgotten. By utilizing scheduled triggers and filtering functions, it simplifies the process of sending birthday wishes, enhancing the atmosphere of care within the team and improving personal social efficiency. It is suitable for corporate teams or individual users and helps strengthen team cohesion and customer relationship management.

Birthday ReminderAutomated Alerts

Create, Update, and Retrieve a Contact in Google Contacts

This workflow enables the automatic creation, updating, and retrieval of contacts in Google Contacts, greatly simplifying the contact management process. Users can complete the addition of new contacts, information updates, and data queries in one simple operation, enhancing work efficiency and information accuracy. It is particularly suitable for businesses, marketers, and customer service teams, helping them efficiently maintain contact information for clients and partners, while addressing the cumbersome and error-prone issues of traditional management methods.

Google ContactsContact Management

Interviewer Information and Employee Profile Data Merging Workflow

The main function of this workflow is to intelligently match and merge interviewer information with employee profile data, achieving automatic conversion of data formats and ensuring precise association based on a unique ID. Through the merging operation, the system can effectively reduce the workload of manual comparisons, enhancing data consistency and accuracy. It is suitable for human resource management and recruitment process automation, helping enterprises quickly integrate and manage personnel information, thereby improving data quality and management efficiency.

Data MergeHuman Resources