Net::Google::Sheets

Simple API access to Google Sheets, using OAuth2::Client::Google

Install

zef install Net::Google::Sheets

Follow the HOW-TO to make a client_id.json in your script dir (eg. /bin for /bin/synopsis)

Synopsis

i#!/usr/bin/env perl6

use lib '../lib';

use Net::Google::Sheets;

my $session = Session.new;

my %sheets = $session.sheets;
my $id = %sheets<AWS_EC2_Sizes>;

# get values from Sheet1
my $sheet1 = Sheet.new(:$session, :$id, range => 'Sheet1');
my $vals = $sheet1.values;
say $vals;
#say $vals[1;*];

# put values into Sheet2
my $sheet2 = Sheet.new(:$session, :$id, range => 'Sheet2');
$sheet2.values: $vals;

Copyright

copyright(c) 2023 Henley Cloud Consulting Ltd.