Automate PDF to CSV for DATEV Cashbook via Google Drive & Gmail

Streamline Your DATEV Cashbook Entries with Automated PDF to CSV Conversion

Effortlessly convert and organize your openFiskal Shopify POS Z-Bon PDF reports into DATEV Kassenbuch-compatible CSV files and have them delivered straight to your inbox. Our seamless automation workflow leverages Google Drive and Gmail to eliminate the manual labor from your financial reporting process.

What This Workflow Does

• Initiate with Ease: Manually trigger the workflow for your desired monthly export.
• File Management: Retrieve all PDF files from a designated Google Drive folder.
• Text Extraction: Download PDFs, extract text, and parse critical details including Z-Bon date, number, cash and card sales, withdrawals, deposits, and refunds.
• Data Aggregation: Accumulate results from relevant PDFs while ignoring non-contributory documents.
• CSV Generation: Compile DATEV Kassenbuch CSV files with detailed VAT rate lines and an offsetting negative "card transit" line.
• Email Delivery: Convert the CSV into a file and send it as an attachment via Gmail to the specified recipient.

Use Cases

• Accountants and Financial Analysts: Automate the export and conversion of Z-Bon reports for hassle-free DATEV Kassenbuch entries.
• SaaS Operators: Integrate report handling directly into your existing workflows, reducing manual input errors and saving time.
• Automation Engineers: Utilize a robust workflow to streamline financial document processing, ensuring accuracy and efficiency.

Technical Details

• Integrations: Google Drive for file management, Gmail for email delivery.
• Nodes Used: set, code, gmail, read pdf, sticky note, Google Drive.
• Setup Requirements: OAuth2 credentials for Google Drive and Gmail, specify folder ID, email recipient, subject prefix, card processor label, and VAT rates during configuration.

Unlock the potential of automated financial reporting with this specialized n8n workflow designed for precision and convenience.