Тёмный
No video :(

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

API-University
Подписаться 4,5 тыс.
Просмотров 42 тыс.
50% 1

Learn to use the Google Sheets API and how you can turn any Google Spreadsheet into a data store that is accessible via API. Download the worksheet to follow every step along the way: api-university...
Learn about APIs in a more structured way, with step-by-step guides:
📗 Book on RESTful API Design: api-university...
📚 Books on other API Topics: api-university...
🎥 Video Course on RESTful API Design: api-university...
🎥 Video Courses on other API Topics: api-university...
👕 Get your "I ❤️ APIs" Shirt api-university...
Subscribe and follow me on my journey and explore some great APIs. New episodes are airing each Wednesday 18:00 CEST (9:00 PDT)! Don't miss any upcoming episode and subscribe to the api-university channel.

Опубликовано:

 

6 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 40   
@tobiasspath5275
@tobiasspath5275 2 года назад
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!
@manzarulhaque9816
@manzarulhaque9816 3 года назад
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.
@tonkardoso
@tonkardoso 4 месяца назад
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 3 месяца назад
You’re welcome 😊
@sathyaappuraj2586
@sathyaappuraj2586 2 года назад
it doesn't work anymore
@techeditz439
@techeditz439 2 года назад
The sheet V3 API has been turned down !!!
@BEATWINCONTROL
@BEATWINCONTROL 6 месяцев назад
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??
@enricomattioli53
@enricomattioli53 3 года назад
and how can I modify the content in the cell? (c#)
@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
@Api-university
@Api-university 4 года назад
Awesome, thank you!
@yanisrenaud
@yanisrenaud Год назад
i didn't found my answer but you guided me through a new step, thanks !
@dr-mnizam
@dr-mnizam Год назад
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-EThaucDBY6g.html
@CreepyUncleIdjit
@CreepyUncleIdjit 3 года назад
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
@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.?
@beardedsawyer6322
@beardedsawyer6322 2 года назад
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.
@leandrobandres9856
@leandrobandres9856 4 года назад
Hi...! Great video, i have a cuestions, if is posible send images with Google Sheets API? THANKS...!
@Api-university
@Api-university 4 года назад
Just try it and post the result here. I am also interested.
@somnath1maji
@somnath1maji 4 года назад
@@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
@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?
@mohamedkacem5095
@mohamedkacem5095 2 года назад
love the way you teach :)
@tonmoitanvi1773
@tonmoitanvi1773 2 года назад
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!
@Api-university
@Api-university 2 года назад
Thanks for sharing!
@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.
@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
@mendeljacks
@mendeljacks 3 года назад
This doesn't work anymore
@delphinelisabeth
@delphinelisabeth 3 года назад
please read my comment, it may help you
@nitishjha4964
@nitishjha4964 2 года назад
not working
@hellodanooo
@hellodanooo 2 года назад
@@delphinelisabeth where is this comment ??
@iamakhilthakur3
@iamakhilthakur3 4 года назад
Great 👍
@Api-university
@Api-university 3 года назад
Thank you! Cheers!
@dorareyizoyun8680
@dorareyizoyun8680 Год назад
1:40 filho você quer saber como comprar seguidores reais barato? AUTORIDADE SOCIAL resposta correta
@Api-university
@Api-university 4 года назад
Get the worksheet here: api-university.com/blog/how-to-use-google-sheets-api/
@vugpgu
@vugpgu 4 месяца назад
Data exposing is a poor design
Далее
Сказала дочке НЕТ!
00:24
Просмотров 513 тыс.
MILLION JAMOASI 2024 4K
2:17:51
Просмотров 13 млн
Making Google Sheet Into a Public REST API
13:14
Просмотров 4,7 тыс.
Turn Your Spreadsheet into an App
6:58
Просмотров 69 тыс.
Make an API With Google Sheets and Google Apps Script
15:53
Google Sheets API - JavaScript NodeJS Tutorial
45:29
Просмотров 114 тыс.
Use Python To Import Data to Google Sheets
14:40
Просмотров 9 тыс.
Convert Google Sheet into JSON Web App
6:26
Просмотров 19 тыс.
5 Google Sheets Tips Every User Should Know!
12:02
Просмотров 671 тыс.
Сказала дочке НЕТ!
00:24
Просмотров 513 тыс.