Analyzing Google Drive Documents with Google CLI

// List files in a specific folder
const files = await google.drive.files.list({
  q: "'FOLDER_ID' in parents",
  fields: 'files(id, name, mimeType, modifiedTime)',
});

// Only recently modified files
const recentFiles = await google.drive.files.list({
  q: "modifiedTime > '2026-03-01'",
  orderBy: 'modifiedTime desc',
});

async function readDriveFile(fileId: string, mimeType: string) {
  if (mimeType === 'application/vnd.google-apps.document') {
    // Google Docs -> export as text
    return await google.drive.files.export(fileId, 'text/plain');
  }
  if (mimeType === 'application/vnd.google-apps.spreadsheet') {
    // Google Sheets -> export as CSV
    return await google.drive.files.export(fileId, 'text/csv');
  }
  if (mimeType === 'application/pdf') {
    // PDF -> extract text (using pdf-parse)
    const buffer = await google.drive.files.download(fileId);
    return await extractPDFText(buffer);
  }
}

const prompt = `The following are documents retrieved from Google Drive.

Question: "${userQuestion}"

Please find the answer to this question from the documents.
When answering, also mention which document the information came from.

Documents:
${documents.map(d => `[${d.name}]\n${d.content.slice(0, 5000)}`).join('\n\n---\n\n')}`;

"Summarize all documents created last month"
-> AI reads all recent documents and generates a summary list

"Find what last year's marketing budget was"
-> AI locates the answer from relevant spreadsheets/documents

"Tell me the key differences between the Q1 and Q2 reports"
-> AI reads both documents and provides a comparative analysis