send data to google sheet tutorial [QUESTION]

Post reply

❤Follow Topic(3)

0 favourites

4 posts

From the Asset Store

Ambient Game

$48 USD

The soundstage is set for an immersive listening experience sending your audience adrift.

Epic Stock Media

- jaytee
- - Joined 2 Jun, 2019
  - 50 topics • 90 posts
- 1
- 2 Oct, 2019
- Quote
construct.net/en/tutorials/sending-data-construct-23-1447 (link to tutorial)
Hi dop2000 I want to send an array to a google sheet but my array values are not sent properly, meaning they are all not arranged.

My codes:

My array:

Data sent to google sheet (Suppose to be arrange the same as above array CurX,0)

Can you correct my coding?

Thank you!
Tagged:

array
construct2
google-sheets
- dop2000
- - Joined 26 May, 2016
  - 139 topics • 12,717 posts
- 1
- 2 Oct, 2019
- Quote
Try this:
Set s to variable1 & "?" Repeat Array.width times Set s to s&"name"&loopindex&"="&URLEnconde(Array.At(loopindex,1))&"&" AJAX send "" to URL s

Note, that the AJAX Send is outside of the loop. The loop should create a string like this: "......?name0=XXX&name1=YYY&name2=ZZZ&" , with all names from the array.

And then you send the entire string.

In the google script you will need to loop through all parameters ("nameN"). See comments in this post:

construct.net/en/forum/construct-2/how-do-i-18/send-data-google-sheet-138376
Try Construct 3

Develop games in your browser. Powerful, performant & highly capable.
Try Now Construct 3 users don't see these ads
- jaytee
- - Joined 2 Jun, 2019
  - 50 topics • 90 posts
- 1
- 9 Oct, 2019
- Quote
Hi dop2000! Sorry to bump you on this week old thread again.

I have accidentally once sent the array as JSON to google sheet using your codes. But i can't seem to make it work right now. How would you do it if it were you? Here's my code:

Its not sending as of now, but i managed to sent it before!!

Thank you!
- dop2000
- - Joined 26 May, 2016
  - 139 topics • 12,717 posts
- 1
- 9 Oct, 2019
- Quote
I have no idea. You are sending the whole array in JSON format. In this case you need to process this JSON string in the google script. I don't know how to do it.