Google Sheets and Ruby

[@twilio]

Google Sheets data is super easy to use in Ruby apps. Now that you know how to do it, what will you build? What would you like to see next on this channel?

[@code_explorations]

I'm using it read-only to generate PDFs of class lists from a master spreadsheet.

[@benwalsh2825]

Thanks for posting this! Your python version of this video is what got me into writing scripts. It's a lot of fun.

[@twilio]

I’m so happy to hear this :)

[@tjbihh]

Brilliantly clear and useful - thank you

[@twilio]

Thanks for watching!

[@thecodeprovider]

Thanks a lot, you save my day bro !

[@Aluston1783]

Thanks! Excellent video!

[@FonchoRG]

Thank you so much, this video is very helpful!

[@_jikkujose]

Very well explained! Thanks!

[@autotask8942]

Its possible to create or copy documents with this gem?? And share the documents?

[@code_explorations]

Loved it; thanks.

[@twilio]

Thanks for watching!

[@dannbrown1468]

could you share the repo ?

[@love_tacos]

Am I the only one who's getting the "cannot load such file -- google/api_client" error? For some reason the google_drive gem is not playing nice...

[@love_tacos]

nevermind..... somehow....when I added google_drive gem to an existing project with an existing gemfile, it installed version 1.0....which is weird. Either way, i've moved on. Cheers!

[@joegillian2548]

Thanks for the video. My question is, how would you feed a google sheet with scraped data from an HTML website using ruby? Thanks

[@SteffenRoller]

It's the same method as feeding your sheet with data from a database. Perhaps your question is: How do I scrape data from a website? Just checkout stackoverflow.com, I'm sure the same question was ask multiple times before. That will most likely give you and idea.

[@pirga19]

I did exactly as you showed, but I'm getting this undefined method `from_service_account_key' for GoogleDrive::Session:Class (NoMethodError)

[@ZnMgkbvprb]

Check the gem version.

[@pamelariquelme1491]

Love u 4 this

[@addubgib]

[@julioa1119]

I have this error message: .rbenv/versions/3.0.0/lib/ruby/gems/3.0.0/gems/google_drive-3.0.7/lib/google_drive/session.rb:85:in `initialize': No such file or directory @ rb_sysopen - client_secret.json (Errno::ENOENT) any idea?

[@twilio]

Your application can't find the client_secret.json file you downloaded from Google. Make sure it's in your project and that you've provided the right path to the file in the app.

[@julioa1119]

@@twilio hello again, well I've to copy the JSON file manually and now it works, but I've received an emal from google said that there is violation on the Google's API, how can I generate this "client_secrets.json" without violate the rules....?