Home / How CamStreamer Turned Beer, QR Codes, and Flow Meters into a Seamless Trade Experience

How CamStreamer Turned Beer, QR Codes, and Flow Meters into a Seamless Trade Experience

01 Sep 2025 - 09:56

Are you curious about what a QR code reader and a flow meter have in common? In today's article, we will combine several apps to create an integration on the edge - Photo Booth for a trade show stand. We combine measuring the flow of liquid (beer in this case), reading the identification of a visitor (QR code on his beer cup) to fetch data from a database (Google Sheets), to send him a personalized email with a photo.


The main flow is as follows:




  • A visitor comes to the stand, and the hostess scans his badge. His name and email address are copied to a Google Sheets table.

  • The hostess gives the visitor a draught beer in a cup with ID encoded in a QR code. She notes the ID in the same table along with the visitor data.

  • The beer tap has a flowmeter installed, which keeps track of the amount of beer being drawn. Real-time data is displayed as an overlay in the camera’s video stream.

  • A salesman talks to the visitor and describes the overlay showing real-time data.

  • The visitor shows the beer cup with the code to the camera.

  • The camera scans the code, decodes the ID, fetches the visitor's data from the database, and sends them an email with a snapshot attached.



The result is that the visitor enjoys the good beer, which is a good ice-breaker for conversation with a salesperson.


On the backdrop of beer, he gets an explanation of video streaming, overlays, and everything else shown on the stand. Part of the stand tour is having a snapshot taken by a camera. Before leaving the stand, the visitor already has a follow-up e-mail with his own picture with a beer in hand in his inbox, resulting in an engaging experience.




How does the setup work

Axis camera

A camera was installed at around 2m height on the stand wall. In this particular case, we have used AXIS P3268-SLVE dome camera. The camera runs CamOverlay App, CamScripter App, and QR code reader application.

CamOverlay App on the camera

This ACAP by CamStreamer adds graphic overlays to the stream from the camera. The widget receives the data from CamScripter App running on Raspberry Pi and creates the graphics showing the amount of beer draught from each of the two beer taps.

CamScripter App on the camera

This ACAP by CamStreamer sends the email to the visitor. After receiving the webhook call from the QR code reader, it looks into the Google Sheet table and fetches the name and email of the visitor. Then it grabs a screen from the video stream, including CamOverlay widget(s), and sends an email using CamStreamer’s SMTP server. 

QR code reader

ACAP, provided by our friends from Peoly, recognizes and decodes QR codes in the picture. The app also notifies the user by adding graphics to the video stream, with a countdown and a mark when the actual webhook call is made. This adds to the good user experience.

Flowmeter with its master unit

Using two standard industrial tube flowmeters connected to a bespoke master unit, we can effectively measure the amount of beer that flows through each of the two taps. 

Raspberry Pi running another CamScripter App

This CamScripter App is ported to the standard mini-PC Raspberry Pi and reads out the data from the flowmeter’s master unit. The CamScripter App converts the data into a format digestible by the CamOverlay App running on the P3268-SLVE dome camera.

Google Sheet table

The table acts as a simple database for this setup. Either manually or using a simple Google Form, the hostess on the exhibition stand enters the name and email address of each visitor, adding the ID of the cup. This is where the visitor data is paired with the beer cup.



We hope you enjoyed the integration

  

This innovative setup seamlessly blends technology and hospitality to create a memorable trade show experience. By integrating QR code scanning, real-time flow measurement, and personalized email delivery, the system not only engages visitors with an interactive and fun activity but also provides a practical demonstration of advanced camera and data processing technologies. The combination of these elements ensures that visitors leave with a positive impression, a personalized keepsake, and a deeper understanding of the showcased technology, making it a powerful tool for both marketing and engagement.

Contact CamStreamer

 

Contact us today

In case of any questions or to arrange a meeting, please contact us.

 

Leave us a message



Author
CamStreamer Team

Related posts