n8n

How to Automate Google Docs RFP Responses?

Receive an RFP file by API and turn it into a ready to edit response document. Ideal for sales teams that need to answer many questionnaires fast and keep answers consistent. The result is a clean Google Doc with each question and the AI generated answer, plus team alerts when done.

Here is how it runs end to end. A webhook collects the uploaded PDF and basic fields like title, ID, and reply email. The file text is extracted and sent to an AI model that pulls out the list of questions. The workflow loops through each question and uses an OpenAI assistant with your company content to draft accurate answers. It creates a new Google Doc, adds metadata, records each question and answer, and then sends a Gmail message and a Slack update with the document link. This design handles messy formats, works in batches, and keeps everything in one place for review.

Setup is simple with the right accounts and credentials. Provide OpenAI, Google Docs, Gmail, and Slack connections, set the target Google Drive folder, and map the reply email field. Teams can cut hours of manual work and respond to more bids with the same staff. Best for RFP intake portals, partner requests, and structured questionnaires that need fast, reliable draft answers.

What are the key features?

  • Webhook intake collects PDF, title, ID, and reply email from a request.
  • PDF text extraction prepares content for AI processing.
  • AI question extraction returns a clean list using an output parser.
  • Batch loop answers each question with an OpenAI assistant using your company context.
  • Google Docs document is created and tagged with helpful metadata.
  • Each question and answer is written into the document as structured entries.
  • Gmail sends a completion email with the document link to the requester.
  • Slack posts a channel message so the team knows the draft is ready.

What are the benefits?

  • Reduce manual drafting from 5 hours to 20 minutes per RFP
  • Automate up to 80% of repetitive copy and paste steps
  • Improve answer consistency and lower errors by 60%
  • Handle 3 times more RFPs with the same team size
  • Connect Google Docs, Gmail, Slack, and OpenAI in one flow
  • Keep a single source of truth with all Q and A in one document

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with OpenAI, Google Docs, Gmail and Slack. See the Tools Required section above for links to create accounts with these services.
  3. Open the Webhook node and copy the Test URL. Keep the node set to POST and form data. Plan to send id, title, reply_to, and data fields as shown in the example request.
  4. Double click the Google Docs nodes and in the Credential to connect with dropdown select Create new credential. Follow the on screen steps to connect your Google account. Confirm access to create and edit Docs.
  5. Open the Create new RFP Response Document node and set the target Google Drive folder. Keep the dynamic title field to include the RFP ID and timestamp.
  6. Open the Gmail node and create a new credential. Choose your Google account and approve sending permissions. Map the To field to the reply_to value from the webhook payload.
  7. Open the Slack node and create a new credential. Approve the app in your Slack workspace. Set the channel and customize the message text.
  8. Open the OpenAI nodes and create a new credential using your API key from the OpenAI website. In the Answer Question with Context node, set your assistant or model settings and confirm the context instructions.
  9. Review the Set Variables node to ensure the doc title and filename fields pull from the webhook data correctly.
  10. Click Execute node on the Webhook and send a test request from Postman or curl with a real PDF. Confirm a new Google Doc is created and populated with Q and A content.
  11. If the PDF fails to parse, check the file field name and content type. If OpenAI calls fail, verify the API key and model settings. If Gmail or Slack do not send, recheck credentials and scopes.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Gmail

Sign up

No cost: Personal Gmail (Gmail API has no usage-based pricing; quotas apply)

Google Docs

Sign up

Free: $0, Google Docs API usage at no additional cost (quota limits apply)

OpenAI

Sign up

Pay-as-you-go: GPT-5 at $1.25 per 1M input tokens and $10 per 1M output tokens

Slack

Sign up

Free plan: $0 / mo; limited to 10 apps (third-party or custom) and usable via Slack API

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.