Forms & Surveys
Confirm Deliveries with a Telegram Bot and Google Drive
When a driver messages the Telegram bot, it collects GPS location and delivery details, stores them in Google Sheets and Drive and emails confirmation via Gmail.
What it does
### 3. Driver's Input Collection Block Based on the state flag value, the workflow process the input expected from the driver. The waiting conditions code node is filtering the request based on the workplace state variable value - If the value is waitingXXX: the output from the driver is processed, a value is recorded in a code node and a confirmation message is sent to the driver (including the next command to follow) - If the value does not start with waiting: a message with instructions is sent to the driver #### How to setup? - Telegram Message Nodes: set up your telegram bot credentials Learn more about the Telegram Message Node - Google Drive Nodes: 1. Add your Google Drive API credentials to access your drive 2. Select the folder using the list, an URL or an ID 3. Select the sheet in which the vocabulary list is stored Learn more about the Google Drive Node
The steps
- Telegram Trigger
- Check State
- Clear State
- addGPS
- Welcome Message
- Command?
- Store GPS Location
- addGPS result
- addShipmentNumber
- Shipment Number
- addShipmentNumber result
- Store Shipment
- Store GPS
- Load Workspace Data
32 steps in total.
Similar automations
Data Sync & ETLFlag at-risk supplier deliveries with Google Sheets and Slack alerts15 stepsAI Agents & AssistantsRetry webhook deliveries with exponential backoff and a dead-letter queue webhook9 stepsAI Agents & AssistantsConfirm Clinic Appointments via Telegram and WhatsApp AI31 stepsForms & SurveysRun a WhatsApp Survey Bot with Postgres Storage22 steps