playMaker

Author Topic: connecting unity playmaker with googlespreasheet  (Read 2962 times)

hoyoyo80

  • Full Member
  • ***
  • Posts: 136
connecting unity playmaker with googlespreasheet
« 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

jeanfabre

  • Administrator
  • Hero Member
  • *****
  • Posts: 15500
  • Official Playmaker Support
Re: connecting unity playmaker with googlespreasheet
« Reply #1 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

hoyoyo80

  • Full Member
  • ***
  • Posts: 136
Re: connecting unity playmaker with googlespreasheet
« Reply #2 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.

jeanfabre

  • Administrator
  • Hero Member
  • *****
  • Posts: 15500
  • Official Playmaker Support
Re: connecting unity playmaker with googlespreasheet
« Reply #3 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

hoyoyo80

  • Full Member
  • ***
  • Posts: 136
Re: connecting unity playmaker with googlespreasheet
« Reply #4 on: October 10, 2018, 12:05:33 AM »
Thanks...ive realized this community is so responsive.

jeanfabre

  • Administrator
  • Hero Member
  • *****
  • Posts: 15500
  • Official Playmaker Support
Re: connecting unity playmaker with googlespreasheet
« Reply #5 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

lionserver

  • Playmaker Newbie
  • *
  • Posts: 13
Re: connecting unity playmaker with googlespreasheet
« Reply #6 on: March 13, 2019, 02:06:26 AM »

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

Maker32

  • Playmaker Newbie
  • *
  • Posts: 3
Re: connecting unity playmaker with googlespreasheet
« Reply #7 on: April 22, 2020, 07:53:01 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
« Last Edit: April 22, 2020, 07:58:17 AM by Maker32 »

jeanfabre

  • Administrator
  • Hero Member
  • *****
  • Posts: 15500
  • Official Playmaker Support
Re: connecting unity playmaker with googlespreasheet
« Reply #8 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