Playmaker Forum

PlayMaker Help & Tips => PlayMaker Help => Topic started by: hoyoyo80 on October 02, 2018, 12:56:40 AM

Title: connecting unity playmaker with googlespreasheet
Post by: hoyoyo80 on October 02, 2018, 12:56:40 AM

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

Title: Re: connecting unity playmaker with googlespreasheet
Post by: jeanfabre on October 02, 2018, 03:42:25 AM

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

Title: Re: connecting unity playmaker with googlespreasheet
Post by: hoyoyo80 on October 02, 2018, 07:30:43 AM

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.

Title: Re: connecting unity playmaker with googlespreasheet
Post by: jeanfabre on October 03, 2018, 02:26:15 AM

Hi,

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

 Bye,

 Jean

Title: Re: connecting unity playmaker with googlespreasheet
Post by: hoyoyo80 on October 10, 2018, 12:05:33 AM

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

Title: Re: connecting unity playmaker with googlespreasheet
Post by: jeanfabre on October 10, 2018, 06:24:55 AM

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

Title: Re: connecting unity playmaker with googlespreasheet
Post by: lionserver on March 13, 2019, 02:06:26 AM

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

Title: Re: connecting unity playmaker with googlespreasheet
Post by: Maker32 on April 22, 2020, 07:53:01 AM

Quote from: jeanfabre on October 02, 2018, 03:42:25 AM

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

Title: Re: connecting unity playmaker with googlespreasheet
Post by: jeanfabre on April 23, 2020, 04:40:00 AM

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