Google Sheets node
Telegram node
+6

🚚 Automate Delivery Confirmation with Telegram Bot, Google Drive and Gmail

Published 4 days ago

Created by

samirsaci
Samir Saci

Categories

Template description

Tags: Supply Chain Management, Logistics, Transportation

Context

Hey! I'm Samir, a Supply Chain Engineer and Data Scientist from Paris founder of
LogiGreen Consulting

We design tools to help small and medium businesses in improving their logistics processes using data analytics and automation.

Let's use N8N to make supply chains more efficient and sustainable Supply Chains!

Who is this template for?

This workflow template is designed for logistics operations that cannot rely on a Transportation Management System to record proofs of deliveries.

Example of Logistic Operations

What is a delivery confirmation?

This workflow uses a Telegram bot to automatically notify logistics teams by email when a shipment is delivered.

Example of Delivery Notice

Drivers (equipped with their smartphones) can record their arrival with all the necessary information for accurate distribution planning.

How do we notify the delivery?

Let us imagine a truck driver arriving at the destination; he can contact the bot to be guided on how to record the delivery.

Screens of Telegram Discussion

  1. User Guide: the first bot's message is a brief explanation of the process
  2. Record Shipment Number: the bot asks the driver to share the shipment number and record it
  3. Collect GPS Location: the bot asks the driver to share its GPS location and record them
  4. Picture of the Shipment: the bot asks for a picture of the shipment and saves it in Google Drive
  5. Send Confirmation: after data collection, the bot proposes to send a confirmation to the logistics management team

An email is then automatically sent by the N8N workflow including all the information recorded by the flow and a picture of the shipment.

Example of Notification via Email

Prerequisite

This workflow does not require any additional paying subscription.

  • A Google Drive Account with a folder including a Google Sheet
  • API Credentials: Google Drive API, Google Sheets API and Gmail API
  • A Telegram Bot with its API token from BotFather
  • A Google sheet to store the shipment records with these five columns prepared: shipmentNumber, recordTime, gpsLattitude, gpsLongitude, cargoPicture, deliveryTime

Next Steps

Follow the sticky notes to set up the parameters inside each node and get ready to improve your logistics operations!

I have detailed the steps in a short tutorial πŸ‘‡
image.png
πŸŽ₯ Check My Tutorial

πŸš€ Interested in applications of N8N for Logistics & Supply Chain Management? Let's connect on Linkedin

Notes

  • This workflow can be adapted to add more functionalities. I explain how in the video.
  • The bot can handle multiple drivers at the same time.
  • If you want to learn more about the original tool designed with Python: 🚚 Blog Article about Telegram Shipment Tracking Bot

This workflow has been created with N8N 1.82.1
Submitted: March 17th, 2025

Share Template

Implement complex processes faster with n8n

red icon yellow icon red icon yellow icon