Discuss Scratch
- Discussion Forums
- » Questions about Scratch
- » Collecting Scratch data from game into Google Sheet
- phy460
-
2 posts
Collecting Scratch data from game into Google Sheet
Hi there,
I was wondering if it is possible for scratch to be programmed to collect data (eg. from a game) and transfer these data (eg. name or scores) into Google sheet?
Any advice? Thank you!
I was wondering if it is possible for scratch to be programmed to collect data (eg. from a game) and transfer these data (eg. name or scores) into Google sheet?
Any advice? Thank you!
- Jeffalo
-
1000+ posts
Collecting Scratch data from game into Google Sheet
unfortunately scratch is quite limited in terms of interacting outside of a few services (text to speech, google translate)
you might want to try snap or adacraft, which are both based off of scratch, and can make http requests.
you would then make requests to the google sheets api and do stuff, but i'm not familiar with how that works. you might need to have a server proxying requests so you don't leak your google api token.
if you really want to use scratch, you want to share it with this awesome community, it is possible to write a server (in nodejs for example) which acts as a cloud data client and would proxy requests to the google sheets api. it's pretty complex, some projects make that simpler but it's messy and a gray area in terms of rules on scratch.
this guy has some projects that make use of that technique
you might want to try snap or adacraft, which are both based off of scratch, and can make http requests.
you would then make requests to the google sheets api and do stuff, but i'm not familiar with how that works. you might need to have a server proxying requests so you don't leak your google api token.
if you really want to use scratch, you want to share it with this awesome community, it is possible to write a server (in nodejs for example) which acts as a cloud data client and would proxy requests to the google sheets api. it's pretty complex, some projects make that simpler but it's messy and a gray area in terms of rules on scratch.
this guy has some projects that make use of that technique
- phy460
-
2 posts
Collecting Scratch data from game into Google Sheet
Thank you so much! ![](//cdn.scratch.mit.edu/scratchr2/static/__c60f3a21d48553913b75273057c29d91__/djangobb_forum/img/smilies/smile.png)
![](http://cdn.scratch.mit.edu/scratchr2/static/__c60f3a21d48553913b75273057c29d91__/djangobb_forum/img/smilies/smile.png)
- Paddle2See
-
1000+ posts
Collecting Scratch data from game into Google Sheet
It is possible to save the contents of a Scratch list to a text file, however. Which could then be imported into a Google Sheet. It requires manually right-clicking on the list monitor and selecting the Export option.
Scratch Team Member, kayak and pickleball enthusiast, cat caregiver.
This is my forum signature! On a forum post, it is okay for Scratchers to advertise in their forum signature. The signature is the stuff that shows up below the horizontal line on the post. It will show up on every post I make.
(credit to Za-Chary)
;
- Discussion Forums
- » Questions about Scratch
-
» Collecting Scratch data from game into Google Sheet