Create ANY Document with PandaDoc in n8n ($60K/yr Saved)
By Jono Catliff
Key Concepts
- Naden: A platform used for workflow automation.
- PandaDoc: A document generation and e-signature platform.
- Workflow Automation: The process of automating business processes using technology.
- API Integrations: Connecting different software applications to share data and functionality.
- Tokens: Placeholders in a document that can be automatically filled with specific data.
- Custom Fields: Fields within a document that can be dynamically populated or require user input.
- Conditional Rendering: Displaying or hiding specific sections of a document based on certain conditions.
- Pricing Table: A flexible component within PandaDoc for itemizing products, services, quantities, prices, discounts, and taxes.
- Upsells: Optional additional products or services offered to customers.
- HTTP Request: A method used to send data to a server, often for creating or updating resources.
- API Key: A unique identifier used for authentication and authorization when accessing an API.
- JSON (JavaScript Object Notation): A lightweight data-interchange format used for structuring data.
- Template UUID: A unique identifier for a specific document template within PandaDoc.
- Make.com: An automation platform that can be used as an alternative to direct API integrations for certain plans.
- QuickBooks: Accounting software for managing business finances.
- Webhooks: A mechanism for receiving real-time data updates from an application.
Workflow Automation with Naden and PandaDoc
This workflow focuses on automating the generation of full-blown documents within PandaDoc, triggered by actions within Naden. The primary goal is to save time, reduce manual effort, and potentially increase revenue.
Benefits of PandaDoc Integration
The integration offers several key advantages:
- Automated Field Population: Documents can have fields that are automatically filled in upon generation, eliminating the need for manual data entry. This is particularly beneficial when dealing with numerous fields (e.g., "a hundred of these fields").
- Two-in-One Document Functionality: PandaDoc allows for documents that combine signing and payment prompts, addressing potential cash flow issues that arise when invoices and contracts are sent separately.
- Client Information Input: Custom fields can be incorporated, allowing clients to provide necessary information before signing and paying. An example given is a field for selecting a payment method (credit card, cash, bank deposit).
- Conditional Terms and Services: The ability to dynamically insert separate terms and services based on client inquiries or selected services. For instance, a landscaping business could have distinct terms for hedge trimming versus general landscaping.
- Flexible Pricing Tables: These tables are highly customizable, allowing for multiple products (e.g., agency services, social media services, ad campaigns) with dynamic pricing, quantities, discounts, and taxes.
- Optional Upsells: The pricing table can include optional upsells, which can be selected by the customer, leading to increased revenue. The example shows how selecting an upsell automatically updates the total price.
- Versatile Document Generation: Beyond contracts, proposals, and invoices, the system can generate service agreements, quotes, NDAs, offer letters, purchase orders, liability waivers, and other client-facing documents.
- Significant Time Savings: The presenter highlights saving "30 minutes every single time" a document was generated, equating to "eight hours that we saved by automating this process every day" in a previous sales-heavy business. This time saving was valued at "$60,000 a year," equivalent to hiring an additional employee.
Technology Costs and Limitations
- Required Accounts: An Naden account and a PandaDoc account are necessary. Both offer free trials.
- API Integration Limitation: To access the production API for seamless automation, an enterprise plan for PandaDoc is typically required, which is "slightly more than $65 every single month."
- Workaround for Plan Limitation: For users who wish to avoid the enterprise plan, an alternative is to use Make.com. This allows for CRM integration and building the workflow via Make.com, potentially using a business plan instead of enterprise. A video tutorial for this workaround is linked in the description.
Setting Up Proposals in PandaDoc
The process involves creating and configuring templates within PandaDoc:
- Template Creation: Navigate to "Templates" in the PandaDoc sidebar and create a new template.
- Template Selection: PandaDoc offers pre-designed templates that are noted for their aesthetic appeal, unlike some other software options. The presenter selects a template shown earlier in the video.
- Customization Tips:
- Deleting Sections: Unwanted sections can be removed by clicking the three dots and selecting "delete page."
- Adding Custom Variables (Tokens): These are created by typing
[square slash]followed byvariable.nameand then[square slash]again (e.g.,client.terms). These can be automatically filled from Naden. - Adding Fields: Fillable fields (like dates) can be dragged and dropped from the sidebar.
- Role Assignment: For fillable fields, roles must be assigned. Typically, a "client role" (recipient) and a "sender role" (you) are defined.
- Pricing Table Configuration:
- Drag and drop a pricing table onto the agreement.
- Delete default rows if necessary.
- Enable Merge Data: Click on the table, go to "properties," and enable "merge data." This signifies that data will be received externally from an application like Naden.
- Payment Setup:
- Navigate to the "payments" tab.
- Integrate Payment Gateway: Connect a payment gateway such as Stripe, Square, or another preferred provider.
- Add Payment Option: Enable the option to collect payments.
- Assign Payee: Designate the client as the payee responsible for payment upon signing.
Workflow Trigger and Automation Steps
The workflow follows a trigger-process-generate structure:
- Trigger: This initiates the document generation process. Several trigger methods are discussed:
- Sales Call Questionnaire (Most Common): During a sales call, information is entered into a questionnaire in real-time. This data then triggers the workflow. For example, asking a client about their service needs, deadlines, and problems.
- Website Chatbot: A chatbot on the website can collect information and trigger document generation.
- Website Buttons: Specific buttons on the website (e.g., "Buy Pro Package") can trigger the sending of corresponding agreements.
- Email Integration: Inquiring emails can be processed to automatically send relevant documents.
- AI Node (Polishing and Refinement):
- Purpose: To take raw information gathered from the trigger (e.g., notes from a sales call) and polish it into professional, coherent text for the document.
- Process: The AI uses three message types:
- System Message: Instructions for the AI (e.g., "polish off the problem and solution").
- User Message: The input data from the trigger (e.g., client's problem and desired solution).
- Assistant Message: Defines the desired output structure, such as separate "problem" and "solution" fields, allowing for precise mapping into the PandaDoc document.
- Document Generation:
- HTTP Field: Since there's no direct PandaDoc app in Naden, an HTTP request is used to create the document.
- Method: A
POSTmethod is used to create a new document. - URL: A specific PandaDoc API endpoint for creating documents is used (e.g.,
public/v1/documents). - Headers: Include authorization credentials, specifically an API key.
- API Key Acquisition: Obtain the API key from PandaDoc settings under "API and Integrations." A sandbox API key is available for testing, but the production API key is needed for live automation.
- Accepting Application JSON: Specifies the data structure being sent.
- JSON Structure: Data is passed in a JSON format, which is a structured way of organizing information.
- Key JSON Fields to Configure:
templateUuid: The unique identifier of the PandaDoc template to be used. This is the primary field to change when using a downloaded blueprint.sendAutomatically: A boolean (true/false) to determine if the document should be sent immediately after generation. Requires the production API key.documentName: The name of the generated document.recipients: An array of recipients, typically including the sender and the client. Client email is pulled from the trigger data. IfsendAutomaticallyistrueand there are no fillable fields for the sender, only one recipient (the client) might be needed.- Tokens (Pre-populated Fields): These are fields within the PandaDoc template that can be automatically populated with data from Naden. Each token has a name (e.g.,
client.company,client.firstName) that needs to be matched with a corresponding value in the JSON payload. New tokens can be added by copying and modifying existing ones. - Pricing Table: The JSON structure allows for defining products, descriptions, prices, and discounts for the pricing table. The presenter shows how a discount entered in the sales form can be applied to the pricing table.
Automating Bookkeeping with Make.com
To automate bookkeeping after a document is signed and paid:
- Make.com Integration: Utilize Make.com's PandaDoc integration.
- Watch for Changes: Configure Make.com to monitor PandaDoc for document status changes.
- Webhooks: Set up a webhook to receive real-time data from PandaDoc.
- Filter by Status: Crucially, filter the incoming data to only process documents with a "paid" status. PandaDoc has various statuses (uploaded, error, draft, sent, viewed, rejected, approved, paid).
- Action: Once a document is marked as paid, trigger an action, such as:
- Sending the data to QuickBooks for accounting.
- Adding a row to Google Sheets.
Conclusion and Further Resources
The presenter emphasizes that this workflow, while taking years to develop personally, has been simplified into a blueprint that can be set up in a "couple hours." The automation is described as "game-changing" and "life-changing."
- Free Blueprints: The blueprints for this workflow are available for free in the video description.
- Customization: The provided blueprints are boilerplate and can be further customized.
- Additional Resources: Links to videos on using Make.com for PandaDoc integration and other automation topics are provided in the description.
- Community and Courses: The presenter mentions their YouTube channel and school community for learning these tools, building an AI automation agency, and scaling a business.
Chat with this Video
AI-PoweredLoad the transcript when you're ready to chat so the initial page stays lighter.