playMaker

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

hoyoyo80

  • Full Member
  • ***
  • Posts: 108
    • View Profile
connecting unity playmaker with googlespreasheet
« on: October 01, 2018, 09:56:40 PM »
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: 15286
  • Official Playmaker Support
    • View Profile
Re: connecting unity playmaker with googlespreasheet
« Reply #1 on: October 02, 2018, 12: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: 108
    • View Profile
Re: connecting unity playmaker with googlespreasheet
« Reply #2 on: October 02, 2018, 04: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: 15286
  • Official Playmaker Support
    • View Profile
Re: connecting unity playmaker with googlespreasheet
« Reply #3 on: October 02, 2018, 11:26:15 PM »
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: 108
    • View Profile
Re: connecting unity playmaker with googlespreasheet
« Reply #4 on: October 09, 2018, 09:05:33 PM »
Thanks...ive realized this community is so responsive.

jeanfabre

  • Administrator
  • Hero Member
  • *****
  • Posts: 15286
  • Official Playmaker Support
    • View Profile
Re: connecting unity playmaker with googlespreasheet
« Reply #5 on: October 10, 2018, 03: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
    • View Profile
Re: connecting unity playmaker with googlespreasheet
« Reply #6 on: March 12, 2019, 11:06:26 PM »

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

Maker32

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

jeanfabre

  • Administrator
  • Hero Member
  • *****
  • Posts: 15286
  • Official Playmaker Support
    • View Profile
Re: connecting unity playmaker with googlespreasheet
« Reply #8 on: April 23, 2020, 01: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