Google Sheets API - How you can access any Google Spreadsheet using an API

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 ต.ค. 2024

ความคิดเห็น • 39

  • @tobiasspath5275
    @tobiasspath5275 2 ปีที่แล้ว +12

    Hi am very sorry, but this doesn´t work any more. "The Sheets v3 API has been turned down." It would be great if you would have a video for the new version, this would really be great!

  • @tonkardoso
    @tonkardoso 6 หลายเดือนก่อน

    What... This is basically a asmr super training, thanks for sharing... This just tells me that I need a new microphone for my streamings 🤣🤣

    • @Api-university
      @Api-university  5 หลายเดือนก่อน

      You’re welcome 😊

  • @yanisrenaud
    @yanisrenaud 2 ปีที่แล้ว

    i didn't found my answer but you guided me through a new step, thanks !

    • @dr-mnizam
      @dr-mnizam ปีที่แล้ว

      th-cam.com/video/EThaucDBY6g/w-d-xo.html

  • @BEATWINCONTROL
    @BEATWINCONTROL 7 หลายเดือนก่อน

    Hi! Nice video!🎉, I have a question, how do we access to get a data not by row and column R1C1, but if I want to fin the data of al the rows that are named xyz in column A, not only the cell, is it possible??

  • @testshade2554
    @testshade2554 4 ปีที่แล้ว

    I really love the way you've taught how to use the sheets API. More than that your enthusiasm and reassuring approach made it all the more easier. Thank you so much

  • @manzarulhaque9816
    @manzarulhaque9816 3 ปีที่แล้ว +2

    I am sorry, but this is available for public google sheets only. We cannot access the gsuite account google sheets if access is set to organization only. Or if there is any possibility please let me know.

  • @CreepyUncleIdjit
    @CreepyUncleIdjit 3 ปีที่แล้ว +7

    4:26 "Sorry, unable to open the file at this time." That's where my journey ends on this video. If this step no longer works, nothing else is going to and I refuse to waste any more time on outdated solutions. Time to update the tutorial.

    • @delphinelisabeth
      @delphinelisabeth 3 ปีที่แล้ว

      please read my comment, it may help you

  • @mohamedkacem5095
    @mohamedkacem5095 2 ปีที่แล้ว

    love the way you teach :)

  • @JavaScriptCentric
    @JavaScriptCentric 3 ปีที่แล้ว

    I have created a google spreedsheet using API and inserted data into it but where is this file stored where I can check it.?

  • @techeditz439
    @techeditz439 2 ปีที่แล้ว +1

    The sheet V3 API has been turned down !!!

  • @enricomattioli53
    @enricomattioli53 3 ปีที่แล้ว +1

    and how can I modify the content in the cell? (c#)

  • @sathyaappuraj2586
    @sathyaappuraj2586 3 ปีที่แล้ว +2

    it doesn't work anymore

  • @leandrobandres9856
    @leandrobandres9856 4 ปีที่แล้ว +1

    Hi...! Great video, i have a cuestions, if is posible send images with Google Sheets API? THANKS...!

    • @Api-university
      @Api-university  4 ปีที่แล้ว +1

      Just try it and post the result here. I am also interested.

    • @somnath1maji
      @somnath1maji 4 ปีที่แล้ว +1

      @@Api-university Fetching an Image through this method is not possible. Although I read that it's possible using API V4. Can you make a video for the same topic using V4 ? Thanks

  • @beardedsawyer6322
    @beardedsawyer6322 2 ปีที่แล้ว +1

    I went to ger the 'worksheet' and ended up being asked to sign up... Man, give us a break now. Either share stuff or just don't bother, no need to ask us to sign up for a stupid website.

  • @tonmoitanvi1773
    @tonmoitanvi1773 3 ปีที่แล้ว +1

    thanks for the nice video. It's really simple to learn from you the way you teach. though I am using another API tool of Sheet Best. It's also easy and simple enough!

  • @DineshPatil-ex6ij
    @DineshPatil-ex6ij 2 ปีที่แล้ว

    Buddy, you said any google sheet, what about private google sheet. Can you please also make a video on how we can achieve it.

    • @thierryjuang2043
      @thierryjuang2043 2 ปีที่แล้ว

      p sure you can't because it's private

  • @bilich7651
    @bilich7651 3 ปีที่แล้ว

    Does it work as CRUD?

  • @foff9549
    @foff9549 3 ปีที่แล้ว

    Does this API update when there are new rows and columns in the spreadsheet?

    • @Api-university
      @Api-university  3 ปีที่แล้ว

      Yes. When you call the API next time, you will see new rows and columns in the spreadsheet that have been added in the meanwhile on the UI.

  • @iamakhilthakur3
    @iamakhilthakur3 4 ปีที่แล้ว

    Great 👍

  • @TimSherman401
    @TimSherman401 3 ปีที่แล้ว

    What's the name of the notepad you're using?

    • @varunsudarsan2936
      @varunsudarsan2936 3 ปีที่แล้ว

      Im wondering too. Did you ever figure it out?

    • @alex.hayward
      @alex.hayward 2 ปีที่แล้ว

      @@varunsudarsan2936 Sublime Text

  • @Api-university
    @Api-university  4 ปีที่แล้ว

    Get the worksheet here: api-university.com/blog/how-to-use-google-sheets-api/

  • @mendeljacks
    @mendeljacks 3 ปีที่แล้ว +1

    This doesn't work anymore

    • @delphinelisabeth
      @delphinelisabeth 3 ปีที่แล้ว

      please read my comment, it may help you

    • @nitishjha4964
      @nitishjha4964 3 ปีที่แล้ว

      not working

    • @hellodanooo
      @hellodanooo 2 ปีที่แล้ว +2

      @@delphinelisabeth where is this comment ??

  • @vugpgu
    @vugpgu 6 หลายเดือนก่อน

    Data exposing is a poor design