Skip to content
FlowHub
FluxonLab
Finance & Accountingfree

OpenAI, Google Sheets & Google Drive Automation

by DIGITAL BIZ TECHUpdated Aug 2026
RequiresOpenAIGoogle SheetsGoogle SheetsGoogle DriveGoogle Drive
Share Post Share
Gmail TriggerCoSplit Binary AttachmentsSplit Binary At…SILoop: Process Each AttachmentLoop: Process E…Extract Timesheet Data (OpenAI)Extract Timeshe…Get Customer Info From PO SheetGet Customer In…SeSet Invoice Date & Due Date DaysSet Invoice Dat…SeGenerate Sheet Name (Employee + Week Start to End Dates)Generate Sheet …SeSet: Invoice RangeSet: Invoice Ra…IfIf: File Already Exists?If: File Alread…IfIf: Invoice Range is 15 Days?If: Invoice Ran…SeSet: File Name from Start & End Based Date RangeSet: File Name …MeMerge: Combine Folder Search ResultsMerge: Combine …Create New SheetMove Created Sheet to Final FolderMove Created Sh…SeSet: Row DataSheets: Append RowSheets: Append …Sheets: Final AppendSheets: Final A…Sheets: Create SheetSheets: Create …Sheets: Append Row1Sheets: Append …HRExtract Text from AttachmentExtract Text fr…Search: Client Invoices FolderSearch: Client …Search: Client Folder by NameSearch: Client …Search: File By Start Date NameSearch: File By…Search: File By End Date NameSearch: File By…Drive: Move Sheet To Final FolderDrive: Move She…SeSet: Empty Row StructureSet: Empty Row …SeSet: Spreadsheet (ID & Name)Set: Spreadshee…Append: Final Row to Existing SheetAppend: Final R…IfCheck if Year Folder ExistsCheck if Year F…Create Client Name FolderCreate Client N…IfCheck Client Name FolderCheck Client Na…Search: Employee Name FolderSearch: Employe…IfCheck Employee Name FolderCheck Employee …Create Employee Name FolderCreate Employee…Search: Year FolderSearch: Year Fo…Create Year FolderCreate Year Fol…Create Current Year FolderCreate Current …SeSet Timesheet JSON FieldsSet Timesheet J…HRHTTP Request(new sheet)HTTP Request(ne…HRHTTP Request1(create sheet)HTTP Request1(c…
1/5
STEPS · 46
Starts on a Gmail event

On a new Gmail email, processes attachments in batches through OpenAI, logs results to Google Sheets, and archives files to Google Drive.

Tags

eventadvancedOpenAIGoogle SheetsInvoice ProcessingAI Summarization
Connects
OpenAIsheetsGoogle SheetsgoogledriveGoogle Drive
CategoryFinance & Accounting
Triggerevent
Complexityadvanced
Nodes40
AddedJun 14, 2026