What’s the Lightest Way to Connect PlayCanvas Game Data to a Spreadsheet?

Random Chat
1

Hello

I am experimenting with a small web game made in PlayCanvas where I want to collect user choices and score data (just a few values per session). :slightly_smiling_face:My goal is to store this info in a spreadsheet either during testing / for basic analytics after deployment. :innocent:

I am not looking to use a full backend or database unless necessary. Ideally; I would like to POST data to something like Google Sheets, Excel Online / a lightweight service via webhook / REST API. :innocent:

Has anyone tried a similar setup or have suggestions for simple integration without overengineering? :thinking: Checked https://stackoverflow.com/questions/19887737/pushing-data-to-google-spreadsheet-through-javascript-running-in-browser guide for reference.

Also, while preparing the data structure, I stumbled upon a list of excel Interview questions and it actually helped me think through how to make the exported spreadsheet more structured and readable. :thinking:

Happy to share that link too if anyone’s interested!

Thank you !! :slightly_smiling_face:

2

A great way to implement something like this is Google Apps Script. It has built in support for Google Sheets, and it is trivial to setup simple webhooks with it. I personally have used it for similar projects before and it is great.

1 Like