I've run a number of tests, and it looks like startup animations don't work when the data is loaded from Google Sheets. I've tried this with several different chart types, and here are the symptoms:
With data retrieved via google.visualization.Query(), if you add an animation object with 'startup: true' and 'duration: 1000', you get the following error message: Invalid column index 4. Should be an integer in the range [0-2].× If I remove the 'startup: true' from the options, the chart will display properly. With local data, the startup animation works properly.
I've tried this with 'current', '45', and 'upcoming' versions, and none of them work.
Does anyone know anything about this?