n8nflow.net logo

Build an OpenAI Assistant with Google Drive Integration

by DavideUpdated: Last update 8 months agoSource: n8n.io
Loading workflow viewer...

Getting Started

Workflow Overview

This workflow automates the creation and management of a custom OpenAI Assistant for a travel agency ("Travel with us"), leveraging Google Drive for document storage.


How It Works

1. Create the OpenAI Assistant

  • Node : OpenAI
    • Action : Creates a custom assistant named "Travel with us" Assistant using the gpt-4o-mini model.
    • Instructions :
      • Respond only using the provided document (e.g., agency-specific info).
      • Stay friendly, brief, and focused on travel-related queries.
      • Ignore irrelevant questions politely.
    • Credentials : Requires OpenAI API key.

2. Upload Agency Document

  • Google Drive Node :
    • Action : Downloads a Google Doc as a PDF.
  • OpenAI2 Node :
    • Action : Uploads the PDF to OpenAI with purpose: "assistants".
    • Output : Generates a file_id.

3. Update the Assistant with the Document

  • OpenAI Node :
    • Action : Updates the assistant to include the uploaded file.

4. Chat Interaction

  • Chat Trigger :
    • Activates when a message is received ("When chat message received").
  • OpenAI Assistant Node :
    • Action : Uses the updated assistant to respond to user queries.
    • Memory : Window Buffer Memory retains chat context for coherent conversations.

Set Up Steps

  1. Prepare the Document :

    • Store your travel agency guide in Google Drive (e.g., as a Google Doc).
    • Update the Google Drive node with your document’s ID.
  2. Configure Credentials :

    • Google Drive : Connect via OAuth2 (googleDriveOAuth2Api).
    • OpenAI : Add your API key to all OpenAI nodes.
  3. Customize the Assistant :

    • Modify the instructions in the OpenAI node to reflect your agency’s needs.
    • Ensure the document includes FAQs, policies, and travel info.
  4. Test the Workflow :

    • Trigger manually ("Test workflow") to create the assistant and upload the file.
    • Send a chat message (e.g., "What are your travel packages?") to test responses.

Dependencies

  • Google Drive Account : To store and retrieve the agency document.
  • OpenAI API Access : For assistant creation and file uploads.