Automate timesheet to invoice conversion with OpenAI, Gmail & Google Workspace
Gmail Trigger
Split Binary Attachments
Loop: Process Each Attachment
noOp
Extract Timesheet Data (OpenAI)
openai
Get Customer Info From PO Sheet
googleSheets
Set Invoice Date & Due Date Days
Generate Sheet Name (Employee + Week Start to End Dates)
Set: Invoice Range
If: File Already Exists?
If: Invoice Range is 15 Days?
Set: File Name from Start & End Based Date Range
Merge: Combine Folder Search Results
Create New Sheet
googleSheets
Move Created Sheet to Final Folder
googleDrive
Set: Row Data
Sheets: Append Row
googleSheets
Sheets: Final Append
googleSheets
Sheets: Create Sheet
googleSheets
Sheets: Append Row1
googleSheets
Extract Text from Attachment
universal-file-to-text-extractor.vercel.app
Search: Client Invoices Folder
googleDrive
Search: Client Folder by Name
googleDrive
Search: File By Start Date Name
googleDrive
Search: File By End Date Name
googleDrive
Drive: Move Sheet To Final Folder
googleDrive
Set: Empty Row Structure
Set: Spreadsheet (ID & Name)
Append: Final Row to Existing Sheet
googleSheets
Check if Year Folder Exists
Create Client Name Folder
googleDrive
Check Client Name Folder
Search: Employee Name Folder
googleDrive
Check Employee Name Folder
Create Employee Name Folder
googleDrive
Search: Year Folder
googleDrive
Create Year Folder
googleDrive
Create Current Year Folder
googleDrive
Set Timesheet JSON Fields
HTTP Request(new sheet)
HTTP Request1(create sheet)
Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.