Save Hours: Auto Notion Sales Proposals

2. The Problem Working on sales proposals from scratch is a complete waste of time and a magnet for human error. You find yourself copying and pasting client data, services, and prices into Word or Canva, praying you didn’t mistype a number or a company name. This administrative friction pulls your focus away from what truly matters: closing deals and serving your clients, all while feeling like your productivity is draining away into repetitive tasks that add no value.

3. The Action Plan To stop being a slave to “copy and paste,” we are going to structure a system where information flows automatically through three logical phases:

4. Related Data Architecture: You will build a network of interconnected databases where each piece of data (client, service, or item) lives in its own place, preventing duplication.

5. Centralization and Automatic Calculation: We will use “Rollup” properties and formulas so that when you link a client to a proposal, Notion automatically sums the prices and calculates totals, taxes, or discounts without you touching a single key. 3. External Generation Trigger: We will set up an automation that detects a status change in Notion (a single click on a button) to extract all that structured information and instantly pour it into a professional PDF template.

6. Detailed Implementation To make this work, you can’t have scattered data; you need this ecosystem of 4 databases with the following exact configurations:

Step 1: Database Setup (The Engine)

• “Clients” Database:
  • Name Property (Title).
  • Email Property (Email).
  • Company Property (Text).
• “Services” Database:
  • Service Name Property (Title).
  • Unit Price Property (Number, currency format).
• “Deliverables” Database:
  • Description Property (Title).
  • Relation to Services Property (Relation): Connected to the “Services” database.
  • Quantity Property (Number).
  • Price Rollup Property (Rollup): Related to “Services,” pointing to the Unit Price property. Configuration: “Show original.”
  • Subtotal Property (Formula): prop("Quantity") * prop("Price Rollup").
• “Proposals” Database (The Brain):
  • Proposal Name Property (Title).
  • Relation to Clients Property (Relation): Connected to “Clients.”
  • Relation to Deliverables Property (Relation): Connected to “Deliverables” (This is where you will choose which items belong to this specific proposal).
  • Client Info Property (Rollup): Related to “Clients,” pointing to Email.
  • Proposal Total Property (Rollup): Related to “Deliverables,” pointing to the Subtotal property, configuration: “Sum.”
  • Status Property (Select): With options such as “Draft,” “In Review,” and “Generate PDF.”

Step 2: PDF Automation (The Trigger)

Once your data is linked, Notion alone cannot automatically “create” a downloadable PDF file with a professional design; you need a bridge.

1. Create a button in the “Proposals” database called “Generate Proposal.”

2. Set up an automation (using Make.com) that activates when the Status changes to “Generate PDF.”

3. The automation must:

   • Search for the data of the current proposal.
   • Iterate through the linked items in “Deliverables.”
   • Inject that data into a Google Docs or HTML template.
   • Convert that document to a PDF and save it to a “Files & Media” property within the same Notion row.

4. Suggested Tool: The key tool for the final step is Make.com (formerly Integromat). It is a visual automation platform that acts as the glue between your Notion databases and a document generator. It is ideal because it allows you to manipulate complex structures (like lists of items) and transform them into an aesthetic format without needing to know complex coding, ensuring the resulting PDF is a polished marketing piece rather than just a text dump.

5. Prompt to copy:

Act as an expert in automation with Make.com and Notion. I need to configure a scenario that triggers when a row in my Notion database (called "Proposals") changes its 'Status' property to 'Generate PDF'. 

The workflow must be as follows:
1. Retrieve the proposal data (Name, Client, Client Email).
2. Perform a 'Search' in the 'Deliverables' database to find all records related to the ID of the current proposal.
3. Group all found 'Deliverables' into a detailed list that includes: Description, Quantity, and Subtotal.
4. Use a Google Docs template containing tags such as {{proposal_name}}, {{client}}, {{email}} and a dynamic table for the item list.
5. Generate a PDF file from the resulting Google Doc.
6. Upload the final PDF file back to the 'PDF File' property in the original Notion row.

Please provide a step-by-step breakdown of which modules I should use in Make.com (Notion Module, Google Docs Module, etc.) and how to configure the data mapping so that the items table prints correctly in the document.