Google Sheets and .NET Core with C#

If you’d like to use the data in your Google Sheets projects from your C# applications, this is the guide for you.

We’ll use Google’s official v4 API SDK for .NET to access an example spreadsheet inside of Google Sheets.

[htoonlkyaw]

A few days ago, I was busy with google sheet api and learned many tutorials about that. After all, your tutorial is the best!

[iliqn]

Amazing! Hands down, the BEST tutorial for Google sheets with C#!

[andriibilych]

This is so helpful, I can't stress enough. May the success be with you.

[bloopydlooper]

You saved my career and my life. God bless you!

[bradpetry]

Google should hire you to make tutorials. A lot more people would use their stuff.

[AleksandarBulovic]

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!

[flamez]

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!

[paritoshgavali]

how to do this in Windows Form Application C#.. we don't have a csproj file there..

[ElysiaGriffin]

Thanks for putting this video together! It was super helpful in getting my project running with GoogleSheets :)

[simonroyjonesuk]

Really helpful. Complete information, well presented and easy to understand. Thanks so much. Will use this in a Blazor project.

[types]

I hope this gets updated so it can be relly useful

[VinayKumar-bykh]

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.

[Richard-ukcr]

Thank you. Better than google's own tutorials.

[caglarcansarikaya]

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.

[_SkyDancer]

It's all fine but how about I read all sheet to the 'IList<IList<object>>' 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<IList<object>>', 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<IList<object>> on read method?

[faisalzubair]

I want to read data from spreadsheet but with just C#. Do you have any video on it?

[Superbbsuper]

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!

[Kroama]

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.

[eraybalaban]

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.

[fastersixth]

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?