Leading Zeros Dropped in Cell
By default, Google will remove any leading zeros in data. This can cause problems with data points such as bar codes.
Example of a barcode with leading zeros
Example output in Google Sheets
Simply add a leading apostrophe
' in the cell in Instasheets. Now Google will no longer drop the leading zero when the data is sent to the Sheet.