HumationHuman + Automation
Back to Catalog

Analyze food ingredients from Telegram photos using Gemini and Airtable

EhsanEhsan
146 views
2/3/2026
NotificationMessagingIntegrationMattermostCommunication
Official Page

Analyze food ingredients from Telegram photos using Gemini and Airtable

telegram_demo.png

🛡️ Personal Ingredient Bodyguard

Turn your Telegram bot into an intelligent food safety scanner. This workflow analyzes photos of ingredient labels sent via Telegram, extracts the text using AI, and cross-references it against your personal database of "Good" and "Bad" ingredients in Airtable.

It solves the problem of manually reading tiny, complex labels for allergies or dietary restrictions. Whether you are Vegan, Halal, allergic to nuts, or just avoiding specific additives, this workflow acts as a strict, personalized bodyguard for your diet. It even features a customizable "Persona" (like a Sarcastic Bodyguard) to make safety checks fun.

🎯 Who is it for?

  • People with specific dietary restrictions (Vegan, Gluten-free, Keto).
  • Individuals with food allergies (Nuts, Dairy, Shellfish).
  • Special dietary observers (Halal, Kosher).
  • Health-conscious shoppers avoiding specific additives (e.g., E120, Aspartame).

🚀 How it works

  1. Trigger: You send a photo of a product label to your Telegram Bot.
  2. Fetch Rules: The workflow retrieves your active "Watchlist" (Ingredients to avoid/prefer) and "Persona" settings from Airtable.
  3. Vision & Logic: It uses an AI Vision model to extract text from the image (OCR) and Google Gemini to analyze the text against your strict veto rules (e.g., "Safe" only if ZERO bad items are found).
  4. Response: The bot replies instantly on Telegram with a Safe/Unsafe verdict, highlighting detected ingredients using HTML formatting.
  5. Log: The result is saved back to Airtable for your records. Screenshot 20251123 142943.png

⚙️ How to set up

This workflow relies on a specific Airtable structure to function as the "Brain."

  1. Set up Airtable
  2. Set up Telegram
    • Message @BotFather on Telegram to create a new bot and get your API Token.
    • Add your Telegram credentials in n8n.
  3. Configure AI
    • Add your Google Gemini API credentials.
    • Note on OCR: This template is configured to use a local LLM for OCR to save costs (via the OpenAI-compatible node). If you do not have a local model running, simply swap the "OpenAI Chat Model" node for a standard GPT-4o or Gemini Vision node.

📋 Requirements

  • n8n (Cloud or Self-hosted)
  • Airtable account (Free tier works)
  • Telegram account
  • Google Gemini API Key
  • Local LLM (Optional, for free OCR) OR OpenAI/Gemini Key (for standard Cloud Vision)

🎨 How to customize

  • Change the Persona: Go to the "Preferences" table in Airtable to change the bot's personality (e.g., "Helpful Nutritionist") and output language. Screenshot 20251123 142925.png
  • Update Ingredients: Add or remove items in the "Watchlist" table. Mark them as "Good Stuff" or "Bad Stuff" and set Status to "Active". Screenshot 20251123 142905.png
  • Adjust Sensitivity: The AI prompt in the "AI Agent" node is set to strict "Veto" mode (Bad overrides Good). You can modify the system prompt to change this logic.

⚠️ Disclaimer

This tool is for informational purposes only.

  1. Not Medical Advice: Do not rely on this for life-threatening allergies.
  2. AI Limitations: OCR can misread text, and AI can hallucinate.
  3. Verify: Always double-check the physical product label.

Use at your own risk.

Analyze Food Ingredients from Telegram Photos using Gemini and Airtable

This n8n workflow automates the process of analyzing food ingredients from photos sent via Telegram, leveraging Google Gemini for AI analysis and Airtable for storing the results. It simplifies the task of extracting and organizing information about food items, making it easier to track dietary details or manage inventory.

