Get Started
Back to Templates

Build an OpenAI Assistant with Google Drive Integration

Created by

Created by: Davide || n3witalia

Davide

Last update

Last update 6 months ago

Categories

Share

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.