How acc-tax-reighteen/email-claim-sender-attch-shell works
This is a small Python automation tool for sending one Shell claim email per invoice. The user supplies an Excel workbook and invoice PDFs, then runs the entry point: it stages the files, extracts the “Isian” sheet, and starts the sender. The sender reads configuration and invoice rows, matches each invoice to a PDF, builds an HTML email, and sends it through Gmail SMTP. Cleanup is performed by the entry point. Connections reflect the excerpts and README; unsampled behavior is not assumed.
Main entry points: Jalankan Sender.py Pipeline runner · 2_GmailSender.py Invoice sender · Dapur Staged files · 1_EkstrakData.py Sheet extractor
Components 11
Orchestration
- Claim workbook
Surat Saffiela - 130326.xlsm - Invoice PDFs
- Pipeline runner
Jalankan Sender.py
Data preparation
- Staged files
Dapur - Sheet extractor
Dapur/1_EkstrakData.py - Temporary workbook
Dapur
Email delivery
- Email configuration
Dapur/config.conf - Invoice sender
Dapur/2_GmailSender.py - Email composer
Dapur/2_GmailSender.py - Gmail SMTP
Other components
- Operator
Connections 14
- Operator → Pipeline runner: runs
README.md - Claim workbook → Pipeline runner: provides workbook
README.md - Invoice PDFs → Pipeline runner: provides attachments
README.md - Pipeline runner → Staged files: copies inputs
Jalankan Sender.py - Pipeline runner → Staged files: cleans files
Jalankan Sender.py - Pipeline runner → Sheet extractor: runs
Jalankan Sender.py - Pipeline runner → Invoice sender: runs
Jalankan Sender.py - Staged files → Sheet extractor: provides workbook
Dapur/1_EkstrakData.py - Sheet extractor → Temporary workbook: writes
Dapur/1_EkstrakData.py - Temporary workbook → Invoice sender: provides invoice rows
Dapur/2_GmailSender.py - Email configuration → Invoice sender: provides settings
Dapur/2_GmailSender.py - Invoice sender → Staged files: matches PDFs
Dapur/2_GmailSender.py - Invoice sender → Email composer: provides invoice data
Dapur/2_GmailSender.py - Email composer → Gmail SMTP: sends messages
Dapur/2_GmailSender.py