Generate cash flow forecasting reports daily in Google Sheets

• Automate daily cash flow forecasting for finance teams
• Integrate accounting data with Google Sheets for real-time reporting
• Notify treasury teams of cash flow updates via Slack

Triggers daily at 06:00 UTC using a cron job Fetches open accounts payable and receivable data from accounting software Retrieves current bank balance from banking software Calculates 13-week cash flow forecast based on fetched data Writes forecast results to Google Sheets Sends notification to Slack channel about updated cash flow forecast

1. 1
   Import the workflow template into n8n
2. 2
   Set up authentication credentials for Google Sheets and accounting software
3. 3
   Configure the Slack channel for notifications
4. 4
   Test the workflow to ensure data fetching and writing functions correctly