Meet Andrea. She is the owner of a small but incredibly popular chain of three coffee shops, “Aroma di Roma,” in the heart of Rome. Her establishments are oases of comfort, where the aroma of freshly brewed espresso mixes with the scent of hot cornetti. Andrea poured her soul into them, and the city responded with love. Her coffee became so famous that every morning, from eight to ten, queues of tourists and local office workers stretched far out onto the cobblestones.
But soon, Andrea began to notice a worrying trend. She was facing the paradox of success: the more popular her coffee shops became, the more often she started losing her most valuable customers. Regulars who worked in nearby offices simply couldn’t afford to wait in line for 15 minutes for their morning cappuccino. Her success was starting to create problems for her. Andrea knew she urgently needed a “Click & Collect” system (order online—pick up when ready), but without expensive apps and complex integrations that would ruin her business’s economics. And she found an elegant solution.
The Price of the Morning Queue
The problem Andrea faced is familiar to many successful small businesses. It’s not just an inconvenience; it represents real financial and reputational losses.
- Losing Regular Customers. This is the biggest threat to a local business. Regular customers who are rushing to work are the least patient with queues. They provide stable income, and their loyalty is the most valuable asset. By losing them, a business loses its foundation.
- Staff Overload During Peak Hours. Andrea’s head barista, Marco, a talented master of his craft, turned into a tired operator during the morning rush. He was simultaneously trying to take orders, process payments, prepare five different drinks, and not mix anything up. This led to stress, mistakes, and the inevitable burnout of the team.
- A Negative Experience for Everyone. Nobody likes to stand in line or wait for their order in a crowded space. This creates a tense atmosphere for both the guests in a hurry and those who would like to quietly enjoy their coffee at a table but can’t due to the general chaos.
The Solution’s Architecture: An Elegant “Click & Collect” System
Andrea decided not to buy ready-made software but to create her own system from simple and accessible tools that would work together like a well-coordinated orchestra.
- The Telegram Bot — The Customer’s “Personal Waiter.”
This is the point of contact for the customer. A client goes to Telegram, finds the “Aroma di Roma” bot, selects drinks and pastries from a simple menu, specifies the desired pickup time (e.g., “in 10 minutes”), and immediately pays for the order. To create the bot, Andrea used a no-code platform like ManyChat. - Airtable — The Barista’s “Digital Order Screen.”
Instead of paper receipts or shouting across the room, the barista Marco now has a tablet with an open Airtable sheet. Each new order from the bot automatically appears here as a new row with fields: “Pickup Time,” “Order,” “Customer Name,” “Status” (e.g., “New,” “Preparing,” “Ready”). - Stripe — For Instant and Secure Payments.
At the end of the order, the bot provides the client with a link to a payment page created in Stripe. This allows for accepting online payments from any card, including via Apple Pay and Google Pay, making the process as fast as possible. - Zapier — The “Digital Runner” That Connects Everything.
This automation service is the heart of the system. It instantly transmits data about a new paid order from the Telegram bot to the Airtable sheet and also sends notifications.
Step-by-Step Setup in Under an Hour
Creating such a system does not require programming skills and only takes a few hours.
Step 1: Create the Order Database in Airtable
Andrea created a new base with a single table. In it, she made the following columns: “Customer Name” (text), “Order” (long text), “Pickup Time” (time), “Paid” (currency), and most importantly—”Status” (a drop-down list with options “New,” “Preparing,” “Ready for Pickup”).
Step 2: Set up the Telegram Bot
In a visual builder (like ManyChat), Andrea created a simple message sequence: a greeting, a “Place an Order” button, a few consecutive questions to choose drinks and pastries, a request for the desired time, and finally, a message with a payment link from Stripe.
Step 3: Connect the Bot and the Database using Zapier
Andrea set up two simple scenarios (Zaps):
Scenario A: New Order.
- Trigger: A new successful order in the Telegram bot.
- Action: Create a new record in the Airtable sheet, mapping the data from the bot to the corresponding columns (“Customer Name” -> to the “Customer Name” column, etc.).
Scenario B: Order is Ready.
- Trigger: When a barista changes the order status in Airtable to “Ready for Pickup.”
- Action: Automatically send a message to the client in Telegram: “Andrea, your cappuccino and cornetto are waiting for you at ‘Aroma di Roma’ on Via del Corso! You can pick them up without the queue.”
Pro Tip: Set up color formatting for rows in Airtable. For example, have new orders automatically highlighted in red, those in progress in yellow, and ready ones in green. This allows baristas to instantly see priorities with a single glance at the screen.
The Results — How “Aroma di Roma” Got Rid of Queues and Increased Profits
The implementation of this simple system had a colossal effect on Andrea’s business.
- Increased Throughput by 30% During Peak Hours. Since some orders were prepared in advance, the team began to serve significantly more people in the same amount of time, which directly impacted revenue.
- The Return of Loyal Customers. Satisfied office workers happily returned. The ability to order coffee on their way to work and pick it up in 15 seconds without a queue became invaluable to them.
- Reduced Stress and Errors for Staff. The barista Marco and his colleagues now see a clear, prioritized list of orders on a tablet. This allows them to prepare drinks calmly and consistently, without fear of mixing something up.
- Improved Cash Flow and Zero Losses. Thanks to 100% prepayment, the coffee shop receives money before the order is even handed over. This completely eliminates the risk of “unclaimed” or unpaid drinks.
- A Powerful Competitive Advantage. The innovative “Click & Collect” service became a unique offering that distinguished the “Aroma di Roma” coffee shops from hundreds of other excellent but less technologically advanced establishments in Rome.
Scaling a Business Through Smart Automation
Andrea’s story is a vivid example of how automation helps not just tech startups but also traditional small businesses solve growth problems, improve customer service, and scale effectively. Often, the best solution is not an expensive and complex system, but a creative combination of simple and accessible tools that you already have at your fingertips.
This approach allows business owners to remain flexible, quickly test new ideas, and improve processes without attracting large investments.
Have a similar problem in your business, but don’t know how to select and connect the tools to solve it? Ask for advice, and our specialists will help you create an effective solution.
