I am in the process of making a Winform app to facilitate data manipulation from a google sheet and this was extremely helpful in setting the environment up!
Hi, I had build this using Windows Forms, but i have a question that is when we share this code to others then we have to ask the user to create the service credentials.? or is there any Simpler way to do that. To make it simpler, can we use our gmail account address Instead of creating google service credentials. We just have to make sure that the user not need to do any manual configuration.? Thanks.
Thanks. I have a question though @twilio What if someone access the file in google sheets the same time you are accessing it via code. Won’t it break? Happened to me several times. Guess going around it by moving all info to sql is the only way?
Managed to get it working perfect to the above utilities. One caveat is that i cannot figure out how to remove the entire row, instead of erasing that row of values. Some online searches led me to another format of inputting the dimension ranges with a start and ending index 1 higher than the start... but i barely got this to work.
It's all fine but how about I read all sheet to the 'IList' then I remove empty rows and store this List as Source for my DataGrid, and when I want to update some object for example object with index 250 in my 'IList', how the hell can I know the range to update the actual sheet? Is there any way to find the range position according to received IList on read method?
I did everything but always it was giving auth error, I found solition in this video. The missing thing was share doc to client mail. How is that stupid? api access should mean that, I have created owner api access but it has auth error.
I have to make a daily insertion of 200 rows in my GoogleSheet, how can I do that without reaching the API requests/minute limitation? I've tried to do a for statement and I've reached the limit. Is it possible to pass multiple row data in just one request? Amazing video by the way :)
Moreover, suppose we delete the row in the middle, and when I try to read the whole sheet including the gap one, it's throwing me an exception. S0, how do we remove the white blank space in the middle of the sheets using the code?
I am not getting a JSON file when I perform all the steps as in the video Do I need an OAuth client ID? Because only there I get a json file. but there are bugs... Thanks!!
you need to create a api key, which will give you the option to download the json file. please note once downloaded you will not be able to download again; unless a new key is created.
Hello everyone, I have a question. Can anyone help me? I need to make a Windows forms application related to Google Sheets. It will have a simple interface, but I do not know how to proceed.
Wow! I have been struggling to get that for for days - you did it in seconds - very smart! Very clear - this is good video instruction. I want more pls! Like how to activate a tab in a sheet - it seems to be a nightmare to set active tab in google sheets API
vary nice tutorial what about if I want to use this with WPF? where I can put the TeamGroup ? i try and get an error in var response = request.Execute(); thank you for your time
Hello, very well explained, everything here and in the blog helped a lot. Though, I have an issue with creating a new worksheet. I managed to create it with a configuration but I can't see to get it to appear in the actual Google sheet. Any way you could answer that?
You probably want the GetDataByFilterRequest googleapis.dev/dotnet/Google.Apis.Sheets.v4/latest/api/Google.Apis.Sheets.v4.SpreadsheetsResource.GetByDataFilterRequest.html
In this case, I was using iTerm2 and I just ran the application. If you’re on Windows you could use Command Prompt or Powershell. I edit out the launching of applications usually to keep things moving.
Maybe some of the process has changed in 3 years? I get "System.InvalidOperationException: 'Error creating credential from JSON or JSON parameters. Unrecognized credential type .'"
Great. Thanks you so much. That what I'm lookinh for since a week. Great tutorials. Ok, how should we find a practical cell and then update. Suppose I jave to find the name="Abhishek" and if it found then I will to the CRUD operation.
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
A few days ago, I was busy with google sheet api and learned many tutorials about that. After all, your tutorial is the best!
Amazing! Hands down, the BEST tutorial for Google sheets with C#!
Thanks for watching!
This video is outstanding, thanks so much! I tried a whole bunch of tutorials and GitHub projects, but none of them came even close to this!
This is so helpful, I can't stress enough. May the success be with you.
You saved my career and my life. God bless you!
how to do this in Windows Form Application C#.. we don't have a csproj file there..
I am in the process of making a Winform app to facilitate data manipulation from a google sheet and this was extremely helpful in setting the environment up!
Hi,
I had build this using Windows Forms, but i have a question that is when we share this code to others then we have to ask the user to create the service credentials.? or is there any Simpler way to do that.
To make it simpler, can we use our gmail account address Instead of creating google service credentials. We just have to make sure that the user not need to do any manual configuration.?
Thanks.
Thanks. I have a question though @twilio
What if someone access the file in google sheets the same time you are accessing it via code. Won’t it break? Happened to me several times. Guess going around it by moving all info to sql is the only way?
Maybe you can create another spreadsheet where you can import and see all the data of the spreadsheet connected to your app
You are awesome. Is it possible to connect google sheets and vba?
How can I install this API on windows using Visual studio 2019?
Tools > Nuget Package Manager > Manage Nuget Package Manages for Solution. Tag 'Browse', type search 'Google Sheets API'
Thanks for putting this video together! It was super helpful in getting my project running with GoogleSheets :)
Really helpful. Complete information, well presented and easy to understand. Thanks so much. Will use this in a Blazor project.
Is there a link to the source?
It uses a different spreadsheet but the basics are the same: www.twilio.com/blog/2017/03/google-spreadsheets-and-net-core.html?
Managed to get it working perfect to the above utilities. One caveat is that i cannot figure out how to remove the entire row, instead of erasing that row of values. Some online searches led me to another format of inputting the dimension ranges with a start and ending index 1 higher than the start... but i barely got this to work.
I want to read data from spreadsheet but with just C#. Do you have any video on it?
It's all fine but how about I read all sheet to the 'IList' then I remove empty rows and store this List as Source for my DataGrid, and when I want to update some object for example object with index 250 in my 'IList', how the hell can I know the range to update the actual sheet? Is there any way to find the range position according to received IList on read method?
when i create a project, i dont have any .csproj file!!! what should i do?
What did you run to create the project?
Thanks for the video, got me going with what I have in mind!
Do you know if it's possible to use batch update an append request?
I hope this gets updated so it can be relly useful
awesome vid thanks a bunch! spent a whole night trying to figure this out on my own and didn't turn out so well so thanks again!
can we used named ranges in this to make it easier?
I did everything but always it was giving auth error, I found solition in this video. The missing thing was share doc to client mail. How is that stupid? api access should mean that, I have created owner api access but it has auth error.
Absolutely amazing video, can you show how to connect mysql to Google sheets ?
Can you make an updated video about this?
I have an errror sayign "There are no versions available for the package 'Google.api'."
I have to make a daily insertion of 200 rows in my GoogleSheet, how can I do that without reaching the API requests/minute limitation? I've tried to do a for statement and I've reached the limit. Is it possible to pass multiple row data in just one request?
Amazing video by the way :)
Does this still work?
Thank you. Better than google's own tutorials.
It only opens spreadsheets and not word documents and powerpoint files?
This example is only Google Sheets. There are APIs for documents and slides though as well.
@@twilio Thankyou
How can I insert a column of values?
Can you make a video tutorial about Google Sheet Api to WindowsForms C#
Can I use Google sheets for 1000 clients?
Hi and thanks for the Video! It helps much! Is it possible to search the position of a Name? So i can change perphaps the birthday of mr. Brown?
How can I create another sheet in the same file?
Moreover, suppose we delete the row in the middle, and when I try to read the whole sheet including the gap one, it's throwing me an exception. S0, how do we remove the white blank space in the middle of the sheets using the code?
you dont ezpz
can we make it with visual basic .net please ?
I am not getting a JSON file when I perform all the steps as in the video
Do I need an OAuth client ID?
Because only there I get a json file. but there are bugs...
Thanks!!
you need to create a api key, which will give you the option to download the json file. please note once downloaded you will not be able to download again; unless a new key is created.
Hello everyone, I have a question. Can anyone help me? I need to make a Windows forms application related to Google Sheets. It will have a simple interface, but I do not know how to proceed.
Wow! I have been struggling to get that for for days - you did it in seconds - very smart!
Very clear - this is good video instruction.
I want more pls!
Like how to activate a tab in a sheet - it seems to be a nightmare to set active tab in google sheets API
vary nice tutorial what about if I want to use this with WPF? where I can put the TeamGroup ? i try and get an error in var response = request.Execute(); thank you for your time
Are you using omnisharp for formatting? Can you share the config?
Thanks for the video. How can i format a cell using c#?
What OS are you using?
This video was created using macOS but it would work exactly the same on Windows.
@@twilio Works on linux :D
When I try to add the json file it says cp is not recognized as an internal or external command, operable program or batch file
You’re looking for “copy” on Windows.
@@twilio thanks everything works now
hi, you example write,read,update in php ?
Hello, very well explained, everything here and in the blog helped a lot. Though, I have an issue with creating a new worksheet. I managed to create it with a configuration but I can't see to get it to appear in the actual Google sheet. Any way you could answer that?
Are you getting an error?
it says Google.Api package not found?
Sounds like either your Google NuGet packages didn't install correctly or you're missing a namespace declaration.
I think they split the package,
try
Google.Apis.Oauth2.v2
Google.Apis.Sheets.v4
For credentials and SheetsService
@@d.arruda6308 Thank u maan
How update row or column by ID (find in range congress!A:A value "sen" and update range congress!A(row index):Grow (index) value) ?
Is it possible to access a row using some field value e.g. by a congressman name?
You probably want the GetDataByFilterRequest googleapis.dev/dotnet/Google.Apis.Sheets.v4/latest/api/Google.Apis.Sheets.v4.SpreadsheetsResource.GetByDataFilterRequest.html
Can I write to the sheet from the console? so it would show in my google drive like edited by [console]... Where can I find this tutorial thx
You can definitely make edits from a console application. As for making is show up as edited by console, that would require some additional work.
Cool! how can i determine the last row?
oh, thank you! How to loading file google sheet and edit on c# and realtime multi user
Hello Sir. I got this error on response.execute. Please help! Thanks!
Google.GoogleApiException: 'Google.Apis.Requests.RequestError
Request had invalid authentication credentials. Expected OAuth 2 access token, login cookie or other valid authentication credential. See developers.google.com/identity/sign-in/web/devconsole-project. [401]
Errors [
Message[Invalid Credentials] Location[Authorization - header] Reason[authError] Domain[global]
]
sorry a newbie question, where can i find the termnial?
Are you on Mac or Windows?
Would you consider your (.Net core) application as SOAP or as REST ?
What is the deference?
dude how did you end up in terminal?
In this case, I was using iTerm2 and I just ran the application. If you’re on Windows you could use Command Prompt or Powershell. I edit out the launching of applications usually to keep things moving.
Not to necro an old video too much but figured I'd shoot a shot. Anybody figured out how to make something like this work in Unity?
Thanks for the video - very helpful to get me started.
Maybe some of the process has changed in 3 years? I get "System.InvalidOperationException: 'Error creating credential from JSON or JSON parameters. Unrecognized credential type .'"
Great. Thanks you so much. That what I'm lookinh for since a week. Great tutorials.
Ok, how should we find a practical cell and then update. Suppose I jave to find the name="Abhishek" and if it found then I will to the CRUD operation.
Thanks! Great video!
Really helpful tutorial. Thanks!
How to fill the cells with color?
Check out this stackoverflow answer for details on how to do this in a batch update: stackoverflow.com/a/42926722
@@twilio much obliged!!!)
We need one for Golang!
Okay, we'll take a look and see if we can get this done :)
Hi man! Can I get the full code?
www.twilio.com/blog/2017/03/google-spreadsheets-and-net-core.html
@@twilio can i filter sheet using this code?? i have phone numbers i want to pass column and phone number to filter the record
Thanks a lot ,You were time saver.
Thank You For this !
Wow, great !
Thanks you so much :)
Very helpful ❤️❤️
It doesn't work anymore
Thanks for the video, helps a lot :)
Thank you 😇
Thank you! 👍
can i filter sheet using this code?? i have phone numbers i want to pass column and phone number to filter the record
Cool,thanks man ))
Thanks i just coppied that 1o1 and moddified it a bit. ÄHRE
Thank you!
best tutorial
Thanks Bro)
thx a lot
Thank u
thanksssss
You're my god
Nah, just a video creator who hopefully helped you :)