n8n

How to Connect Google Drive to OpenAI Chat Support?

Turn a single document into a live chat guide for your website or sales team. The flow builds a focused assistant that answers only from the file you choose, so replies stay clear and on topic. It fits teams that want fast answers without training a full chatbot system.

The setup pulls a file from Google Drive, converts it to a PDF, uploads it to OpenAI, and links the file to a new or existing assistant. A chat trigger listens for messages, and a memory node keeps a short history so replies feel natural. Strict instructions tell the assistant to use only the attached file, which helps control quality and reduce off topic answers. Manual trigger steps handle creation and updates, while chat runs on a webhook for live use.

You need Google Drive and OpenAI accounts, plus n8n credentials. Add your file ID, choose an OpenAI model, and run the manual path once to load the content. Teams can expect faster replies, fewer repeat questions, and less time searching docs. Good fits include product FAQs, service menus, pricing notes, or travel packages.

What are the key features?

  • Manual trigger to run setup steps and test the build before going live
  • Google Drive download with automatic conversion to PDF and a named binary file
  • OpenAI assistant creation with clear system rules that restrict sources
  • File upload to OpenAI with the correct purpose so the assistant can use it
  • Assistant update that attaches uploaded file IDs to the selected assistant
  • Chat trigger with memory that sends messages to the assistant and keeps recent context

What are the benefits?

  • Reduce manual Q and A from 60 minutes to 10 minutes per day
  • Automate up to 80 percent of repeat questions with one source of truth
  • Improve answer accuracy by limiting replies to one approved file
  • Connect Google Drive and OpenAI without custom code
  • Scale to more users by serving many chats from 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 Google Drive and OpenAI. See the Tools Required section above for links to create accounts with these services.
  3. In the n8n credentials manager, open the Google Drive node, select Credential to connect with, click Create new credential, and follow the on screen steps to sign in to your Google account.
  4. Open the OpenAI nodes one by one, select Credential to connect with, click Create new credential, and paste your OpenAI API key from your OpenAI account API keys page.
  5. In the Google Drive node, set Operation to download. Paste the file ID from your Google Doc URL. Turn on Google file conversion to PDF and set the binary property name to data.pdf.
  6. Open the OpenAI assistant create node. Choose a model such as GPT 4o mini. Add a simple instruction that tells the assistant to answer only from the attached file.
  7. Open the OpenAI file upload node. Set purpose to assistants and set binaryPropertyName to data.pdf so it uploads the converted file.
  8. Open the OpenAI assistant update node. Select the target assistant ID and map the file IDs from the upload node output so the assistant can read the file.
  9. Open the chat trigger node. Copy the test webhook URL. Keep the Window Buffer Memory node linked to the assistant so recent messages are remembered.
  10. Run the manual trigger once. Check the execution to confirm the file downloaded, uploaded to OpenAI, and the assistant shows the new file ID.
  11. Send a test message to the chat trigger URL. Verify the reply pulls facts from your document and does not guess beyond it.
  12. If you see permission errors, make sure the Google account used by the credential can access the file. If the assistant cannot find the file, confirm the binary name is data.pdf and the file ID mapping is set in the update node.

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.

Google Drive

Sign up

Drive API: $0 (no additional cost; quota-limited)

OpenAI

Sign up

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

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.