Thomas Wilburn thomaswilburn

If you have fewer than a thousand addresses and you need them geocoded quickly and accurately, Google Sheets is generally the best way to do it. Here's how to set up the Apps Script necessary. Here is a demo sheet with everything set up, including the Apps Script code.

Create or open your sheet, and then in the Extensions menu, choose "Apps Script" to open the editor. Erase the placeholder contents in Code.gs and paste this in:

const SHEET_NAME = "data";
const ADDRESS_COLUMN = 2;
const LATITUDE_COLUMN = 3;

function geocode() {

	class Cluster {
	start = 0;
	end = 0;
	min = 0;
	max = 0;
	items = [];

	constructor(items, start, end, min, max) {
	this.items = items;
	this.start = start;

	var stack = [];
	var verbose = false;

	// make our own undefined sentinel value
	var undefined = Symbol("undefined signal");

	class Signal extends EventTarget {
	#value = undefined;
	#computation = null;
	#lifetime = new AbortController();

	var links = document.querySelectorAll(`link[rel="stylesheet"][media="async"], link[rel="async-styles"]`);

	for (var link of links) {
	var resolved = new URL(link.href, window.location);
	var processed = await getSheet(resolved.toString());
	var style = document.createElement("style");
	var constructed = new CSSStyleSheet();
	var output = serializeCSS(processed);
	constructed.replaceSync(output);
	// console.log(output);

	<!doctype html>
	<style>
	.card {
	display: grid;
	grid-template-columns: 1fr 2fr;

	& img {
	max-height: 200px;
	}
	}

	const TARGET = Symbol("proxy target");

	function defaultdict(missing) {
	var dict = {};
	var instantiate = missing;
	if (missing instanceof Function) {
	if (missing.constructor) {
	instantiate = () => new missing();
	}
	} else if (missing instanceof Object) {

	var proxyRegistry = new WeakMap();

	function observe(root, callback) {
	var handler = {
	get(target, property, rec) {
	var value = target[property];
	if (value instanceof Object && !(value instanceof Function)) {
	if (proxyRegistry.has(value)) {
	return proxyRegistry.get(value);
	}

	var tracking = [];
	var pending = new Set();
	function anticipate(fn) {
	pending.add(fn);
	requestAnimationFrame(() => {
	for (var p of pending) p();
	pending.clear();
	});
	}

	<!doctype html>
	<ul id="ul"></ul>

	<script type="module">
	import { html, render } from "https://unpkg.com/lit-html";
	import { repeat } from "https://unpkg.com/lit-html/directives/repeat.js";
	import { map } from "https://unpkg.com/lit-html/directives/map.js";


	function replacer(container, data, factory, update = () => {}) {

	// run with deno run --allow-all datapatcher.js {SHEET_ID} {SHEET_TAB (optional)}

	import { login, google } from "https://raw.githubusercontent.com/Chalkbeat/deno-google-login/main/index.js";

	import * as flags from "https://deno.land/[email protected]/flags/mod.ts";

	var args = flags.parse(Deno.args);

	var spreadsheetId = args.sheet \|\| args._[0];