AutomationFlowsAI & RAG › Generate Business Proposals with Azure Gpt-4o & Save as Gmail Drafts From Sheets

Generate Business Proposals with Azure Gpt-4o & Save as Gmail Drafts From Sheets

ByRahul Joshi @rahul08 on n8n.io

Description:

Event trigger★★★★☆ complexityAI-powered16 nodesGoogle SheetsAgentLm Chat Azure Open AiGmail
AI & RAG Trigger: Event Nodes: 16 Complexity: ★★★★☆ AI nodes: yes Added:

This workflow corresponds to n8n.io template #8480 — we link there as the canonical source.

This workflow follows the Agent → Gmail recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "id": "uM6YAMBuMgbu0VKt",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Proposal generation_draft save automation",
  "tags": [],
  "nodes": [
    {
      "id": "b6261462-f2cf-4989-81f1-9303e2b805e7",
      "name": "When clicking \u2018Execute workflow\u2019",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -208,
        -624
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "101bb3e2-36a1-4df7-ab49-b116abb69f86",
      "name": "Get row(s) in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        16,
        -624
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "2b13049a-e27d-48d8-bb99-48beba7c7476",
      "name": "checks propsal status",
      "type": "n8n-nodes-base.if",
      "position": [
        240,
        -624
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "886f8fb6-c9d0-4575-865e-ba067c8f59df",
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        688,
        -624
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "b1edd21d-e96e-4729-8726-543a6f6b58b7",
      "name": "Azure OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
      "position": [
        784,
        -400
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "372e14c9-f545-4643-b3a6-54a0439a43e5",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        464,
        -624
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "8e55578c-f6f9-40b9-8d41-b69601d9d671",
      "name": "Code",
      "type": "n8n-nodes-base.code",
      "position": [
        1072,
        -624
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "855b8a09-9ca0-4966-8c0d-ec2078a0a75c",
      "name": "Create a draft",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1312,
        -624
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "1fd057dd-1793-4905-9329-ed1f8131d4ff",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -272,
        -880
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "2fe2308c-9a60-4b34-a465-83ba05b69be7",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -48,
        -448
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "082d3907-cfe6-4c1f-bacd-a83374e79246",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        176,
        -944
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "84d7e086-966c-431b-9b99-847990ffc1d2",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        400,
        -448
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "5b863a97-92d7-40b0-ac95-e5e8cd2cbea4",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        688,
        -1104
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "305705dd-01a9-4229-a3af-00c32182b95c",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        720,
        -256
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "69898e6c-54ad-4a9d-a63d-5d17376e511f",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1008,
        -464
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "2409ec85-6238-468b-8e4b-3052cd1e7015",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1232,
        -944
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "39af8b7b-2a69-4881-b93c-9edf6bbdf49f",
  "connections": {
    "Code": {
      "main": [
        [
          {
            "node": "Create a draft",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Agent": {
      "main": [
        [
          {
            "node": "Code",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet": {
      "main": [
        [
          {
            "node": "checks propsal status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "checks propsal status": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Azure OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "When clicking \u2018Execute workflow\u2019": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

Description:

Source: https://n8n.io/workflows/8480/ — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

AI & RAG

Automate your AI-powered outreach and follow-up pipeline end-to-end with GPT-4o, Gmail, and Google Sheets. 🤖📬 This workflow personalizes emails for each lead, manages follow-ups automatically, tracks

Lm Chat Azure Open Ai, Google Sheets, Agent +1
AI & RAG

This workflow automates the creation, storage, and reporting of personalized sales collateral for booked leads using GPT-4o, Google Sheets, Google Drive, and Gmail. It pulls leads from a central sheet

Google Sheets, Lm Chat Azure Open Ai, Agent +2
AI & RAG

This workflow automates end-to-end validation, assessment, and reporting of n8n workflow JSON templates using Google Drive, Azure OpenAI GPT-4o, Gmail, and Slack. It retrieves workflows from a Drive f

Memory Buffer Window, Lm Chat Azure Open Ai, Output Parser Structured +5
AI & RAG

Automatically capture customer onboarding help requests from Typeform, log them in Google Sheets, validate email addresses, and send a professional HTML welcome email via Gmail. Ensures smooth onboard

Typeform Trigger, Google Sheets, Gmail +6
AI & RAG

Automate customer feedback analysis and action planning by integrating Monday.com, Azure OpenAI, Jira, Google Sheets, and Outlook. This workflow classifies customer feedback with AI, calculates busine

Monday.com, Jira, Google Sheets +7