Hi, I have a client working in food preparation who stores dry food and frozen food to make meals. The expiry dates of the food is important and they need to avoid waste.
I need a Google Apps Script to check a Google Sheet for the background colour of cells in two columns that turn red (using conditional formatting) when the expiry date of the product is soon. This tells the client which ingredients to use first when making meals.
I would like the script to send an email if one or more of the product lines has a red background colour (indicating its imminent expiry). An example sheet (read-only) is available below: https://docs.google.com/spreadsheets/d/1BtdLG63l8nB2ppYcbLMknYN8PqdHmspIv9J6gPN3HB8/edit?usp=sharing
Ideally, the email will show the following: Email subject example (taken from Cell E2): "Restaurant Food Stores" Expiry Dates
Email body example in html table format: Section Item Name Batch Serial No. Exp. Date Dry 7 Flour 12345 11-02-26 Dry 7 pasta 1 asdfg 16-01-26 Dry 7 milk powder 12345 11-02-26
I look forward to hearing from you, Kindest regards Nick
Integrate RevenueCat into Android App Category: Android, Android App Development, API Integration, Backend Development, Java, Kotlin, Mobile App Development, Software Development Budget: ₹600 - ₹1500 INR
04-Jun-2026 10:02 GMT
Grow Telegram Finance Community Category: Analytics, Content Creation, Content Marketing, Digital Marketing, Influencer Marketing, Market Research, Social Media Marketing, Wealth Management Budget: ₹600 - ₹1500 INR
04-Jun-2026 10:02 GMT
Livescore Website Competitor Analysis & Launch Plan Category: Competitor Analysis, Content Strategy, Digital Marketing, Internet Marketing, Market Research, Marketing, SEO, Social Media Marketing, Sports Budget: $30 - $250 USD
04-Jun-2026 10:01 GMT
Automated Monthly Salary Sheet Category: Copy Typing, Data Entry, Data Processing, Excel, Excel Macros, Excel VBA, Financial Modeling, PDF, Word Budget: ₹100 - ₹400 INR
04-Jun-2026 10:00 GMT
OMAN Roller Shutter Door Parts Procurement Category: Inventory Management, Logistics, Market Research, Procurement, Product Sourcing, Shipping, Supplier Sourcing, Supply Chain Budget: $30 - $250 USD
04-Jun-2026 09:59 GMT
Need High quality backlinks Category: Internet Marketing, Link Building, Marketing, SEO, SEO Auditing Budget: ₹600 - ₹1500 INR
AI UGC Video Ad Creation Category: Adobe Premiere Pro, After Effects, AI Content Creation, AI Design, AI Video, Animation, Video Editing, Video Services Budget: ₹12500 - ₹37500 INR
04-Jun-2026 09:57 GMT
Entri Data Campuran E-commerce Category: Data Analysis, Data Cleansing, Data Collection, Data Entry, Data Management, Data Processing, Excel, Web Search Budget: $30 - $250 USD
