Ok. I tried to play with this a bit more. Geez, even installing Net::Google:Spreadsheets::V4 took some work! I ran into a failed Furl installation dependency and had to back up 5 versions to Furl-3.08. Then I tripped across the issue at Perl Google Sheets API Install Problems. I did manage to create a Google Client_id and Secret, but for the moment have given up because I have some other work in progress. Evidently I have to spend some more time learning about the Google App eco-system.

However, this example appears to be what you want:
I can't run this critter myself, you hopefully you can. 

#!/usr/bin/env perl

use strict;
use warnings;
use 5.010_000;
use utf8;
binmode STDOUT, ":encoding(utf8)";

use FindBin;
use lib $FindBin::Bin . '/../lib';
use Net::Google::Spreadsheets::V4;
use URI::Escape;

my $gs = Net::Google::Spreadsheets::V4->new(
    client_id      => "YOUR_CLIENT_ID",
    client_secret  => "YOUR_CLIENT_SECRET",
    refresh_token  => "YOUR_REFRESH_TOKEN",

    spreadsheet_id => "YOUR_SPREADSHEET_ID",
);

my($content, $res);

my $title = 'My sheet';

my $sheet = $gs->get_sheet(title => $title);

# read data
($content, $res) = $gs->request(
    GET => sprintf("/values/%s", uri_escape($gs->a1_notation(
        sheet_title => $title,
    )))
);

for my $row (@{ $content->{values} }) {
    say join(', ', @$row);
}

exit;

[download]
PS: If I were messing with this, I'd run Data::Dumper on $sheet,$content and $res and see what those things looks like.

In reply to Re^3: Net::Google::Spreadsheets::V4 usage by Marshall
in thread Net::Google::Spreadsheets::V4 usage by xodus_fr

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.