There is a CPAN module available for accessing Google Sheets - Google::Spreadsheets.
It may be worth creating some test code around this module to see if it too fails in the same way.

I've not used this module so cannot say how well it works but it might just help in your diagnosis.