NAME

Net::Google::Spreadsheets::V4 - Google Sheets API v4 client

SYNOPSIS

            

              
              
use Net::Google::Spreadsheets::V4;
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) = $gs->request(
    POST => ':batchUpdate',
    {
        requests => [ ... ],
    },
);
            
          

See also examples/import.pl for more complex code.

DESCRIPTION

Net::Google::Spreadsheets::V4 is Google Sheets API v4 client

METHODS

Class Methods

new(%args:Hash) :Net::Google::Spreadsheets::V4

Creates and returns a new Net::Google::Spreadsheets::V4 client instance. Dies on errors.

%args is following:

client_id => Str

client_secret => Str

refresh_token => Str

spreadsheet_id => Str

Instance Methods

get_sheet(title|index|sheet_id => Str) :HashRef

Get Sheet object by title or index or sheet_id.

clear_sheet(sheet_id => Str)

Delete all data.

to_csv(Array)

Convert Array to CSV Str.

AUTHOR

HIROSE Masaaki <hirose31@gmail.com>

REPOSITORY

https://github.com/hirose31/Net-Google-Spreadsheets-V4

            

              
              
git clone https://github.com/hirose31/Net-Google-Spreadsheets-V4.git
            
          

patches and collaborators are welcome.

SEE ALSO

https://developers.google.com/sheets/

COPYRIGHT

Copyright HIROSE Masaaki

LICENSE

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

cpanm Net::Google::Spreadsheets::V4

perl -MCPAN -e shell
install Net::Google::Spreadsheets::V4