AI-Powered Client Proposal Generation with Google Slides and Airtable - n8n Workflow

• Sales Teams and Consultants: Who need to quickly generate detailed proposals after discovery calls.


• Automation Engineers: Looking for advanced examples of integrating AI, document generation, and CRM updates within a single n8n workflow.


• Businesses Using Airtable and Google Workspace: Seeking to automate their post-sales lead management processes.

Generating customized proposals is a crucial but time-consuming task. This powerful n8n workflow eliminates manual data entry by using Artificial Intelligence to structure key information directly from unstructured text, like a call transcript. When the input is received (via the n8n trigger), the workflow uses an OpenAI model to identify critical variables—such as budget, timeline, and deliverables—and formats them perfectly. This structured data is then used to populate an existing Google Slides proposal template, creating a personalized document ready for the client. Finally, the n8n workflow automatically shares the document and updates the corresponding lead status in Airtable, providing a seamless, automated handoff. This specific n8n template showcases high-level integration between AI services and core business applications, making it an essential tool for scaling operations.

This end-to-end automation starts with the When chat message received n8n trigger. This acts as the entry point for the call transcript data.

1. AI Extraction: The transcript is passed to the Message a model (OpenAI) n8n node. A highly specific system prompt instructs the AI to extract eight key variables (including company, budget, timeline, and client email) and return them in a strict JSON format.


2. Template Duplication: The structured data powers the subsequent steps. First, the Copy file Google Drive n8n node duplicates a master Google Slides template, naming the new proposal using the client's company name.


3. Content Population: The Replace text in a presentation Google Slides n8n node injects the AI-extracted values into specific placeholders within the copied presentation. This dynamically customized proposal is now complete.


4. Client Delivery: The Share file Google Drive n8n node automatically grants 'reader' access to the document using the client email extracted by the AI, sending the proposal immediately.


5. CRM Update: Finally, the Update record Airtable n8n node finds the corresponding lead record using the client's email and updates the LeadStatus field to 'Proposal sent'. This ensures your CRM is always up-to-date, making this n8n workflow a cornerstone of sales efficiency.

To deploy this comprehensive n8n template, follow these steps:

1. Import: Copy the provided JSON into your n8n instance using the 'New' -> 'Import from JSON' option.


2. OpenAI Setup: Create a credential for the OpenAI n8n node. You will need an API key. (Reference the sticky note instructions in the n8n workflow for guidance).


3. Google Credentials (Drive/Slides): Set up OAuth 2.0 credentials for both the Google Drive and Google Slides n8n nodes. Ensure your Google API project is configured with the necessary scopes to access Drive and Slides.


4. Airtable Token: Configure an Airtable Personal Access Token credential, ensuring it has read/write access to the specific Base (appZS6usU96byHXU3) and Table (tblROcPRoSG3aMwhT) used in this n8n workflow.


5. Template ID: Update the Google Drive Copy file n8n node with the File ID of your specific master Google Slides proposal template.


6. Activate: Save and activate the n8n workflow to enable the chat message trigger.

• When chat message received (LangChain Chat Trigger): This serves as the primary n8n trigger, initiating the process upon receiving the input call transcript.


• Message a model (OpenAI/LangChain n8n node): Leverages gpt-4.1-mini to perform complex data extraction from the raw text input. It ensures output is structured strictly as JSON, vital for subsequent data mapping in the n8n workflow.


• Copy file (Google Drive n8n node): Takes a predefined template ID (11FCrQCmvjck3eKHMGeDF0wGf0TDyUB78FLsyR0graKI) and creates a new, named copy based on the company name extracted by the AI.


• Replace text in a presentation (Google Slides n8n node): This core step uses dynamic expressions (e.g., ={{ $('Message a model').item.json.message.content.company }}) to replace placeholders within the slide deck with the extracted project details, completing the proposal document.


• Share file (Google Drive n8n node): Configured to share the final presentation ID (={{ $json.presentationId }}) with the client's email address, setting their role to 'reader'.


• Update record (Airtable n8n node): Matches a record using the client's email and updates the LeadStatus to 'Proposal sent', maintaining the integrity of the sales pipeline.