Oka Hironobu
Workflows by Oka Hironobu
Track meal nutrition from meal photos with LINE, Google Gemini and Google Sheets
# AI Meal Nutrition Tracker with LINE and Google Sheets ## Who's it for This workflow is designed for health-conscious individuals, fitness enthusiasts, and anyone who wants to track their daily food intake without manual calorie counting. It is best suited for users who want a simple, AI-powered meal logging system that analyzes food photos one at a time and provides instant nutritional feedback via LINE. ## What it does This workflow processes a single meal photo sent via LINE, analyzes it using Google Gemini AI to identify foods and estimate nutritional content, and stores the data in Google Sheets for tracking. The workflow focuses on simplicity and encouragement: it receives a meal image, performs AI-based food recognition, estimates calories and macronutrients, calculates a health score, provides personalized advice, and replies with a detailed nutritional breakdown on LINE. ## How it works 1. A single meal photo is sent to the LINE bot. 2. The workflow is triggered via a LINE webhook. 3. The image file is downloaded and sent to Google Gemini AI for food analysis. 4. The AI identifies foods and estimates nutritional values (calories, protein, carbs, fat, fiber). 5. A health score (1-10) is calculated with personalized improvement tips. 6. The data is appended to Google Sheets for meal history tracking. 7. The image is uploaded to Google Drive for reference. 8. A formatted nutritional report with advice is sent back as a LINE reply. This workflow is intentionally designed to handle **one image per execution**. ## Requirements To use this workflow, you will need: - A LINE Messaging API account - A Google Gemini API key - A Google account with access to Google Sheets and Google Drive - A Google Sheets document with the following column names: - Date - Time - Meal Type - Food Items - Calories - Protein (g) - Carbs (g) - Fat (g) - Fiber (g) - Health Score - Advice - Image URL ## Important limitations - This workflow **does not support multiple images sent in a single message**. - Sending images in quick succession may trigger multiple executions and lead to unexpected results. - Only the first image in an event payload is processed. - Nutritional values are **AI estimates** based on visual analysis and typical serving sizes. - Accuracy depends on image quality, lighting, and food visibility. - This tool should **not replace professional dietary advice**. These limitations are intentional to keep the workflow simple and easy to understand. ## How to set up 1. Create a LINE Messaging API channel and obtain a Channel Access Token. 2. Generate a Google Gemini API key. 3. Update the Config node with your LINE token, Google Sheets ID, Google Drive folder ID, and daily calorie goal. 4. Configure credentials for LINE, Google Gemini, Google Sheets, and Google Drive. 5. Register the n8n webhook URL in your LINE channel settings. 6. Activate the workflow in n8n and test it with a single meal photo. ## How to customize - Modify the AI prompt in the "Analyze Meal with AI" node to support different languages or dietary frameworks (keto, vegan, etc.). - Adjust the daily calorie goal in the Config node to match individual needs. - Add additional nutritional fields such as sodium, sugar, or vitamins. - Replace Google Sheets with a fitness app API or database. - Integrate with other services to send daily/weekly nutrition summaries. --- **Note:** This workflow was tested using real meal photos sent individually via the LINE Messaging API. Nutritional estimates are approximations and may vary from actual values. For accurate dietary tracking, consult a registered dietitian.
Sync AI-enriched TimeRex bookings to Google Sheets and Slack with Gemini
# TimeRex AI-Powered Booking Automation ## Description (for n8n template submission) Transform your TimeRex booking management with AI-powered automation. This workflow automatically processes bookings, enriches data with AI insights, and keeps your team informed via Slack—all in real-time. ### What This Workflow Does **🤖 AI-Powered Intelligence** - **Smart Company Detection**: Automatically identifies company names from guest email domains - **Booking Categorization**: Uses Google Gemini to classify bookings (Sales/Support/Interview/Partnership/Media) - **Meeting Brief Generation**: AI creates actionable preparation notes for hosts before each meeting **⚡ Automated Processing** - Receives webhooks from TimeRex for confirmed and cancelled bookings - Validates requests with security token verification - Logs enriched booking data to Google Sheets - Sends detailed Slack notifications with AI-generated insights **🛡️ Security & Reliability** - Token-based webhook authentication - Security alerts for unauthorized access attempts - Automatic cancellation handling with data cleanup ### Use Cases - **Sales Teams**: Automatically categorize leads and prepare meeting briefs - **Recruitment**: Streamline interview scheduling with AI-powered candidate insights - **Customer Success**: Track support meetings and prepare context for calls - **Media Relations**: Manage press interviews with automated briefings ### How It Works 1. TimeRex sends a webhook when a booking is confirmed or cancelled 2. Security token is verified (failed attempts trigger Slack alerts) 3. For confirmed bookings: - Media source is detected from calendar name - Company name is extracted from email domain - AI categorizes the booking purpose - AI generates a meeting preparation brief - Enriched data is saved to Google Sheets - Slack notification is sent with AI insights 4. For cancellations: - Booking is found by Event ID - Row is deleted from Google Sheets - Cancellation alert is sent to Slack ### Setup Instructions 1. **Webhook Configuration** - Copy the webhook URL from the "TimeRex Webhook" node - Paste it in TimeRex Settings → Webhook 2. **Security Token** - Copy your TimeRex security token - Update the `Verify Security Token` node with your token 3. **Google Sheets** - Create a spreadsheet with these columns: `event_id`, `booking_date`, `guest_name`, `guest_email`, `calendar_name`, `meeting_url`, `host_name`, `media_source`, `company_name`, `booking_category`, `ai_meeting_brief`, `created_at` - Update all Google Sheets nodes with your Sheet ID 4. **AI Credentials** - Connect your Google Gemini API credentials to both AI model nodes 5. **Slack** - Connect your Slack account - Select your notification channel in all Slack nodes 6. **Activate** - Turn on the workflow and start receiving AI-enhanced booking notifications! ### Requirements - TimeRex account with webhook access - Google Cloud account (for Sheets & Gemini API) - Slack workspace - n8n instance (self-hosted or cloud) ### Customization Tips - Modify the `Filter by Calendar Type` node to match your calendar naming convention - Adjust AI prompts in the LLM Chain nodes for different categorization or brief styles - Add more media sources to the Media Master sheet for accurate source tracking - Extend the workflow with email confirmations or calendar event creation --- ## Short Description (100 characters max) Automate TimeRex bookings with AI-powered categorization, meeting briefs, and Slack notifications. --- ## Categories - Sales - Productivity - AI - Scheduling --- ## Tags TimeRex, Booking, AI, Google Gemini, Slack, Google Sheets, Automation, Meeting Management, LLM, Scheduling
Automate business card management with LINE, AI, and Google Sheets
# Automate Business Card Management with LINE, AI, and Google Sheets ## Who's it for This workflow is designed for business professionals and sales teams who receive business card images via LINE and want to quickly digitize contact information with minimal manual work. It is best suited for users who process business cards one image at a time and want a simple, reliable automation rather than a high-volume ingestion pipeline. ## What it does This workflow processes a single business card image sent via LINE, extracts text using Google Gemini AI, and stores the structured contact information in Google Sheets. The workflow focuses on simplicity and clarity: it receives an image, performs AI-based OCR, parses the extracted text, saves the result, uploads the original image for reference, sends a thank-you email, and replies with the extracted data on LINE. ## How it works 1. A single business card image is sent to the LINE bot. 2. The workflow is triggered via a LINE webhook. 3. The image file is downloaded and sent to Google Gemini AI for OCR. 4. The extracted text is parsed into structured fields. 5. The data is appended to Google Sheets. 6. The image is uploaded to Google Drive. 7. A thank-you email is sent via Gmail. 8. The extracted information is sent back as a LINE reply. This workflow is intentionally designed to handle **one image per execution**. ## Requirements To use this workflow, you will need: - A LINE Messaging API account - A Google Gemini API key - A Google account with access to Google Sheets and Google Drive - A Gmail account for sending thank-you emails - A Google Sheets document with the following column names: - Company Name - Contact Name - Department - Address - Email Address - Phone Number ## Important limitations - This workflow **does not support multiple images sent in a single message**. - Sending images in quick succession may trigger multiple executions and lead to unexpected results. - Only the first image in an event payload is processed. - OCR accuracy depends on image quality, lighting, and card design. These limitations are intentional to keep the workflow simple and easy to understand. ## How to set up 1. Create a LINE Messaging API channel and obtain a Channel Access Token. 2. Generate a Google Gemini API key. 3. Update the Config node with your LINE token, Google Sheets ID, and Google Drive folder ID. 4. Configure credentials for LINE, Google Gemini, Google Sheets, Google Drive, and Gmail. 5. Register the n8n webhook URL in your LINE channel settings. 6. Activate the workflow in n8n and test it with a single business card image. ## How to customize - Modify the AI prompt in the “Extract Card Info” node to support different languages or fields. - Adjust the parsing logic to match different business card layouts. - Replace Google Sheets with a CRM or database. - Add queueing or locking logic if you want to support batch or sequential image uploads. --- **Note:** This workflow was tested using real business card images sent individually via the LINE Messaging API. For production use, testing with your own card samples is strongly recommended.