Back to APIs list

Google Sheets API examples & templates

Use these vals as a playground to view and fork Google Sheets API examples and templates on Val Town. Run any example below or find templates that can be used as a pre-built solution.
nbbaier avatar
readabilityHTTPProxy
@nbbaier
HTTP
Forked from maxm/peachMagpie
jxnblk avatar
JxnblkApp
@jxnblk
Script
React components for https://val.town/v/jxnblk/dotcom – https://jxnblk.com
pomdtr avatar
ninja_keys
@pomdtr
HTTP
GET https://pomdtr-ninja_keys.web.val.run
omgwtfbrblolttyl avatar
googleProxy
@omgwtfbrblolttyl
Script
An interactive, runnable TypeScript val by omgwtfbrblolttyl
iamseeley avatar
beigeMandrill
@iamseeley
HTTP
An interactive, runnable TypeScript val by iamseeley
vladimyr avatar
bookmarklets
@vladimyr
HTTP
Forked from pomdtr/bookmarklets
stevekrouse avatar
remarkDemoJSX
@stevekrouse
HTTP
Forked from stevekrouse/remarkDemo
pomdtr avatar
lastlogin
@pomdtr
Script
Lastlogin Authentication for val.town Looking for an hono integration ? See @pomdtr/lastloginHono Support login in trough: Email Link QR Code Google Oauth Github Oauth Gitlab Oauth Facebook Oauth Demo You can try a demo at https://pomdtr-lastloginhonoexample.web.val.run (see @pomdtr/lastLoginHonoExample for code) Usage Wrap your http handlers in a lastlogin middleware (sessions will be persisted in the lastlogin_session table on your sqlite account). If you want to be the only one able to access your val, you can use @pomdtr/verifyUserEmail. import { lastlogin } from "https://esm.town/v/pomdtr/lastlogin"; import { verifyUserEmail } from "https://esm.town/v/pomdtr/verifyUserEmail"; export default lastlogin((req) => { return new Response(`You are logged in as ${req.headers.get("X-LastLogin-Email")}`); }, { // check that the user email match your val town email verifyEmail: verifyUserEmail }); If you want to customize how is allowed to signup, you can set the verifyEmail option: import { lastlogin } from "https://esm.town/v/pomdtr/lastlogin"; export default lastlogin((req) => { return new Response(`You are logged in as ${req.headers.get("X-LastLogin-Email")}`); }, { verifyEmail: (email) => { email == "steve@valtown" } }); You can allow anyone to signup by returning a boolean from the verifyEmail function: import { lastlogin } from "https://esm.town/v/pomdtr/lastlogin"; export default lastlogin((req) => { return new Response(`You are logged in as ${req.headers.get("X-LastLogin-Email")}`); }, { verifyEmail: (_email) => true }); Public Routes import { lastlogin } from "https://esm.town/v/pomdtr/lastlogin"; import { verifyUserEmail } from "https://esm.town/v/pomdtr/verifyUserEmail"; export default lastlogin(() => { return new Response("Hi!"); }, { verifyEmail: verifyUserEmail, public_routes: ["/", "/public/*"], }); See the URLPattern API for reference. Logout Just redirect the user to /auth/logout
stevekrouse avatar
tanLadybug
@stevekrouse
HTTP
Forked from jahabeebs/safeMessageBoard
stevekrouse avatar
lookupTwitterIdFree
@stevekrouse
Script
An interactive, runnable TypeScript val by stevekrouse
jamisonl avatar
ruralCrimsonGuppy
@jamisonl
HTTP
Forked from camajudson/handleDiscordInteraction
cofsana avatar
websim
@cofsana
HTTP
Forked from substrate/websim
tfayyaz avatar
whiteMongoose
@tfayyaz
HTTP
Forked from tfayyaz/tahirsTil
tr3ntg avatar
googleGenerativeAIStreamingExample
@tr3ntg
HTTP
Google Generative AI Streaming Example Example Val showing how to set up an authenticated Google GoogleGenerativeAI client. Prerequisite: Follow Google's Getting Started guide to get an API key and view some example methods.
jamisonl avatar
aloneBronzeCattle
@jamisonl
HTTP
Forked from camajudson/handleDiscordInteraction
movienerd avatar
AIMovie
@movienerd
HTTP (preview)
Forked from movienerd/originalEmeraldPython