Discover gists

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.

Bypassing Cloudflare, Akamai, etc

Some notes/resources for bypassing anti-bot/scraping features on Cloudflare, Akamai, etc.

Chat GPT "DAN" (and other "Jailbreaks")

Tesla Key Card Protocol

Researched by Robert Quattlebaum darco@deepdarc.com.

Last updated 2020-02-03.

When following this guide on a host not capable of native arm64 KVM, replace -M virt -cpu host -accel kvm with -M virt,virtualization=on -cpu max.

The reason for virtualization=on is that the Windows bootloader does an smc #0 PSCI call, but without EL2, QEMU's TCG does not handle those because PSCI is in HVC mode and such that instruction is treated as undefined. With KVM enabled, smc #0 is handled properly.

Workaround in QEMU for using TCG without virtualization=on:

diff --git a/hw/arm/virt.c b/hw/arm/virt.c
index b871350856..de11ff51d1 100644
--- a/hw/arm/virt.c

	#!/bin/bash


	# utility functions
	function rand_str() {
	local length=${1:-8}
	LC_ALL=C tr -dc A-Za-z0-9 </dev/urandom \| head -c $length
	}

	function debug() {

	function checkOrigin(origin) {
	if (!origin) {
	return false;
	}
	const [protocol, host, port] = origin.split(':');
	// TODO: put your own logic here
	if (!host) {
	return false;
	}
	if (host === '//localhost') {

	// check version
	node -v \|\| node --version

	// list locally installed versions of node
	nvm ls

	// list remove available versions of node
	nvm ls-remote

	// install specific version of node

	groups:
	- name: node_exporter_alerts
	rules:
	- alert: Node down
	expr: up{job="monitoring-pi"} == 0
	for: 2m
	labels:
	severity: warning
	annotations:
	title: Node {{ $labels.instance }} is down