1 hour ago · Tech · 0 comments

We have a Google Drive folder with documents needing review. It’s a little hard keeping track of our progress so I got some help from Gemini in creating a checklist. It worked out pretty well. I’m also happy to have a starting point for learning more about some features of Apps Script that I haven’t used much before — the DriveApp API — and a few details on how PDFs work. I was also happy to be reminded about a couple small things on regexes that I’m surprised I forgot. My first prompt: I have a Google Drive folder with some documents that we need to review. It’s hard to keep track of our progress reading them. Could I use Apps Script to create a spreadsheet with a checkbox for each item? You can see the rest of our conversation here. Final code that it came up with: function generateLinkedReviewList() { const folderId = 'YOUR_FOLDER_ID_HERE'; const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); const folder = DriveApp.getFolderById(folderId); const files =…

No comments yet. Log in to reply on the Fediverse. Comments will appear here.