What it does

  1. Listens for Telegram Messages: The workflow is triggered whenever a new message is received in a configured Telegram bot.
  2. Extracts Photo Information: It processes the incoming Telegram message to identify if it contains a photo and extracts relevant details like the file ID.
  3. Analyzes Photo with Google Gemini: The extracted photo is sent to the Google Gemini Chat Model for AI-powered analysis of its contents, specifically focusing on identifying food ingredients.
  4. Stores Analysis in Airtable: The analysis results from Google Gemini, along with the original Telegram message details, are then saved as a new record in a specified Airtable base.
  5. Sends Confirmation to Telegram: A confirmation message is sent back to the user via Telegram, indicating that the photo has been processed and the analysis stored.

Prerequisites/Requirements

To use this workflow, you will need:

  • n8n Instance: A running n8n instance (cloud or self-hosted).
  • Telegram Bot: A Telegram bot token and a chat ID to listen for messages and send responses.
  • Google Gemini API Key: Access to the Google Gemini API for AI analysis.
  • Airtable Account: An Airtable account with a base and a table configured to store the food ingredient analysis.

Setup/Usage

  1. Import the Workflow:

    • Download the provided JSON file.
    • In your n8n instance, go to "Workflows" and click "New".
    • Click the three dots in the top right corner and select "Import from JSON".
    • Paste the workflow JSON or upload the file.

  2. Configure Credentials:

    • Telegram Trigger:
      • Click on the "Telegram Trigger" node.
      • Add a new Telegram API credential, providing your Bot Token.
    • Google Gemini Chat Model:
      • Click on the "Google Gemini Chat Model" node.
      • Add a new Google Gemini API credential, providing your API Key.
    • Airtable:
      • Click on the "Airtable" node.
      • Add a new Airtable API credential, providing your API Key.

  3. Configure Nodes:

    • Telegram Trigger: Ensure the "Updates" are set to message and photo to capture incoming photos.
    • Google Gemini Chat Model:
      • Configure the prompt to instruct Gemini on how to analyze food ingredients from an image.
      • Map the incoming image data from the Telegram trigger to the Gemini node.
    • Airtable:
      • Select your Airtable "Base ID" and "Table Name".
      • Map the data from the previous nodes (Telegram message details, Gemini analysis) to the appropriate fields in your Airtable table.
    • Telegram (Send Message):
      • Configure the "Chat ID" to send the confirmation message back to the user. You can usually get this from the incoming Telegram message data.
      • Compose a confirmation message using data from the previous steps.

  4. Activate the Workflow:

    • Once all credentials and nodes are configured, save the workflow.
    • Toggle the workflow to "Active" to start listening for Telegram messages.

Now, when you send a photo of food to your Telegram bot, the workflow will automatically analyze its ingredients using Gemini and store the information in Airtable.

Related Templates

Automate event RSVPs with email validation & badge generation using VerifiEmail & HTMLCssToImage

