Automate Notion Contracts in Seconds

You spend hours copying and pasting data from your database into Word, only to save it as a PDF and upload it back to the system. It is repetitive, tedious, and worst of all, you expose yourself to manual errors in amounts or names that can ruin your day. I completely understand the frustration of feeling like an administrative clerk for your own company instead of an efficient manager.

3. The Action Plan:

4. Centralization and Structuring: The first step is to organize all relevant information (names, dates, amounts, clauses) in a master database where each entry is a unique contract with clear properties.

5. Master Template Creation: Design a model document (in Google Docs) that contains specific tags or “placeholders” for the dynamic information.

6. Automation Orchestration: Set up a logical workflow that detects when you trigger a signal in Notion, pulls the data, fills the template, converts it to PDF, and automatically returns the final file to your database.

7. Detailed Implementation:

To make this work flawlessly, you need to configure three key pieces. Follow these technical steps:

1. Notion Setup (The Source of Truth): Create a database called “Rental Agreements” with the following essential properties:

• Tenant Name: Text type.
• Rental Price: Number type (Currency format).
• Start Date: Date type.
• Property Address: Text type.
• Line Items Detail: This is the secret to handling multiple details. Create a “Rollup” or “Formula” property. If you have another database for “Extra Charges,” use a Rollup to bring in the information and, if necessary, a formula that concatenates all elements into a single text block (e.g., map(prop("Items"), current)) so the automation can read it as one continuous block of text.
• Generate PDF: Button or Checkbox type. This will be your trigger.
• Contract PDF: “Files & Media” type. This is where the automation will deposit the final result.

2. Google Docs Template Setup (The Mold): Open a new document and write the legal text of your contract. Wherever you want dynamic information to appear, use double curly braces. For example: “In the city of [Date], between the landlord and {{tenant_name}}, it is agreed to rent the property located at {{property_address}} for a monthly amount of {{rental_price}}.” It is vital that the names inside the braces {{...}} exactly match the names of the properties you will map in the automation.

3. Make.com Workflow Setup (The Engine): Create a new “Scenario” with this step-by-step process:

• Module 1 (Notion - Watch Database Items): Configure the module to monitor your “Rental Agreements” database. Filter the search so it only acts when the Generate PDF property is “True” or the button is pressed.
• Module 2 (Google Docs - Create a Document from a Template): Select your template. The system will automatically show you all the fields it detected with curly braces {{...}}. Here, you must map each Notion field to its corresponding tag in the Doc. For example: Field tenant_name <--- Notion Property Tenant Name.
• Module 3 (Google Drive - Download a File): Select the ID of the document created in the previous step. In “Convert to PDF,” check the option to download it directly in PDF format.
• Module 4 (Notion - Update a Database Item): Search for the same Notion page that triggered the automation. In the Contract PDF property, upload the file downloaded in the previous step. Don’t forget to add a final step that changes the Generate PDF checkbox to “False” so the process does not repeat infinitely.

5. Suggested Tool:

The recommended tool is Make (formerly Integromat). It is a visual automation platform that works through connectable modules. Unlike more limited options, Make allows you to manipulate complex data, such as transforming lists of items into plain text or handling large file conversions, all without writing a single line of code and at a very low cost for personal or small office use.

6. Prompt to copy:

Act as an expert in legal writing and automation. I need to create the content for a Google Docs template that will be automatically filled from Notion. The content must be professional, clear, and structured. I will provide you with a list of tags inside curly braces {{...}}. Your task is to draft a standard rental agreement where the variable spaces are covered by these tags: {{tenant_name}}, {{property_address}}, {{rental_price}}, {{start_date}}, {{end_date}}, and {{line_items_detail}}. The tone should be formal yet easy to read. Ensure that the {{line_items_detail}} section is a space where additional items are listed in an organized manner.