Automate Timesheet to Invoice Conversion with OpenAI, Gmail & Google Workspace

About

This workflow converts emailed timesheets into structured invoice rows in Google Sheets and stores them in the correct Google Drive folder structure. It: Listens to Gmail for timesheet attachments Runs OCR and AI parsing Looks up Customer and PO data from a Google Sheet Organizes files in Client → Employee → Year folders Reuses an existing invoice sheet or creates a new one and writes the invoice row Quick Implementation Steps Import the workflow JSON into your n8n instance. Set