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.
pps avatar
sqliteExplorerApp
@pps
HTTP (deprecated)
Forked from postpostscript/sqliteExplorerApp
devonzuegel avatar
subscribe_to_a_substack_2
@devonzuegel
Script
Forked from bensu/subscribe_to_a_substack
tmcw avatar
blocks
@tmcw
Express
Unfancy blocks In the old days, there was a website called bl.ocks.org which re-hosted content on GitHub Gists and displayed visualizations made in those gists. It wasn't shiny but it was well-crafted and for the little community that used it, it was very nice. This is a much worse, but very small, version of the same kind of program. This also shows you stuff from blocks. It displays readmes, with Titus's lovely micromark . It uses Ian's collected search index of bl.ocks.org to show you examples and thumbnails. It uses Alpine to pull together a little interface. And, of course, Val Town to make it all work.
yawnxyz avatar
luciaValtownSqlite
@yawnxyz
Script
A reorganization of: https://www.val.town/v/stevekrouse/lucia_adapter https://esm.town/v/stevekrouse/lucia_adapter_base
ejfox avatar
googleCalendarWeekEndpoint
@ejfox
HTTP
// This approach uses Google OAuth to authenticate the user and fetch their actual calendar events for the week.
bensu avatar
subscribe_to_a_substack
@bensu
Script
Forked from devonzuegel/subscribe_to_a_substack
lolocoo avatar
googlesearch
@lolocoo
Express
An interactive, runnable TypeScript val by lolocoo
Glench avatar
googlePhotosMarketingRSS
@Glench
HTTP (deprecated)
An interactive, runnable TypeScript val by Glench
fil avatar
earthquakes
@fil
HTTP
Earthquake map 🌏 This val loads earthquake data from USGS, a topojson file for the land shape, and supporting libraries. It then creates a map and save it as a SVG string. The result is cached for a day. Note that we must strive to keep it under val.town’s limit of 100kB, hence the heavy simplification of the land shape. (For a simpler example, see becker barley .) | | | |-----|-----| | Web page | https://fil-earthquakes.web.val.run/ | | Observable Plot | https://observablehq.com/plot/ | | linkedom | https://github.com/WebReflection/linkedom | | topojson | https://github.com/topojson/topojson | | earthquakes | https://earthquake.usgs.gov | | world | https://observablehq.com/@visionscarto/world-atlas-topojson | | css | https://milligram.io/ |
maxm avatar
niceTodoList
@maxm
HTTP
* This is a minimalist to-do list app using server-side rendering without any client-side JavaScript. * It uses Val Town's SQLite for data persistence, Deno's standard library for HTML escaping, * and custom SVG icons for a cohesive design.
namwen avatar
TravelApp
@namwen
HTTP (deprecated)
@jsxImportSource https://esm.sh/react
janpaul123 avatar
valle_tmp_17314117069468577415194390357787
@janpaul123
HTTP (deprecated)
An interactive, runnable TypeScript val by janpaul123
Olive avatar
linkInBioTemplate
@Olive
HTTP (deprecated)
Forked from stevekrouse/linkInBioTemplate
janpaul123 avatar
valle_tmp_0563475334662015830056231202392625
@janpaul123
HTTP (deprecated)
* Approach: * - Use an HTTP val to serve the HTML page. * - HTML will be designed for a Wordle game. * - CSS will include fun gradients, crazy fonts, and colors. * - JavaScript will handle the game logic for Wordle.
stevekrouse avatar
dateme_form_react
@stevekrouse
Script
Forked from stevekrouse/date_me_form
fahmi avatar
accessibleScarletToad
@fahmi
HTTP (deprecated)
Forked from fahmi/comparableJadePtarmigan