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 Instagram Kreatif Category: Brand Management, Content Creation, Content Writing, Copywriting, Digital Marketing, Instagram Marketing, Social Media Management, Social Media Marketing Budget: $15 - $25 USD
07-Apr-2026 10:03 GMT
Video Review Skincare di YouTube Category: Content Creation, Script Writing, SEO, Video Editing, Video Production, Video Services, Videography, YouTube Budget: $15 - $25 USD
07-Apr-2026 10:03 GMT
3D Product Model (STL) Category: 3D CAD, 3D Design, 3D Modelling, 3D Print Design, 3D Rendering, CAD / CAM, Fusion 360, Solidworks Budget: $10 - $30 USD
07-Apr-2026 10:02 GMT
Teen Learning App UI Design Category: Adobe XD, Figma, Graphic Design, IPhone, Mobile App Development, Sketch, UI / User Interface, User Interface / IA Budget: $30 - $250 USD
07-Apr-2026 09:59 GMT
Shopify Small Corrections Developer Category: CSS, Frontend Development, HTML, JavaScript, Shopify Templates, Web Development, Web Design, Website Optimization Budget: ₹600 - ₹1500 INR
07-Apr-2026 09:59 GMT
AI UGC Video Creator for Facebook And Instagram Ads Category: AI Animation, AI Chatbot Development, AI Content Creation, AI Design, AI Development, Animation, Video Editing, Video Production Budget: ₹750 - ₹1250 INR
Lead Collector & CRM App Development Category: Android, Android App Development, API Development, Flutter, IOS Development, IPhone, Mobile App Development, PHP, React Native, Web Development Budget: £5000 - £10000 GBP
Document Technical Market Research Conversations Category: Data Analysis, Data Collection, Documentation, Internet Research, Market Research, Research, Virtual Assistant Budget: ₹1500 - ₹12500 INR
07-Apr-2026 09:52 GMT
Live Product Demo Presenter Category: Branding, Public Speaking, Sales, Time Management, Video Conferencing, Video Production Budget: $15 - $25 USD
07-Apr-2026 09:52 GMT
Brand Graphics & Video Suite Category: Adobe Creative Cloud, After Effects, Branding, Graphic Design, Logo Design, Motion Graphics, Video Editing, Video Production Budget: ₹12500 - ₹37500 INR
07-Apr-2026 09:50 GMT
Radiological Diagnosis: SCI Journal Publication Category: Academic Writing, Data Analysis, Healthcare Education, Medical, Medical Products, Medical Research, Medical Writing, Research, Research Writing, Scientific Writing Budget: $30 - $250 USD
