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