Perl Google Sheets API Install Problems

[jamesk]

Hi All, I am attempting to install a Perl module:

Net::Google::Spreadsheets::V4

One of the dependencies is failing three tests and so will not install:

Net::Google::DataAPI::Auth::OAuth2

The failed tests give this output:

#   Failed test at t/04_auth/04_oauth2.t line 72.
#     Structures begin differing at:
#          $got->{hd} = ''
#     $expected->{hd} = Does not exist

#   Failed test at t/04_auth/04_oauth2.t line 101.
#     Structures begin differing at:
#          $got->{hd} = ''
#     $expected->{hd} = Does not exist

#   Failed test at t/04_auth/04_oauth2.t line 124.
#     Structures begin differing at:
#          $got->{hd} = ''
#     $expected->{hd} = Does not exist
# Looks like you failed 3 tests of 28.
t/04_auth/04_oauth2.t .................................. Dubious, test
+ returned 3 (wstat 768, 0x300)
Failed 3/28 subtests
t/05_types.t ........................................... Any::Moose is
+ deprecated. Please use Moo instead at t/05_types.t line 6.
t/05_types.t ........................................... ok

Test Summary Report
-------------------
t/04_auth/04_oauth2.t                                (Wstat: 768 Tests
+: 28 Failed: 3)
  Failed tests:  9, 22, 28
  Non-zero exit status: 3
Files=24, Tests=423,  4 wallclock secs ( 0.10 usr  0.03 sys +  4.14 cu
+sr  0.40 csys =  4.67 CPU)
Result: FAIL
Failed 1/24 test programs. 3/423 subtests failed.
Makefile:801: recipe for target 'test_dynamic' failed
make: *** [test_dynamic] Error 255
Terminal does not support GetHistory.
Lockfile removed.
  DANJOU/Net-Google-DataAPI-0.2805.tar.gz
  /usr/bin/make test -- NOT OK
//hint// to see the cpan-testers results for installing this module, t
+ry:
  reports DANJOU/Net-Google-DataAPI-0.2805.tar.gz
Failed during this command:
 DANJOU/Net-Google-DataAPI-0.2805.tar.gz      : make_test NO

It would appear at least one other person has had the same problem:

https://rt.cpan.org/Public/Bug/Display.html?id=124866

Assuming that this module is essential for what I'm doing, can anybody shed some light on it? Is it me doing something wrong or is it a genuine bug with the module? Alternative options are very welcome. I essentially need to send data that Perl has to an existing Google Sheet.

If it matters I'm using Ubuntu 16.04.6 LTS (GNU/Linux 4.4.0-21-generic x86_64) with Perl v5.22.1

Thanks, James