Skip to content

Instantly share code, notes, and snippets.

View richardblondet's full-sized avatar

Richard Blondet richardblondet

View GitHub Profile
@richardblondet
richardblondet / README.md
Last active February 13, 2025 05:58
Create a simple API backend with Google App Script and a Spreadsheet

Google App Script CRUD

Inspired by this gist.

Getting Started

  1. Create a new App Script project.
  2. Paste the content of the file google-app-script-crud.gs in the default Code.gs file.
  3. Create a new Spreadsheet.
  4. Copy the Spreadsheet ID found in the URL into the variable SHEET_ID located in line 1 of your file.
@alanbsmith
alanbsmith / structuring-our-styled-components-an-example-block.js
Last active March 30, 2022 13:46
structuring-our-styled-components-an-example-block
// src/blocks/Card/index.js
import styled from 'styled-components';
import Header from './Header';
import Image from './Image';
import Text from './Text';
import Title from './Title';
const Card = styled.div`
@nyancodeid
nyancodeid / README.md
Last active February 19, 2025 06:57
Make RESTful API with Google Apps Script and SpreadSheet

Google Script CRUD

By Ryan Aunur Rassyid

Simply create RESTful API with Google Script and store it to Google SpreadSheet like a Pro.

// Includes functions for exporting active sheet or all sheets as JSON object (also Python object syntax compatible).
// Tweak the makePrettyJSON_ function to customize what kind of JSON to export.
var FORMAT_ONELINE = 'One-line';
var FORMAT_MULTILINE = 'Multi-line';
var FORMAT_PRETTY = 'Pretty';
var LANGUAGE_JS = 'JavaScript';
var LANGUAGE_PYTHON = 'Python';