Thomas raidzklart

Google App Script CRUD

Inspired by this gist.

Create a new App Script project.
Paste the content of the file google-app-script-crud.gs in the default Code.gs file.
Create a new Spreadsheet.
Copy the Spreadsheet ID found in the URL into the variable SHEET_ID located in line 1 of your file.

First, Create a folder inside of lib called seeds

Put your CSV file example.csv into the lib/seeds folder. In the example below, the file is called real_estate_transactions.csv

Make sure you've created a resource with the appropriate columns to match your seed data. The names don't have to match up.

	<?php
	// Your PHP code here
	?>

	<!doctype html>
	<html lang="en">
	<head>
	<meta charset="UTF-8">
	<meta name="viewport" content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
	<meta http-equiv="X-UA-Compatible" content="ie=edge">

	{% comment %}
	*
	* This loop loops through a collection called `collection_name`
	* and sorts it by the front matter variable `date` and than filters
	* the collection with `reverse` in reverse order
	*
	* To make it work you first have to assign the data to a new string
	* called `sorted`.
	*
	{% endcomment %}