in reply to Accessing Google sheets using perl

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".

Replies are listed 'Best First'.
Re^2: Accessing Google sheets using perl
by xodus_fr (Novice) on Aug 22, 2021 at 00:11 UTC
    The documentation of the Net-Google-Spreadsheets-V4 doesn't explain how to read cell values from google sheet. I could not managed to read data from my google sheet yet.