Convert Bank Statements to Markdown Using Gemini AI
Workflow Description
Automate the extraction of bank statement data from PDFs or images, process them through Gemini AI to convert into organized Markdown tables, and save or share results across Google Drive and social platforms.
How it works
- 1.Trigger the workflow manually and upload your bank statement file
- 2.Process the document with Gemini to extract transactions and balances
- 3.Sort and format the extracted data into Markdown tables
- 4.Compress files and store them in Google Drive
- 5.Publish results to Twitter/X or other communication channels
Use cases
- Archive monthly bank statements in searchable, standardized format
- Generate financial reports automatically from source documents
- Simplify sharing financial data with team members in consistent format
Requirements
- Google account with Google Drive access permissions
- Gemini API key from Google Cloud Console
- Bank statement files in PDF or clear image format
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (20)
When clicking ‘Test workflow’
Manual Trigger
Google Gemini Chat Model
Gemini Model
Sort Pages
Sort
Sticky Note
Sticky Note
Get Bank Statement
Google Drive
Split PDF into Images
HTTP Request
Extract Zip File
Compression
Images To List
Code
Resize Images For AI
Edit Image
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Google Gemini Chat Model1
Gemini Model
Sticky Note4
Sticky Note
Sticky Note6
Sticky Note
Combine All Pages
Aggregate
Sticky Note5
Sticky Note
Extract All Deposit Table Rows
Information Extractor
Sticky Note7
Sticky Note
Transcribe to Markdown
LLM Chain