Notion ERP: Automation of invoices and payments (Python)
Python
Project Description:
Developed a financial cycle automation system for freelancers and small businesses based on Notion, Python, and Vercel. The solution transforms regular task tables into a powerful accounting tool with bidirectional synchronization and notifications.
What has been implemented:
- One-click invoice generation: The script scans the task database, collects marked items, groups them by projects, and creates a record in the "Invoices" database with a unique UID.
- Telegram reporting: After creating an invoice, the bot sends a structured message (Project -> Task List -> Prices -> Total).
- Smart interface (Formula 2.0): Implemented a dynamic toggle button. It automatically changes the state from "Confirm Payment" to "Reset Payment" depending on the status in the database.
- Payment and archiving automation:
- Upon payment confirmation, the script in one second:
- Sets the status "Paid" for all related tasks.
- Records the payment date.
- Fills in deadlines (if they were empty).
- Moves tasks to the archive.
- Rollback function: The ability to instantly cancel payment and return tasks from the archive to active status.
Technical Stack:
- Backend: Python (Notion SDK).
- Infrastructure: Vercel Serverless Functions (high speed, $0 hosting costs).
- Frontend: Notion API + Formula 2.0.
- Integration: Telegram Bot API.
Result:
Time spent on routine accounting and task closure has decreased from 15 minutes to a few seconds. Errors in invoice generation and data transfer to the archive have been completely eliminated.
Want to automate your processes in Notion? Write to us, and we will discuss your task!
#notion #notionapi #python #Automation #API integrations #vercel #Automation
Developed a financial cycle automation system for freelancers and small businesses based on Notion, Python, and Vercel. The solution transforms regular task tables into a powerful accounting tool with bidirectional synchronization and notifications.
What has been implemented:
- One-click invoice generation: The script scans the task database, collects marked items, groups them by projects, and creates a record in the "Invoices" database with a unique UID.
- Telegram reporting: After creating an invoice, the bot sends a structured message (Project -> Task List -> Prices -> Total).
- Smart interface (Formula 2.0): Implemented a dynamic toggle button. It automatically changes the state from "Confirm Payment" to "Reset Payment" depending on the status in the database.
- Payment and archiving automation:
- Upon payment confirmation, the script in one second:
- Sets the status "Paid" for all related tasks.
- Records the payment date.
- Fills in deadlines (if they were empty).
- Moves tasks to the archive.
- Rollback function: The ability to instantly cancel payment and return tasks from the archive to active status.
Technical Stack:
- Backend: Python (Notion SDK).
- Infrastructure: Vercel Serverless Functions (high speed, $0 hosting costs).
- Frontend: Notion API + Formula 2.0.
- Integration: Telegram Bot API.
Result:
Time spent on routine accounting and task closure has decreased from 15 minutes to a few seconds. Errors in invoice generation and data transfer to the archive have been completely eliminated.
Want to automate your processes in Notion? Write to us, and we will discuss your task!
#notion #notionapi #python #Automation #API integrations #vercel #Automation