Automate Notion Invoices in Seconds

Automate your invoices in Notion effortlessly

I know what it’s like to spend hours staring at a screen, copying client data from one page to another, checking if the VAT calculation is correct, and struggling with a PDF format that always looks messy. It’s frustrating to waste valuable time on repetitive tasks that don’t help you grow, only to end up with the constant fear of having made a typo in an amount or an email address.

The Action Plan:

2. Establish logical links between the databases using relations and rollups so that information flows automatically without manual intervention.
3. Set up an automation trigger that detects a status change in Notion and executes the generation of the final PDF document.

Detailed Implementation:

To make this work, you can’t treat Notion as a simple list of notes; you have to build a relational system. Follow these technical steps precisely:

Step 1: Creating the Databases (The Skeleton) You need to create four distinct databases in your Notion. Don’t mix them; each has a unique function:

• Clients Database: This is only for static information. Required properties: Client Name (Title), Email (Email), Address (Text).
• Products/Services Database: Your pricing catalog. Required properties: Service Name (Title), Unit Price (Number, Currency format).
• Invoice Line Items Database: This is the intermediate database that connects everything. Required properties: Description (Title), Relation to Products (Relation), Quantity (Number).
• Invoices Database: The command center. Set up these properties: Invoice ID (ID or Title), Client (Relation), Status (Select: Draft, Ready to Generate, Sent), Date (Date).

Step 2: The Magic of Relations and Rollups (The Connection) This is where you stop copying and pasting. You need to configure the logic so that numbers appear automatically:

1. In the Invoice Line Items database, create a Relation property pointing to the Products/Services database. When you select a product, Notion will already know its price.
2. Create a Rollup property in this same database (Invoice Line Items). Configure the “Relation” to Products, the “Property” to Unit Price, and the “Calculate” to “Show original.” Name this Unit Price.
3. Now, create a Formula property in Invoice Line Items called Subtotal. The formula should be: prop("Quantity") * prop("Unit Price").
4. In the main Invoices database, create a Relation to the Invoice Line Items database.
5. Create a Rollup in the Invoices database called Invoice Total. Configure the “Relation” to Invoice Line Items, the “Property” to Subtotal, and the “Calculate” to Sum.

Step 3: The Trigger (The Trigger) To ensure you don’t have to do anything manually, you will use the Status property in your Invoices database. The automation will only activate when you change an invoice status from “Draft” to ”

Ready to Generate.” This status change will be the signal for the external tool to grab the data and create the PDF.

Suggested Tool:

To execute the final step, I recommend using Make.com. It is a visual automation platform (known as iPaaS) that allows you to connect Notion with many other applications without writing a single line of code. It is ideal for this use case because it has a specific module for Notion that can “listen” for when a record changes and, using a Google Docs or HTML template, transform that data into a professional PDF with your logo and design, automatically saving it back to your database.

Prompt to copy:

Act as an expert in process automation with Make.com and Notion. I need to create a scenario that triggers when the status of a database in Notion changes to "Ready to Generate". The scenario must: 1. Retrieve the invoice information, including client details and the item breakdown (using existing relations). 2. Use a Google Docs template with tags such as {{client_name}}, {{date}}, and a dynamic table for {{items}}. 3. Convert that document into a PDF. 4. Upload the resulting PDF to a Google Drive folder and update the "File" property in the original Notion database with the file link. Please provide a step-by-step guide on how to configure each module in Make.com and what structure my Google Docs template should have so that the fields map correctly.