Spreadsheet + webhook automation: COD order → call center → status → report

Samuel Freitas · 2026-10-07

Tools

Process automation in e-commerce can increase efficiency and reduce errors. Let’s break down each step to implement a solution that integrates COD (Cash on Delivery) orders with a call center and generates daily reports.

Fields

Start by defining which fields you need in your spreadsheet. The essentials include:

• Order ID
• Customer name
• Customer phone number
• Delivery address
• Order status (e.g., Pending, In progress, Completed)
• Order date
• Additional notes

This structure will make it easier to manage and track orders.

Webhook

The webhook is the key piece of the automation. Set up a webhook that connects to your order system. The flow should be:

1. An order is created in the system.
2. The webhook automatically sends the necessary data to the spreadsheet.
3. The spreadsheet updates order statuses in real time.

Make sure the webhook is set to trigger whenever a new COD order is registered.

Status

Create a status system that lets the call center track the situation of each order. Statuses can be:

• Pending: awaiting confirmation
• In progress: confirmation received, awaiting delivery
• Completed: order delivered
• Canceled: order not fulfilled

This categorization helps quickly identify which orders need attention.

Daily report

Set up a routine that generates a daily report with the following information:

• Total orders received that day
• Order statuses (how many are pending, in progress, etc.)
• Completed and canceled orders
• Average delivery time

You can use spreadsheet functions to generate charts and make the data easier to visualize.

Telegram alerts

Finally, set up Telegram alerts to notify the call center team about important updates. Alerts can include:

• New COD orders received
• Status changes (e.g., order completed)
• Orders that need special attention (e.g., orders pending for more than 24 hours)

To do this, use the Telegram API to integrate notifications with your spreadsheet.

Final thoughts

Implementing this automation can significantly reduce response time and improve the customer experience. By integrating the spreadsheet, webhook, and call center, you create an efficient and organized workflow.

How many COD orders do you receive per day, and how are you currently managing that data?