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.
csvViewer
@g
HTTP
* This application creates a CSV viewer using a Hono app that serves a client-side application.
* It allows users to upload a CSV file, view its contents in a table format, and provides basic sorting functionality.
*
* The approach:
* 1. Create a server-side Hono app to handle file uploads and serve the HTML, CSS, and JavaScript.
* 2. Implement client-side JavaScript to handle file reading, parsing CSV, and displaying the data in a table.
* 3. Add sorting functionality to allow users to sort the table by clicking on column headers.
*
* Libraries used:
* - Hono for the server-side application
* - Papa Parse (via esm.sh) for parsing CSV on the client-side
glideImportDemo
@dvdsgl
Script
Glide API 2.0: Bulk Import You can fork this Val to implement your own bulk import to Glide. Glide's high-performance bulk import API can load millions of rows
into Big Tables. It's designed for importing your business data
into Glide on a regular schedule (e.g. nightly). We designed this API for customers who regularly import tens of
thousands of rows or more to Glide using tools like Make. Our goal
was to make this process more efficient and less expensive. Note: This API is currently free to use. Future usage will cost
approximately 1 update per 10k rows.