Validated RSVP Confirmation with Automated Badge Generation Overview: This comprehensive workflow automates the entire event RSVP process from form submission to attendee confirmation, including real-time email validation and personalized digital badge generation. ✨ KEY FEATURES: • Real-time Email Validation - Verify attendee emails using VerifiEmail API to prevent fake registrations • Automated Badge Generation - Create beautiful, personalized event badges with attendee details • Smart Email Routing - Send confirmation emails with badges for valid emails, rejection notices for invalid ones • Comprehensive Logging - Track all RSVPs (both valid and invalid) in Google Sheets for analytics • Dual Path Logic - Handle valid and invalid submissions differently with conditional branching • Anti-Fraud Protection - Detect disposable emails and invalid domains automatically 🔧 WORKFLOW COMPONENTS: Webhook Trigger - Receives RSVP submissions Email Validation - Verifies email authenticity using VerifiEmail API Conditional Logic - Separates valid from invalid submissions Badge Creator - Generates HTML-based personalized event badges Image Converter - Converts HTML badges to shareable PNG images using HTMLCssToImage Email Sender - Delivers confirmation with badge or rejection notice via Gmail Data Logger - Records all attempts in Google Sheets for tracking and analytics 🎯 PERFECT FOR: • Conference organizers managing hundreds of RSVPs • Corporate event planners requiring verified attendee lists • Webinar hosts preventing fake registrations • Workshop coordinators issuing digital badges • Community event managers tracking attendance 💡 BENEFITS: • Reduces manual verification time by 95% • Eliminates fake email registrations • Creates professional branded badges automatically • Provides real-time RSVP tracking and analytics • Improves attendee experience with instant confirmations • Maintains clean, verified contact lists 🛠️ REQUIRED SERVICES: • n8n (cloud or self-hosted) • VerifiEmail API (https://verifi.email) • HTMLCssToImage API (https://htmlcsstoimg.com) • Gmail account (OAuth2) • Google Sheets 📈 USE CASE SCENARIO: When someone submits your event RSVP form, this workflow instantly validates their email, generates a personalized badge with their details, and emails them a confirmation—all within seconds. Invalid emails receive a helpful rejection notice, and every submission is logged for your records. No manual work required! 🎨 BADGE CUSTOMIZATION: The workflow includes a fully customizable HTML badge template featuring: • Gradient background with modern design • Attendee name, designation, and organization • Event name and date • Email address and validation timestamp • Google Fonts (Poppins) for professional typography 📊 ANALYTICS INCLUDED: Track metrics like: • Total RSVPs received • Valid vs invalid email ratio • Event-wise registration breakdown • Temporal patterns • Organization/company distribution ⚡ PERFORMANCE: • Processing time: ~3-5 seconds per RSVP • Scales to handle 100+ concurrent submissions • Email delivery within 10 seconds • Real-time Google Sheets updates 🔄 EASY SETUP: Import the workflow JSON Configure your credentials (detailed instructions included) Create your form with required fields (name, email, event, designation, organization) Connect the webhook Activate and start receiving validated RSVPs! 🎓 LEARNING VALUE: This workflow demonstrates: • Webhook integration patterns • API authentication methods • Conditional workflow branching • HTML-to-image conversion • Email automation best practices • Data logging strategies • Error handling techniques ---

Jitesh DugarBy Jitesh Dugar
67

Send Rapiwa WhatsApp apology & reorder link when Shopify order is cancelled

Who Is This For? This n8n workflow listens for order cancellations in Shopify, extracts relevant customer and order data, checks if the customer’s phone number is registered on WhatsApp via the Rapiwa API, and sends a personalised apology message with a re-order link. It also logs successful and unsuccessful attempts in Google Sheets for tracking. What This Workflow Does Listens for cancelled orders in your Shopify store Extracts customer details and order information Generates a personalised apology message including a reorder link Sends the message to customers via WhatsApp using a messaging API (e.g., Twilio or Rapiwa) Logs the communication results for tracking purposes Key Features Real-Time Cancellation Detection: Automatically triggers when an order is cancelled Personalised Messaging: Includes customer name, order details, and a direct reorder link WhatsApp Integration: Sends messages via WhatsApp for higher engagement Error Handling: Logs successful and failed message deliveries Reorder Link: Provides a convenient link for customers to reorder with one click Requirements n8n instance with nodes: Shopify Trigger, HTTP Request (for WhatsApp API), Code, Google Sheets (optional) Shopify store with API access WhatsApp messaging provider account with API access Valid customer phone numbers stored in Shopify orders How to Use — Step-by-Step Setup Credentials Setup Shopify API: Configure Shopify API credentials in n8n to listen for order cancellations WhatsApp API: Set up WhatsApp messaging credentials (e.g., Twilio, Rapiwa, or any supported provider) Google Sheets (Optional): Configure Google Sheets OAuth2 if you want to log communications Configure Trigger Set the workflow to trigger on Shopify order cancellation events Customize Message Content Modify the apology message template to include your store branding and tone Ensure the reorder link dynamically includes the customer's cancelled order info Set Up WhatsApp Node Connect your WhatsApp API credentials Ensure the phone numbers are formatted correctly for WhatsApp delivery Google Sheet Required Columns You’ll need two Google Sheets (or two tabs in one spreadsheet): A Google Sheet formatted like this ➤ sample The workflow uses a Google Sheet with the following columns to track coupon distribution: | Name | Number | Email | Address | Price | Title | Re-order Link | Validity | Status | | -------------- | ------------- | --------------------------------------------------- | ----------------- | ----------- | -------------- | ------------------------------------------------------------------------------------------------------------------------------------------------ | ------------ | ---------- | | Abdul Mannan | 8801322827799 | contact@spagreen.net | Dhaka, Bangladesh | BDT 1955.00 | Pakistani Lawn | Link 🔗 | unverified | not sent | | Abdul Mannan | 8801322827799 | contact@spagreen.net | Dhaka, Bangladesh | BDT 1955.00 | Pakistani Lawn | Link 🔗 | verified | sent | Important Notes Phone Number Validation: Ensure customer phone numbers are WhatsApp-enabled and formatted properly API Rate Limits: Respect your WhatsApp provider’s API limits to avoid throttling Data Privacy: Always comply with privacy laws when messaging customers Error Handling: Monitor logs regularly to handle failed message deliveries Testing: Test thoroughly with dummy data before activating the workflow live Useful Links Dashboard: https://app.rapiwa.com Official Website: https://rapiwa.com Documentation: https://docs.rapiwa.com Support & Help WhatsApp: Chat on WhatsApp Discord: SpaGreen Community Facebook Group: SpaGreen Support Website: https://spagreen.net Developer Portfolio: Codecanyon SpaGreen

RapiwaBy Rapiwa
103

Automate job searching & resume customization with AI, LinkedIn & Google Sheets

🤖 AI-Powered Job Matcher & Resume Customizer Description This advanced workflow automates the entire job search and preparation process, moving beyond simple notifications to provide AI-driven career intelligence. It connects to LinkedIn to scrape fresh job postings, filters against jobs you've already seen, and then uses powerful LLMs (Mistral Large/Small) to perform a detailed resume-to-job match, generate tailored cover letters, and provide concrete resume improvement suggestions. All data is logged into a Google Sheet for comprehensive tracking, and a clean, single Daily Digest Email summarizes the top 5 matches found each day. --- ✨ Key Features Automated Scheduling: Runs daily to find new job postings. Multi-Keyword Search: Uses your main job title and three alternate titles generated by an AI Agent for maximum search coverage. LinkedIn Web Scraping: Pulls new job URLs, details, location, and salary data from LinkedIn Search results. Duplicate Prevention: Uses the Compare Datasets node to ensure only new, unseen jobs are processed against your master Google Sheet. Intelligent Matching (LLM): The workflow performs a detailed job-to-resume comparison, generating: A Match Score (0-100) with evidence for alignment in skills, experience, and domain. A Tailored Cover Letter specific to the job title and company. Actionable Resume Improvement points (e.g., [ADD], [QUANTIFY]) to optimize your resume for the specific role. Centralized Tracking: Saves all job data, match scores, cover letters, and resume suggestions to a Google Sheet. Professional Daily Digest: Sends a single, clean HTML email summarizing the top 5 highest-scoring job matches for easy review. --- 🛠️ Prerequisites n8n Credentials: Google Drive: To download your resume (PDF/DOCX file URL). Google Sheets: To connect to your job tracking sheet. Gmail: To send the daily digest email. Mistral Cloud: For the LLM processing (Resume Breakdown, Job Matching, and Resume Analysis). External Files: A Job Tracking Google Sheet (used as a master database). Your current Resume file (PDF recommended, hosted on Google Drive). Setup Notes: Update the file links (Download Resume node) and Google Sheet details (Get row(s)/Append nodes). Set your personal email address in the Send Digest Email node. Review the LLM prompts to tailor the AI agent's persona and output fields to your exact needs.

Jordan HoyleBy Jordan Hoyle
1405