How I fixed product feed disapprovals caused by GTIN formatting

I ran into this in an online retail catalog feeding products to a shopping ads channel. The issue was products were disapproved for invalid GTIN even though the numbers looked correct in the catalog. At first I blamed the ad platform being strict for no reason, but it showed up whenever a spreadsheet import stripped leading zeros from several UPC values. This caused paid shopping coverage dropped…