Mail

[{"_1":2,"_1527":-5,"_1528":-5},"loaderData",{"_3":4,"_91":92},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":32,"_33":22},"auth",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"tokenType","session_token","sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","ff2b4b5d46c0d41ac97a7ec389dfa57b1b567d3b","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","API_URL","https://api.val.town","clerkState",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":22,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":22,"_90":22},"__clerk_ssr_state",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_81":22,"_21":22,"_82":72,"_83":84,"_85":72,"_86":45,"_87":22,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.search",{"_93":22,"_94":32,"_95":96,"_97":98,"_99":100,"_101":102,"_227":228,"_265":266,"_289":290,"_1511":1512,"_1513":288,"_1514":177,"_1515":1516,"_1517":288,"_1518":816,"_1519":1520,"_1521":1522},"error","page","query","aoc","apiURL","https://codesearch.val.run/?q=aoc&format=json&page=1&type=users","type","users","fileResults",[103,146,161,188,214],{"_104":105,"_106":107,"_108":109,"_110":111,"_112":113,"_114":115,"_116":117,"_118":119,"_120":121,"_122":-5,"_123":-5,"_124":125,"_144":145},"id","19655864-d052-11f0-9ab2-42dde27851f2","url","https://www.val.town/x/coweb/untitled-6897/code/main.ts","project_id","1962c50e-d052-11f0-9ab2-42dde27851f2","name","main.ts","content","export default function (req: Request) {\n return new Response(\n `\n \n \n\t\n\t\n\t\n\t\n Mail \n\n\t\n\n\n\n \n\n

$\"\"$

\n\n

\n $\"\"$ \n

\n \n\t\t\tPlease wait\n

\n\n

\n \n\t\t\tMail\n

\n\n\t\t\n \n\t\t \n

\n\t\n\t\n\t\n \n\n\t `,\n {\n headers: {\n \"Content-Type\": \"text/html\",\n },\n },\n );\n}","updated_at","2025-12-03T14:13:50.448Z","project_name","untitled-6897","project_url","https://www.val.town/x/coweb/untitled-6897/code/","username","coweb","description","image_url","matchedLines",[126,132,135,139,141],{"_127":128,"_129":130,"_131":22},"lineNumber",12,"lineContent"," Mail ","isMatch",{"_127":133,"_129":134,"_131":22},13,"","totalMatches",1,{"_104":147,"_106":148,"_108":149,"_110":111,"_112":150,"_114":151,"_116":152,"_118":153,"_120":154,"_122":-5,"_123":-5,"_124":155,"_144":145},"27614ed8-cfa7-11f0-ab73-42dde27851f2","https://www.val.town/x/maillog/untitled-5485/code/main.ts","275efd90-cfa7-11f0-ab73-42dde27851f2","export default function (req: Request) {\n return new Response(\n ` \n \n \n\t\n\t\n\t\n\t\n Mail \n\n\t\n\n\n\n \n\n

$\"\"$

\n\n

\n $\"\"$ \n

\n \n\t\t\tPlease wait\n

\n\n

\n \n\t\t\tMail\n

\n\n\t\t\n \n\t\t \n

\n\t\n\t\n\t\n \n\n\t `,\n {\n headers: {\n \"Content-Type\": \"text/html\",\n },\n },\n );\n}","2025-12-02T17:49:49.157Z","untitled-5485","https://www.val.town/x/maillog/untitled-5485/code/","maillog",[156,157,158,159,160],{"_127":128,"_129":130,"_131":22},{"_127":133,"_129":134,"_131":22},{"_127":136,"_129":137,"_131":138},{"_127":140,"_129":72,"_131":22},{"_127":142,"_129":143,"_131":22},{"_104":162,"_106":163,"_108":164,"_110":165,"_112":166,"_114":167,"_116":168,"_118":169,"_120":170,"_122":171,"_123":-5,"_124":172,"_144":145},"67144950-cc72-11f0-82b4-42dde27851f2","https://www.val.town/x/sitnik/trmnl-lastfm/code/frontend/index.html","650a3f5c-cc72-11f0-88b9-42dde27851f2","index.html","\n\n \n \n \n TRMNL Last.fm\n \n \n \n \n \n \n \n

\n \n

\n TRMNL Last.fm Plugin\n

\n \n

+

\n Hey, welcome! 👋\n

\n Bring your listening habits to life on your TRMNL! Track what you’ve been listening to, discover\n your top artists and songs, and enjoy a personal snapshot of\n your Last.fm throughout the day.\n

\n \n \n Click to Install this Plugin on TRMNL!\n \n \n

\n Preview\n \n \n \n

\n \n \n \n \n \n","2025-11-28T20:26:40.591Z","trmnl-lastfm","https://www.val.town/x/sitnik/trmnl-lastfm/code/","sitnik","Spotify public plugin for TRMNL",[173,176,179,182,185],{"_127":174,"_129":175,"_131":22},90," >",{"_127":177,"_129":178,"_131":22},91," ",{"_104":189,"_106":190,"_108":191,"_110":192,"_112":193,"_114":194,"_116":195,"_118":196,"_120":197,"_122":-5,"_123":-5,"_124":198,"_144":145},"019ac8a7-7791-7396-8957-fb1fd52508d3","https://www.val.town/x/arfan/sqliteExplorerReact/code/deno.lock","212c4b20-cc10-11f0-af5e-42dde27851f2","deno.lock","{\n \"version\": \"5\",\n \"specifiers\": {\n \"npm:@biomejs/biome@^2.3.5\": \"2.3.5\",\n \"npm:@libsql/client@0.6.0\": \"0.6.0\",\n \"npm:@valtown/sdk@0.37.0\": \"0.37.0\",\n \"npm:@valtown/sdk@1.9.0\": \"1.9.0\",\n \"npm:badge-maker@*\": \"5.0.2\",\n \"npm:hono@*\": \"4.10.1\",\n \"npm:hono@4\": \"4.10.1\",\n \"npm:mime-types@2.1.35\": \"2.1.35\",\n \"npm:preact-render-to-string@*\": \"6.6.2_preact@10.27.2\",\n \"npm:pretty-ms@*\": \"9.3.0\",\n \"npm:zod@*\": \"4.1.12\",\n \"npm:zod@4.1.12\": \"4.1.12\"\n },\n \"npm\": {\n \"@biomejs/biome@2.3.5\": {\n \"integrity\": \"sha512-HvLhNlIlBIbAV77VysRIBEwp55oM/QAjQEin74QQX9Xb259/XP/D5AGGnZMOyF1el4zcvlNYYR3AyTMUV3ILhg==\",\n \"optionalDependencies\": [\n \"@biomejs/cli-darwin-arm64\",\n \"@biomejs/cli-darwin-x64\",\n \"@biomejs/cli-linux-arm64\",\n \"@biomejs/cli-linux-arm64-musl\",\n \"@biomejs/cli-linux-x64\",\n \"@biomejs/cli-linux-x64-musl\",\n \"@biomejs/cli-win32-arm64\",\n \"@biomejs/cli-win32-x64\"\n ],\n \"bin\": true\n },\n \"@biomejs/cli-darwin-arm64@2.3.5\": {\n \"integrity\": \"sha512-fLdTur8cJU33HxHUUsii3GLx/TR0BsfQx8FkeqIiW33cGMtUD56fAtrh+2Fx1uhiCsVZlFh6iLKUU3pniZREQw==\",\n \"os\": [\"darwin\"],\n \"cpu\": [\"arm64\"]\n },\n \"@biomejs/cli-darwin-x64@2.3.5\": {\n \"integrity\": \"sha512-qpT8XDqeUlzrOW8zb4k3tjhT7rmvVRumhi2657I2aGcY4B+Ft5fNwDdZGACzn8zj7/K1fdWjgwYE3i2mSZ+vOA==\",\n \"os\": [\"darwin\"],\n \"cpu\": [\"x64\"]\n },\n \"@biomejs/cli-linux-arm64-musl@2.3.5\": {\n \"integrity\": \"sha512-eGUG7+hcLgGnMNl1KHVZUYxahYAhC462jF/wQolqu4qso2MSk32Q+QrpN7eN4jAHAg7FUMIo897muIhK4hXhqg==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"arm64\"]\n },\n \"@biomejs/cli-linux-arm64@2.3.5\": {\n \"integrity\": \"sha512-u/pybjTBPGBHB66ku4pK1gj+Dxgx7/+Z0jAriZISPX1ocTO8aHh8x8e7Kb1rB4Ms0nA/SzjtNOVJ4exVavQBCw==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"arm64\"]\n },\n \"@biomejs/cli-linux-x64-musl@2.3.5\": {\n \"integrity\": \"sha512-awVuycTPpVTH/+WDVnEEYSf6nbCBHf/4wB3lquwT7puhNg8R4XvonWNZzUsfHZrCkjkLhFH/vCZK5jHatD9FEg==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"x64\"]\n },\n \"@biomejs/cli-linux-x64@2.3.5\": {\n \"integrity\": \"sha512-XrIVi9YAW6ye0CGQ+yax0gLfx+BFOtKaNX74n+xHWla6Cl6huUmcKNO7HPx7BiKnJUzrxXY1qYlm7xMvi08X4g==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"x64\"]\n },\n \"@biomejs/cli-win32-arm64@2.3.5\": {\n \"integrity\": \"sha512-DlBiMlBZZ9eIq4H7RimDSGsYcOtfOIfZOaI5CqsWiSlbTfqbPVfWtCf92wNzx8GNMbu1s7/g3ZZESr6+GwM/SA==\",\n \"os\": [\"win32\"],\n \"cpu\": [\"arm64\"]\n },\n \"@biomejs/cli-win32-x64@2.3.5\": {\n \"integrity\": \"sha512-nUmR8gb6yvrKhtRgzwo/gDimPwnO5a4sCydf8ZS2kHIJhEmSmk+STsusr1LHTuM//wXppBawvSQi2xFXJCdgKQ==\",\n \"os\": [\"win32\"],\n \"cpu\": [\"x64\"]\n },\n \"@libsql/client@0.6.0\": {\n \"integrity\": \"sha512-qhQzTG/y2IEVbL3+9PULDvlQFWJ/RnjFXECr/Nc3nRngGiiMysDaOV5VUzYk7DulUX98EA4wi+z3FspKrUplUA==\",\n \"dependencies\": [\n \"@libsql/core\",\n \"@libsql/hrana-client\",\n \"js-base64\",\n \"libsql\"\n ]\n },\n \"@libsql/core@0.6.2\": {\n \"integrity\": \"sha512-c2P4M+4u/4b2L02A0KjggO3UW51rGkhxr/7fzJO0fEAqsqrWGxuNj2YtRkina/oxfYvAof6xjp8RucNoIV/Odw==\",\n \"dependencies\": [\n \"js-base64\"\n ]\n },\n \"@libsql/darwin-arm64@0.3.19\": {\n \"integrity\": \"sha512-rmOqsLcDI65zzxlUOoEiPJLhqmbFsZF6p4UJQ2kMqB+Kc0Rt5/A1OAdOZ/Wo8fQfJWjR1IbkbpEINFioyKf+nQ==\",\n \"os\": [\"darwin\"],\n \"cpu\": [\"arm64\"]\n },\n \"@libsql/darwin-x64@0.3.19\": {\n \"integrity\": \"sha512-q9O55B646zU+644SMmOQL3FIfpmEvdWpRpzubwFc2trsa+zoBlSkHuzU9v/C+UNoPHQVRMP7KQctJ455I/h/xw==\",\n \"os\": [\"darwin\"],\n \"cpu\": [\"x64\"]\n },\n \"@libsql/hrana-client@0.6.2\": {\n \"integrity\": \"sha512-MWxgD7mXLNf9FXXiM0bc90wCjZSpErWKr5mGza7ERy2FJNNMXd7JIOv+DepBA1FQTIfI8TFO4/QDYgaQC0goNw==\",\n \"dependencies\": [\n \"@libsql/isomorphic-fetch\",\n \"@libsql/isomorphic-ws\",\n \"js-base64\",\n \"node-fetch@3.3.2\"\n ]\n },\n \"@libsql/isomorphic-fetch@0.2.5\": {\n \"integrity\": \"sha512-8s/B2TClEHms2yb+JGpsVRTPBfy1ih/Pq6h6gvyaNcYnMVJvgQRY7wAa8U2nD0dppbCuDU5evTNMEhrQ17ZKKg==\"\n },\n \"@libsql/isomorphic-ws@0.1.5\": {\n \"integrity\": \"sha512-DtLWIH29onUYR00i0GlQ3UdcTRC6EP4u9w/h9LxpUZJWRMARk6dQwZ6Jkd+QdwVpuAOrdxt18v0K2uIYR3fwFg==\",\n \"dependencies\": [\n \"@types/ws\",\n \"ws\"\n ]\n },\n \"@libsql/linux-arm64-gnu@0.3.19\": {\n \"integrity\": \"sha512-mgeAUU1oqqh57k7I3cQyU6Trpdsdt607eFyEmH5QO7dv303ti+LjUvh1pp21QWV6WX7wZyjeJV1/VzEImB+jRg==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"arm64\"]\n },\n \"@libsql/linux-arm64-musl@0.3.19\": {\n \"integrity\": \"sha512-VEZtxghyK6zwGzU9PHohvNxthruSxBEnRrX7BSL5jQ62tN4n2JNepJ6SdzXp70pdzTfwroOj/eMwiPt94gkVRg==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"arm64\"]\n },\n \"@libsql/linux-x64-gnu@0.3.19\": {\n \"integrity\": \"sha512-2t/J7LD5w2f63wGihEO+0GxfTyYIyLGEvTFEsMO16XI5o7IS9vcSHrxsvAJs4w2Pf907uDjmc7fUfMg6L82BrQ==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"x64\"]\n },\n \"@libsql/linux-x64-musl@0.3.19\": {\n \"integrity\": \"sha512-BLsXyJaL8gZD8+3W2LU08lDEd9MIgGds0yPy5iNPp8tfhXx3pV/Fge2GErN0FC+nzt4DYQtjL+A9GUMglQefXQ==\",\n \"os\": [\"linux\"],\n \"cpu\": [\"x64\"]\n },\n \"@libsql/win32-x64-msvc@0.3.19\": {\n \"integrity\": \"sha512-ay1X9AobE4BpzG0XPw1gplyLZPGHIgJOovvW23gUrukRegiUP62uzhpRbKNogLlUOynyXeq//prHgPXiebUfWg==\",\n \"os\": [\"win32\"],\n \"cpu\": [\"x64\"]\n },\n \"@neon-rs/load@0.0.4\": {\n \"integrity\": \"sha512-kTPhdZyTQxB+2wpiRcFWrDcejc4JI6tkPuS7UZCG4l6Zvc5kU/gGQ/ozvHTh1XR5tS+UlfAfGuPajjzQjCiHCw==\"\n },\n \"@types/node-fetch@2.6.13\": {\n \"integrity\": \"sha512-QGpRVpzSaUs30JBSGPjOg4Uveu384erbHBoT1zeONvyCfwQxIkUshLAOqN/k9EjGviPRmWTTe6aH2qySWKTVSw==\",\n \"dependencies\": [\n \"@types/node@24.2.0\",\n \"form-data\"\n ]\n },\n \"@types/node@18.19.129\": {\n \"integrity\": \"sha512-hrmi5jWt2w60ayox3iIXwpMEnfUvOLJCRtrOPbHtH15nTjvO7uhnelvrdAs0dO0/zl5DZ3ZbahiaXEVb54ca/A==\",\n \"dependencies\": [\n \"undici-types@5.26.5\"\n ]\n },\n \"@types/node@24.2.0\": {\n \"integrity\": \"sha512-3xyG3pMCq3oYCNg7/ZP+E1ooTaGB4cG8JWRsqqOYQdbWNY4zbaV0Ennrd7stjiJEFZCaybcIgpTjJWHRfBSIDw==\",\n \"dependencies\": [\n \"undici-types@7.10.0\"\n ]\n },\n \"@types/ws@8.18.1\": {\n \"integrity\": \"sha512-ThVF6DCVhA8kUGy+aazFQ4kXQ7E1Ty7A3ypFOe0IcJV8O/M511G99AW24irKrW56Wt44yG9+ij8FaqoBGkuBXg==\",\n \"dependencies\": [\n \"@types/node@24.2.0\"\n ]\n },\n \"@valtown/sdk@0.37.0\": {\n \"integrity\": \"sha512-8YnynWRljje10MDRGJdftC5qU5FguFLYLDIauEjDUb5IlZbVevMdiunJpK7i37jDBm/QljCmIjPdPUpDE89snw==\",\n \"dependencies\": [\n \"@types/node@18.19.129\",\n \"@types/node-fetch\",\n \"abort-controller\",\n \"agentkeepalive\",\n \"form-data-encoder\",\n \"formdata-node\",\n \"node-fetch@2.7.0\"\n ]\n },\n \"@valtown/sdk@1.9.0\": {\n \"integrity\": \"sha512-xV8B02a+IJZYkxMk7CVS5hcNjyJ2XhZvJ3iXxqaILVbNsaq9BCAzSvYS+GteaFxG0OO9YiWSSNh68047o+Rk+g==\",\n \"dependencies\": [\n \"@types/node@18.19.129\",\n \"@types/node-fetch\",\n \"abort-controller\",\n \"agentkeepalive\",\n \"form-data-encoder\",\n \"formdata-node\",\n \"node-fetch@2.7.0\"\n ]\n },\n \"abort-controller@3.0.0\": {\n \"integrity\": \"sha512-h8lQ8tacZYnR3vNQTgibj+tODHI5/+l06Au2Pcriv/Gmet0eaj4TwWH41sO9wnHDiQsEj19q0drzdWdeAHtweg==\",\n \"dependencies\": [\n \"event-target-shim\"\n ]\n },\n \"agentkeepalive@4.6.0\": {\n \"integrity\": \"sha512-kja8j7PjmncONqaTsB8fQ+wE2mSU2DJ9D4XKoJ5PFWIdRMa6SLSN1ff4mOr4jCbfRSsxR4keIiySJU0N9T5hIQ==\",\n \"dependencies\": [\n \"humanize-ms\"\n ]\n },\n \"anafanafo@2.0.0\": {\n \"integrity\": \"sha512-Nlfq7NC4AOkTJerWRIZcOAiMNtIDVIGWGvQ98O7Jl6Kr2Dk0dX5u4MqN778kSRTy5KRqchpLdF2RtLFEz9FVkQ==\",\n \"dependencies\": [\n \"char-width-table-consumer\"\n ]\n },\n \"asynckit@0.4.0\": {\n \"integrity\": \"sha512-Oei9OH4tRh0YqU3GxhX79dM/mwVgvbZJaSNaRk+bshkj0S5cfHcgYakreBjrHwatXKbz+IoIdYLxrKim2MjW0Q==\"\n },\n \"badge-maker@5.0.2\": {\n \"integrity\": \"sha512-Xd3YUmKPEShQcn6PFB03Wxq0RNJRFwVVroyRz0qIjSXwniYUGsGWNHqtNsQYi/Sbs8Ni7qAEf7LKgDOtcAoCDg==\",\n \"dependencies\": [\n \"anafanafo\",\n \"css-color-converter\"\n ],\n \"bin\": true\n },\n \"binary-search@1.3.6\": {\n \"integrity\": \"sha512-nbE1WxOTTrUWIfsfZ4aHGYu5DOuNkbxGokjV6Z2kxfJK3uaAb8zNK1muzOeipoLHZjInT4Br88BHpzevc681xA==\"\n },\n \"call-bind-apply-helpers@1.0.2\": {\n \"integrity\": \"sha512-Sp1ablJ0ivDkSzjcaJdxEunN5/XvksFJ2sMBFfq6x0ryhQV/2b/KwFe21cMpmHtPOSij8K99/wSfoEuTObmuMQ==\",\n \"dependencies\": [\n \"es-errors\",\n \"function-bind\"\n ]\n },\n \"char-width-table-consumer@1.0.0\": {\n \"integrity\": \"sha512-Fz4UD0LBpxPgL9i29CJ5O4KANwaMnX/OhhbxzvNa332h+9+nRKyeuLw4wA51lt/ex67+/AdsoBQJF3kgX2feYQ==\",\n \"dependencies\": [\n \"binary-search\"\n ]\n },\n \"color-convert@0.5.3\": {\n \"integrity\": \"sha512-RwBeO/B/vZR3dfKL1ye/vx8MHZ40ugzpyfeVG5GsiuGnrlMWe2o8wxBbLCpw9CsxV+wHuzYlCiWnybrIA0ling==\"\n },\n \"color-name@1.1.4\": {\n \"integrity\": \"sha512-dOy+3AuW3a2wNbZHIuMZpTcgjGuLU/uBL/ubcZF9OXbDo8ff4O8yVp5Bf0efS8uEoYo5q4Fx7dY9OgQGXgAsQA==\"\n },\n \"combined-stream@1.0.8\": {\n \"integrity\": \"sha512-FQN4MRfuJeHf7cBbBMJFXhKSDq+2kAArBlmRBvcvFE5BB1HZKXtSFASDhdlz9zOYwxh8lDdnvmMOe/+5cdoEdg==\",\n \"dependencies\": [\n \"delayed-stream\"\n ]\n },\n \"css-color-converter@2.0.0\": {\n \"integrity\": \"sha512-oLIG2soZz3wcC3aAl/7Us5RS8Hvvc6I8G8LniF/qfMmrm7fIKQ8RIDDRZeKyGL2SrWfNqYspuLShbnjBMVWm8g==\",\n \"dependencies\": [\n \"color-convert\",\n \"color-name\",\n \"css-unit-converter\"\n ]\n },\n \"css-unit-converter@1.1.2\": {\n \"integrity\": \"sha512-IiJwMC8rdZE0+xiEZHeru6YoONC4rfPMqGm2W85jMIbkFvv5nFTwJVFHam2eFrN6txmoUYFAFXiv8ICVeTO0MA==\"\n },\n \"data-uri-to-buffer@4.0.1\": {\n \"integrity\": \"sha512-0R9ikRb668HB7QDxT1vkpuUBtqc53YyAwMwGeUFKRojY/NWKvdZ+9UYtRfGmhqNbRkTSVpMbmyhXipFFv2cb/A==\"\n },\n \"delayed-stream@1.0.0\": {\n \"integrity\": \"sha512-ZySD7Nf91aLB0RxL4KGrKHBXl7Eds1DAmEdcoVawXnLD7SDhpNgtuII2aAkg7a7QS41jxPSZ17p4VdGnMHk3MQ==\"\n },\n \"detect-libc@2.0.2\": {\n \"integrity\": \"sha512-UX6sGumvvqSaXgdKGUsgZWqcUyIXZ/vZTrlRT/iobiKhGL0zL4d3osHj3uqllWJK+i+sixDS/3COVEOFbupFyw==\"\n },\n \"dunder-proto@1.0.1\": {\n \"integrity\": \"sha512-KIN/nDJBQRcXw0MLVhZE9iQHmG68qAVIBg9CqmUYjmQIhgij9U5MFvrqkUL5FbtyyzZuOeOt0zdeRe4UY7ct+A==\",\n \"dependencies\": [\n \"call-bind-apply-helpers\",\n \"es-errors\",\n \"gopd\"\n ]\n },\n \"es-define-property@1.0.1\": {\n \"integrity\": \"sha512-e3nRfgfUZ4rNGL232gUgX06QNyyez04KdjFrF+LTRoOXmrOgFKDg4BCdsjW8EnT69eqdYGmRpJwiPVYNrCaW3g==\"\n },\n \"es-errors@1.3.0\": {\n \"integrity\": \"sha512-Zf5H2Kxt2xjTvbJvP2ZWLEICxA6j+hAmMzIlypy4xcBg1vKVnx89Wy0GbS+kf5cwCVFFzdCFh2XSCFNULS6csw==\"\n },\n \"es-object-atoms@1.1.1\": {\n \"integrity\": \"sha512-FGgH2h8zKNim9ljj7dankFPcICIK9Cp5bm+c2gQSYePhpaG5+esrLODihIorn+Pe6FGJzWhXQotPv73jTaldXA==\",\n \"dependencies\": [\n \"es-errors\"\n ]\n },\n \"es-set-tostringtag@2.1.0\": {\n \"integrity\": \"sha512-j6vWzfrGVfyXxge+O0x5sh6cvxAog0a/4Rdd2K36zCMV5eJ+/+tOAngRO8cODMNWbVRdVlmGZQL2YS3yR8bIUA==\",\n \"dependencies\": [\n \"es-errors\",\n \"get-intrinsic\",\n \"has-tostringtag\",\n \"hasown\"\n ]\n },\n \"event-target-shim@5.0.1\": {\n \"integrity\": \"sha512-i/2XbnSz/uxRCU6+NdVJgKWDTM427+MqYbkQzD321DuCQJUqOuJKIA0IM2+W2xtYHdKOmZ4dR6fExsd4SXL+WQ==\"\n },\n \"fetch-blob@3.2.0\": {\n \"integrity\": \"sha512-7yAQpD2UMJzLi1Dqv7qFYnPbaPx7ZfFK6PiIxQ4PfkGPyNyl2Ugx+a/umUonmKqjhM4DnfbMvdX6otXq83soQQ==\",\n \"dependencies\": [\n \"node-domexception\",\n \"web-streams-polyfill@3.3.3\"\n ]\n },\n \"form-data-encoder@1.7.2\": {\n \"integrity\": \"sha512-qfqtYan3rxrnCk1VYaA4H+Ms9xdpPqvLZa6xmMgFvhO32x7/3J/ExcTd6qpxM0vH2GdMI+poehyBZvqfMTto8A==\"\n },\n \"form-data@4.0.4\": {\n \"integrity\": \"sha512-KrGhL9Q4zjj0kiUt5OO4Mr/A/jlI2jDYs5eHBpYHPcBEVSiipAvn2Ko2HnPe20rmcuuvMHNdZFp+4IlGTMF0Ow==\",\n \"dependencies\": [\n \"asynckit\",\n \"combined-stream\",\n \"es-set-tostringtag\",\n \"hasown\",\n \"mime-types\"\n ]\n },\n \"formdata-node@4.4.1\": {\n \"integrity\": \"sha512-0iirZp3uVDjVGt9p49aTaqjk84TrglENEDuqfdlZQ1roC9CWlPk6Avf8EEnZNcAqPonwkG35x4n3ww/1THYAeQ==\",\n \"dependencies\": [\n \"node-domexception\",\n \"web-streams-polyfill@4.0.0-beta.3\"\n ]\n },\n \"formdata-polyfill@4.0.10\": {\n \"integrity\": \"sha512-buewHzMvYL29jdeQTVILecSaZKnt/RJWjoZCF5OW60Z67/GmSLBkOFM7qh1PI3zFNtJbaZL5eQu1vLfazOwj4g==\",\n \"dependencies\": [\n \"fetch-blob\"\n ]\n },\n \"function-bind@1.1.2\": {\n \"integrity\": \"sha512-7XHNxH7qX9xG5mIwxkhumTox/MIRNcOgDrxWsMt2pAr23WHp6MrRlN7FBSFpCpr+oVO0F744iUgR82nJMfG2SA==\"\n },\n \"get-intrinsic@1.3.0\": {\n \"integrity\": \"sha512-9fSjSaos/fRIVIp+xSJlE6lfwhES7LNtKaCBIamHsjr2na1BiABJPo0mOjjz8GJDURarmCPGqaiVg5mfjb98CQ==\",\n \"dependencies\": [\n \"call-bind-apply-helpers\",\n \"es-define-property\",\n \"es-errors\",\n \"es-object-atoms\",\n \"function-bind\",\n \"get-proto\",\n \"gopd\",\n \"has-symbols\",\n \"hasown\",\n \"math-intrinsics\"\n ]\n },\n \"get-proto@1.0.1\": {\n \"integrity\": \"sha512-sTSfBjoXBp89JvIKIefqw7U2CCebsc74kiY6awiGogKtoSGbgjYE/G/+l9sF3MWFPNc9IcoOC4ODfKHfxFmp0g==\",\n \"dependencies\": [\n \"dunder-proto\",\n \"es-object-atoms\"\n ]\n },\n \"gopd@1.2.0\": {\n \"integrity\": \"sha512-ZUKRh6/kUFoAiTAtTYPZJ3hw9wNxx+BIBOijnlG9PnrJsCcSjs1wyyD6vJpaYtgnzDrKYRSqf3OO6Rfa93xsRg==\"\n },\n \"has-symbols@1.1.0\": {\n \"integrity\": \"sha512-1cDNdwJ2Jaohmb3sg4OmKaMBwuC48sYni5HUw2DvsC8LjGTLK9h+eb1X6RyuOHe4hT0ULCW68iomhjUoKUqlPQ==\"\n },\n \"has-tostringtag@1.0.2\": {\n \"integrity\": \"sha512-NqADB8VjPFLM2V0VvHUewwwsw0ZWBaIdgo+ieHtK3hasLz4qeCRjYcqfB6AQrBggRKppKF8L52/VqdVsO47Dlw==\",\n \"dependencies\": [\n \"has-symbols\"\n ]\n },\n \"hasown@2.0.2\": {\n \"integrity\": \"sha512-0hJU9SCPvmMzIBdZFqNPXWa6dqh7WdH0cII9y+CyS8rG3nL48Bclra9HmKhVVUHyPWNH5Y7xDwAB7bfgSjkUMQ==\",\n \"dependencies\": [\n \"function-bind\"\n ]\n },\n \"hono@4.10.1\": {\n \"integrity\": \"sha512-rpGNOfacO4WEPClfkEt1yfl8cbu10uB1lNpiI33AKoiAHwOS8lV748JiLx4b5ozO/u4qLjIvfpFsPXdY5Qjkmg==\"\n },\n \"humanize-ms@1.2.1\": {\n \"integrity\": \"sha512-Fl70vYtsAFb/C06PTS9dZBo7ihau+Tu/DNCk/OyHhea07S+aeMWpFFkUaXRa8fI+ScZbEI8dfSxwY7gxZ9SAVQ==\",\n \"dependencies\": [\n \"ms\"\n ]\n },\n \"js-base64@3.7.8\": {\n \"integrity\": \"sha512-hNngCeKxIUQiEUN3GPJOkz4wF/YvdUdbNL9hsBcMQTkKzboD7T/q3OYOuuPZLUE6dBxSGpwhk5mwuDud7JVAow==\"\n },\n \"libsql@0.3.19\": {\n \"integrity\": \"sha512-Aj5cQ5uk/6fHdmeW0TiXK42FqUlwx7ytmMLPSaUQPin5HKKKuUPD62MAbN4OEweGBBI7q1BekoEN4gPUEL6MZA==\",\n \"dependencies\": [\n \"@neon-rs/load\",\n \"detect-libc\"\n ],\n \"optionalDependencies\": [\n \"@libsql/darwin-arm64\",\n \"@libsql/darwin-x64\",\n \"@libsql/linux-arm64-gnu\",\n \"@libsql/linux-arm64-musl\",\n \"@libsql/linux-x64-gnu\",\n \"@libsql/linux-x64-musl\",\n \"@libsql/win32-x64-msvc\"\n ],\n \"os\": [\"darwin\", \"linux\", \"win32\"],\n \"cpu\": [\"x64\", \"arm64\", \"wasm32\"]\n },\n \"math-intrinsics@1.1.0\": {\n \"integrity\": \"sha512-/IXtbwEk5HTPyEwyKX6hGkYXxM9nbj64B+ilVJnC/R6B0pH5G4V3b0pVbL7DBj4tkhBAppbQUlf6F6Xl9LHu1g==\"\n },\n \"mime-db@1.52.0\": {\n \"integrity\": \"sha512-sPU4uV7dYlvtWJxwwxHD0PuihVNiE7TyAbQ5SWxDCB9mUYvOgroQOwYQQOKPJ8CIbE+1ETVlOoK1UC2nU3gYvg==\"\n },\n \"mime-types@2.1.35\": {\n \"integrity\": \"sha512-ZDY+bPm5zTTF+YpCrAU9nK0UgICYPT0QtT1NZWFv4s++TNkcgVaT0g6+4R2uI4MjQjzysHB1zxuWL50hzaeXiw==\",\n \"dependencies\": [\n \"mime-db\"\n ]\n },\n \"ms@2.1.3\": {\n \"integrity\": \"sha512-6FlzubTLZG3J2a/NVCAleEhjzq5oxgHyaCU9yYXvcLsvoVaHJq/s5xXI6/XXP6tz7R9xAOtHnSO/tXtF3WRTlA==\"\n },\n \"node-domexception@1.0.0\": {\n \"integrity\": \"sha512-/jKZoMpw0F8GRwl4/eLROPA3cfcXtLApP0QzLmUT/HuPCZWyB7IY9ZrMeKw2O/nFIqPQB3PVM9aYm0F312AXDQ==\",\n \"deprecated\": true\n },\n \"node-fetch@2.7.0\": {\n \"integrity\": \"sha512-c4FRfUm/dbcWZ7U+1Wq0AwCyFL+3nt2bEw05wfxSz+DWpWsitgmSgYmy2dQdWyKC1694ELPqMs/YzUSNozLt8A==\",\n \"dependencies\": [\n \"whatwg-url\"\n ]\n },\n \"node-fetch@3.3.2\": {\n \"integrity\": \"sha512-dRB78srN/l6gqWulah9SrxeYnxeddIG30+GOqK/9OlLVyLg3HPnr6SqOWTWOXKRwC2eGYCkZ59NNuSgvSrpgOA==\",\n \"dependencies\": [\n \"data-uri-to-buffer\",\n \"fetch-blob\",\n \"formdata-polyfill\"\n ]\n },\n \"parse-ms@4.0.0\": {\n \"integrity\": \"sha512-TXfryirbmq34y8QBwgqCVLi+8oA3oWx2eAnSn62ITyEhEYaWRlVZ2DvMM9eZbMs/RfxPu/PK/aBLyGj4IrqMHw==\"\n },\n \"preact-render-to-string@6.6.2_preact@10.27.2\": {\n \"integrity\": \"sha512-VJ++Pkzv6+ZOmeN/9Qvx0mRdXqnei1Lo3uu9bGvYHhoMI1VUkDT44hcpGbiokl/kuuYTayYa3yvmYTLZMplfMA==\",\n \"dependencies\": [\n \"preact\"\n ]\n },\n \"preact@10.27.2\": {\n \"integrity\": \"sha512-5SYSgFKSyhCbk6SrXyMpqjb5+MQBgfvEKE/OC+PujcY34sOpqtr+0AZQtPYx5IA6VxynQ7rUPCtKzyovpj9Bpg==\"\n },\n \"pretty-ms@9.3.0\": {\n \"integrity\": \"sha512-gjVS5hOP+M3wMm5nmNOucbIrqudzs9v/57bWRHQWLYklXqoXKrVfYW2W9+glfGsqtPgpiz5WwyEEB+ksXIx3gQ==\",\n \"dependencies\": [\n \"parse-ms\"\n ]\n },\n \"tr46@0.0.3\": {\n \"integrity\": \"sha512-N3WMsuqV66lT30CrXNbEjx4GEwlow3v6rr4mCcv6prnfwhS01rkgyFdjPNBYd9br7LpXV1+Emh01fHnq2Gdgrw==\"\n },\n \"undici-types@5.26.5\": {\n \"integrity\": \"sha512-JlCMO+ehdEIKqlFxk6IfVoAUVmgz7cU7zD/h9XZ0qzeosSHmUJVOzSQvvYSYWXkFXC+IfLKSIffhv0sVZup6pA==\"\n },\n \"undici-types@7.10.0\": {\n \"integrity\": \"sha512-t5Fy/nfn+14LuOc2KNYg75vZqClpAiqscVvMygNnlsHBFpSXdJaYtXMcdNLpl/Qvc3P2cB3s6lOV51nqsFq4ag==\"\n },\n \"web-streams-polyfill@3.3.3\": {\n \"integrity\": \"sha512-d2JWLCivmZYTSIoge9MsgFCZrt571BikcWGYkjC1khllbTeDlGqZ2D8vD8E/lJa8WGWbb7Plm8/XJYV7IJHZZw==\"\n },\n \"web-streams-polyfill@4.0.0-beta.3\": {\n \"integrity\": \"sha512-QW95TCTaHmsYfHDybGMwO5IJIM93I/6vTRk+daHTWFPhwh+C8Cg7j7XyKrwrj8Ib6vYXe0ocYNrmzY4xAAN6ug==\"\n },\n \"webidl-conversions@3.0.1\": {\n \"integrity\": \"sha512-2JAn3z8AR6rjK8Sm8orRC0h/bcl/DqL7tRPdGZ4I1CjdF+EaMLmYxBHyXuKL849eucPFhvBoxMsflfOb8kxaeQ==\"\n },\n \"whatwg-url@5.0.0\": {\n \"integrity\": \"sha512-saE57nupxk6v3HY35+jzBwYa0rKSy0XR8JSxZPwgLr7ys0IBzhGviA1/TUGJLmSVqs8pb9AnvICXEuOHLprYTw==\",\n \"dependencies\": [\n \"tr46\",\n \"webidl-conversions\"\n ]\n },\n \"ws@8.18.3\": {\n \"integrity\": \"sha512-PEIGCY5tSlUt50cqyMXfCzX+oOPqN0vuGqWzbcJ2xvnkzkq46oOpz7dQaTDBdfICb4N14+GARUDw2XV2N4tvzg==\"\n },\n \"zod@4.1.12\": {\n \"integrity\": \"sha512-JInaHOamG8pt5+Ey8kGmdcAcg3OL9reK8ltczgHTAwNhMys/6ThXHityHxVV2p3fkw/c+MAvBHFVYHFZDmjMCQ==\"\n }\n },\n \"redirects\": {\n \"https://esm.sh/@json2csv/plainjs\": \"https://esm.sh/@json2csv/plainjs@7.0.6\",\n \"https://esm.sh/@types/react-dom@~18.2.25/client.d.ts\": \"https://esm.sh/@types/react-dom@18.2.25/client.d.ts\",\n \"https://esm.sh/@types/react@~18.2.79/index.d.ts\": \"https://esm.sh/@types/react@18.2.79/index.d.ts\",\n \"https://esm.sh/@types/react@~18.2.79/jsx-runtime.d.ts\": \"https://esm.sh/@types/react@18.2.79/jsx-runtime.d.ts\",\n \"https://esm.sh/preact/jsx-runtime\": \"https://esm.sh/preact@10.27.2/jsx-runtime\",\n \"https://esm.town/v/std/API_URL\": \"https://esm.town/v/std/API_URL?v=5\",\n \"https://esm.town/v/std/ValTownBlobError\": \"https://esm.town/v/std/ValTownBlobError?v=2\",\n \"https://esm.town/v/std/ValTownBlobNotFoundError\": \"https://esm.town/v/std/ValTownBlobNotFoundError?v=2\",\n \"https://esm.town/v/std/blob\": \"https://esm.town/v/std/blob?v=13\",\n \"https://esm.town/v/std/oauth/middleware.ts\": \"https://esm.town/v/std/oauth@172-main/middleware.ts\",\n \"https://esm.town/v/std/sqlite\": \"https://esm.town/v/std/sqlite?v=6\",\n \"https://esm.town/v/std/utils/index.ts\": \"https://esm.town/v/std/utils@196-main/index.ts\"\n },\n \"remote\": {\n \"https://esm.sh/@codemirror/lang-sql@6.5.4\": \"cab7d12aa08cd1c22ddc983d90e174229d36e62e57fdb441969b4ed66937dc94\",\n \"https://esm.sh/@codemirror/view@6.22.0\": \"564be27874b7c2b0a9b8834947f1b52b2bac0c23410136828adf8dcdb72f6b5e\",\n \"https://esm.sh/@json2csv/plainjs@7.0.6\": \"acc8af37aa8824688f818dbaae3d52730dc6c3582db6f0c93cd926448fb3caf7\",\n \"https://esm.sh/@uiw/react-codemirror@4.21.21?deps=react@18.2.0\": \"fa3bab229b11b67368ce613534db502ccb58131f1831ab7ee04d67b4512e35eb\",\n \"https://esm.sh/lucide-react@0.479.0/X-ZHJlYWN0QDE4LjIuMA/denonext/lucide-react.mjs\": \"7649775980650efc330224ae77e399916d407ae5f30204ee891ab1e316dd3a40\",\n \"https://esm.sh/lucide-react@0.479.0?deps=react@18.2.0\": \"a511cd32ce85e45105715be8e428e64462d2adf5d2d9b53d8ce305453053d540\",\n \"https://esm.sh/preact@10.27.2/jsx-runtime\": \"47eea90062ca8af935c0018026958ab025fea5ef1307ee07f73eff4386200167\",\n \"https://esm.sh/react-dom@18.2.0/client\": \"f43f7bb47905958ce487302ca818ba5a845a6029daa7ea22ef097a575b72045b\",\n \"https://esm.sh/react@18.2.0\": \"fed8aeb7d240bb42a2167c9c7c6e842e128c7630cbcb08c4d61c9c1926f89c75\",\n \"https://esm.sh/react@18.2.0/denonext/react.mjs\": \"a986c2876dc2f73879f395e677dc34cb751f260e69db16364810655f884df173\",\n \"https://esm.sh/react@18.2.0/jsx-runtime\": \"0bb3cca902d25a6827ac8153c8038b637e21bd20180bd58e827515d67de80582\",\n \"https://esm.sh/sql-query-identifier@2.7.0\": \"ed78d3f99b7714eea7febca3e9102ea7d76fcef36ba4cdd4de346483f3f867fd\",\n \"https://esm.town/v/std/API_URL?v=5\": \"46109f905a50e32281d3ffbe7b9c8209a778290c5274d83d131fba2d26c4974d\",\n \"https://esm.town/v/std/ValTownBlobError?v=2\": \"5f078bdb92be6111fc3e039a223d2e7c606eec737fb5ba664dc9d9931edfc04e\",\n \"https://esm.town/v/std/ValTownBlobNotFoundError?v=2\": \"0f4f41f3504a33fca793e83a73f2d12de8ca5acbcc397ad8e29510d32527a6ac\",\n \"https://esm.town/v/std/blob?v=13\": \"1ddf1e6a329b18d2109333ad589ebbeef86aa6957e51bf12df48f51180067bfd\",\n \"https://esm.town/v/std/oauth@172-main/crypto.ts\": \"97c603adf621881d00a55cf86d743b36c5913ae3b93584d41fecca1b4cee682e\",\n \"https://esm.town/v/std/oauth@172-main/middleware.ts\": \"936fccebd8e8cb6531c80ea609bab5a1d1ffc75f90ff28122371c74a5e9df6a3\",\n \"https://esm.town/v/std/oauth@172-main/oauth.ts\": \"f12ebe685d79eb2afba366121c7b529e0203e67ab4920809684cca1ade192b7b\",\n \"https://esm.town/v/std/oauth@172-main/session.ts\": \"89c0363087649d9586c0c59ce7d7c6b572f94663722aa4353f3a8b54a5b48f77\",\n \"https://esm.town/v/std/sqlite?v=6\": \"9b20a6ae261b6e3e15bd50cc5268bb4f0713f86f5ae4a525c97982c2162e1519\",\n \"https://esm.town/v/std/utils@105-main/parseImportMeta/project.ts\": \"1ebbe08847a68e921c988511b0ad1d0f18ead83d9b755503e6b4787d443bb2db\",\n \"https://esm.town/v/std/utils@196-main/file.ts\": \"ae1bba38dc3dd1111ac81bdad8a8d6672be2ee0a561991ec5927880ecfae31b1\",\n \"https://esm.town/v/std/utils@196-main/index.ts\": \"333d7454f47cc0dfa6996fd41c12076d3c604871c3c519b308947f3d619de1a5\",\n \"https://esm.town/v/std/utils@196-main/is-main.ts\": \"602b3f833e2a2d08f301b52dced89943f45ff422d5e904cd3608fa15f96a2fd8\",\n \"https://esm.town/v/std/utils@196-main/parseImportMeta.ts\": \"55f0e3e896ca0d950bc6ee27f8208b6c066707f6e030ec22ea360f12aa30fdac\",\n \"https://esm.town/v/std/utils@196-main/serve-file.ts\": \"cd7fd9b0c418b8a89ec2b0ac0fb0eb782321de2b13895c3825725b7b826b171a\",\n \"https://esm.town/v/std/utils@196-main/static.tsx\": \"274bec2ed7492b8bcfc5784f6b765550b7454517d6e20a55dce8dbfe5e53e376\",\n \"https://esm.town/v/std/utils@196-main/test.tsx\": \"996acd34c6b6b273043cbcb4822ac3a47d0650c78b22a25c3349a309cd94a79d\",\n \"https://esm.town/v/std/utils@85-main/file/index.ts\": \"f7b4d1f95fb1ef1cbcb3bc0d2fe83194f18403c7d35115a9f066cba4ef6b84d0\",\n \"https://esm.town/v/std/utils@85-main/index.ts\": \"3d060a58ccd352517da960077ffd78b80c1051ca2117cb37adbff0365cb45efb\",\n \"https://esm.town/v/std/utils@85-main/parseImportMeta/project.ts\": \"1a47e75e21faf22b38fb07e6ead284b6a381a48970a39490e585507a8bb47bbf\",\n \"https://esm.town/v/std/utils@85-main/serve-file/index.ts\": \"1386c1fe12e8e9a41e3561b0a1e55f332bc559fe98fa81f99434b4f642275cd4\",\n \"https://esm.town/v/std/utils@85-main/test/index.tsx\": \"41fc8ccb29945e8cf65263dc61a6840decf9f62fb035be8d0651267ac84b573d\"\n },\n \"workspace\": {\n \"dependencies\": [\n \"npm:@biomejs/biome@^2.3.5\"\n ]\n }\n}\n","2025-11-28T04:10:09.625Z","sqliteExplorerReact","https://www.val.town/x/arfan/sqliteExplorerReact/code/","arfan",[199,202,205,208,211],{"_127":200,"_129":201,"_131":22},213," },",{"_127":203,"_129":204,"_131":22},214," \"badge-maker@5.0.2\": {",{"_127":206,"_129":207,"_131":138},215," \"integrity\": \"sha512-Xd3YUmKPEShQcn6PFB03Wxq0RNJRFwVVroyRz0qIjSXwniYUGsGWNHqtNsQYi/Sbs8Ni7qAEf7LKgDOtcAoCDg==\",",{"_127":209,"_129":210,"_131":22},216," \"dependencies\": [",{"_127":212,"_129":213,"_131":22},217," \"anafanafo\",",{"_104":215,"_106":216,"_108":217,"_110":192,"_112":193,"_114":218,"_116":195,"_118":219,"_120":220,"_122":-5,"_123":-5,"_124":221,"_144":145},"14e1d65e-c1d0-11f0-bc5e-42dde27851f2","https://www.val.town/x/nbbaier/sqliteExplorerReact/code/deno.lock","9f32a75c-98f4-11f0-99e5-0224a6c84d84","2025-11-18T23:14:43.121Z","https://www.val.town/x/nbbaier/sqliteExplorerReact/code/","nbbaier",[222,223,224,225,226],{"_127":200,"_129":201,"_131":22},{"_127":203,"_129":204,"_131":22},{"_127":206,"_129":207,"_131":138},{"_127":209,"_129":210,"_131":22},{"_127":212,"_129":213,"_131":22},"projectResults",[229,239,248,254,260],{"_104":230,"_106":231,"_110":232,"_120":233,"_122":-5,"_123":-5,"_234":-5,"_114":235,"_236":237,"_238":32},"6972032c-fc6b-11ef-987f-569c3dd06744","https://www.val.town/x/OmMousa/memorableMagentaOce/code/","memorableMagentaOce","OmMousa","forked_branch_id","2025-03-08T22:19:33.252Z","user_id","38a8ee20-f53d-11ef-804e-cd1503a70b22","matchCount",{"_104":240,"_106":241,"_110":242,"_120":243,"_122":-5,"_123":-5,"_234":244,"_114":245,"_236":246,"_238":247},"513ddf1c-278e-11f0-a822-569c3dd06744","https://www.val.town/x/robsimmons/aoc_2023_21_1/code/","aoc_2023_21_1","robsimmons","5157f6b8-278e-11f0-a822-569c3dd06744","2024-03-08T03:01:30.566Z","9df63109-b7cd-4c5f-af88-a0b5ae6371f9",2,{"_104":249,"_106":250,"_110":251,"_120":243,"_122":-5,"_123":-5,"_234":252,"_114":253,"_236":246,"_238":247},"5052d062-278e-11f0-a822-569c3dd06744","https://www.val.town/x/robsimmons/aoc_2023_15_2/code/","aoc_2023_15_2","5181dc94-278e-11f0-a822-569c3dd06744","2023-12-16T01:41:33.346Z",{"_104":255,"_106":256,"_110":257,"_120":243,"_122":-5,"_123":-5,"_234":258,"_114":259,"_236":246,"_238":247},"51808934-278e-11f0-a822-569c3dd06744","https://www.val.town/x/robsimmons/aoc_2023_15_1/code/","aoc_2023_15_1","5077d024-278e-11f0-a822-569c3dd06744","2023-12-16T01:35:49.385Z",{"_104":261,"_106":262,"_110":263,"_120":243,"_122":-5,"_123":-5,"_234":258,"_114":264,"_236":246,"_238":247},"50a7347c-278e-11f0-a822-569c3dd06744","https://www.val.town/x/robsimmons/aoc_2023_14_feasible/code/","aoc_2023_14_feasible","2023-12-15T18:38:47.401Z","userResults",[267,275,282],{"_104":268,"_120":269,"_270":-5,"_271":272,"_106":273,"_114":274,"_238":145},"019a5a31-f8c0-723e-bd9d-cef1627ea9f7","aochagavia","bio","profile_image_url","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzM1NzhhRmZ2UXNDd2t6WlZnVUp6SUdmSmVKTyJ9","https://www.val.town/u/aochagavia","2025-11-10T14:46:45.865Z",{"_104":276,"_120":277,"_270":-5,"_271":278,"_106":279,"_114":280,"_238":281},"db8c40b0-3679-11f0-8fa1-55b6765ef200","jessicaocean","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeFExeUQyU0VlRHI3UGZ6NTE5RWJwak55S1IifQ","https://www.val.town/u/jessicaocean","2025-09-17T19:30:27.107Z",9,{"_104":283,"_120":284,"_270":-5,"_271":285,"_106":286,"_114":287,"_238":288},"98704e00-413e-11f0-ac26-6f9aa82eb942","AnthoniaOchai","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeTJqbUNwbktvekdXeWlrUVEwS0NDeHN4bTYifQ","https://www.val.town/u/AnthoniaOchai","2025-08-12T21:24:56.200Z",3,"docResults",[291,359,650,763,915,957,1038,1204,1279,1361],{"_106":292,"_112":293,"_294":295,"_296":297,"_300":301,"_312":313,"_332":333,"_334":293,"_335":336,"_337":338,"_339":340},"https://docs.val.town/guides/creating-a-webhook/","Creating a webhook. Copy page Copy page. Copy this page as Markdown for LLMs. View as Markdown View this page as plain text. Open in ChatGPT Ask questions about this page. Webhooks are for realtime server-to-server communication. Many apps – like GitHub, Discord, and Stripe – let you configure webhooks so that you can get programmatic notifications. When the event happens, they will send an HTTP request to a URL you specify. For example, we registered this val to receive webhooks from Stripe when we get a new subscriber to Val Town Pro. It sends new subscribers a thank you email and notifies our team in our internal Discord channel. Creating a webhook. Section titled “Creating a webhook” While the specifics vary by service, the general steps are: Create an HTTP handler to receive the webhook. Register the webhook with the service. Handle the incoming webhook. Secure the webhook by validating the request came from the service. We have examples for receiving webhooks from Github, Telegram, Stripe, and Supabase. Let us know if there are other integrations you’d like us to document!","word_count",182,"meta",{"_298":299},"title","Creating a webhook","anchors",[302,308],{"_303":304,"_104":305,"_306":299,"_307":32},"element","h1","_top","text","location",{"_303":309,"_104":310,"_306":299,"_307":311},"h2","creating-a-webhook",110,"weighted_locations",[314,319,322,324,326,330],{"_315":316,"_317":318,"_307":145},"weight",7,"balanced_score",14365.4375,{"_315":145,"_317":320,"_307":321},293.17218,68,{"_315":145,"_317":320,"_307":323},86,{"_315":145,"_317":320,"_307":325},97,{"_315":327,"_317":328,"_307":329},6,10554.199,111,{"_315":145,"_317":320,"_307":331},116,"locations",[145,321,323,325,329,331],"raw_content","raw_url","/guides/creating-a-webhook/","excerpt","Creating a webhook. Copy page Copy page. Copy this page as Markdown for LLMs. View as Markdown View this page as plain text. Open in ChatGPT Ask questions about this","sub_results",[341,351],{"_298":299,"_106":342,"_343":344,"_312":345,"_332":350,"_337":338},"https://docs.val.town/guides/creating-a-webhook/#_top","anchor",{"_303":304,"_104":305,"_306":299,"_307":32},[346,347,348,349],{"_315":316,"_317":318,"_307":145},{"_315":145,"_317":320,"_307":321},{"_315":145,"_317":320,"_307":323},{"_315":145,"_317":320,"_307":325},[145,321,323,325],{"_298":299,"_106":352,"_343":353,"_312":354,"_332":357,"_337":358},"https://docs.val.town/guides/creating-a-webhook/#creating-a-webhook",{"_303":309,"_104":310,"_306":299,"_307":311},[355,356],{"_315":327,"_317":328,"_307":329},{"_315":145,"_317":320,"_307":331},[329,331],"Creating a webhook. Section titled “Creating a webhook” While the specifics vary by service, the general steps are: Create an HTTP handler to receive the webhook. Register the webhook with",{"_106":360,"_112":361,"_294":362,"_296":363,"_300":369,"_312":436,"_332":529,"_334":530,"_335":531,"_337":532,"_339":533},"https://docs.val.town/guides/google-sheets/","Store data in a Google Sheet. Copy page Copy page. Copy this page as Markdown for LLMs. View as Markdown View this page as plain text. Open in ChatGPT Ask questions about this page. You can send data to Google Sheets from a val. You can collect data from incoming HTTP requests or from an HTTP endpoint on a schedule. You have two options for authenticating with the Google Sheets API: Use Pipedream’s Accounts API to fetch a fresh OAuth access token at runtime. Use your own Google Cloud service account. Use Pipedream’s Accounts API. Section titled “Use Pipedream’s Accounts API” Pipedream provides a workflow automation product for developers. Workflows are built as a sequence of steps — pre-built actions for thousands of APIs or custom code — triggered by an event (HTTP request, timer, when a new row is added to a Google Sheets, and more). Pipedream also manages the OAuth token refresh process for apps like Google Sheets, exposing a fresh access token in the workflow runtime and the Accounts API. If you connect your Google Sheets account to Pipedream, you can use the Accounts API to fetch a fresh token within your val and use that token to authenticate requests to the Google Sheets API. 1. Sign up for Pipedream and retrieve your API key. Section titled “1. Sign up for Pipedream and retrieve your API key” Sign up for Pipedream and visit https://pipedream.com/settings/user. Find the API Key section and copy your key: You’ll use this key to authenticate requests to the Accounts API, letting you fetch Google Sheets access tokens in your val. 2. Add that key as a Val Town environment variable. Section titled “2. Add that key as a Val Town environment variable” Add the API key as an environment variable in Val Town. In this example, we’ve named the environment variable pipedream_api_key: 3. Connect your Google Sheets account in Pipedream. Section titled “3. Connect your Google Sheets account in Pipedream” Visit https://pipedream.com/accounts. Click the Connect an app button at the top-right: You’ll be directed through the OAuth authorization process to connect your Google Sheets account to Pipedream. Once you’ve connected your account, you’ll see it listed on the Accounts page. 4. Copy the account ID. Section titled “4. Copy the account ID” Click the … to the right of the account and Copy Account ID: All account IDs are prefixed with apn_, so yours should look something like apn_abc123. 5. Note your sheet ID. Section titled “5. Note your sheet ID” In the Google Sheet you’d like to access, copy the sheet ID from the URL bar. It’s the long string of characters between /d/ and /edit. 6. Fetch a Google Sheets access token and use it in your val. Section titled “6. Fetch a Google Sheets access token and use it in your val” In your val, fetch a fresh Google Sheets access token from Pipedream and use it to authenticate requests: ExampleRun in Val Town ↗ import { fetchJSON } from \"https://esm.town/v/stevekrouse/fetchJSON?v=41\"; const accountID = \"\"; const sheetID = \"\"; const baseURL = `https://sheets.googleapis.com/v4/spreadsheets/${sheetID}/values`; async function fetchAccessToken() { const response = await fetch( `https://api.pipedream.com/v1/accounts/${accountID}?include_credentials=1`, { headers: { Authorization: `Bearer ${Deno.env.get(\"pipedream_api_key\")}`, }, } ); if (!response.ok) { throw new Error(`Error fetching access token: ${response.statusText}`); } const { data } = await response.json(); return data.credentials.oauth_access_token; } async function makeSheetsRequest(url, method, body = null) { const accessToken = await fetchAccessToken(); const options: RequestInit = { method, headers: { Authorization: `Bearer ${accessToken}`, }, }; if (body) { options.body = JSON.stringify(body); } return fetchJSON(url, options); } // Write data to a sheet. await makeSheetsRequest( `${baseURL}/A1:C1:append?valueInputOption=RAW`, \"POST\", { values: [[Date(), Math.random(), 1]] } ); // Read data from a sheet. const data = await makeSheetsRequest( `${baseURL}/A1:C1?majorDimension=ROWS`, \"GET\". ); console.log(data.values[0]); Use your own Google Cloud service account. Section titled “Use your own Google Cloud service account” Authenticating with the Google Sheets API is a bit tricky, but we walk you through it below. It should only take a few minutes, and only needs to be done once. Google recommends OAuth2 server to server authentication for bot-based applications. We will walk you through creating a Google Cloud service account, giving it access to one of your Google Sheets, and using its key to make authenticated requests to the Google Sheets API. 1. Create a Google Cloud service account. Section titled “1. Create a Google Cloud service account” Creating a Google Cloud service account is the recommended way to authenticate to the Google Sheets API. a. Create a Google Cloud project. Section titled “a. Create a Google Cloud project” Open the Google Cloud console and click on the Select a project dropdown in the top left. In the dialog that pops up, click on the New project button. Choose any name for the project name, then click Create. b. Enable the Google Sheets API. Section titled “b. Enable the Google Sheets API” Open the Google Sheets API page, then double check if the correct project is selected. Once you have made sure that you are using the correct project, click Enable. c. Create a service account. Section titled “c. Create a service account” On the left of the screen, click on Credentials. On the bar at the top, click on the Create credentials button, then select Service account. Enter any name for the Service account name. You may also enter a description, as you see fit. Save the email address for later, as it will be required to add the service account to a Google Sheet. Click Done, as granting permissions to this service account is not required. d. Create a service account key. Section titled “d. Create a service account key” To the right of the screen, open the menu on the newly created service account, and click Manage keys. Click Add key, then Create new key. Click Create key. Leave the type as JSON. You will get a JSON file in your downloads directory. e. Import the key into Val Town. Section titled “e. Import the key into Val Town” Open the service account key JSON file in a text editor, and copy the full contents. Open the Environment Variables page, then click New env variable. Set the key to a name like google_service_account, then paste the entire JSON data into the value. Once you are finished, click Add. 2. Create a sheet and grant access. Section titled “2. Create a sheet and grant access” Open Google Sheets and create a new empty sheet or open an existing one. Click the Share button, then paste your service account’s email into the dialog. Make sure it is added as an editor, and optionally disable “Notify people”. Lastly, copy the sheet ID from the URL bar. It’s the long string of characters between /d/ and /edit. 3. Create a val to send data. Section titled “3. Create a val to send data” To interact with the Google Sheets API, use the @mattx.gsheet_call wrapper. This automates requesting an access token from Google to access the Google Sheets API. It requires 4 arguments: The contents of your service account JSON file: in almost all cases, this should be retrieved from environment variables using - for example, Deno.env.get(\"google_service_account\"). The sheet ID. The action to perform: This parameter is the part of the URL that comes after https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/, along with any URL parameters that might be required (often this is valueInputOption). For example, for spreadsheets.values.append, this will be values/{range}:append?valueInputOption=RAW, where {range} needs to be substituted for a range like A1:C3. You can find a list of available actions in the Google Sheets API reference. The request body: In the same example as above, the request body could be {values: [[1, 2, 3]]}. Notice that this is an array of arrays, in line with the API documentation. Here is an example of what the above looks like when put together: ExampleRun in Val Town ↗ import { gsheet_call } from \"https://esm.town/v/mattx/gsheet_call\"; // Appending to a sheet. await gsheet_call( Deno.env.get(\"google_sa\"), \"1LDgOhO6Fxg2wt5rGFH29t6XYbmKe6fXI7fLSFaqZkDA\", \"POST\", \"values/A1:C1:append?valueInputOption=RAW\", { values: [[Date(), Math.random(), 1]] } ); // Reading from the top of the sheet. const data = await gsheet_call( Deno.env.get(\"google_sa\"), \"1LDgOhO6Fxg2wt5rGFH29t6XYbmKe6fXI7fLSFaqZkDA\", \"GET\", \"values/A1:C1?majorDimension=ROWS\", {} ); console.log(data[\"values\"][0]);",1360,{"_364":365,"_366":367,"_298":368},"image","/_astro/pipedream-api-key.BzovfhSL_ZCJnN9.webp","image_alt","API Key","Store data in a Google Sheet",[370,371,374,379,383,387,391,395,399,403,407,412,416,420,424,428,432],{"_303":304,"_104":305,"_306":368,"_307":32},{"_303":309,"_104":372,"_306":373,"_307":177},"use-pipedreams-accounts-api","Use Pipedream’s Accounts API",{"_303":375,"_104":376,"_306":377,"_307":378},"h3","1-sign-up-for-pipedream-and-retrieve-your-api-key","1. Sign up for Pipedream and retrieve your API key",208,{"_303":375,"_104":380,"_306":381,"_307":382},"2-add-that-key-as-a-val-town-environment-variable","2. Add that key as a Val Town environment variable",267,{"_303":375,"_104":384,"_306":385,"_307":386},"3-connect-your-google-sheets-account-in-pipedream","3. Connect your Google Sheets account in Pipedream",309,{"_303":375,"_104":388,"_306":389,"_307":390},"4-copy-the-account-id","4. Copy the account ID",367,{"_303":375,"_104":392,"_306":393,"_307":394},"5-note-your-sheet-id","5. Note your sheet ID",406,{"_303":375,"_104":396,"_306":397,"_307":398},"6-fetch-a-google-sheets-access-token-and-use-it-in-your-val","6. Fetch a Google Sheets access token and use it in your val",444,{"_303":309,"_104":400,"_306":401,"_307":402},"use-your-own-google-cloud-service-account","Use your own Google Cloud service account",628,{"_303":375,"_104":404,"_306":405,"_307":406},"1-create-a-google-cloud-service-account","1. Create a Google Cloud service account",718,{"_303":408,"_104":409,"_306":410,"_307":411},"h4","a-create-a-google-cloud-project","a. Create a Google Cloud project",751,{"_303":408,"_104":413,"_306":414,"_307":415},"b-enable-the-google-sheets-api","b. Enable the Google Sheets API",804,{"_303":408,"_104":417,"_306":418,"_307":419},"c-create-a-service-account","c. Create a service account",847,{"_303":408,"_104":421,"_306":422,"_307":423},"d-create-a-service-account-key","d. Create a service account key",934,{"_303":408,"_104":425,"_306":426,"_307":427},"e-import-the-key-into-val-town","e. Import the key into Val Town",992,{"_303":375,"_104":429,"_306":430,"_307":431},"2-create-a-sheet-and-grant-access","2. Create a sheet and grant access",1057,{"_303":375,"_104":433,"_306":434,"_307":435},"3-create-a-val-to-send-data","3. Create a val to send data",1132,[437,438,440,442,444,446,448,450,452,454,456,460,462,464,466,468,470,472,474,476,478,480,482,484,487,489,491,493,495,497,499,501,503,505,507,509,511,513,515,517,519,521,523,525,527],{"_315":316,"_317":318,"_307":288},{"_315":145,"_317":320,"_307":439},42,{"_315":145,"_317":320,"_307":441},58,{"_315":145,"_317":320,"_307":443},77,{"_315":145,"_317":320,"_307":445},103,{"_315":145,"_317":320,"_307":447},113,{"_315":145,"_317":320,"_307":449},136,{"_315":145,"_317":320,"_307":451},142,{"_315":145,"_317":320,"_307":453},161,{"_315":145,"_317":320,"_307":455},190,{"_315":457,"_317":458,"_307":459},5,7329.3047,272,{"_315":145,"_317":320,"_307":461},284,{"_315":457,"_317":458,"_307":463},446,{"_315":145,"_317":320,"_307":465},461,{"_315":145,"_317":320,"_307":467},476,{"_315":145,"_317":320,"_307":469},600,{"_315":145,"_317":320,"_307":471},617,{"_315":145,"_317":320,"_307":473},651,{"_315":145,"_317":320,"_307":475},665,{"_315":145,"_317":320,"_307":477},691,{"_315":457,"_317":458,"_307":479},720,{"_315":145,"_317":320,"_307":481},729,{"_315":145,"_317":320,"_307":483},735,{"_315":485,"_317":486,"_307":411},4,4690.755,{"_315":485,"_317":486,"_307":488},753,{"_315":145,"_317":320,"_307":490},759,{"_315":145,"_317":320,"_307":492},761,{"_315":145,"_317":320,"_307":494},775,{"_315":485,"_317":486,"_307":496},849,{"_315":145,"_317":320,"_307":498},856,{"_315":145,"_317":320,"_307":500},896,{"_315":145,"_317":320,"_307":502},919,{"_315":485,"_317":486,"_307":504},936,{"_315":145,"_317":320,"_307":506},944,{"_315":145,"_317":320,"_307":508},985,{"_315":145,"_317":320,"_307":510},1016,{"_315":145,"_317":320,"_307":512},1038,{"_315":457,"_317":458,"_307":514},1059,{"_315":145,"_317":320,"_307":516},1068,{"_315":145,"_317":320,"_307":518},1078,{"_315":457,"_317":458,"_307":520},1134,{"_315":145,"_317":320,"_307":522},1143,{"_315":145,"_317":320,"_307":524},1248,{"_315":145,"_317":320,"_307":526},1255,{"_315":145,"_317":320,"_307":528},1325,[288,439,441,443,445,447,449,451,453,455,459,461,463,465,467,469,471,473,475,477,479,481,483,411,488,490,492,494,496,498,500,502,504,506,508,510,512,514,516,518,520,522,524,526,528],"Store data in a Google Sheet. Copy page Copy page. Copy this page as Markdown for LLMs. View as Markdown View this page as plain text. Open in ChatGPT Ask questions about this page. You can send data to Google Sheets from a val. You can collect data from incoming HTTP requests or from an HTTP endpoint on a schedule. You have two options for authenticating with the Google Sheets API: Use Pipedream’s Accounts API to fetch a fresh OAuth access token at runtime. Use your own Google Cloud service account. Use Pipedream’s Accounts API. Section titled “Use Pipedream’s Accounts API” Pipedream provides a workflow automation product for developers. Workflows are built as a sequence of steps — pre-built actions for thousands of APIs or custom code — triggered by an event (HTTP request, timer, when a new row is added to a Google Sheets, and more). Pipedream also manages the OAuth token refresh process for apps like Google Sheets, exposing a fresh access token in the workflow runtime and the Accounts API. If you connect your Google Sheets account to Pipedream, you can use the Accounts API to fetch a fresh token within your val and use that token to authenticate requests to the Google Sheets API. 1. Sign up for Pipedream and retrieve your API key. Section titled “1. Sign up for Pipedream and retrieve your API key” Sign up for Pipedream and visit https://pipedream.com/settings/user. Find the API Key section and copy your key: You’ll use this key to authenticate requests to the Accounts API, letting you fetch Google Sheets access tokens in your val. 2. Add that key as a Val Town environment variable. Section titled “2. Add that key as a Val Town environment variable” Add the API key as an environment variable in Val Town. In this example, we’ve named the environment variable pipedream_api_key: 3. Connect your Google Sheets account in Pipedream. Section titled “3. Connect your Google Sheets account in Pipedream” Visit https://pipedream.com/accounts. Click the Connect an app button at the top-right: You’ll be directed through the OAuth authorization process to connect your Google Sheets account to Pipedream. Once you’ve connected your account, you’ll see it listed on the Accounts page. 4. Copy the account ID. Section titled “4. Copy the account ID” Click the … to the right of the account and Copy Account ID: All account IDs are prefixed with apn_, so yours should look something like apn_abc123. 5. Note your sheet ID. Section titled “5. Note your sheet ID” In the Google Sheet you’d like to access, copy the sheet ID from the URL bar. It’s the long string of characters between /d/ and /edit. 6. Fetch a Google Sheets access token and use it in your val. Section titled “6. Fetch a Google Sheets access token and use it in your val” In your val, fetch a fresh Google Sheets access token from Pipedream and use it to authenticate requests: ExampleRun in Val Town ↗ import { fetchJSON } from \"https://esm.town/v/stevekrouse/fetchJSON?v=41\"; const accountID = \"<YOUR ACCOUNT ID HERE>\"; const sheetID = \"<YOUR SHEET ID HERE>\"; const baseURL = `https://sheets.googleapis.com/v4/spreadsheets/${sheetID}/values`; async function fetchAccessToken() { const response = await fetch( `https://api.pipedream.com/v1/accounts/${accountID}?include_credentials=1`, { headers: { Authorization: `Bearer ${Deno.env.get(\"pipedream_api_key\")}`, }, } ); if (!response.ok) { throw new Error(`Error fetching access token: ${response.statusText}`); } const { data } = await response.json(); return data.credentials.oauth_access_token; } async function makeSheetsRequest(url, method, body = null) { const accessToken = await fetchAccessToken(); const options: RequestInit = { method, headers: { Authorization: `Bearer ${accessToken}`, }, }; if (body) { options.body = JSON.stringify(body); } return fetchJSON(url, options); } // Write data to a sheet. await makeSheetsRequest( `${baseURL}/A1:C1:append?valueInputOption=RAW`, \"POST\", { values: [[Date(), Math.random(), 1]] } ); // Read data from a sheet. const data = await makeSheetsRequest( `${baseURL}/A1:C1?majorDimension=ROWS`, \"GET\". ); console.log(data.values[0]); Use your own Google Cloud service account. Section titled “Use your own Google Cloud service account” Authenticating with the Google Sheets API is a bit tricky, but we walk you through it below. It should only take a few minutes, and only needs to be done once. Google recommends OAuth2 server to server authentication for bot-based applications. We will walk you through creating a Google Cloud service account, giving it access to one of your Google Sheets, and using its key to make authenticated requests to the Google Sheets API. 1. Create a Google Cloud service account. Section titled “1. Create a Google Cloud service account” Creating a Google Cloud service account is the recommended way to authenticate to the Google Sheets API. a. Create a Google Cloud project. Section titled “a. Create a Google Cloud project” Open the Google Cloud console and click on the Select a project dropdown in the top left. In the dialog that pops up, click on the New project button. Choose any name for the project name, then click Create. b. Enable the Google Sheets API. Section titled “b. Enable the Google Sheets API” Open the Google Sheets API page, then double check if the correct project is selected. Once you have made sure that you are using the correct project, click Enable. c. Create a service account. Section titled “c. Create a service account” On the left of the screen, click on Credentials. On the bar at the top, click on the Create credentials button, then select Service account. Enter any name for the Service account name. You may also enter a description, as you see fit. Save the email address for later, as it will be required to add the service account to a Google Sheet. Click Done, as granting permissions to this service account is not required. d. Create a service account key. Section titled “d. Create a service account key” To the right of the screen, open the menu on the newly created service account, and click Manage keys. Click Add key, then Create new key. Click Create key. Leave the type as JSON. You will get a JSON file in your downloads directory. e. Import the key into Val Town. Section titled “e. Import the key into Val Town” Open the service account key JSON file in a text editor, and copy the full contents. Open the Environment Variables page, then click New env variable. Set the key to a name like google_service_account, then paste the entire JSON data into the value. Once you are finished, click Add. 2. Create a sheet and grant access. Section titled “2. Create a sheet and grant access” Open Google Sheets and create a new empty sheet or open an existing one. Click the Share button, then paste your service account’s email into the dialog. Make sure it is added as an editor, and optionally disable “Notify people”. Lastly, copy the sheet ID from the URL bar. It’s the long string of characters between /d/ and /edit. 3. Create a val to send data. Section titled “3. Create a val to send data” To interact with the Google Sheets API, use the @mattx.gsheet_call wrapper. This automates requesting an access token from Google to access the Google Sheets API. It requires 4 arguments: The contents of your service account JSON file: in almost all cases, this should be retrieved from environment variables using - for example, Deno.env.get(\"google_service_account\"). The sheet ID. The action to perform: This parameter is the part of the URL that comes after https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/, along with any URL parameters that might be required (often this is valueInputOption). For example, for spreadsheets.values.append, this will be values/{range}:append?valueInputOption=RAW, where {range} needs to be substituted for a range like A1:C3. You can find a list of available actions in the Google Sheets API reference. The request body: In the same example as above, the request body could be {values: [[1, 2, 3]]}. Notice that this is an array of arrays, in line with the API documentation. Here is an example of what the above looks like when put together: ExampleRun in Val Town ↗ import { gsheet_call } from \"https://esm.town/v/mattx/gsheet_call\"; // Appending to a sheet. await gsheet_call( Deno.env.get(\"google_sa\"), \"1LDgOhO6Fxg2wt5rGFH29t6XYbmKe6fXI7fLSFaqZkDA\", \"POST\", \"values/A1:C1:append?valueInputOption=RAW\", { values: [[Date(), Math.random(), 1]] } ); // Reading from the top of the sheet. const data = await gsheet_call( Deno.env.get(\"google_sa\"), \"1LDgOhO6Fxg2wt5rGFH29t6XYbmKe6fXI7fLSFaqZkDA\", \"GET\", \"values/A1:C1?majorDimension=ROWS\", {} ); console.log(data[\"values\"][0]);","/guides/google-sheets/","data in a Google Sheet. Copy page Copy page. Copy this page as Markdown for LLMs. View as Markdown View this page as plain text. Open in ChatGPT Ask questions",[534,543,555,563,574,583,592,603,613,622,630,639],{"_298":368,"_106":535,"_343":536,"_312":537,"_332":542,"_337":532},"https://docs.val.town/guides/google-sheets/#_top",{"_303":304,"_104":305,"_306":368,"_307":32},[538,539,540,541],{"_315":316,"_317":318,"_307":288},{"_315":145,"_317":320,"_307":439},{"_315":145,"_317":320,"_307":441},{"_315":145,"_317":320,"_307":443},[288,439,441,443],{"_298":373,"_106":544,"_343":545,"_312":546,"_332":553,"_337":554},"https://docs.val.town/guides/google-sheets/#use-pipedreams-accounts-api",{"_303":309,"_104":372,"_306":373,"_307":177},[547,548,549,550,551,552],{"_315":145,"_317":320,"_307":445},{"_315":145,"_317":320,"_307":447},{"_315":145,"_317":320,"_307":449},{"_315":145,"_317":320,"_307":451},{"_315":145,"_317":320,"_307":453},{"_315":145,"_317":320,"_307":455},[445,447,449,451,453,455],"as a sequence of steps — pre-built actions for thousands of APIs or custom code — triggered by an event (HTTP request, timer, when a new row is added to",{"_298":381,"_106":556,"_343":557,"_312":558,"_332":561,"_337":562},"https://docs.val.town/guides/google-sheets/#2-add-that-key-as-a-val-town-environment-variable",{"_303":375,"_104":380,"_306":381,"_307":382},[559,560],{"_315":457,"_317":458,"_307":459},{"_315":145,"_317":320,"_307":461},[459,461],"2. Add that key as a Val Town environment variable. Section titled “2. Add that key as a Val Town environment variable” Add the API key as an environment variable",{"_298":397,"_106":564,"_343":565,"_312":566,"_332":572,"_337":573},"https://docs.val.town/guides/google-sheets/#6-fetch-a-google-sheets-access-token-and-use-it-in-your-val",{"_303":375,"_104":396,"_306":397,"_307":398},[567,568,569,570,571],{"_315":457,"_317":458,"_307":463},{"_315":145,"_317":320,"_307":465},{"_315":145,"_317":320,"_307":467},{"_315":145,"_317":320,"_307":469},{"_315":145,"_317":320,"_307":471},[463,465,467,469,471],"Fetch a Google Sheets access token and use it in your val. Section titled “6. Fetch a Google Sheets access token and use it in your val” In your val,",{"_298":401,"_106":575,"_343":576,"_312":577,"_332":581,"_337":582},"https://docs.val.town/guides/google-sheets/#use-your-own-google-cloud-service-account",{"_303":309,"_104":400,"_306":401,"_307":402},[578,579,580],{"_315":145,"_317":320,"_307":473},{"_315":145,"_317":320,"_307":475},{"_315":145,"_317":320,"_307":477},[473,475,477],"account” Authenticating with the Google Sheets API is a bit tricky, but we walk you through it below. It should only take a few minutes, and only needs to be",{"_298":405,"_106":584,"_343":585,"_312":586,"_332":590,"_337":591},"https://docs.val.town/guides/google-sheets/#1-create-a-google-cloud-service-account",{"_303":375,"_104":404,"_306":405,"_307":406},[587,588,589],{"_315":457,"_317":458,"_307":479},{"_315":145,"_317":320,"_307":481},{"_315":145,"_317":320,"_307":483},[479,481,483],"1. Create a Google Cloud service account. Section titled “1. Create a Google Cloud service account” Creating a Google Cloud service account is the recommended way to authenticate to the",{"_298":410,"_106":593,"_343":594,"_312":595,"_332":601,"_337":602},"https://docs.val.town/guides/google-sheets/#a-create-a-google-cloud-project",{"_303":408,"_104":409,"_306":410,"_307":411},[596,597,598,599,600],{"_315":485,"_317":486,"_307":411},{"_315":485,"_317":486,"_307":488},{"_315":145,"_317":320,"_307":490},{"_315":145,"_317":320,"_307":492},{"_315":145,"_317":320,"_307":494},[411,488,490,492,494],"a. Create a Google Cloud project. Section titled “a. Create a Google Cloud project” Open the Google Cloud console and click on the Select a project dropdown in the top",{"_298":418,"_106":604,"_343":605,"_312":606,"_332":611,"_337":612},"https://docs.val.town/guides/google-sheets/#c-create-a-service-account",{"_303":408,"_104":417,"_306":418,"_307":419},[607,608,609,610],{"_315":485,"_317":486,"_307":496},{"_315":145,"_317":320,"_307":498},{"_315":145,"_317":320,"_307":500},{"_315":145,"_317":320,"_307":502},[496,498,500,502],"Create a service account. Section titled “c. Create a service account” On the left of the screen, click on Credentials. On the bar at the top, click on the Create",{"_298":422,"_106":614,"_343":615,"_312":616,"_332":620,"_337":621},"https://docs.val.town/guides/google-sheets/#d-create-a-service-account-key",{"_303":408,"_104":421,"_306":422,"_307":423},[617,618,619],{"_315":485,"_317":486,"_307":504},{"_315":145,"_317":320,"_307":506},{"_315":145,"_317":320,"_307":508},[504,506,508],"Create a service account key. Section titled “d. Create a service account key” To the right of the screen, open the menu on the newly created service account, and click",{"_298":426,"_106":623,"_343":624,"_312":625,"_332":628,"_337":629},"https://docs.val.town/guides/google-sheets/#e-import-the-key-into-val-town",{"_303":408,"_104":425,"_306":426,"_307":427},[626,627],{"_315":145,"_317":320,"_307":510},{"_315":145,"_317":320,"_307":512},[510,512],"key JSON file in a text editor, and copy the full contents. Open the Environment Variables page, then click New env variable. Set the key to a name like google_service_account,",{"_298":430,"_106":631,"_343":632,"_312":633,"_332":637,"_337":638},"https://docs.val.town/guides/google-sheets/#2-create-a-sheet-and-grant-access",{"_303":375,"_104":429,"_306":430,"_307":431},[634,635,636],{"_315":457,"_317":458,"_307":514},{"_315":145,"_317":320,"_307":516},{"_315":145,"_317":320,"_307":518},[514,516,518],"2. Create a sheet and grant access. Section titled “2. Create a sheet and grant access” Open Google Sheets and create a new empty sheet or open an existing one.",{"_298":434,"_106":640,"_343":641,"_312":642,"_332":648,"_337":649},"https://docs.val.town/guides/google-sheets/#3-create-a-val-to-send-data",{"_303":375,"_104":433,"_306":434,"_307":435},[643,644,645,646,647],{"_315":457,"_317":458,"_307":520},{"_315":145,"_317":320,"_307":522},{"_315":145,"_317":320,"_307":524},{"_315":145,"_317":320,"_307":526},{"_315":145,"_317":320,"_307":528},[520,522,524,526,528],"Create a val to send data. Section titled “3. Create a val to send data” To interact with the Google Sheets API, use the @mattx.gsheet_call wrapper. This automates requesting an",{"_106":651,"_112":652,"_294":653,"_296":654,"_300":656,"_312":673,"_332":709,"_334":710,"_335":711,"_337":712,"_339":713},"https://docs.val.town/guides/save-html-form-data/","Save HTML form data. Copy page Copy page. Copy this page as Markdown for LLMs. View as Markdown View this page as plain text. Open in ChatGPT Ask questions about this page. You can submit forms to Val Town using an HTTP trigger. You can place these forms on any page on the internet - or host the form directly on Val Town. These examples show how to accept and store email addresses on Val Town. The email addresses are saved into a val, and you also get sent an email notification for each new signup. Add a form to your website. Section titled “Add a form to your website” Create an HTTP trigger. Section titled “Create an HTTP trigger” Write a val function that accepts a Request and returns a Response. Add the form to your webpage. Section titled “Add the form to your webpage” Copy your val’s Web endpoint URL using the menu (Endpoints > Copy web endpoint) and set it as the form’s action (this tells the form where to send its data when it’s submitted). Below is a full HTML page example. If you are adding a form to an existing page just copy and paste the block. Email Form Host your form on Val Town. Section titled “Host your form on Val Town” There are two ways to do this. You can write a val function that serves a webpage, and a separate val that accepts the form data - or you can write a single val that does both like the example below. When a form is submitted, it sends a HTTP request with the POST method. When a user visits a webpage in their web browser, the server (your val function) gets sent a GET request. You can check the HTTP method using req.method and change how your val function responds. See Web forms — Working with user data on the MDN Web Docs site for more help with forms. Forms are a basic part of the web - you don’t need a lot of front-end JavaScript to make them work.",386,{"_298":655},"Save HTML form data",[657,658,662,665,669],{"_303":304,"_104":305,"_306":655,"_307":32},{"_303":309,"_104":659,"_306":660,"_307":661},"add-a-form-to-your-website","Add a form to your website",96,{"_303":375,"_104":663,"_306":664,"_307":311},"create-an-http-trigger","Create an HTTP trigger",{"_303":375,"_104":666,"_306":667,"_307":668},"add-the-form-to-your-webpage","Add the form to your webpage",132,{"_303":309,"_104":670,"_306":671,"_307":672},"host-your-form-on-val-town","Host your form on Val Town",242,[674,676,677,679,681,683,685,687,688,690,692,694,696,698,700,702,704,706,707],{"_315":145,"_317":320,"_307":675},82,{"_315":327,"_317":328,"_307":325},{"_315":145,"_317":320,"_307":678},105,{"_315":145,"_317":320,"_307":680},121,{"_315":145,"_317":320,"_307":682},126,{"_315":145,"_317":320,"_307":684},130,{"_315":145,"_317":320,"_307":686},181,{"_315":145,"_317":320,"_307":455},{"_315":145,"_317":320,"_307":689},266,{"_315":145,"_317":320,"_307":691},271,{"_315":145,"_317":320,"_307":693},274,{"_315":145,"_317":320,"_307":695},287,{"_315":145,"_317":320,"_307":697},298,{"_315":145,"_317":320,"_307":699},304,{"_315":145,"_317":320,"_307":701},312,{"_315":145,"_317":320,"_307":703},315,{"_315":145,"_317":320,"_307":705},328,{"_315":145,"_317":320,"_307":390},{"_315":145,"_317":320,"_307":708},377,[675,325,678,680,682,684,686,455,689,691,693,695,697,699,701,703,705,390,708],"Save HTML form data. Copy page Copy page. Copy this page as Markdown for LLMs. View as Markdown View this page as plain text. Open in ChatGPT Ask questions about this page. You can submit forms to Val Town using an HTTP trigger. You can place these forms on any page on the internet - or host the form directly on Val Town. These examples show how to accept and store email addresses on Val Town. The email addresses are saved into a val, and you also get sent an email notification for each new signup. Add a form to your website. Section titled “Add a form to your website” Create an HTTP trigger. Section titled “Create an HTTP trigger” Write a val function that accepts a Request and returns a Response. Add the form to your webpage. Section titled “Add the form to your webpage” Copy your val’s Web endpoint URL using the menu (Endpoints > Copy web endpoint) and set it as the form’s action (this tells the form where to send its data when it’s submitted). Below is a full HTML page example. If you are adding a form to an existing page just copy and paste the <form></form> block. <!DOCTYPE html> <html> <head> <title>Email Form</title> </head> <body>  <form action=\"https://user-saveFormData.web.val.run\" method=\"post\"> <label for=\"email\">Email:</label> <input type=\"email\" id=\"email\" name=\"email\" required /> <br /> <input type=\"submit\" value=\"Submit\" /> </form> </body> </html> Host your form on Val Town. Section titled “Host your form on Val Town” There are two ways to do this. You can write a val function that serves a webpage, and a separate val that accepts the form data - or you can write a single val that does both like the example below. When a form is submitted, it sends a HTTP request with the POST method. When a user visits a webpage in their web browser, the server (your val function) gets sent a GET request. You can check the HTTP method using req.method and change how your val function responds. See Web forms — Working with user data on the MDN Web Docs site for more help with forms. Forms are a basic part of the web - you don’t need a lot of front-end JavaScript to make them work.","/guides/save-html-form-data/","Add a form to your website. Section titled “Add a form to your website” Create an HTTP trigger. Section titled “Create an HTTP trigger” Write a val function that accepts",[714,721,729,738,746],{"_298":655,"_106":715,"_343":716,"_312":717,"_332":719,"_337":720},"https://docs.val.town/guides/save-html-form-data/#_top",{"_303":304,"_104":305,"_306":655,"_307":32},[718],{"_315":145,"_317":320,"_307":675},[675],"to accept and store email addresses on Val Town. The email addresses are saved into a val, and you also get sent an email notification for each new signup.",{"_298":660,"_106":722,"_343":723,"_312":724,"_332":727,"_337":728},"https://docs.val.town/guides/save-html-form-data/#add-a-form-to-your-website",{"_303":309,"_104":659,"_306":660,"_307":661},[725,726],{"_315":327,"_317":328,"_307":325},{"_315":145,"_317":320,"_307":678},[325,678],"Add a form to your website. Section titled “Add a form to your website”",{"_298":664,"_106":730,"_343":731,"_312":732,"_332":736,"_337":737},"https://docs.val.town/guides/save-html-form-data/#create-an-http-trigger",{"_303":375,"_104":663,"_306":664,"_307":311},[733,734,735],{"_315":145,"_317":320,"_307":680},{"_315":145,"_317":320,"_307":682},{"_315":145,"_317":320,"_307":684},[680,682,684],"Create an HTTP trigger. Section titled “Create an HTTP trigger” Write a val function that accepts a Request and returns a Response.",{"_298":667,"_106":739,"_343":740,"_312":741,"_332":744,"_337":745},"https://docs.val.town/guides/save-html-form-data/#add-the-form-to-your-webpage",{"_303":375,"_104":666,"_306":667,"_307":668},[742,743],{"_315":145,"_317":320,"_307":686},{"_315":145,"_317":320,"_307":455},[686,455],"form where to send its data when it’s submitted). Below is a full HTML page example. If you are adding a form to an existing page just copy and paste",{"_298":671,"_106":747,"_343":748,"_312":749,"_332":761,"_337":762},"https://docs.val.town/guides/save-html-form-data/#host-your-form-on-val-town",{"_303":309,"_104":670,"_306":671,"_307":672},[750,751,752,753,754,755,756,757,758,759,760],{"_315":145,"_317":320,"_307":689},{"_315":145,"_317":320,"_307":691},{"_315":145,"_317":320,"_307":693},{"_315":145,"_317":320,"_307":695},{"_315":145,"_317":320,"_307":697},{"_315":145,"_317":320,"_307":699},{"_315":145,"_317":320,"_307":701},{"_315":145,"_317":320,"_307":703},{"_315":145,"_317":320,"_307":705},{"_315":145,"_317":320,"_307":390},{"_315":145,"_317":320,"_307":708},[689,691,693,695,697,699,701,703,705,390,708],"write a single val that does both like the example below. When a form is submitted, it sends a HTTP request with the POST method. When a user visits a",{"_106":764,"_112":765,"_294":766,"_296":767,"_300":771,"_312":805,"_332":839,"_334":765,"_335":840,"_337":841,"_339":842},"https://docs.val.town/guides/discord/bot/","Discord welcome bot. Copy page Copy page. Copy this page as Markdown for LLMs. View as Markdown View this page as plain text. Open in ChatGPT Ask questions about this page. You can create a Discord welcome bot using scheduled vals. In this example, a scheduled val gets the most recent members for your server and sends a DM to new users from a bot that you’ll create. It avoids messaging users who joined the server before the bot was added. When users reply to the bot, the message is forwarded as a DM. Create a new Discord application. Section titled “Create a new Discord application” Visit https://discord.com/developers/applications: Enable the server members intent. Section titled “Enable the server members intent” Since the bot will be requesting a list of guild members, you need to enable the SERVER MEMBERS INTENT on the Bot tab. Get your bot’s token. Section titled “Get your bot’s token” On the Bot tab, copy the TOKEN, and save it as a Val Town environment variable as discordBot. Create a link via the URL Generator. Section titled “Create a link via the URL Generator” On the OAuth2 tab, under URL Generator, select the bot scope, and give it permission to Send Messages, and then copy the GENERATED URL at the bottom of the page. Click on the generated link. Section titled “Click on the generated link” Choose the server you want to invite the bot to and press Continue. Get your Server ID. Section titled “Get your Server ID” Save your server id as a Val Town environment variable as discordServerId. (See: Where can I find my User/Server/Message ID?). Setup your welcome message scheduled val. Section titled “Setup your welcome message scheduled val” Remix this scheduled val that will send a welcome message to new users. This val stores state in three other vals. @me.discordWelcomeBotStartedAt stores the timestamp of the bot’s creation so that everyone who’s already on the server doesn’t get a welcome message when the bot is added. @me.discordWelcomedMembers stores the ids of everyone that has been messaged so that they don’t receive another message. @me.discordDMs stores the channel ids (each time the bot DMs a user it creates a channel) so that we can check for replies to the bot. These vals will be automatically created if they don’t already exist. Get your User ID. Section titled “Get your User ID” Save your user id as a Val Town environment variable as discordUserId. (See: Where can I find my User/Server/Message ID?). This is so the bot knows where to forward user replies. Set up your message forwarder scheduled val. Section titled “Set up your message forwarder scheduled val” Remix this scheduled val that will forward user replies to your Discord user. This val loops through all of the DMs between the bot and new users. It checks for any new replies and then forwards these messages as a new DM (from the bot, to your Discord user).",493,{"_364":768,"_366":769,"_298":770},"/_astro/create-an-app.CJ6V-7L5_Z5IxEi.webp","create-an-app.png","Discord welcome bot",[772,773,776,780,784,788,791,794,797,801],{"_303":304,"_104":305,"_306":770,"_307":32},{"_303":309,"_104":774,"_306":775,"_307":186},"create-a-new-discord-application","Create a new Discord application",{"_303":309,"_104":777,"_306":778,"_307":779},"enable-the-server-members-intent","Enable the server members intent",108,{"_303":309,"_104":781,"_306":782,"_307":783},"get-your-bots-token","Get your bot’s token",143,{"_303":309,"_104":785,"_306":786,"_307":787},"create-a-link-via-the-url-generator","Create a link via the URL Generator",171,{"_303":309,"_104":789,"_306":790,"_307":212},"click-on-the-generated-link","Click on the generated link",{"_303":309,"_104":792,"_306":793,"_307":672},"get-your-server-id","Get your Server ID",{"_303":309,"_104":795,"_306":796,"_307":459},"setup-your-welcome-message-scheduled-val","Setup your welcome message scheduled val",{"_303":309,"_104":798,"_306":799,"_307":800},"get-your-user-id","Get your User ID",387,{"_303":309,"_104":802,"_306":803,"_307":804},"set-up-your-message-forwarder-scheduled-val","Set up your message forwarder scheduled val",428,[806,808,810,812,814,815,817,819,820,822,824,825,827,829,831,833,835,837],{"_315":145,"_317":320,"_307":807},34,{"_315":145,"_317":320,"_307":809},44,{"_315":145,"_317":320,"_307":811},57,{"_315":145,"_317":320,"_307":813},63,{"_315":145,"_317":320,"_307":180},{"_315":327,"_317":328,"_307":816},95,{"_315":145,"_317":320,"_307":818},102,{"_315":145,"_317":320,"_307":682},{"_315":145,"_317":320,"_307":821},164,{"_315":327,"_317":328,"_307":823},172,{"_315":145,"_317":320,"_307":686},{"_315":145,"_317":320,"_307":826},257,{"_315":145,"_317":320,"_307":828},293,{"_315":145,"_317":320,"_307":830},325,{"_315":145,"_317":320,"_307":832},360,{"_315":145,"_317":320,"_307":834},364,{"_315":145,"_317":320,"_307":836},402,{"_315":145,"_317":320,"_307":838},483,[807,809,811,813,180,816,818,682,821,823,686,826,828,830,832,834,836,838],"/guides/discord/bot/","users reply to the bot, the message is forwarded as a DM. Create a new Discord application. Section titled “Create a new Discord application” Visit https://discord.com/developers/applications: Enable the server members",[843,854,862,869,876,884,891,901,908],{"_298":770,"_106":844,"_343":845,"_312":846,"_332":852,"_337":853},"https://docs.val.town/guides/discord/bot/#_top",{"_303":304,"_104":305,"_306":770,"_307":32},[847,848,849,850,851],{"_315":145,"_317":320,"_307":807},{"_315":145,"_317":320,"_307":809},{"_315":145,"_317":320,"_307":811},{"_315":145,"_317":320,"_307":813},{"_315":145,"_317":320,"_307":180},[807,809,811,813,180],"create a Discord welcome bot using scheduled vals. In this example, a scheduled val gets the most recent members for your server and sends a DM to new users from",{"_298":775,"_106":855,"_343":856,"_312":857,"_332":860,"_337":861},"https://docs.val.town/guides/discord/bot/#create-a-new-discord-application",{"_303":309,"_104":774,"_306":775,"_307":186},[858,859],{"_315":327,"_317":328,"_307":816},{"_315":145,"_317":320,"_307":818},[816,818],"Create a new Discord application. Section titled “Create a new Discord application” Visit https://discord.com/developers/applications:",{"_298":778,"_106":863,"_343":864,"_312":865,"_332":867,"_337":868},"https://docs.val.town/guides/discord/bot/#enable-the-server-members-intent",{"_303":309,"_104":777,"_306":778,"_307":779},[866],{"_315":145,"_317":320,"_307":682},[682],"Enable the server members intent. Section titled “Enable the server members intent” Since the bot will be requesting a list of guild members, you need to enable the SERVER MEMBERS",{"_298":782,"_106":870,"_343":871,"_312":872,"_332":874,"_337":875},"https://docs.val.town/guides/discord/bot/#get-your-bots-token",{"_303":309,"_104":781,"_306":782,"_307":783},[873],{"_315":145,"_317":320,"_307":821},[821],"Get your bot’s token. Section titled “Get your bot’s token” On the Bot tab, copy the TOKEN, and save it as a Val Town environment variable as discordBot.",{"_298":786,"_106":877,"_343":878,"_312":879,"_332":882,"_337":883},"https://docs.val.town/guides/discord/bot/#create-a-link-via-the-url-generator",{"_303":309,"_104":785,"_306":786,"_307":787},[880,881],{"_315":327,"_317":328,"_307":823},{"_315":145,"_317":320,"_307":686},[823,686],"Create a link via the URL Generator. Section titled “Create a link via the URL Generator” On the OAuth2 tab, under URL Generator, select the bot scope, and give it",{"_298":793,"_106":885,"_343":886,"_312":887,"_332":889,"_337":890},"https://docs.val.town/guides/discord/bot/#get-your-server-id",{"_303":309,"_104":792,"_306":793,"_307":672},[888],{"_315":145,"_317":320,"_307":826},[826],"Get your Server ID. Section titled “Get your Server ID” Save your server id as a Val Town environment variable as discordServerId. (See: Where can I find my User/Server/Message ID?).",{"_298":796,"_106":892,"_343":893,"_312":894,"_332":899,"_337":900},"https://docs.val.town/guides/discord/bot/#setup-your-welcome-message-scheduled-val",{"_303":309,"_104":795,"_306":796,"_307":459},[895,896,897,898],{"_315":145,"_317":320,"_307":828},{"_315":145,"_317":320,"_307":830},{"_315":145,"_317":320,"_307":832},{"_315":145,"_317":320,"_307":834},[828,830,832,834],"receive another message. @me.discordDMs stores the channel ids (each time the bot DMs a user it creates a channel) so that we can check for replies to the bot. These",{"_298":799,"_106":902,"_343":903,"_312":904,"_332":906,"_337":907},"https://docs.val.town/guides/discord/bot/#get-your-user-id",{"_303":309,"_104":798,"_306":799,"_307":800},[905],{"_315":145,"_317":320,"_307":836},[836],"Get your User ID. Section titled “Get your User ID” Save your user id as a Val Town environment variable as discordUserId. (See: Where can I find my User/Server/Message ID?).",{"_298":803,"_106":909,"_343":910,"_312":911,"_332":913,"_337":914},"https://docs.val.town/guides/discord/bot/#set-up-your-message-forwarder-scheduled-val",{"_303":309,"_104":802,"_306":803,"_307":804},[912],{"_315":145,"_317":320,"_307":838},[838],"the DMs between the bot and new users. It checks for any new replies and then forwards these messages as a new DM (from the bot, to your Discord user).",{"_106":916,"_112":917,"_294":918,"_296":919,"_300":923,"_312":925,"_332":939,"_334":940,"_335":941,"_337":942,"_339":943},"https://docs.val.town/guides/github/get-a-github-user/","Get a Github user. Copy page Copy page. Copy this page as Markdown for LLMs. View as Markdown View this page as plain text. Open in ChatGPT Ask questions about this page. For example, we can get a user without passing an authentication token. GitHub API endpoints have a cURL command that you can manually translate into a fetchJSON call (e.g. see Get a user). Here’s a Val that returns a GitHub user object for a given username: @vtdocs/getGithubUserRun in Val Town ↗ import { fetchJSON } from \"https://esm.town/v/stevekrouse/fetchJSON?v=41\"; export const getGithubUser = async (username: string) => { const user = await fetchJSON( `https://api.github.com/users/${username}`, ); return user; }; You can alter it, or just call it directly like this: Usage of @vtdocs/getGithubUserRun in Val Town ↗ import { getGithubUser } from \"https://esm.town/v/vtdocs/getGithubUser\"; console.log(await getGithubUser(\"stevekrouse\")); You can also do this with octokit.js. Reminder: import npm packages by prepending the package name with npm:. Usage of npm:@octokit/coreRun in Val Town ↗ import { Octokit } from \"npm:@octokit/core\"; export const getGithubUserViaOctokit = async (username: string) => { const octokit = new Octokit(); const user = await octokit.request(\"GET /users/{username}\", { username, headers: { \"X-GitHub-Api-Version\": \"2022-11-28\", }, }); return user; };",196,{"_364":920,"_366":921,"_298":922},"/_astro/screenshot_2023-06-13_at_003949.BqmkiaHv_Z2wFQBF.webp","GitHub API endpoints have a cURL command that you can manually translate into a fetchJSON call (e.g. see Get a user). ","Get a Github user",[924],{"_303":304,"_104":305,"_306":922,"_307":32},[926,927,929,931,932,933,935,937],{"_315":316,"_317":318,"_307":145},{"_315":145,"_317":320,"_307":928},37,{"_315":145,"_317":320,"_307":930},48,{"_315":145,"_317":320,"_307":811},{"_315":145,"_317":320,"_307":813},{"_315":145,"_317":320,"_307":934},66,{"_315":145,"_317":320,"_307":936},70,{"_315":145,"_317":320,"_307":938},75,[145,928,930,811,813,934,936,938],"Get a Github user. Copy page Copy page. Copy this page as Markdown for LLMs. View as Markdown View this page as plain text. Open in ChatGPT Ask questions about this page. For example, we can get a user without passing an authentication token. GitHub API endpoints have a cURL command that you can manually translate into a fetchJSON call (e.g. see Get a user). Here’s a Val that returns a GitHub user object for a given username: @vtdocs/getGithubUserRun in Val Town ↗ import { fetchJSON } from \"https://esm.town/v/stevekrouse/fetchJSON?v=41\"; export const getGithubUser = async (username: string) => { const user = await fetchJSON( `https://api.github.com/users/${username}`, ); return user; }; You can alter it, or just call it directly like this: Usage of @vtdocs/getGithubUserRun in Val Town ↗ import { getGithubUser } from \"https://esm.town/v/vtdocs/getGithubUser\"; console.log(await getGithubUser(\"stevekrouse\")); You can also do this with octokit.js. Reminder: import npm packages by prepending the package name with npm:. Usage of npm:@octokit/coreRun in Val Town ↗ import { Octokit } from \"npm:@octokit/core\"; export const getGithubUserViaOctokit = async (username: string) => { const octokit = new Octokit(); const user = await octokit.request(\"GET /users/{username}\", { username, headers: { \"X-GitHub-Api-Version\": \"2022-11-28\", }, }); return user; };","/guides/github/get-a-github-user/","Get a Github user. Copy page Copy page. Copy this page as Markdown for LLMs. View as Markdown View this page as plain text. Open in ChatGPT Ask questions about",[944],{"_298":922,"_106":945,"_343":946,"_312":947,"_332":956,"_337":942},"https://docs.val.town/guides/github/get-a-github-user/#_top",{"_303":304,"_104":305,"_306":922,"_307":32},[948,949,950,951,952,953,954,955],{"_315":316,"_317":318,"_307":145},{"_315":145,"_317":320,"_307":928},{"_315":145,"_317":320,"_307":930},{"_315":145,"_317":320,"_307":811},{"_315":145,"_317":320,"_307":813},{"_315":145,"_317":320,"_307":934},{"_315":145,"_317":320,"_307":936},{"_315":145,"_317":320,"_307":938},[145,928,930,811,813,934,936,938],{"_106":958,"_112":959,"_294":960,"_296":961,"_300":965,"_312":981,"_332":995,"_334":996,"_335":997,"_337":998,"_339":999},"https://docs.val.town/guides/slack/send-messages-to-slack/","Sending Slack messages. Copy page Copy page. Copy this page as Markdown for LLMs. View as Markdown View this page as plain text. Open in ChatGPT Ask questions about this page. Time to complete: 5 minutes. This guide walks you through sending your first Slack message from Val Town. This guide uses Slack’s incoming webhooks to send messages to a Slack channel. For more complex interactions, like responding to user messages or handling buttons, check out our Slack bot guide. 1. Create a Slack app & webhook. Section titled “1. Create a Slack app & webhook” Click here to create a new Slack app. Click From Scratch. Type an App Name. Select your Slack workspace. Click Incoming Webhooks in the left sidebar of your app (under Features). Toggle Activate Incoming Webhooks to On. Click Add New Webhook at the bottom of the page. Select your target channel. Copy the Webhook URL from Slack. (Bonus) Customize the App icon under Basic Information in the left sidebar (Val Town icons). 2. Add the webhook URL to Val Town. Section titled “2. Add the webhook URL to Val Town” Click Environment Variables in your val’s left sidebar. Add a new env variable with key: SLACK_WEBHOOK_URL. Paste the webhook URL you copied from Slack as the value. 3. Send a message. Section titled “3. Send a message” Now you’re ready to send your first message to Slack! Send messageRun in Val Town ↗ import { IncomingWebhook } from \"npm:@slack/webhook\"; const slack = new IncomingWebhook(Deno.env.get(\"SLACK_WEBHOOK_URL\")); const EDIT = `<${import.meta.url.replace(\"esm\", \"val\")}|(edit val)>`; await slack.send(`🥳 Hi from Val Town! ${EDIT}`); We recommend including this link to the edit val, so everyone on your team is one click away from making changes. What’s next? Section titled “What’s next?” Learn how to make your message fancy with advanced formatting. Take this a step further by responding to mentions, slash commands, buttons, and other user interactions with our full Slack bot guide! You can find more Slack examples on our Templates page.",332,{"_364":962,"_366":963,"_298":964},"/_astro/app.B3GwB_87_Z2inKHC.webp","Create Slack app","Sending Slack messages",[966,967,971,975,978],{"_303":304,"_104":305,"_306":964,"_307":32},{"_303":309,"_104":968,"_306":969,"_307":970},"1-create-a-slack-app--webhook","1. Create a Slack app & webhook",80,{"_303":309,"_104":972,"_306":973,"_307":974},"2-add-the-webhook-url-to-val-town","2. Add the webhook URL to Val Town",168,{"_303":309,"_104":976,"_306":977,"_307":200},"3-send-a-message","3. Send a message",{"_303":309,"_104":979,"_306":980,"_307":461},"whats-next","What’s next?",[982,984,985,986,988,990,991,993],{"_315":145,"_317":320,"_307":983},59,{"_315":327,"_317":328,"_307":675},{"_315":145,"_317":320,"_307":177},{"_315":145,"_317":320,"_307":987},100,{"_315":145,"_317":320,"_307":989},195,{"_315":327,"_317":328,"_307":206},{"_315":145,"_317":320,"_307":992},221,{"_315":145,"_317":320,"_307":994},302,[983,675,177,987,989,206,992,994],"Sending Slack messages. Copy page Copy page. Copy this page as Markdown for LLMs. View as Markdown View this page as plain text. Open in ChatGPT Ask questions about this page. Time to complete: 5 minutes. This guide walks you through sending your first Slack message from Val Town. This guide uses Slack’s incoming webhooks to send messages to a Slack channel. For more complex interactions, like responding to user messages or handling buttons, check out our Slack bot guide. 1. Create a Slack app & webhook. Section titled “1. Create a Slack app & webhook” Click here to create a new Slack app. Click From Scratch. Type an App Name. Select your Slack workspace. Click Incoming Webhooks in the left sidebar of your app (under Features). Toggle Activate Incoming Webhooks to On. Click Add New Webhook at the bottom of the page. Select your target channel. Copy the Webhook URL from Slack. (Bonus) Customize the App icon under Basic Information in the left sidebar (Val Town icons). 2. Add the webhook URL to Val Town. Section titled “2. Add the webhook URL to Val Town” Click Environment Variables in your val’s left sidebar. Add a new env variable with key: SLACK_WEBHOOK_URL. Paste the webhook URL you copied from Slack as the value. 3. Send a message. Section titled “3. Send a message” Now you’re ready to send your first message to Slack! Send messageRun in Val Town ↗ import { IncomingWebhook } from \"npm:@slack/webhook\"; const slack = new IncomingWebhook(Deno.env.get(\"SLACK_WEBHOOK_URL\")); const EDIT = `<${import.meta.url.replace(\"esm\", \"val\")}|(edit val)>`; await slack.send(`🥳 Hi from Val Town! ${EDIT}`); We recommend including this link to the edit val, so everyone on your team is one click away from making changes. What’s next? Section titled “What’s next?” Learn how to make your message fancy with advanced formatting. Take this a step further by responding to mentions, slash commands, buttons, and other user interactions with our full Slack bot guide! You can find more Slack examples on our Templates page.","/guides/slack/send-messages-to-slack/","our Slack bot guide. 1. Create a Slack app & webhook. Section titled “1. Create a Slack app & webhook” Click here to create a new Slack app. Click From",[1000,1007,1016,1023,1031],{"_298":964,"_106":1001,"_343":1002,"_312":1003,"_332":1005,"_337":1006},"https://docs.val.town/guides/slack/send-messages-to-slack/#_top",{"_303":304,"_104":305,"_306":964,"_307":32},[1004],{"_315":145,"_317":320,"_307":983},[983],"Slack message from Val Town. This guide uses Slack’s incoming webhooks to send messages to a Slack channel. For more complex interactions, like responding to user messages or handling buttons,",{"_298":969,"_106":1008,"_343":1009,"_312":1010,"_332":1014,"_337":1015},"https://docs.val.town/guides/slack/send-messages-to-slack/#1-create-a-slack-app--webhook",{"_303":309,"_104":968,"_306":969,"_307":970},[1011,1012,1013],{"_315":327,"_317":328,"_307":675},{"_315":145,"_317":320,"_307":177},{"_315":145,"_317":320,"_307":987},[675,177,987],"1. Create a Slack app & webhook. Section titled “1. Create a Slack app & webhook” Click here to create a new Slack app. Click From Scratch. Type an App",{"_298":973,"_106":1017,"_343":1018,"_312":1019,"_332":1021,"_337":1022},"https://docs.val.town/guides/slack/send-messages-to-slack/#2-add-the-webhook-url-to-val-town",{"_303":309,"_104":972,"_306":973,"_307":974},[1020],{"_315":145,"_317":320,"_307":989},[989],"2. Add the webhook URL to Val Town. Section titled “2. Add the webhook URL to Val Town” Click Environment Variables in your val’s left sidebar. Add a new env",{"_298":977,"_106":1024,"_343":1025,"_312":1026,"_332":1029,"_337":1030},"https://docs.val.town/guides/slack/send-messages-to-slack/#3-send-a-message",{"_303":309,"_104":976,"_306":977,"_307":200},[1027,1028],{"_315":327,"_317":328,"_307":206},{"_315":145,"_317":320,"_307":992},[206,992],"3. Send a message. Section titled “3. Send a message” Now you’re ready to send your first message to Slack! Send messageRun in Val Town ↗ import { IncomingWebhook }",{"_298":980,"_106":1032,"_343":1033,"_312":1034,"_332":1036,"_337":1037},"https://docs.val.town/guides/slack/send-messages-to-slack/#whats-next",{"_303":309,"_104":979,"_306":980,"_307":461},[1035],{"_315":145,"_317":320,"_307":994},[994],"What’s next? Section titled “What’s next?” Learn how to make your message fancy with advanced formatting. Take this a step further by responding to mentions, slash commands, buttons, and other",{"_106":1039,"_112":1040,"_294":1041,"_296":1042,"_300":1046,"_312":1106,"_332":1135,"_334":1040,"_335":1136,"_337":1137,"_339":1138},"https://docs.val.town/guides/databases/supabase/","Supabase. Copy page Copy page. Copy this page as Markdown for LLMs. View as Markdown View this page as plain text. Open in ChatGPT Ask questions about this page. Supabase provide a hosted Postgres database with 500MB of storage in the free tier. You can query and create data inside your vals using either Supabase’s JavaScript SDK, or a Postgres client. Using the SDK. Section titled “Using the SDK” 1. Sign up to Supabase. Section titled “1. Sign up to Supabase” Visit https://supabase.com/dashboard/sign-up. 2. Create a project. Section titled “2. Create a project” On Supabase’s dashboard, create a new project. 3. Get your API URL and service role key. Section titled “3. Get your API URL and service role key” Go to your project’s Settings via the sidebar. Inside API, scroll down and copy the Project URL, and then, inside Project API Keys, copy the service role secret. Save these as two separate Val Town environment variables as supabaseURL and supabaseKey respectively. 4. Create your first table. Section titled “4. Create your first table” Head to the Table editor in the sidebar. Create a new table called my_first_table with the following schema. 5. Insert some data. Section titled “5. Insert some data” Copy and paste the following val to insert some data. Data insertionRun in Val Town ↗ import { createClient } from \"https://esm.sh/@supabase/supabase-js@2\"; const supabase = createClient( Deno.env.get(\"supabaseURL\"), Deno.env.get(\"supabaseKey\"). ); const { data, error } = await supabase. .from(\"my_first_table\"). .insert({ name: \"Alice\", data: { job: \"software engineer\" } }); console.log(data, error); 6. Query back that data. Section titled “6. Query back that data” Get back the data you just inserted by using eq() (like SQL’s WHERE). Data queryRun in Val Town ↗ import { createClient } from \"https://esm.sh/@supabase/supabase-js@2\"; const supabase = createClient( Deno.env.get(\"supabaseURL\"), Deno.env.get(\"supabaseKey\"). ); const { data, error } = await supabase. .from(\"my_first_table\"). .select(\"name, data\"). .eq(\"name\", \"Alice\"). .limit(1); if (error) { throw error; } console.log(data); 7. Keep going! Section titled “7. Keep going!” Use Supabase’s JavaScript Client library documentation to write more queries! Using a Postgres client. Section titled “Using a Postgres client” 1. Sign up to Supabase. Section titled “1. Sign up to Supabase” Visit https://supabase.com/dashboard/sign-up. 2. Create a project. Section titled “2. Create a project” On Supabase’s dashboard, create a new project. Keep a note of your database password, you’ll need this to create a database connection string. 3. Get your database’s connection string. Section titled “3. Get your database’s connection string” Go to your project’s Settings via the sidebar. Inside Database, scroll down and copy the Connection string for Nodejs. Replace [YOUR-PASSWORD] (removing the square brackets) with your database password (alternatively, reset your database password to create a new one). Save this connection string as a Val Town environment variable as supabasePostgres. 4. Create your first table. Section titled “4. Create your first table” Copy and paste this val to create a table with the given schema. Table creationRun in Val Town ↗ import { supaBaseQuery } from \"https://esm.town/v/vtdocs/supaBaseQuery\"; await supaBaseQuery( Deno.env.get(\"supabasePostgres\"), `create table my_first_table ( id bigint generated by default as identity primary key, inserted_at timestamp with time zone default timezone('utc'::text, now()) not null, updated_at timestamp with time zone default timezone('utc'::text, now()) not null, data jsonb, name text. );` ); 5. Insert some data. Section titled “5. Insert some data” Use a prepared statement like below to prevent SQL injection. Data insertionRun in Val Town ↗ import { supaBaseQuery } from \"https://esm.town/v/vtdocs/supaBaseQuery\"; await supaBaseQuery( Deno.env.get(\"supabasePostgres\"), `INSERT INTO MY_FIRST_TABLE (NAME, DATA) VALUES ($1, $2);`, [\"Alice\", '{\"job\": \"software engineer\"}'] ); 6. Query back that data. Section titled “6. Query back that data” Usually, you’ll just want the rows property from the response. Data queryRun in Val Town ↗ import { supaBaseQuery } from \"https://esm.town/v/vtdocs/supaBaseQuery\"; const data = await supaBaseQuery( Deno.env.get(\"supabasePostgres\"), `SELECT NAME, DATA FROM MY_FIRST_TABLE WHERE NAME = $1;`, [\"Alice\"] ); console.log(data); 7. More resources. Section titled “7. More resources” Learn more about the Deno Postgres client used in this guide, view the Supabase Database documentation, or get help on Val Town’s Discord.",667,{"_364":1043,"_366":1044,"_298":1045},"/_astro/screenshot_2023-07-02_at_131928.sOxtJuic_1zqghw.webp","Screenshot 2023-07-02 at 13.19.28.png","Supabase",[1047,1048,1052,1056,1060,1063,1067,1071,1075,1079,1083,1086,1089,1093,1096,1099,1102],{"_303":304,"_104":305,"_306":1045,"_307":32},{"_303":309,"_104":1049,"_306":1050,"_307":1051},"using-the-sdk","Using the SDK",61,{"_303":375,"_104":1053,"_306":1054,"_307":1055},"1-sign-up-to-supabase","1. Sign up to Supabase",69,{"_303":375,"_104":1057,"_306":1058,"_307":1059},"2-create-a-project","2. Create a project",83,{"_303":375,"_104":1061,"_306":1062,"_307":987},"3-get-your-api-url-and-service-role-key","3. Get your API URL and service role key",{"_303":375,"_104":1064,"_306":1065,"_307":1066},"4-create-your-first-table","4. Create your first table",162,{"_303":375,"_104":1068,"_306":1069,"_307":1070},"5-insert-some-data","5. Insert some data",192,{"_303":375,"_104":1072,"_306":1073,"_307":1074},"6-query-back-that-data","6. Query back that data",252,{"_303":375,"_104":1076,"_306":1077,"_307":1078},"7-keep-going","7. Keep going!",317,{"_303":309,"_104":1080,"_306":1081,"_307":1082},"using-a-postgres-client","Using a Postgres client",335,{"_303":375,"_104":1084,"_306":1054,"_307":1085},"1-sign-up-to-supabase-1",345,{"_303":375,"_104":1087,"_306":1058,"_307":1088},"2-create-a-project-1",359,{"_303":375,"_104":1090,"_306":1091,"_307":1092},"3-get-your-databases-connection-string","3. Get your database’s connection string",392,{"_303":375,"_104":1094,"_306":1065,"_307":1095},"4-create-your-first-table-1",457,{"_303":375,"_104":1097,"_306":1069,"_307":1098},"5-insert-some-data-1",536,{"_303":375,"_104":1100,"_306":1073,"_307":1101},"6-query-back-that-data-1",584,{"_303":375,"_104":1103,"_306":1104,"_307":1105},"7-more-resources","7. More resources",636,[1107,1109,1110,1112,1113,1114,1116,1118,1120,1122,1123,1125,1126,1128,1130,1132,1133],{"_315":145,"_317":320,"_307":1108},31,{"_315":145,"_317":320,"_307":441},{"_315":457,"_317":458,"_307":1111},85,{"_315":145,"_317":320,"_307":177},{"_315":145,"_317":320,"_307":325},{"_315":145,"_317":320,"_307":1115},183,{"_315":327,"_317":328,"_307":1117},336,{"_315":145,"_317":320,"_307":1119},342,{"_315":457,"_317":458,"_307":1121},361,{"_315":145,"_317":320,"_307":390},{"_315":145,"_317":320,"_307":1124},373,{"_315":145,"_317":320,"_307":708},{"_315":145,"_317":320,"_307":1127},388,{"_315":145,"_317":320,"_307":1129},442,{"_315":145,"_317":320,"_307":1131},450,{"_315":145,"_317":320,"_307":467},{"_315":145,"_317":320,"_307":1134},547,[1108,441,1111,177,325,1115,1117,1119,1121,390,1124,708,1127,1129,1131,467,1134],"/guides/databases/supabase/","more queries! Using a Postgres client. Section titled “Using a Postgres client” 1. Sign up to Supabase. Section titled “1. Sign up to Supabase” Visit https://supabase.com/dashboard/sign-up. 2. Create a project.",[1139,1147,1156,1163,1171,1182,1190,1197],{"_298":1045,"_106":1140,"_343":1141,"_312":1142,"_332":1145,"_337":1146},"https://docs.val.town/guides/databases/supabase/#_top",{"_303":304,"_104":305,"_306":1045,"_307":32},[1143,1144],{"_315":145,"_317":320,"_307":1108},{"_315":145,"_317":320,"_307":441},[1108,441],"Supabase provide a hosted Postgres database with 500MB of storage in the free tier. You can query and create data inside your vals using either Supabase’s JavaScript SDK, or a",{"_298":1058,"_106":1148,"_343":1149,"_312":1150,"_332":1154,"_337":1155},"https://docs.val.town/guides/databases/supabase/#2-create-a-project",{"_303":375,"_104":1057,"_306":1058,"_307":1059},[1151,1152,1153],{"_315":457,"_317":458,"_307":1111},{"_315":145,"_317":320,"_307":177},{"_315":145,"_317":320,"_307":325},[1111,177,325],"2. Create a project. Section titled “2. Create a project” On Supabase’s dashboard, create a new project.",{"_298":1065,"_106":1157,"_343":1158,"_312":1159,"_332":1161,"_337":1162},"https://docs.val.town/guides/databases/supabase/#4-create-your-first-table",{"_303":375,"_104":1064,"_306":1065,"_307":1066},[1160],{"_315":145,"_317":320,"_307":1115},[1115],"4. Create your first table. Section titled “4. Create your first table” Head to the Table editor in the sidebar. Create a new table called my_first_table with the following schema.",{"_298":1081,"_106":1164,"_343":1165,"_312":1166,"_332":1169,"_337":1170},"https://docs.val.town/guides/databases/supabase/#using-a-postgres-client",{"_303":309,"_104":1080,"_306":1081,"_307":1082},[1167,1168],{"_315":327,"_317":328,"_307":1117},{"_315":145,"_317":320,"_307":1119},[1117,1119],"Using a Postgres client. Section titled “Using a Postgres client”",{"_298":1058,"_106":1172,"_343":1173,"_312":1174,"_332":1180,"_337":1181},"https://docs.val.town/guides/databases/supabase/#2-create-a-project-1",{"_303":375,"_104":1087,"_306":1058,"_307":1088},[1175,1176,1177,1178,1179],{"_315":457,"_317":458,"_307":1121},{"_315":145,"_317":320,"_307":390},{"_315":145,"_317":320,"_307":1124},{"_315":145,"_317":320,"_307":708},{"_315":145,"_317":320,"_307":1127},[1121,390,1124,708,1127],"2. Create a project. Section titled “2. Create a project” On Supabase’s dashboard, create a new project. Keep a note of your database password, you’ll need this to create a",{"_298":1091,"_106":1183,"_343":1184,"_312":1185,"_332":1188,"_337":1189},"https://docs.val.town/guides/databases/supabase/#3-get-your-databases-connection-string",{"_303":375,"_104":1090,"_306":1091,"_307":1092},[1186,1187],{"_315":145,"_317":320,"_307":1129},{"_315":145,"_317":320,"_307":1131},[1129,1131],"with your database password (alternatively, reset your database password to create a new one). Save this connection string as a Val Town environment variable as supabasePostgres.",{"_298":1065,"_106":1191,"_343":1192,"_312":1193,"_332":1195,"_337":1196},"https://docs.val.town/guides/databases/supabase/#4-create-your-first-table-1",{"_303":375,"_104":1094,"_306":1065,"_307":1095},[1194],{"_315":145,"_317":320,"_307":467},[467],"4. Create your first table. Section titled “4. Create your first table” Copy and paste this val to create a table with the given schema. Table creationRun in Val Town",{"_298":1069,"_106":1198,"_343":1199,"_312":1200,"_332":1202,"_337":1203},"https://docs.val.town/guides/databases/supabase/#5-insert-some-data-1",{"_303":375,"_104":1097,"_306":1069,"_307":1098},[1201],{"_315":145,"_317":320,"_307":1134},[1134],"5. Insert some data. Section titled “5. Insert some data” Use a prepared statement like below to prevent SQL injection. Data insertionRun in Val Town ↗ import { supaBaseQuery }",{"_106":1205,"_112":1206,"_294":1117,"_296":1207,"_300":1209,"_312":1241,"_332":1252,"_334":1206,"_335":1253,"_337":1254,"_339":1255},"https://docs.val.town/guides/slack/bot/","Build a Slack bot. Copy page Copy page. Copy this page as Markdown for LLMs. View as Markdown View this page as plain text. Open in ChatGPT Ask questions about this page. Time to complete: 10 minutes. This guide walks you through building a Slack bot that responds to mentions in channels. If you just want to send simple Slack messages without interactivity, check out our Slack webhook guide. Step 1: Remix the bot template. Section titled “Step 1: Remix the bot template” Remix this val to get started: Copy the HTTP endpoint URL (via the … menu for main.tsx) - this is where Slack will send events to your Val Town bot. Step 2: Create a Slack app. Section titled “Step 2: Create a Slack app” Go to Slack API and create a new app From Scratch. Name your app and select your workspace. Step 3: Add environment variables. Section titled “Step 3: Add environment variables” In your val’s sidebar, add these Environment Variables: slackVerificationToken: From Settings → Basic Information → Verification Token. slackToken: Leave empty (you’ll fill this after installing). Step 4: Set up events. Section titled “Step 4: Set up events” Go to Features → Event Subscriptions. Enable events and paste your val’s HTTP endpoint in Request URL. Subscribe to app_mention under Subscribe to bot events. Step 5: Set bot permissions. Section titled “Step 5: Set bot permissions” In OAuth & Permissions → Scopes, add: app_mentions:read (should already be there). chat:write. Step 6: Install your app. Section titled “Step 6: Install your app” Go to Settings → Install App and install to your workspace. Step 7: Add OAuth token. Section titled “Step 7: Add OAuth token” Copy the Bot User OAuth Token from OAuth & Permissions. Update your val’s slackToken environment variable. Step 8: Test your bot. Section titled “Step 8: Test your bot” Invite the bot to a channel Mention the bot - it will reply! What’s next? Section titled “What’s next?” You can find more Slack examples on our Templates page.",{"_364":962,"_366":963,"_298":1208},"Build a Slack bot",[1210,1211,1214,1217,1221,1224,1228,1232,1235,1239],{"_303":304,"_104":305,"_306":1208,"_307":32},{"_303":309,"_104":1212,"_306":1213,"_307":1055},"step-1-remix-the-bot-template","Step 1: Remix the bot template",{"_303":309,"_104":1215,"_306":1216,"_307":447},"step-2-create-a-slack-app","Step 2: Create a Slack app",{"_303":309,"_104":1218,"_306":1219,"_307":1220},"step-3-add-environment-variables","Step 3: Add environment variables",145,{"_303":309,"_104":1222,"_306":1223,"_307":295},"step-4-set-up-events","Step 4: Set up events",{"_303":309,"_104":1225,"_306":1226,"_307":1227},"step-5-set-bot-permissions","Step 5: Set bot permissions",219,{"_303":309,"_104":1229,"_306":1230,"_307":1231},"step-6-install-your-app","Step 6: Install your app",244,{"_303":309,"_104":1233,"_306":1234,"_307":382},"step-7-add-oauth-token","Step 7: Add OAuth token",{"_303":309,"_104":1236,"_306":1237,"_307":1238},"step-8-test-your-bot","Step 8: Test your bot",295,{"_303":309,"_104":979,"_306":980,"_307":1240},320,[1242,1243,1245,1246,1248,1250],{"_315":316,"_317":318,"_307":145},{"_315":145,"_317":320,"_307":1244},43,{"_315":327,"_317":328,"_307":331},{"_315":145,"_317":320,"_307":1247},124,{"_315":145,"_317":320,"_307":1249},133,{"_315":145,"_317":320,"_307":1251},311,[145,1244,331,1247,1249,1251],"/guides/slack/bot/","Build a Slack bot. Copy page Copy page. Copy this page as Markdown for LLMs. View as Markdown View this page as plain text. Open in ChatGPT Ask questions about",[1256,1263,1272],{"_298":1208,"_106":1257,"_343":1258,"_312":1259,"_332":1262,"_337":1254},"https://docs.val.town/guides/slack/bot/#_top",{"_303":304,"_104":305,"_306":1208,"_307":32},[1260,1261],{"_315":316,"_317":318,"_307":145},{"_315":145,"_317":320,"_307":1244},[145,1244],{"_298":1216,"_106":1264,"_343":1265,"_312":1266,"_332":1270,"_337":1271},"https://docs.val.town/guides/slack/bot/#step-2-create-a-slack-app",{"_303":309,"_104":1215,"_306":1216,"_307":447},[1267,1268,1269],{"_315":327,"_317":328,"_307":331},{"_315":145,"_317":320,"_307":1247},{"_315":145,"_317":320,"_307":1249},[331,1247,1249],"Step 2: Create a Slack app. Section titled “Step 2: Create a Slack app” Go to Slack API and create a new app From Scratch. Name your app and select",{"_298":1237,"_106":1273,"_343":1274,"_312":1275,"_332":1277,"_337":1278},"https://docs.val.town/guides/slack/bot/#step-8-test-your-bot",{"_303":309,"_104":1236,"_306":1237,"_307":1238},[1276],{"_315":145,"_317":320,"_307":1251},[1251],"Step 8: Test your bot. Section titled “Step 8: Test your bot” Invite the bot to a channel Mention the bot - it will reply!",{"_106":1280,"_112":1281,"_294":1282,"_296":1283,"_300":1287,"_312":1314,"_332":1327,"_334":1281,"_335":1328,"_337":1329,"_339":1330},"https://docs.val.town/guides/databases/planetscale/","PlanetScale. Copy page Copy page. Copy this page as Markdown for LLMs. View as Markdown View this page as plain text. Open in ChatGPT Ask questions about this page. PlanetScale once provided a hosted MySQL database with 5GB of storage included in the free tier. On April 8, 2024, the free plan was retired and the cheapest plan starts at $39 with 10GB storage. 1. Sign up to PlanetScale. Section titled “1. Sign up to PlanetScale” Go to https://auth.planetscale.com/sign-up. 2. Create a new database. Section titled “2. Create a new database” Select New database on the dashboard. Create a database. 3. Create a password. Section titled “3. Create a password” Go to Settings → Passwords and click New password. Save the host, username, and password values as Val Town environment variables - use planetScaleHost, planetScaleUsername, and planetScalePassword respectively. 4. Create your first table. Section titled “4. Create your first table” Copy and paste this val to create a table with the given schema. Table creationRun in Val Town ↗ import { queryPlanetScale } from \"https://esm.town/v/vtdocs/queryPlanetScale\"; await queryPlanetScale( { host: Deno.env.get(\"planetScaleHost\"), username: Deno.env.get(\"planetScaleUsername\"), password: Deno.env.get(\"planetScalePassword\"), }, `CREATE TABLE stock ( id int NOT NULL AUTO_INCREMENT PRIMARY KEY, name varchar(255) NOT NULL, price varchar(255) NOT NULL. );` ); 5. Insert an item. Section titled “5. Insert an item” Insert one or more items. Data insertionRun in Val Town ↗ import { queryPlanetScale } from \"https://esm.town/v/vtdocs/queryPlanetScale\"; await queryPlanetScale( { host: Deno.env.get(\"planetScaleHost\"), username: Deno.env.get(\"planetScaleUsername\"), password: Deno.env.get(\"planetScalePassword\"), }, `INSERT INTO stock (name, price) VALUES (?, ?);`, [\"banana\", 15] ); 6. Query an item. Section titled “6. Query an item” Use the rows property to get your query results - or log the entire results object to see what other data is available. Query stock tableRun in Val Town ↗ import { queryPlanetScale } from \"https://esm.town/v/vtdocs/queryPlanetScale\"; const results = await queryPlanetScale( { host: Deno.env.get(\"planetScaleHost\"), username: Deno.env.get(\"planetScaleUsername\"), password: Deno.env.get(\"planetScalePassword\"), }, `SELECT id, name, price FROM stock WHERE name=?`, [\"banana\"] ); console.log(results.rows[0]); 7. Do more than queries! Section titled “7. Do more than queries!” Read the source of the @vtdocs/queryPlanetScale helper, see how it uses the @planetscale/database SDK, refer to the driver’s documentation, and extend it!",358,{"_364":1284,"_366":1285,"_298":1286},"/_astro/screenshot_2023-06-25_at_214325.BmyNOcz0_25EgO.webp","Screenshot 2023-06-25 at 21.43.25.png","PlanetScale",[1288,1289,1293,1297,1300,1302,1306,1310],{"_303":304,"_104":305,"_306":1286,"_307":32},{"_303":309,"_104":1290,"_306":1291,"_307":1292},"1-sign-up-to-planetscale","1. Sign up to PlanetScale",64,{"_303":309,"_104":1294,"_306":1295,"_307":1296},"2-create-a-new-database","2. Create a new database",79,{"_303":309,"_104":1298,"_306":1299,"_307":987},"3-create-a-password","3. Create a password",{"_303":309,"_104":1064,"_306":1065,"_307":1301},138,{"_303":309,"_104":1303,"_306":1304,"_307":1305},"5-insert-an-item","5. Insert an item",206,{"_303":309,"_104":1307,"_306":1308,"_307":1309},"6-query-an-item","6. Query an item",254,{"_303":309,"_104":1311,"_306":1312,"_307":1313},"7-do-more-than-queries","7. Do more than queries!",324,[1315,1317,1319,1321,1323,1324,1325],{"_315":145,"_317":320,"_307":1316},32,{"_315":327,"_317":328,"_307":1318},81,{"_315":145,"_317":320,"_307":1320},88,{"_315":145,"_317":320,"_307":1322},98,{"_315":327,"_317":328,"_307":818},{"_315":145,"_317":320,"_307":779},{"_315":145,"_317":320,"_307":1326},157,[1316,1318,1320,1322,818,779,1326],"/guides/databases/planetscale/","2. Create a new database. Section titled “2. Create a new database” Select New database on the dashboard. Create a database. 3. Create a password. Section titled “3. Create a",[1331,1338,1347,1355],{"_298":1286,"_106":1332,"_343":1333,"_312":1334,"_332":1336,"_337":1337},"https://docs.val.town/guides/databases/planetscale/#_top",{"_303":304,"_104":305,"_306":1286,"_307":32},[1335],{"_315":145,"_317":320,"_307":1316},[1316],"page as plain text. Open in ChatGPT Ask questions about this page. PlanetScale once provided a hosted MySQL database with 5GB of storage included in the free tier. On April",{"_298":1295,"_106":1339,"_343":1340,"_312":1341,"_332":1345,"_337":1346},"https://docs.val.town/guides/databases/planetscale/#2-create-a-new-database",{"_303":309,"_104":1294,"_306":1295,"_307":1296},[1342,1343,1344],{"_315":327,"_317":328,"_307":1318},{"_315":145,"_317":320,"_307":1320},{"_315":145,"_317":320,"_307":1322},[1318,1320,1322],"2. Create a new database. Section titled “2. Create a new database” Select New database on the dashboard. Create a database.",{"_298":1299,"_106":1348,"_343":1349,"_312":1350,"_332":1353,"_337":1354},"https://docs.val.town/guides/databases/planetscale/#3-create-a-password",{"_303":309,"_104":1298,"_306":1299,"_307":987},[1351,1352],{"_315":327,"_317":328,"_307":818},{"_315":145,"_317":320,"_307":779},[818,779],"3. Create a password. Section titled “3. Create a password” Go to Settings → Passwords and click New password. Save the host, username, and password values as Val Town environment",{"_298":1065,"_106":1356,"_343":1357,"_312":1358,"_332":1360,"_337":1196},"https://docs.val.town/guides/databases/planetscale/#4-create-your-first-table",{"_303":309,"_104":1064,"_306":1065,"_307":1301},[1359],{"_315":145,"_317":320,"_307":1326},[1326],{"_106":1362,"_112":1363,"_294":1364,"_296":1365,"_300":1368,"_312":1408,"_332":1441,"_334":1442,"_335":1443,"_337":1444,"_339":1445},"https://docs.val.town/guides/discord/how-to-make-a-discord-bot-hosted-24-7-for-free-in-/","Discord bot. Copy page Copy page. Copy this page as Markdown for LLMs. View as Markdown View this page as plain text. Open in ChatGPT Ask questions about this page. Introduction. Section titled “Introduction” By the end of this tutorial you will have a Discord bot hosted 24/7, for free, forever, on Val Town, that responds to a basic /ping Slash Command. Val Town is a social website to write, and deploy JavaScript from the browser. No prior coding experience required. The vast majority of this tutorial is creating the bot on Discord and pasting your keys into Val Town. The actual coding parts are just clicking Run two times to remix two pieces of code to your Val Town account. Note. 💡 If you get stuck, come join us in the Val Town Discord! Video Tutorial. Section titled “Video Tutorial” If you prefer videos, here’s this same tutorial in a 3-minute YouTube video. https://youtu.be/yYXmInPSSfg. Step 1: Create a Discord app. Section titled “Step 1: Create a Discord app” Go to the Discord Developer Portal and select “New Application” in the top right. Enter a name for your Bot, accept the terms and press Create. Step 2: Add the bot to your server. Section titled “Step 2: Add the bot to your server” To invite your new bot to your server, you need to generate a link to click on. Head to the Oauth2 > URL Generator page. Select the bot scope, then the Send Messages permission. Copy the URL at the bottom of the page and paste it into a new browser tab. Click through the steps until you’re prompted to choose your server and press Continue. Press Authorize. 🎉 Your bot is now a member of your server! Now let’s get it to respond to Slash Commands. Step 3: Login to Val Town. Section titled “Step 3: Login to Val Town” Val Town is a social website to write, run, and host JavaScript. You can create APIs, scheduled functions, email yourself, and persist small pieces of data — all from the browser and instantly deployed. There is a generous free plan, and no credit card required. Login or create an account. Step 4: Save bot secrets. Section titled “Step 4: Save bot secrets” Go to the “General Information” page. Copy your Application ID. Go to val.town/settings/environment-variables. Create a new environment variable called discordAppId and paste in the value. Copy your Public Key, saving it as discordPublicKey. Go to the Bot page. Click Reset Token and accept the warning. Copy and paste it in val.town/settings/environment-variables as discordBotToken. Step 5: Register a new Slash Command. Section titled “Step 5: Register a new Slash Command” The embedded code below should have your name in the top-left corner. If you see anonymous, refresh this page. If you still see anonymous, ensure you’re logged into Val Town. Press Run to add the /ping command to your bot. Register /ping commandRun in Val Town ↗ import { registerDiscordSlashCommand } from \"https://esm.town/v/neverstew/registerDiscordSlashCommand\"; const result = await registerDiscordSlashCommand( Deno.env.get(\"discordAppId\"), Deno.env.get(\"discordBotToken\"), { name: \"ping\", description: \"Say hi to your bot\", }, ); export const registerDiscordCommand = result.json(); Step 6: Listen for Slash Commands. Section titled “Step 6: Listen for Slash Commands” Press Run to listen for Slash Commands and reply. Next to your val’s name, click 🔒 > Unlisted. In the val above, in the bottom-left corner of the val, click Script and change it to HTTP. Click on the URL at the bottom of that val that looks like https://username-handleDiscordInteraction.web.val.run. Visit the General Information page for your bot and paste your copied endpoint into INTERACTIONS ENDPOINT URL and click Save Changes. 💬 Try it out. Section titled “💬 Try it out” Refresh Discord and try out your bot using /ping. Further Directions. Section titled “Further Directions” Now that you have a basic Discord Bot setup, you’ll want to customize it to do exactly what you want. You’ll probably want to: Register a new Slash Command. Connect your bot to APIs like OpenAI’s GPT or Dall-E. Come join us in the Val Town Discord if you get stuck, have questions, or want to show off your cool new bot!",692,{"_364":1366,"_366":1366,"_298":1367},"https://i.postimg.cc/bw5Xj8Rd/ping.gif","Discord bot",[1369,1370,1374,1378,1382,1385,1389,1393,1396,1400,1404],{"_303":304,"_104":305,"_306":1367,"_307":32},{"_303":309,"_104":1371,"_306":1372,"_307":1373},"introduction","Introduction",30,{"_303":309,"_104":1375,"_306":1376,"_307":1377},"video-tutorial","Video Tutorial",135,{"_303":309,"_104":1379,"_306":1380,"_307":1381},"step-1-create-a-discord-app","Step 1: Create a Discord app",155,{"_303":309,"_104":1383,"_306":1384,"_307":989},"step-2-add-the-bot-to-your-server","Step 2: Add the bot to your server",{"_303":309,"_104":1386,"_306":1387,"_307":1388},"step-3-login-to-val-town","Step 3: Login to Val Town",299,{"_303":309,"_104":1390,"_306":1391,"_307":1392},"step-4-save-bot-secrets","Step 4: Save bot secrets",363,{"_303":309,"_104":1394,"_306":1395,"_307":804},"step-5-register-a-new-slash-command","Step 5: Register a new Slash Command",{"_303":309,"_104":1397,"_306":1398,"_307":1399},"step-6-listen-for-slash-commands","Step 6: Listen for Slash Commands",520,{"_303":309,"_104":1401,"_306":1402,"_307":1403},"-try-it-out","💬 Try it out",605,{"_303":309,"_104":1405,"_306":1406,"_307":1407},"further-directions","Further Directions",624,[1409,1410,1411,1413,1415,1417,1419,1421,1423,1425,1427,1429,1431,1433,1435,1437,1439],{"_315":145,"_317":320,"_307":1244},{"_315":145,"_317":320,"_307":811},{"_315":145,"_317":320,"_307":1412},65,{"_315":145,"_317":320,"_307":1414},150,{"_315":327,"_317":328,"_307":1416},158,{"_315":145,"_317":320,"_307":1418},166,{"_315":145,"_317":320,"_307":1420},184,{"_315":145,"_317":320,"_307":1422},225,{"_315":145,"_317":320,"_307":1424},260,{"_315":145,"_317":320,"_307":1426},285,{"_315":145,"_317":320,"_307":1428},316,{"_315":145,"_317":320,"_307":1430},349,{"_315":145,"_317":320,"_307":1432},389,{"_315":327,"_317":328,"_307":1434},431,{"_315":145,"_317":320,"_307":1436},440,{"_315":145,"_317":320,"_307":1438},634,{"_315":145,"_317":320,"_307":1440},655,[1244,811,1412,1414,1416,1418,1420,1422,1424,1426,1428,1430,1432,1434,1436,1438,1440],"Discord bot. Copy page Copy page. Copy this page as Markdown for LLMs. View as Markdown View this page as plain text. Open in ChatGPT Ask questions about this page. Introduction. Section titled “Introduction” By the end of this tutorial you will have a Discord bot hosted 24/7, for free, forever, on Val Town, that responds to a basic /ping Slash Command. Val Town is a social website to write, and deploy JavaScript from the browser. No prior coding experience required. The vast majority of this tutorial is creating the bot on Discord and pasting your keys into Val Town. The actual coding parts are just clicking Run two times to remix two pieces of code to your Val Town account. Note. 💡 If you get stuck, come join us in the Val Town Discord! Video Tutorial. Section titled “Video Tutorial” If you prefer videos, here’s this same tutorial in a 3-minute YouTube video. https://youtu.be/yYXmInPSSfg. Step 1: Create a Discord app. Section titled “Step 1: Create a Discord app” Go to the Discord Developer Portal and select “New Application” in the top right. Enter a name for your Bot, accept the terms and press Create. Step 2: Add the bot to your server. Section titled “Step 2: Add the bot to your server” To invite your new bot to your server, you need to generate a link to click on. Head to the Oauth2 > URL Generator page. Select the bot scope, then the Send Messages permission. Copy the URL at the bottom of the page and paste it into a new browser tab. Click through the steps until you’re prompted to choose your server and press Continue. Press Authorize. 🎉 Your bot is now a member of your server! Now let’s get it to respond to Slash Commands. Step 3: Login to Val Town. Section titled “Step 3: Login to Val Town” Val Town is a social website to write, run, and host JavaScript. You can create APIs, scheduled functions, email yourself, and persist small pieces of data — all from the browser and instantly deployed. There is a generous free plan, and no credit card required. Login or create an account. Step 4: Save bot secrets. Section titled “Step 4: Save bot secrets” Go to the “General Information” page. Copy your Application ID. Go to val.town/settings/environment-variables. Create a new environment variable called discordAppId and paste in the value. Copy your Public Key, saving it as discordPublicKey. Go to the Bot page. Click Reset Token and accept the warning. Copy and paste it in val.town/settings/environment-variables as discordBotToken. Step 5: Register a new Slash Command. Section titled “Step 5: Register a new Slash Command” The embedded code below should have your name in the top-left corner. If you see anonymous, refresh this page. If you still see anonymous, ensure you’re logged into Val Town. Press Run to add the /ping command to your bot. Register /ping commandRun in Val Town ↗ import { registerDiscordSlashCommand } from \"https://esm.town/v/neverstew/registerDiscordSlashCommand\"; const result = await registerDiscordSlashCommand( Deno.env.get(\"discordAppId\"), Deno.env.get(\"discordBotToken\"), { name: \"ping\", description: \"Say hi to your bot\", }, ); export const registerDiscordCommand = result.json(); Step 6: Listen for Slash Commands. Section titled “Step 6: Listen for Slash Commands” Press Run to listen for Slash Commands and reply. Next to your val’s name, click 🔒 > Unlisted. In the val above, in the bottom-left corner of the val, click Script and change it to HTTP. Click on the URL at the bottom of that val that looks like https://username-handleDiscordInteraction.web.val.run. Visit the General Information page for your bot and paste your copied endpoint into INTERACTIONS ENDPOINT URL and click Save Changes. 💬 Try it out. Section titled “💬 Try it out” Refresh Discord and try out your bot using /ping. Further Directions. Section titled “Further Directions” Now that you have a basic Discord Bot setup, you’ll want to customize it to do exactly what you want. You’ll probably want to: Register a new Slash Command. Connect your bot to APIs like OpenAI’s GPT or Dall-E. Come join us in the Val Town Discord if you get stuck, have questions, or want to show off your cool new bot!","/guides/discord/how-to-make-a-discord-bot-hosted-24-7-for-free-in-/","prefer videos, here’s this same tutorial in a 3-minute YouTube video. https://youtu.be/yYXmInPSSfg. Step 1: Create a Discord app. Section titled “Step 1: Create a Discord app” Go to the Discord",[1446,1455,1462,1471,1480,1488,1495,1503],{"_298":1372,"_106":1447,"_343":1448,"_312":1449,"_332":1453,"_337":1454},"https://docs.val.town/guides/discord/how-to-make-a-discord-bot-hosted-24-7-for-free-in-/#introduction",{"_303":309,"_104":1371,"_306":1372,"_307":1373},[1450,1451,1452],{"_315":145,"_317":320,"_307":1244},{"_315":145,"_317":320,"_307":811},{"_315":145,"_317":320,"_307":1412},[1244,811,1412],"tutorial you will have a Discord bot hosted 24/7, for free, forever, on Val Town, that responds to a basic /ping Slash Command. Val Town is a social website to",{"_298":1376,"_106":1456,"_343":1457,"_312":1458,"_332":1460,"_337":1461},"https://docs.val.town/guides/discord/how-to-make-a-discord-bot-hosted-24-7-for-free-in-/#video-tutorial",{"_303":309,"_104":1375,"_306":1376,"_307":1377},[1459],{"_315":145,"_317":320,"_307":1414},[1414],"Video Tutorial. Section titled “Video Tutorial” If you prefer videos, here’s this same tutorial in a 3-minute YouTube video. https://youtu.be/yYXmInPSSfg.",{"_298":1380,"_106":1463,"_343":1464,"_312":1465,"_332":1469,"_337":1470},"https://docs.val.town/guides/discord/how-to-make-a-discord-bot-hosted-24-7-for-free-in-/#step-1-create-a-discord-app",{"_303":309,"_104":1379,"_306":1380,"_307":1381},[1466,1467,1468],{"_315":327,"_317":328,"_307":1416},{"_315":145,"_317":320,"_307":1418},{"_315":145,"_317":320,"_307":1420},[1416,1418,1420],"Step 1: Create a Discord app. Section titled “Step 1: Create a Discord app” Go to the Discord Developer Portal and select “New Application” in the top right. Enter a",{"_298":1384,"_106":1472,"_343":1473,"_312":1474,"_332":1478,"_337":1479},"https://docs.val.town/guides/discord/how-to-make-a-discord-bot-hosted-24-7-for-free-in-/#step-2-add-the-bot-to-your-server",{"_303":309,"_104":1383,"_306":1384,"_307":989},[1475,1476,1477],{"_315":145,"_317":320,"_307":1422},{"_315":145,"_317":320,"_307":1424},{"_315":145,"_317":320,"_307":1426},[1422,1424,1426],"paste it into a new browser tab. Click through the steps until you’re prompted to choose your server and press Continue. Press Authorize. 🎉 Your bot is now a member",{"_298":1387,"_106":1481,"_343":1482,"_312":1483,"_332":1486,"_337":1487},"https://docs.val.town/guides/discord/how-to-make-a-discord-bot-hosted-24-7-for-free-in-/#step-3-login-to-val-town",{"_303":309,"_104":1386,"_306":1387,"_307":1388},[1484,1485],{"_315":145,"_317":320,"_307":1428},{"_315":145,"_317":320,"_307":1430},[1428,1430],"“Step 3: Login to Val Town” Val Town is a social website to write, run, and host JavaScript. You can create APIs, scheduled functions, email yourself, and persist small pieces",{"_298":1391,"_106":1489,"_343":1490,"_312":1491,"_332":1493,"_337":1494},"https://docs.val.town/guides/discord/how-to-make-a-discord-bot-hosted-24-7-for-free-in-/#step-4-save-bot-secrets",{"_303":309,"_104":1390,"_306":1391,"_307":1392},[1492],{"_315":145,"_317":320,"_307":1432},[1432],"Step 4: Save bot secrets. Section titled “Step 4: Save bot secrets” Go to the “General Information” page. Copy your Application ID. Go to val.town/settings/environment-variables. Create a new environment variable",{"_298":1395,"_106":1496,"_343":1497,"_312":1498,"_332":1501,"_337":1502},"https://docs.val.town/guides/discord/how-to-make-a-discord-bot-hosted-24-7-for-free-in-/#step-5-register-a-new-slash-command",{"_303":309,"_104":1394,"_306":1395,"_307":804},[1499,1500],{"_315":327,"_317":328,"_307":1434},{"_315":145,"_317":320,"_307":1436},[1434,1436],"Step 5: Register a new Slash Command. Section titled “Step 5: Register a new Slash Command” The embedded code below should have your name in the top-left corner. If you",{"_298":1406,"_106":1504,"_343":1505,"_312":1506,"_332":1509,"_337":1510},"https://docs.val.town/guides/discord/how-to-make-a-discord-bot-hosted-24-7-for-free-in-/#further-directions",{"_303":309,"_104":1405,"_306":1406,"_307":1407},[1507,1508],{"_315":145,"_317":320,"_307":1438},{"_315":145,"_317":320,"_307":1440},[1438,1440],"Directions” Now that you have a basic Discord Bot setup, you’ll want to customize it to do exactly what you want. You’ll probably want to: Register a new Slash Command.","totalCount",211,"paginationCount","totalFileResults","totalProjectResults",22,"totalUserResults","totalDocResults","executionTimeMs",3894,"results",{"_101":102,"_227":228,"_265":266,"_289":290,"_1514":177,"_1515":1516,"_1517":288,"_1518":816,"_94":145,"_1523":1524,"_1525":145,"_1526":100,"_1519":1520},"pageSize",10,"totalPages","resultType","actionData","errors"]

Search

Users3

Users
3