The Prince Academy株式会社 | Setting the Stage: Connecting Gmail and Google Sheets in Your Workspace Studio Project | Leveraging AI: How to Summarize Emails and Categorize Data for Your Workflow | First Steps with Google Workspace Studio: AI Workflow Development Course Connecting Gmail, Calendar and Spreadsheets

While the academic foundations we just reviewed provide the theoretical power for our AI workflow, theory alone doesn't organize an inbox. To bring concepts like text summarization and categorization to life, we need to build the practical plumbing—the digital pipes that connect our data source to our processing engine. This is where the real work begins, and it all starts with establishing a solid connection between the services we want to automate.

In this section, we will roll up our sleeves and set the stage for our entire project. Our goal is to create a direct line of communication between your Gmail inbox and a Google Sheet. Think of Google Sheets not just as a spreadsheet, but as our structured database and dashboard. It’s where we’ll log the raw email data, store the AI-generated summaries, and track the assigned categories. Without this foundational connection, our script is an isolated island with no access to the outside world.

The magic that makes this possible is Google Apps Script, the cloud-based JavaScript platform that underpins Google Workspace Studio. Apps Script provides pre-built services that act as bridges to your Google applications. For our purpose, the two most important services are GmailApp, which allows us to programmatically read and manage emails, and SpreadsheetApp, which gives us full control over our Google Sheets.

graph TD;
    A[Gmail Inbox] -->|Apps Script reads emails| B(Google Workspace Studio Project);
    B -->|Script writes data| C[Google Sheet];

Let's create our project. The simplest way to begin is by starting in our destination: Google Sheets. Create a new, blank Sheet and give it a name like "AI Email Processor." This sheet will become the home for our script.

Now, navigate to Extensions > Apps Script from the menu. This will open a new browser tab with the Google Workspace Studio editor, automatically creating a script project that is "bound" to your spreadsheet. This binding is convenient, making it easy for the script to identify and manipulate its parent sheet.

In the script editor, you'll see a default file named Code.gs with an empty function. Replace the contents with this initial setup code. This script doesn't perform any complex logic yet; its sole purpose is to verify that we can successfully access both the Sheet and the Gmail service.

function setupInitialConnection() {
  // 1. Access the active spreadsheet and the first sheet within it.
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = ss.getSheets()[0];
  Logger.log('Connected to spreadsheet: ' + ss.getName());
  Logger.log('Active sheet is: ' + sheet.getName());

  // 2. Reference the Gmail service to trigger authorization.
  // This line simply confirms we can access the GmailApp object.
  const userEmail = GmailApp.getUserLabelByName(''); // A simple, harmless call.
  Logger.log('Successfully initialized GmailApp service.');
}

function setupInitialConnection() { // 1. Access the active spreadsheet and the first sheet within it. const ss = SpreadsheetApp.getActiveSpreadsheet(); const sheet = ss.getSheets()[0]; Logger.log('Connected to spreadsheet: ' + ss.getName()); Logger.log('Active sheet is: ' + sheet.getName()); // 2. Reference the Gmail service to trigger authorization. // This line simply confirms we can access the GmailApp object. const userEmail = GmailApp.getUserLabelByName(''); // A simple, harmless call. Logger.log('Successfully initialized GmailApp service.'); }