Using GoogleSheet API

Unity Engine
1

Hi,

First of all, already using the GoogleSheet API Python from Maya and it works charm.

Now trying to find out how works the GoogleSheet API C# with Unity :

First problem I have is I cannot access to the Google namespace which is mentioned in the quick-start sample.

Since I am using MonoDevelop, I downloaded the packages with the methods below :

  • Download the package nuget.exe v4.3.0 from NuGet Gallery | Downloads
  • drop the nuget.exe file in an empty folder.
  • with cmd from the same folder run the following command to download the GoogleAPI packages :

  • a list of folders will be downloaded.

  • from the following folders, drag and drop the folders “netstandard1.3” into you Unity project.

  • Google.Apis.1.29.1

  • Google.Apis.Auth.1.29.1

  • Google.Apis.Core.1.29.1

  • Google.Apis.Sheets.v4.1.29.1.980

If I create a new script then type “using Google;”, it doesn’t find the namespace.

Any idea?

Thank you by advance! :slight_smile:

1 Like
2

Same problem

3

Same problem, we want to create an overview in Google Sheets and exchange/update data on our spreadsheets from Unity

4

Do you have the .NET example working using Visual Studio? I always get the samples working first, using the technologies mentioned (VS versus MonoDevelop for example). Once I get it working, THEN I customize to my requirements/IDE.

5

I had the same problem, but I was able to get the Google Sheets API working in Unity 2018.1.9f1.

When I tried to use their “netstandard2.0” DLL’s with Scripting Runtime Version .NET 3.5, it didn’t work and the properties of their dll’s showed an error indicating they required .NET 4.x.

When I used the “net45” versions of their DLL’s and Scripting Runtime Version .NET 4.x it worked.

1 Like
6

So… Does anyone have a solution yet?? @SteveCastroKFF I have no Idea what that means

7

Hello to all! I managed to do this, even managed to write a working example.

4995398–487895–GoogleSheetDemo.unitypackage (1.42 MB)

3 Likes