Skip to content

Instantly share code, notes, and snippets.

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.