Sometimes you may need to collect data from players. This could be their scores, game statistics, feedback, survey answers or anything else.
There are many ways you can transmit this data - you can send it to MySQL database, upload to Firebase, email etc. Not many people know this, but it's also possible to send it to Google Spreadsheet.
DISCLAIMER: The method described below is not secure! The data is not encrypted or protected in any way, and anyone who has the web app link can send "fake" data to your spreadsheet. So don't use it for any sensitive information!
If you have multiple Google accounts, I recommend signing off all of them except just the one you want to be associated with this spreadsheet.
1. Open Google Sheets and create a new document. Enter the name of the document, for example "High scores".
Make sure your sheet name is "Sheet1" - this is important if you are using Google Docs in a language different from English.
Add the following headers into the first row:
Select the entire third column and click Format -> Number -> Date time.
2. Click Extensions -> Apps Script to create a new Google Apps Script
Rename it to "Submit Data to Google Sheet" or something similar.
Remove all existing code, open the file script.zip attached to this tutorial, unzip it and paste its content into the code.gs window.
3. On the top toolbar select "setup" function in the list and then click Run to execute the setup() function.
In the Authorization Required dialog, click on Review Permissions.
If you see this warning, click "Advanced" and then select "Go to <your script name> (unsafe)".
Confirm all permissions and click "Allow".
4. Click Deploy button on top and select "New deployment".
Make sure to select "New deployment" every time! You can archive old deployments if needed.
Set "Who has access: Anyone"
In the next dialog copy the "Current web app URL", you'll need it later:
Now open the CAPX project attached to this tutorial.
Paste the copied web app url into the global variable web_app_url.
Run the project and test:
Congratulations, you did it!
If you wish to send more data fields, simply add more parameters to the url and edit these lines in the script:
After making these changes in the script make sure to deploy the web app again and select "New deployment".
And finally, if you want to read the data back from the spreadsheet, please see this tutorial: Create Online Database with Google Spreadsheet.