What version of the Sheets API does the Plugin Use?

Hello,

We are running into a problem and I thought you might have some insight.

We have form on our website that goes into a google sheet via your free plugin. This form has a ZIP code field. The problem is that when the submissions gets sent to sheets and a new row is created the new row totally ignores the number format that was previously set on the column. So zip codes that start with a zero get reformatted like so:

01234
becomes
1234

This is important to us because we have a Zapier Integration that compares the zip codes against a table to see what dealer should be contacted – then inserts the form submission into the client’s CRM.

So I started looking into App Script based solutions. Supposedly if your app is using the latest version of the Sheets REST API when data is added it should trigger the onchange event. However that doesn’t seem to be happening. I created an App Script that looks like this:

function onChange() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[0];
  var column = sheet.getRange("E2:E");
  column.setNumberFormat("00000");
}

If I submit the form on the website it doesnt trigger the app script to reformat the number value.

If you have any insight or suggestions on ANY method I could use to get those numbers into sheets in the proper format I would be very appreciative! Would the pro version solve this issue?