[Productivity] Google Drive API × NotebookLM: Automated Generation of Management Reports from Meeting Minutes and Chat Logs

The New Bottleneck in Knowledge Management

Daily meeting memos, Google Docs from conferences, development progress in Spreadsheets, and ongoing discussions on Email (Resend) or Email (Resend)—all of these constitute the valuable "knowledge" of a company.

However, because this information is scattered across various folders and channels, the reality for many companies is that "employees cannot access the necessary information" and "staff spend hours copying and pasting across multiple tools just to create weekly or monthly management reports."

Google's AI-powered note-taking tool, NotebookLM, has garnered significant attention for its ability to provide highly accurate summaries and dialogues by strictly referencing only uploaded materials (such as PDFs, Google Docs, and web links) as its context.

By moving away from manual operations and integrating this seamlessly (Touchless) via the Google Drive API, you can build a data synchronization system where information is constantly updated, allowing you to generate high-quality management reports and explanatory podcasts with a single click.

---

2. Before & After: Resolving Operational Bottlenecks

Item	Manual Knowledge Organization (Before)	API Integration + NotebookLM (After)
Report Creation Time	3-4 hours weekly (collecting logs, summarizing, drafting)	Effectively 0 seconds (Automated API updates)
Information Hallucination	Standard AI chats are prone to fabricating information	Accurate, as NotebookLM references only specified documents
Searchability	Requires searching across multiple sheets and docs	Enables extracting company knowledge via Q&A in a chat interface
Document Freshness	Requires manual re-upload of files	AI sources automatically follow updates to files in Drive

---

3. Implementation Example: Automating Document Uploads via Google Drive API

Below is a implementation example using the Google Drive API (TypeScript) to automatically convert and dump Email (Resend) discussion logs and meeting minutes into a company knowledge-sharing folder (e.g., /AIO Media Hub/).

import { google } from "googleapis";

// Load credentials from the Google Cloud Service Account
const SCOPES = ["https://www.googleapis.com/auth/drive.file"];
const auth = new google.auth.GoogleAuth({
  credentials: {
    client_email: process.env.GOOGLE_CLIENT_EMAIL,
    private_key: process.env.GOOGLE_PRIVATE_KEY?.replace(/\\n/g, "\n"),
  },
  scopes: SCOPES,
});

const drive = google.drive({ version: "v3", auth });

export async function uploadReportToDrive(filename: string, content: string, parentFolderId: string) {
  try {
    const fileMetadata = {
      name: filename,
      parents: [parentFolderId],
      mimeType: "application/vnd.google-apps.document", // Automatically converts to Google Docs format
    };

    const media = {
      mimeType: "text/plain",
      body: content,
    };

    const response = await drive.files.create({
      requestBody: fileMetadata,
      media: media,
      fields: "id, webViewLink",
    });

    console.log(`Document created successfully. ID: ${response.data.id}`);
    return {
      id: response.data.id,
      link: response.data.webViewLink,
    };
  } catch (error) {
    console.error("Failed to upload to Google Drive:", error);
    throw error;
  }
}

By deploying this process to Vercel Workflows or a scheduled batch job (Cron), the business texts and meeting minutes accumulated daily are automatically synchronized to Google Drive, ensuring that NotebookLM's reference documents are always up to date.

---

4. HadayaLab's Google Workspace Integration Consulting

HadayaLab offers knowledge BPR services that seamlessly connect various Google Workspace APIs (Gmail, Drive, Sheets, Docs, Calendar) with our proprietary AI systems.

• Automated Sales Summaries: Extract key points from Google Meet recordings and transcripts, automatically syncing them to customer management sheets (Spreadsheets) and Drive.
• NotebookLM Optimization: AI automatically cleanses and formats document structures (such as heading hierarchies and glossaries) into layouts most easily interpretable by the AI.
• Decision-Making Dashboards: Integrate with Google Data Studio (Looker Studio) to visualize AI analysis results through graphs and charts.

If you are an administrator looking to streamline internal document management and create an environment where AI can provide appropriate advice at any time, please consult HadayaLab regarding our knowledge automation solutions.