To view the n8n flow demo and copy the JSON you need to purchase our Bundle... don't worry, it's FREE

Go to the BUNDLE

Build an OpenAI Assistant with Google Drive Integration

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 (eg, 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 : Use the updated assistant to respond to user queries.
    • Memory : Window Buffer Memory retains chat context for coherent conversations.

Setup Steps

  1. Prepare the Document :

    • Store your travel agency guide in Google Drive (eg, 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 (eg, "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.
Do you want to automate your business?

Let's talk about your project