Skip to content

Instantly share code, notes, and snippets.

jodmoreira

Block or report user

Report or block jodmoreira

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View gist:1a27fc73d2445b17f27a0d8eebbe09ad
=IMPORTDATA(CONCAT("https://drive.google.com/uc?export=download&id=";REGEXREPLACE(URL cell;".*/d/|/edit.*|/view.*";"")))
@jodmoreira
jodmoreira / gist:8ac2fef140e3fbdee0ad943449dabe65
Created Sep 5, 2017
Code to create a new row and update a list in google sheets
View gist:8ac2fef140e3fbdee0ad943449dabe65
//Add this script to a google sheet that you will use as database. Set a trigger to run this script periodically. Daily midnight can be a good time
//Adicione esse escript à planilha do google que você vai usar como base de dados. Configure u acionador para funcionar periodicamente. Diariamente
//à meia noite pode ser um bom horário.
function updateList() {
//Don't forget to change the folder ID bellow
//Não se esqueça de mudar o ID da pasta abaixo
var folder = DriveApp.getFolderById('INSERT-HERE-THE-FOLDER-ID');
var contents = folder.getFiles();
var file;
You can’t perform that action at this time.