Realtime Shipment Tracking Using n8n Automation Workflow

n8n pulls shipment statuses from FedEx API, updates Google Sheets, and notifies stakeholders via email.

• n8n installed.
• FedEx account with API access.
• Google Sheets with API credentials.
• Gmail account with API key.

 

Prepare n8n Environment

• Navigate to http://localhost:5678 and log in.
• Click “Workflows,” then “+ New,” and name it (e.g., “Shipment Tracker”). Click “+” to start.

Trigger Node: Schedule

Node: Schedule

Settings:

• Interval: Every 4 hours

Output: Trigger signal.

Track Node: FedEx

Node: HTTP Request

Settings:

• Method: POST
• URL: FedEx tracking API endpoint
• Body: Tracking number (e.g., {{ "123456789" }})

Output: Status (e.g., {{ $json.status }}).

Update Node: Google Sheets

Node: Google Sheets

Settings:

• Credentials: Google API key
• Operation: Append
• Sheet ID: Shipment log sheet ID
• Data: {{ $node["HTTP Request"].json.status }}

Output: Log updated.

Notify Node: Gmail

Node: Gmail

Settings:

• To: logistics@example.com
• Subject: Shipment Update
• Body: Status: {{ $node["HTTP Request"].json.status }}

Output: Email sent.

• Flow: Schedule (trigger) → FedEx (track) → Google Sheets (update) → Gmail (notify).
• Execution: ~15 seconds.

• Automates tracking updates.
• Improves delivery transparency.
• Saves ~1 hour daily on manual checks.

 

• FedEx Fail: Check API key and tracking number.
• Sheets Issues: Verify permissions.

Ready to transform your business with our technology solutions? Contact Us  today to Leverage Our AI/ML Expertise.