If you update a webProperty with a default View Id that doesn't exists, you receive the error 'Internal server error'.

I get this issue for some other website I am managing (from other company) .. I've tested your Google docs sheet and when I want to Insert / to Google Analytics > i get this issue >>

GoogleJsonResponseException: Your project does not have access to this feature.,

[17-08-22 14:35:33:822 CEST] Execution failed: Cannot auto-resize column at column index ‘18’ because there are only ‘18’ columns. [11.707 seconds total runtime]

When inserting new dimensions, you get an error that the dimension doesn't exist. It seems that the script is trying to update instead of insert.

When you audit an account which has properties without views, the getData function gives an undefined error over here: property.profiles.forEach(function(view) {

Before running datavalidation, verify the columns / sheet structure

When the timezone of a view = Argentina, you get an error when retrieving that view.

To simplify the installation and maintenance of this tool, we convert it to a library.
Users can then add it to a Google Spreadsheet as a library. Upgrading the script is much more easier this way.

Differentiate between GA Standard and GA Premium and adapt dataValidation to it

When retrieving a view which has MYR as currency, you get an error.

On auditing this error pops up:

Probably the city list needs an update.
Reported by @iulianabaciu

In some cases it can be useful to have additional columns in the GAM generated sheets. Right now they get deleted when you retrieve data

When requesting large amounts of data (76 properties in this example) you get this message:

Investigate to see if we should improve this message.

accounts.name is undefined in the below function.

function generateReport(accounts, apiType) {
    var callApi = api[apiType];

    callApi.init('generateReport', function() {
        callApi.getData(function(data) {
            // Verify if data is present
            if (data[0] === undefined || !data[0].length) {
                throw new Error('No data found for ' + apiType + ' in ' + accounts.name + '.');
            }

            sheet
                .init('initSheet', 'GAM: ' + callApi.name, callApi.config, data)
                .buildData();
        });
    }, {'accounts': accounts});
}

There are more fields available in the API then we currently set. Extend the properties object with these additional fields.

When writing data back to the sheet after inserting via the API, it can happen dat the returned data doesn't fit the dataValidation in a cell. This can be the case with the currency field for example. Because in GA there are more currencies available than you can set via the API...

Make sure onChange validation keeps working when a column gets deleted

If you make a typo in a property id, this causes a new property to be created. This should return an error instead.