Automated Sales Proposal & Summary Generator using GPT-4o, Sheets & Drive - n8n Workflow

• Sales Operations professionals seeking to automate personalized outreach.


• Marketing teams needing to generate sales collateral at scale.


• Users looking for advanced examples of how to integrate AI agents (GPT-4o) within n8n templates.


• Business Analysts aiming to streamline lead management and reporting using n8n and Google Sheets.

Manual sales collateral creation is slow and non-scalable. This expert n8n workflow solves this by fully automating the process for 'booked' leads stored in a Google Sheet. It leverages the advanced generative capabilities of GPT-4o to produce three critical sales assets—a Sales Summary, a One-Pager, and a full Proposal Draft—for every lead, ensuring maximum personalization.

After generation, the materials are structured, converted into readable text reports, and uploaded to Google Drive. The workflow then ensures traceability by updating the original Google Sheet record with the unique proposal link. Finally, a complete, HTML-formatted summary report is generated by an n8n node and delivered via Gmail, providing instant feedback on the automation run. This sophisticated n8n template significantly reduces time-to-proposal while enhancing the quality of sales material.

This powerful n8n workflow initiates manually using the 'When clicking Execute workflow' n8n trigger, though it could easily be adapted to a scheduled or webhook n8n trigger.

1. Data Retrieval: The flow starts by querying Google Sheets to retrieve all current lead records.


2. Validation & Filtering: An n8n node validates the data integrity (specifically checking for valid emails). Invalid leads are routed and logged via a dedicated Google Sheets n8n node, while valid leads proceed to a conditional filter that only allows entries marked as 'BOOKED' to continue.


3. AI Content Generation: The core of the n8n workflow uses a LangChain Agent (running on GPT-4o) to ingest the detailed lead data and generate a structured JSON output containing the Sales Summary, One-Pager, and Proposal Draft.


4. Parsing and Conversion: Two consecutive Code n8n nodes clean the raw AI output, parse the JSON, and convert the structured data into formatted, individual .txt report files ready for storage.


5. Storage and Linking: The generated collateral is uploaded to a specified Google Drive folder using the Google Drive n8n node, obtaining the public URL for each file.


6. Parallel Updates: The flow splits:

To deploy this advanced n8n workflow, follow these steps:

1. Import the JSON: Copy the provided n8n workflow JSON and paste it into your n8n canvas using the 'Import from JSON' option.


2. Set up Credentials: This n8n template requires three main credentials:

1. Configure Sheets Node: In the 'Retrieve Lead Records from Google Sheets' n8n node and the 'Update Lead Record with Proposal Link' n8n node, ensure the Document ID and Sheet Name match your actual lead database.


2. Configure Drive Node: In the 'Upload Sales Collateral to Google Drive' n8n node, verify the Folder ID points to the correct destination folder in your Google Drive.


3. Set Target Email: In the 'Send Sales Summary Email via Gmail' n8n node, update the Send To address to the desired sales or marketing inbox.

This n8n workflow utilizes several key nodes for data handling, AI interaction, and persistence:

Google Sheets (Retrieve Lead Records): Function: Acts as the primary data source, retrieving lead information that fuels the entire n8n automation process.
If (Filter for Booked Leads): Function: A crucial flow control n8n node that ensures only leads with Booking Status equal to 'BOOKED' proceed to the costly AI generation steps.
Agent (Generate Sales Collateral (AI)): Function: The core AI n8n node, utilizing GPT-4o to generate three distinct, personalized sales materials (summary, one-pager, proposal). Key Configuration: System message defines the persona (AI sales assistant) and strictly enforces JSON output format.
Code (Parse AI JSON Output): Function: A custom JavaScript n8n node designed to clean and reliably parse the raw text output from GPT-4o into a structured JSON object, handling common markdown formatting issues.
Code (Convert Collateral into Text Reports): Function: Formats the structured AI data into a readable .txt file, converting the text into binary data (Buffer) necessary for the Google Drive n8n node upload.
Google Drive (Upload Sales Collateral to Google Drive): Function: Handles the secure upload of the generated text reports, providing the essential webViewLink used for updating the Google Sheet.
Code (Map Uploaded Files with Lead Data): Function: Maps the file links obtained from the Drive n8n node back to the corresponding original lead data using index tracking, preparing the data for the sheet update.
Google Sheets (Update Lead Record with Proposal Link): Function: Updates the lead database, matching on the Email column to append the new 'Proposal Link', maintaining a complete record within the n8n workflow.
Agent (Generate Sales Summary Email): Function: Uses GPT-4o again to synthesize the results and generate a polished, HTML-formatted summary report based on the total leads processed and the uploaded file links.
Gmail (Send Sales Summary Email): Function: The final action n8n node that delivers the AI-generated HTML summary report to the designated sales inbox.