This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
=IMPORTDATA(CONCAT("https://drive.google.com/uc?export=download&id=";REGEXREPLACE(URL cell;".*/d/|/edit.*|/view.*";""))) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//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; |