connecting unity playmaker with googlespreasheet

[hoyoyo80]

Hi all:)

Im thinking of making a simple online database(non game) with unity playmaker.
Is there any tutorial/tool i need as extension to playmaker or unity that can use google spreadsheet as backend of the online database?

Thanks

[jeanfabre]

Hi,

 yes, There is a sample on the PlayMaker Ecosystem that shows how to read from the google spreadsheet.

https://twitter.com/JeanAtPlayMaker/status/1037230277494558721

 unfortunatly, there is no good solution for writing back, the only solution I know isn't quite battle tested yet so I can't do any port for that solution just yet, I have put the link below: WARNING: it has no PlayMaker support.

https://assetstore.unity.com/packages/tools/utilities/google-sheets-to-unity-73410


 Bye,

 Jean

[hoyoyo80]

Thanks for reply. I will look at it once im home.
Another quest, can we query the sheet via playmaker? Before i get deeper into this.

[jeanfabre]

Hi,

 yes, querying is possible via PlayMaker, check the ecosystem sample ( follow the twitter link from my previous post for more infos)

 Bye,

 Jean

[hoyoyo80]

Thanks...ive realized this community is so responsive.

[jeanfabre]

Hi,

 yeah, we try to if you don't get a reply within few days, don't hesite to bump your question, and pm me.

 Bye,

 Jean

[lionserver]

It is simple tutorial for writing to Google ExcelSheet from Unity3D.
Hope this can help you.

[Maker32]

Hi,

 yes, There is a sample on the PlayMaker Ecosystem that shows how to read from the google spreadsheet.

https://twitter.com/JeanAtPlayMaker/status/1037230277494558721

 Bye,

 Jean

Hi Jean!

Firstly a big thank you for making this into a sample. Its quite good for reference.
I have a query regarding using the Google Sheets.

Is it converting directly the data using the "XML Save into Proxy" action or there is another action that is doing the conversion of this data into XML format?

Upon inspection I found out that there are tags with "gsx" used in the XML, are we supposed to use the Google Sheets API to convert this data?

Secondly,

There was an error using the WWW in the sample in my project. I had to use the Web Request action instead.

Please guide.
Regards

[jeanfabre]

Hi,

 yeah, the www action doesn't always work, on IOS for example, so indeed, use the web request.

as for the gsx, this is the domain, check out how I query using xpath to get to there domains, xmlMaker works ok with that.

Bye,

 Jean