Automate freelance project intake with custom proposals using Jotform & Gemini
Workflow explaination: This workflow is designed to automatically handle new freelance project requests from a JotForm, analyze the requirements using AI, create a custom proposal, log the details in a Google Sheet, and send a personalized response to the client. --- 1. JotForm Trigger Purpose: This node is the entry point of the entire automation. It waits for a new freelance pr
At a glance
Automate freelance project intake with custom proposals using Jotform & Gemini is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Gmail, Google Sheets, Gemini
- Modules
- 8
- Price
- Free
- Version
- v1.0

About this workflow
Workflow explaination: This workflow is designed to automatically handle new freelance project requests from a JotForm, analyze the requirements using AI, create a custom proposal, log the details in a Google Sheet, and send a personalized response to the client. --- 1. JotForm Trigger Purpose: This node is the entry point of the entire automation. It waits for a new freelance project submission from your specified JotForm. Action: When a potential client fills out and submits the form, this node instantly triggers the workflow, passing all submitted data (name, email, project requirements, and budget) to the next node. Key Detail: Uses a webhook for real-time activation, ensuring immediate processing of every new project request. --- 2. AI Agent Purpose: The central brain of your freelance workflow. 🧠 It takes the project submission and turns it into a structured, customized proposal. Action: The agent follows a prompt sequence to perform these tasks: 1. Calls the My Freelance Document Tool: Fetches your Google Doc containing details about your services, pricing, and project templates — your “source of truth.” 2. Analyzes the Project Request: Reads the client’s requirements and goals from the form. 3. Generates a Custom Proposal: Based on scope, budget, and relevance to your offerings, it prepares a short, tailored proposal or quote that fits the project. 4. Creates a Personalized Email: Builds an HTML email with the proposal embedded, including next steps or a scheduling link for further discussion. 5. Outputs Structured Data: Packages everything (project summary, proposal text, email subject, and body) into a clean JSON object for downstream use. --- 3. Append or Update Row in Sheet (Google Sheets) Purpose: Serves as your lightweight CRM for all project inquiries. Action: Logs data from the AI Agent (proposal details, client info, and project summary) into a Google Sheet. Key Detail: Configured to Append or Update—if an email already exists, it updates that row instead of duplicating. Keeps your client records clean and organized. --- 4. If Purpose: Acts as a control node to decide whether a proposal email should be sent. Action: Checks the output from the AI Agent to ensure the proposal text is valid (not empty). Key Detail: If the proposal generation fails or returns “NAN,” the workflow stops here to avoid sending incomplete responses. --- 5. Send a Message (Gmail) Purpose: Sends the final personalized proposal email to the client. Action: Pulls the recipient’s email from the sheet and sends the AI-generated subject and HTML proposal email automatically. Key Detail: The email is customized per project, giving the client an instant, professional response with no manual effort.
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Create a FreshBooks invoice and send a Gmail notification from a new WooCommerce order
Add new Adalo records to Google Sheets as rows
Warm up Gmail inboxes with OpenAI GPT-4o-mini and Data Tables
Create Facebook ads copy with Google Sheets and ChatGPT: FAB formula
Generate B2B lead magnet articles with AI deep research and Google Docs
Automate medical claims processing with GPT-4 multi-agent orchestration
Automated WordPress post tagging with AI analysis and Claude Opus 4.5
Json string validator via webhook
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you