Create and send AI sales proposals using Gemini, Google Docs & Gmail

How it works
This workflow automatically generates and sends personalized sales proposals when a new row is added to Google Sheets. It uses AI to create proposal content, updates contact details in HubSpot, and generates a formatted document. The document is converted into a PDF and emailed to the client. This eliminates manual proposal writing and ensures fast, consistent delivery.

Step-by-step

Capture lead and generate AI content**
Google Sheets Trigger – Detects new form submissions in your sheet.
Loop Over Items – Processes each new entry individually.
Message a model – Uses Gemini AI to generate the proposal content.
Code in JavaScript – Cleans and splits AI output into structured fields.

Create contact and generate document**
Create or update a contact – Stores or updates client data in HubSpot.
Copy file – Duplicates a proposal template from Google Drive.
Update a document – Replaces placeholders with real client and AI data.
Download file – Converts the final document into a PDF file.

Send proposal to client**
Send a message – Emails the generated PDF proposal to the client.

Why use this?
Automatically generates professional proposals without manual writing
Ensures consistent formatting using templates and placeholders
Saves time by combining CRM, AI, and document creation
Improves response speed for leads and increases conversion chances
Scales easily for handling multiple client requests simultaneously