Skip to content

Instantly share code, notes, and snippets.

View ernesgarcia's full-sized avatar

ernesgarcia

2 followers · 4 following
View GitHub Profile
@ernesgarcia
ernesgarcia / README.md
Created January 17, 2023 16:50 — forked from nyancodeid/README.md
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.

@ernesgarcia
ernesgarcia / spreadsheet_to_email.gs
Created January 17, 2023 16:47 — forked from richardblondet/spreadsheet_to_email.gs
Send Emails from messages from Spreadsheet
function sendEmail() {
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var currentsheet = spreadsheet.getSheetByName('Sheet1');
var data = currentsheet.getDataRange().getValues();
var html = HtmlService.createTemplateFromFile('TEMPLATE'); // create a html file, named template case sentitive
var date = new Date();
//loop over each line
@ernesgarcia
ernesgarcia / README.md
Created January 17, 2023 16:47 — forked from richardblondet/README.md
Make RESTful API with Google Apps Script and SpreadSheet
@ernesgarcia
ernesgarcia / README.md
Created January 17, 2023 16:41 — forked from richardblondet/README.md
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.