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
Penulis Konten Facebook Kreatif Category: Content Creation, Content Writing, Copywriting, Creative Writing, Digital Marketing, Facebook Marketing, Social Media Management, Social Media Marketing Budget: $15 - $25 USD
18 Mar 2026 11:04 GMT
Bimbingan Cerita Fantasi Pendek Category: Conflict Resolution, Creative Writing, Editing, Google Docs, Microsoft Word, Publishing, Writing Tutoring Budget: $250 - $750 USD
Tamil-English Form Filling Category: Copy Typing, Data Entry, Data Management, Data Processing, English Translation, Excel, Google Docs, Microsoft Word, PDF, Typing Budget: $15 - $25 USD
18 Mar 2026 11:00 GMT
Film Set SketchUp Conversion Category: 3D Design, 3D Modelling, 3D Rendering, Architectural Visualization, Building Architecture, Interior Design, SketchUp Budget: £20 - £250 GBP
18 Mar 2026 11:00 GMT
Facebook Brand Awareness Strategy Development -- 2 Category: Article Writing, Brand Management, Content Strategy, Content Writing, Creative Writing, Ghostwriting, Social Media Marketing Budget: ₹1000000 - ₹2500000 INR
Traditional Domestic Help Logo Category: Adobe Illustrator, Branding, Corel Draw, Graphic Design, Illustration, Logo Design, Photoshop, Vector Design Budget: ₹1500 - ₹12500 INR
18 Mar 2026 10:56 GMT
Instagram Motion Graphics Editor Category: Adobe Premiere Pro, After Effects, Kinetic Typography, Motion Graphics, Video Editing, Video Production Budget: ₹600 - ₹1500 INR
18 Mar 2026 10:54 GMT
Podcast Social Content Creation Category: Adobe Premiere Pro, After Effects, Animation, Content Creation, Graphic Design, Social Media Marketing, Video Editing, Video Production Budget: $30 - $250 USD
Versatile Writer-Designer Needed Category: Blog Writing, Content Writing, Copywriting, Digital Marketing, Graphic Design, SEO, Social Media Marketing, Visual Design Budget: $25 - $50 USD
