AI Agent for Transportation Order Management with GPT-4o and Open Route API

This n8n workflow automates the process of managing transportation orders by leveraging AI to extract information from emails, enrich it with routing data, and then store it in Google Sheets. It also includes a human-in-the-loop approval step via email.

What it does

This workflow streamlines transportation order management through the following steps:

1. Triggers on new emails: It continuously monitors a specified Gmail inbox for new emails.
2. Processes email content with an AI Agent: The content of incoming emails is fed to an AI Agent (powered by an OpenAI Chat Model) which is designed to identify and extract key information related to transportation orders.
3. Parses structured output: The AI Agent's response is then processed by a Structured Output Parser to ensure the extracted data is in a consistent, usable format.
4. Enriches data with routing information: An HTTP Request node is used to query an external API (likely an Open Route API, given the directory name) to get additional routing details based on the extracted order information.
5. Prepares data for Google Sheets: An "Edit Fields (Set)" node transforms and formats the data into the correct structure for Google Sheets.
6. Stores data in Google Sheets: The processed transportation order details, including routing information, are appended to a designated Google Sheet.
7. Sends an approval email: A Gmail node sends an email to a designated recipient for human review and approval of the transportation order.
8. Waits for approval: The workflow pauses, awaiting a response to the approval email. (Note: The current JSON does not show a direct connection for the approval response, implying a manual check or a separate workflow for handling responses).

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Gmail Account: A configured Gmail credential in n8n for triggering on new emails and sending approval requests.
• OpenAI API Key: A credential for OpenAI to power the AI Agent's chat model.
• Google Sheets Account: A configured Google Sheets credential in n8n for storing transportation order data.
• External Routing API: Access to an external routing API (e.g., Open Route API) that can be queried via HTTP requests.

Setup/Usage

1. Import the workflow: Download the workflow JSON and import it into your n8n instance.
2. Configure Credentials:
   • Set up your Gmail Account credential for both the "Gmail Trigger" and "Gmail" nodes.
   • Configure your OpenAI API Key credential for the "OpenAI Chat Model" node.
   • Set up your Google Sheets Account credential for the "Google Sheets" node.
3. Update Node Settings:
   • Gmail Trigger: Configure the mailbox and filters to listen for relevant transportation order emails.
   • AI Agent: Review and potentially refine the prompt for the AI Agent to accurately extract transportation order details.
   • HTTP Request: Update the URL and parameters for your chosen external routing API. Ensure it correctly uses data from previous nodes (e.g., origin, destination) to fetch routing information.
   • Edit Fields (Set): Adjust the fields to match the schema of your Google Sheet and the data extracted by the AI Agent and routing API.
   • Google Sheets: Specify the Spreadsheet ID and Sheet Name where the data should be appended.
   • Gmail (Approval): Configure the recipient email address for approval requests and customize the email content.
   • Wait: Adjust the wait duration if necessary.
4. Activate the workflow: Once configured, activate the workflow to start processing incoming emails automatically.