Google Sheets Recycling Certificate Tool

I want a lightweight solution built in Google Sheets with App Script that lets my recycling company log each transaction and instantly produce a polished certificate for our clients.

Core workflow
• Simple form or sidebar where we key in customer name, scrap type, quantity and date (mobile-friendly).
• Behind the scenes, the script calls an online API to fetch the carbon-footprint or recycling-impact factor for the chosen scrap type, multiplies it by the quantity and stores the result.
• A certificate template (English) is pre-designed in Google Docs or Slides and merged from the sheet. It must show:
– Customer name & date
– Scrap type & quantity
– Company logo plus the calculated carbon-footprint impact
• One-click button to generate the certificate as a PDF and open the print dialog.
• Option in the script to tweak a green-tinted background colour so we can match branding without editing code each time.
• The entire flow should look clean on both desktop and phone browsers.

Acceptance
The deliverable is a fully functioning Google Sheet with embedded App Script, documented so I can adjust API keys, add new scrap types or recolour the certificate later. A short hand-off call or video walkthrough is welcome but not mandatory.