Automated Freelance Proposal Generator using Google Docs and GPT-4 - n8n Workflow

• Freelance Automation Specialists and Technical Consultants.


• Users looking to scale their client acquisition process significantly.


• Teams interested in advanced AI Agent orchestration and tool calling using n8n.


• Anyone seeking ready-made, high-conversion n8n templates for business development.

The manual process of crafting highly customized, professional freelance proposals is often a bottleneck for scaling operations. This comprehensive n8n workflow solves this by instantly generating three critical assets for high-converting Upwork applications. The core of this automation is an AI Agent built within n8n that orchestrates sub-workflows for proposal generation. The resulting output includes a short, personalized application copy, a public-facing Google Docs proposal detailing scope and timeline, and a visual Mermaid flow diagram, demonstrating expertise. By utilizing this n8n template, users can transform hours of preparation into a few automated minutes, maximizing submission speed and improving conversion rates, leveraging the power of a finely tuned n8n automation strategy.

This complex n8n workflow operates through a layered system of AI agents and specialized sub-workflows. The automation begins with the When chat message received n8n trigger, which accepts the Upwork job description.

1. Agent Orchestration: The central AI Agent n8n node, configured with an OpenAI Chat Model and Window Buffer Memory, acts as the commander. It uses three ToolWorkflow n8n nodes to execute the specialized tasks concurrently, maintaining context throughout the n8n workflow.


2. Application Copy Generation: A dedicated sub-flow is triggered via an Execute Workflow Trigger n8n trigger. It merges predefined personal social proof (Set Variable n8n node) with the job description. The OpenAI n8n node then generates a concise, compelling application text, which crucially includes a $$$ placeholder for the proposal link.


3. Google Doc Proposal Creation: This sub-flow first uses OpenAI1 to generate structured JSON data (title, steps, explanation) tailored to the job. A Google Drive n8n node copies a master proposal template, and Google Drive1 shares the new document publicly. The Google Docs n8n node executes targeted find-and-replace operations, inserting the AI-generated content into the template placeholders.


4. Mermaid Diagram Generation: The third sub-flow uses OpenAI2 to analyze the requirements and output raw Mermaid.js flowchart code, offering a clear visual representation of the proposed solution.


5. Final Assembly: The main AI Agent n8n node receives the outputs from all three tools. Following its system instructions, it replaces the $$$ in the application copy with the newly generated Google Doc URL, delivering the complete, highly professional proposal back to the user via the initial chat connection. This entire n8n workflow is an excellent example of using chained n8n templates for business automation.

To deploy this powerful n8n workflow, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON code and import it directly into your n8n instance using the 'New' -> 'Import from JSON' option.


2. Credential Setup: You must establish credentials for the following services (n8n node types):

1. Template Configuration: Update the Set Variable n8n node instances in the sub-workflows (Set Variable and Set Variable1) with your specific professional background and social proof details. This personalization is key to the effectiveness of the n8n workflow.


2. Tool Linking (Crucial): Ensure the ToolWorkflow n8n nodes (Generate Application Copy, Generate Google Doc Proposal, Generate Mermaid.js) correctly reference the corresponding sub-workflows (which would also need to be imported or built in your n8n environment). Note that the provided JSON implies these sub-workflows already exist and are linked by ID.


3. Activation: Once configured, set the primary n8n workflow to 'Active' to start listening for the chat trigger.

This n8n workflow template uses several key n8n node types to achieve complex orchestration:

• When chat message received (n8n trigger): Initiates the entire n8n automation flow by receiving the raw job description input from a chat interface, acting as the primary n8n trigger.


• AI Agent (n8n node): The core control unit. It interprets the request and decides which ToolWorkflow n8n node to execute to fulfill the goal. It is responsible for replacing the link placeholder.


• OpenAI / OpenAI1 / OpenAI2 (n8n node): These nodes utilize GPT-4o-mini (or GPT-4) to perform specialized generation tasks: writing application copy, structuring the document proposal content, and generating valid Mermaid.js code.


• Tool Workflow (n8n node): Used to modularize the complexity, calling separate sub-workflows (e.g., 'Generate Application Copy') as external functions. This demonstrates advanced n8n workflow design.


• Google Drive (n8n node): Used twice in the proposal sub-flow: first to copy a master template document, and second to share the newly created document publicly.


• Google Docs (n8n node): Executes update operations, using actions like replaceAll to dynamically inject the AI-generated content into specific placeholders within the Google document using data from the OpenAI1 n8n node.


• Set Variable / Edit Fields (n8n node): Used for injecting static social proof data (aboutMe) and formatting the final output responses from the LLM into a usable format for subsequent n8n nodes.