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
Princess Cruise Employment Verification, Princess Cruise lines Category: Customer Service, Data Management, Data Protection, Documentation, Human Resources, Project Management, Recruitment, Report Writing, Time Management, Word Processing Budget: $10 - $50 USD
14 Jan 2026 17:04 GMT
Employment History Verification, melomed pyt holdings Category: Customer Service, Data Collection, Data Entry, Data Management, Documentation, Human Resources, Interviewing, Report Writing, Research, Time Management Budget: $10 - $50 USD
14 Jan 2026 17:02 GMT
Advanced E-commerce Website Development Category: API Integration, Content Management System (CMS), ECommerce, HTML, Payment Gateway Integration, PHP, Web Development, Web Design Budget: ₹37500 - ₹75000 INR
Ortho & Dental Job Verification, Ortho and Dental Category: Customer Service, Data Analysis, Data Entry, Data Management, Recruitment, Report Writing, Research, Time Management, Word Processing Budget: $10 - $50 USD
14 Jan 2026 17:00 GMT
Residential Loan Originator & Client Lead Category: CRM, Customer Service, Internet Marketing, Lead Generation, Leads, Marketing, Real Estate, Sales Budget: $8 - $15 USD
Verify Dr. Ross Employment History, Dr. Reza Ross Category: Audit, Data Entry, Data Management, Documentation, Email Handling, Phone Support, Project Management, Report Writing, Research, Time Management Budget: $10 - $50 USD
Florida Wind Stamp for Shed Category: Architectural Engineering, Construction Engineering, Structural Engineering Budget: $250 - $750 USD
14 Jan 2026 16:55 GMT
TikTok Product Demo Videos Category: Adobe Premiere Pro, After Effects, CapCut, Final Cut Pro, Motion Graphics, Video Editing, Video Production, Video Services Budget: $10 - $100 USD
14 Jan 2026 16:55 GMT
Cancer Specialty Hospital Project in Guwahati Category: 3D Rendering, 3D Visualization, Architecture, AutoCAD, Building Architecture, Building Design, Building Information Modeling, Interior Design, Photoshop, Rhino 3D Budget: ₹12500 - ₹37500 INR
14 Jan 2026 16:53 GMT
Tally Audit Data Analysis Support Category: Accounting, Business Analysis, Data Analysis, Finance, Financial Analysis, Financial Research, Inventory Management, Ratio Analysis Budget: ₹1500 - ₹12500 INR
14 Jan 2026 16:52 GMT
Amazon India Market Research for SkinCare Launch Category: Amazon Product Launch, Business Development, Competitor Analysis, Covers & Packaging, Data Analytics, Internet Marketing, Market Research, Product Management, Product Sourcing Budget: ₹1500 - ₹12500 INR
