GoogleSheetsTool Automate

Target Audience

• Businesses: Companies looking to automate CV parsing and usage tracking for billing purposes.
• Freelancers: Individuals offering document extraction services who need to manage client usage efficiently.
• Data Analysts: Professionals needing structured data from unstructured sources like CVs.
• Developers: Those interested in integrating AI services with Google Sheets for data management and invoicing.

Problem Solved

This workflow addresses the challenge of tracking AI service usage and costs associated with processing CVs. It automates the logging of client interactions, calculates token usage and costs, and generates invoices, ensuring accurate billing and resource management.

Workflow Steps

1. Form Submission: The workflow begins with a form trigger where clients upload CVs in PDF format.
2. PDF Parsing: The uploaded PDF is processed using the Extract From File node to extract text data.
3. Logging Attributes: Key identifiers such as workflow_id, execution_id, and client_id are logged for tracking.
4. Data Extraction: The Extract Resume Data node organizes the parsed data into a structured JSON format.
5. Custom LLM Subnode: A LangChain code node captures token usage metadata from the AI model's response.
6. Client Usage Log: The Client Usage Log node appends the usage metrics to a Google Sheet, including details like input_tokens, output_tokens, and total_cost.
7. End of Month Processing: At the end of each month, the workflow retrieves client logs, filters them for the last month, and calculates total usage and costs.
8. Invoice Generation: Finally, an invoice is sent via Gmail, detailing the usage and total amount due, including a 20% tax.