Proxy Google Docs List Hot!
Run npm install (or yarn ) after creating the file. // server.js import express from "express"; import morgan from "morgan"; import dotenv from "dotenv"; import google from "googleapis"; import readFile from "fs/promises"; import path from "path"; import fileURLToPath from "url";
// Query only Google Docs (mimeType = application/vnd.google-apps.document) const response = await drive.files.list( q: "mimeType='application/vnd.google-apps.document' and trashed = false", fields: "files(id, name, createdTime, modifiedTime, owners/displayName)", pageSize: 1000 // adjust as needed (max 1000 per request) );
const docs = response.data.files.map((f) => ( id: f.id, name: f.name, createdTime: f.createdTime, modifiedTime: f.modifiedTime, owner: f.owners?.[0]?.displayName ?? "unknown" )); Proxy Google Docs List
// ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ // 1οΈβ£ Helper: create an authenticated Google API client // ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ async function getAuthClient() path.join(__dirname, "service-account.json"); const oauthPath = process.env.OAUTH_CLIENT_PATH
res.json( count: docs.length, docs ); catch (err) console.error("β Error while listing Docs:", err); res.status(500).json( error: "Failed to fetch Google Docs list", details: err.message ); ); Run npm install (or yarn ) after creating the file
dotenv.config(); // loads .env (optional)
# 2οΈβ£ (If you are using a serviceβaccount) make sure service-account.json is present # If you prefer OAuth, place oauth-client.json and run the firstβtime flow. try const auth = await getAuthClient()
// ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ // 2οΈβ£ Route: GET /list-docs // Returns a compact JSON array of Google Docs files. // ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ app.get("/list-docs", async (req, res) => try const auth = await getAuthClient(); const drive = google.drive( version: "v3", auth );