Igor Cotruta Hugoberry

Google Sheets Script for Fetching Data from Supabase

This Google Sheets script fetches data from a Supabase database and writes the selected headers and data to the active sheet. The script first clears the sheet, writes the headers, then fetches the data from the Supabase API, and finally writes the data to the sheet. It is optimized and has anonymized variables for public use.

How to Use

Create a new Google Sheet or open an existing one.
Click on "Extensions" in the menu, then select "Apps Script." (If you don't see "Extensions," click on "Tools" and then "Script editor.")
In the Apps Script editor, replace the default Code.gs content with the content of supabase_to_google_sheets.gs.
Replace the SUPABASE_URL and SUPABASE_ANON_KEY variables with your actual Supabase URL and anon key.

Rough draft of this chart.

We started out with a SVG animation, tried out Elijah's canvas sankey particles and ended up rewriting in regl to get more dots on the screen.

The final version gets better performance by passing in array of attibutes to the vertex shader - I'm not sure why that is.

Update: Ricky Reusser points out that I was creating a new array of points every frame with:

attributes: {x: () => data.map(d => d.x)}

	<!--
	$Id: markers.html,v 1.4 2013/10/28 08:44:55 gaudenz Exp $
	Copyright (c) 2006-2014, JGraph Ltd

	Demonstrates creating a custom edge in mxGraph
	-->
	<html>
	<head>
	<title>Custom edge example for mxGraph</title>

	/**
	BSD 3-Clause License

	Copyright (c) 2019 Odzhan. All rights reserved.

	Redistribution and use in source and binary forms, with or without
	modification, are permitted provided that the following conditions are met:

	* Redistributions of source code must retain the above copyright notice, this
	list of conditions and the following disclaimer.

	$method = "GET"
	$headerDate = '2017-04-17'
	$headers = @{"x-ms-version"="$headerDate"}
	$StorageAccountName = "<your account name>"
	$StorageAccountKey = "<your account key>"
	$Url = "https://$StorageAccountName.file.core.windows.net/?comp=list"
	$xmsdate = (get-date -format r).ToString()
	$headers.Add("x-ms-date",$xmsdate)

	$signatureString = "$method$([char]10)$([char]10)$([char]10)$contentLength$([char]10)$([char]10)$([char]10)$([char]10)$([char]10)$([char]10)$([char]10)$([char]10)$([char]10)"

	# coding: utf-8
	# vim: set ts=4 sw=4 sts=4 si ai et ft=powershell:
	# Copyright (c) 2013, ZenRobotics Ltd.
	# author: Paul Tötterman <[email protected]>
	#
	# Permission to use, copy, modify, and/or distribute this software for any
	# purpose with or without fee is hereby granted, provided that the above
	# copyright notice and this permission notice appear in all copies.
	#
	# THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES

	D:\www\apache-2.4.25\bin>ab.exe -n 10000 -c 10 http://localhost:8080/
	This is ApacheBench, Version 2.3 <$Revision: 1757674 $>
	Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
	Licensed to The Apache Software Foundation, http://www.apache.org/

	Benchmarking localhost (be patient)

	Server Software:
	Server Hostname: localhost
	Server Port: 8080

	license: mit
	scrolling: true
	height: 300

	border: no
	license: Apache-2.0