Skip to main content
SimilarExport ZIP
100%

Google Sheets Script for Fetching Data from Supabase

✓ Published0🌍 Public
HHugoberry
Last edited Apr 17, 2023
Created on May 29, 2024

This example shows a Google Sheets script that pulls data from a Supabase database and writes it into the active sheet, first clearing existing content. It uses the Supabase REST API via `UrlFetchApp.fetch` and handles JSON responses with `JSON.parse`. The script writes a configurable set of headers to row one, then maps each data row into corresponding columns. It relies on `SpreadsheetApp.getActiveSpreadsheet().getActiveSheet()` for sheet operations, and constants for the Supabase URL, anon key, and table name. The process is automated through a single `mainFunction` that chains clearing, header writing, and data fetching.

AI-generated description

Similar vizzes

Loading thumbnail…

Untitled

This example demonstrates how to load and display a single cell from a public Google Sheets document directly in a browser page. The page shows the content of cell A1 rendered as plain text inside a `<pre>` element, with a dark blue background and large Ubuntu font. It uses Google Sheets’ JSON-in-script feed with a callback, and relies on the native `fetch`-like script loading mechanism rather than D3. The code also imports D3’s `select` function in `index.js` to set text on a separate message element, though no such element exists in the HTML.

Kkhalilha
60% match
Loading thumbnail…

Loading CSV data

This example demonstrates how to fetch a CSV file from a Google Sheets public URL and log its contents to the browser console. The code uses native JavaScript `fetch()` and `async`/`await` syntax to retrieve the text, avoiding external libraries. It features a simple HTML page with a centered "Hello CSV Fetch" heading and large font styling. The data source is a Google Sheets CSV export endpoint, and the fetched text is printed via `console.log()`. Two commented-out alternative promise-based approaches are also shown, though the active implementation is the async/await version.

KKelly Egan
59% match
Loading thumbnail…

Gist d2f55e96546318a1e8e393d423ea36e9

This example shows a SQL query that transfers data from one Excel sheet to another, creating a new table in a separate workbook file. The visualization demonstrates how data can be exported or copied between spreadsheet locations using an embedded query. The code uses the `SELECT * INTO` syntax with an `[Excel 8.0;DATABASE=...]` connection string, specifying the destination file path and sheet name. The query pulls all records from the source sheet and writes them to the target workbook, illustrating a straightforward data-migration pattern. The rendering approach relies on the database driver’s handling of the Excel file format, with no additional charting or graphics libraries involved.

HHugoberry
54% match
Loading thumbnail…

Fork of HTML Starter

This example demonstrates a minimal setup for fetching and displaying data from a remote CSV file using native browser APIs. The page renders no visible content beyond a large empty body, as the script defines an `async` function that fetches text from a GitHub gist URL but never calls it or processes the response. The code uses the Fetch API to retrieve the CSV, though the function is misspelled as `asyc` and remains unused. It relies on plain HTML, CSS, and JavaScript, with no external libraries, serving as a basic template for future data visualization work.

AAbin
52% match
Loading thumbnail…

My Webpage

This example demonstrates how to embed a CSV data table directly into a webpage using the native Fetch API to load a remote file from a GitHub gist. It shows the first ten rows of parsed data displayed in an HTML table, with headers and cells populated dynamically through DOM manipulation. The page also includes basic HTML structure, a reference to an SVG logo image, and a link to a D3 version 6 tutorial video, though no D3 visualization is actually implemented. The code relies on standard browser APIs like `fetch` and `document.createElement` rather than any external charting library.

BBhavanaGIrni
51% match
Loading thumbnail…

fetching data

This example shows a bare-bones HTML page that fetches data from a remote URL. It demonstrates the basic Fetch API workflow in JavaScript, where a `fetch()` call is made to a GitHub Gist URL and a promise is created to handle the response. The page includes a static "Hello HTML!" message and sets up the foundation for asynchronous data loading, though the response handling is incomplete. The example uses plain HTML, CSS for styling, and JavaScript's built-in `fetch()` function, with no external libraries or visualization components yet.

Sshre1310
51% match
Loading thumbnail…

Gist ea8710410afc9bb88a65f846e46d04da

This example demonstrates how to automate opening a Google Sheets tab in Chrome at user logon and session unlock, using a PowerShell script to register a Windows scheduled task. The task triggers on logon and session unlock events, launching Chrome with an app-mode URL pointing directly to the spreadsheet. The code constructs an XML task definition with the `Register-ScheduledTask` cmdlet, embedding the Chrome executable path and the spreadsheet URL as arguments. It highlights the use of PowerShell’s scheduled task API and XML trigger configuration, showing a practical workflow automation for persistent access to a specific data source without manual intervention.

HHerbCaudill
51% match
Loading thumbnail…

LogicalFile Fetch

This example demonstrates asynchronous data fetching from multiple HPCC Systems endpoints and external APIs, logging each response directly into the DOM. It uses the `@hpcc-js/comms` library to instantiate `Result`, `Workunit`, `ESPConnection`, and `Connection` objects, retrieving logical file schemas and row batches with `fetchXMLSchema` and `fetchRows`, querying completed workunits, and sending ESP requests via `DFUQuery`. Results from Google Maps geocoding are also included, with all output rendered as plain text in the placeholder `div`.

GGordonSmith
50% match