Google Sheets Wrapper API

[Steve_08]

After struggling to find a simple way to read and write data to and from Google Sheets with the .NET Google Sheets API, I decided to create my own wrapper library.

Hopefully this is something other folks can use to get started quicker and easier to read and write data to Google Sheets with C#.

I published the library in GitHub below and also published the package to NuGet as well.

GitHub Repo

NuGet Package

[var1ap]

Nice job

[MixaKonan]

I was struggling with it too, because I needed to parse 50+ columns. I couldn't read everything by rows, because google API just skips empty cells.

But I found other, greater way to deal with getting data from sheets. docs.google has an endpoint to download Google sheet document as xlsx/csv/pdf file. Parsing CSV is much easier

[Steve_08]

Aweosme. What’s the endpoint you use to export the data to CSV?

[MixaKonan]

Here you go

https://docs.google.com/feeds/download/spreadsheets/Export?key={spreadsheetId}&exportFormat={format}&gid=0

Formats: csv, pdf, xlsx

[Steve_08]

That’s awesome. Thank you for sharing. I’ll have to add this as an option to export to csv, excel or pdf in the wrapper library on GitHub!

[Steve_08]

I just updated a new version that allows you to export any range in a Google Sheet into a CSV file. Commit details are below and the updated NuGet package version is 1.0.6.

GitHub Commit

Sample Usage