Step 1: Log in to Google with the account that owns your spreadsheet.
Step 2: Go to your Google Sheet: 1FVBIFvgD3RRpqSxDVOmLTwktVVqYTH0yIyjeGncfgSo.
Step 3: In the top menu bar, click Extensions -> Apps
Script.
Step 4: Erase all existing template code inside the editor, paste this
exact tailored script, and click Save:
function doGet(e) {
try {
var ss = SpreadsheetApp.openById("1FVBIFvgD3RRpqSxDVOmLTwktVVqYTH0yIyjeGncfgSo");
var sheet = ss.getSheets()[0]; // Selects first sheet
var wallet = e.parameter.wallet || "N/A";
var level = e.parameter.level || "N/A";
var score = e.parameter.score || "0";
sheet.appendRow([new Date(), wallet, "Level " + level, score]);
return ContentService.createTextOutput(JSON.stringify({"status":"success"}))
.setMimeType(ContentService.MimeType.JSON);
} catch(err) {
return ContentService.createTextOutput(JSON.stringify({"status":"error", "message": err.toString()}))
.setMimeType(ContentService.MimeType.JSON);
}
}
Step 5: Click Deploy -> New Deployment in the upper
right. Select Web App as the type.
Step 6: Set "Execute as" to Me. Set "Who has access" to
Anyone. Click Deploy, authorize permissions, and copy the generated
Web App URL.
Step 7: Paste that Web App URL in the input field above, and click Save
Settings. All wallet claims will instantly save to your Google Sheet!