I noticed that there is Net-Google-Spreadsheets-V4-0.002. Its from 2017 but appears to be passing tests currently. I think Net-Google-Spreadsheets means a version from 2012. It could be that Google deprecated something that used to work. I haven't kept up with GDrive recent changes.

Update:
I have no experience with Perl and accessing a Google Drive. However, this subject does interest me for future work. At my Windows 10 command line, with Active State Perl (v5.24.3 built on Dec 11 2017 11:09:26), I did "cpan Net-Google-Drive-Simple". The installation reported success. CPAN reports this version as of Jan 28, 2021.

I am in the midst of another project right now and don't really have much time to mess with this at the moment. However, my perusal of the documentation indicates that this is a very promising avenue of investigation. If this recent module does what you need, it could be better than what you have now? I don't know. Let us know if it is?

PS: The installation spewed out 1,600 lines of stuff to my terminal. I don't think any of that matters. At the end of the day, it said that the installation "worked".

In reply to Re: Accessing Google sheets using perl by Marshall
in thread Accessing Google sheets using perl 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.