Please meet Google Apps Script

Recently, I wanted to write a script for parsing all the Google Docs from a specific folder stored in a Shared Google Drive to build a Spreadsheet containing some information from the files. Think about it as an index generation.

Listing the files was as easy as:

folder = DriveApp.getFolderById(folderId);
files = folder.getFiles();
listOfFileIds = [];

while (files.hasNext()){
  file = files.next();
  listOfFileIds.push(file.getId());
}

And then, you can read the content of each file:

doc = DocumentApp.openById(fileId);
body = doc.getBody();
table = body.getTables()[0];
text = table.getCell(0,0).getText();

To eventually save it in a Spreadsheet:

spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
sheet = spreadsheet.getSheetByName(sheetName);;  
range = sheet.getRange(rangeStr).activate();

range.setValues(data);

It seems like Google Apps Script can automate stuff in Google Workspace Apps.

Even in Google Calendar!

---