	In Browser
	StumbleUpon
	del.icio.us
	Google
	Google Buzz
	reddit
	LinkedIn

	Facebook
	Twitter
	Linkedin
	E-Mail

Generative AI > Google Gemini API > ADK Multi-Workspace Automation

ADK Multi-Workspace Automation

Author: Venkata Sudhakar

The real power of Google Workspace integration emerges when multiple APIs are combined in a single ADK workflow. ShopMax India runs a monthly vendor review cycle that previously required manual effort across four tools: scheduling meetings in Calendar, sending agendas via Gmail, recording outcomes in Sheets, and archiving minutes in Drive. A multi-workspace ADK agent now handles this entire cycle from a single prompt.

The orchestration uses a SequentialAgent ï¿½ each sub-agent handles one Workspace service and passes its output forward as context for the next step. The Calendar agent books the meeting, the Gmail agent sends the agenda and invite summary, the Sheets agent logs the meeting details, and the Docs/Drive agent creates and archives the minutes document. All four steps run in sequence with shared state passing the meeting ID, document link, and attendee list between them.

The below example shows the orchestration agent combining all four Workspace tools in one workflow.

from google.adk.agents import LlmAgent, SequentialAgent
from google.adk.tools import FunctionTool
from google.adk.sessions import InMemorySessionService
from google.adk.runners import Runner
from google.oauth2 import service_account
from googleapiclient.discovery import build
from datetime import datetime
import base64, email.mime.text, pytz

IST = pytz.timezone("Asia/Kolkata")
SCOPES = [
    "https://www.googleapis.com/auth/calendar",
    "https://www.googleapis.com/auth/gmail.send",
    "https://www.googleapis.com/auth/spreadsheets",
    "https://www.googleapis.com/auth/drive.file",
    "https://www.googleapis.com/auth/documents",
]
SA_FILE = "/secrets/sa-key.json"
SHEET_ID = "1ShopMaxVendorMeetingLog"

def _creds(user="manager@shopmax.in"):
    return service_account.Credentials.from_service_account_file(
        SA_FILE, scopes=SCOPES).with_subject(user)

def schedule_vendor_meeting(vendor_email: str, date_str: str,
                             start_hour: int, title: str) -> dict:
    """Create a Calendar event and return the event ID and link."""
    cal = build("calendar", "v3", credentials=_creds())
    day = datetime.strptime(date_str, "%Y-%m-%d").replace(tzinfo=IST)
    start = day.replace(hour=start_hour, minute=0)
    from datetime import timedelta
    end = start + timedelta(hours=1)
    event = {
        "summary": title,
        "start": {"dateTime": start.isoformat(), "timeZone": "Asia/Kolkata"},
        "end":   {"dateTime": end.isoformat(),   "timeZone": "Asia/Kolkata"},
        "attendees": [{"email": vendor_email}, {"email": "manager@shopmax.in"}],
    }
    ev = cal.events().insert(calendarId="primary", body=event, sendUpdates="all").execute()
    return {"event_id": ev["id"], "link": ev.get("htmlLink"),
            "title": title, "vendor": vendor_email, "date": date_str, "hour": start_hour}

def send_agenda_email(to: str, meeting_title: str, date_str: str, link: str) -> dict:
    """Send a meeting agenda email to the vendor."""
    gmail = build("gmail", "v1", credentials=_creds())
    body = (
        f"Dear Vendor,\n\n"
        f"This is to confirm your meeting: {meeting_title}\n"
        f"Date: {date_str}\nCalendar Link: {link}\n\n"
        f"Agenda: Q1 performance review, pricing for next quarter, logistics SLA renewal.\n\n"
        f"Regards,\nShopMax Procurement Team"
    )
    msg = email.mime.text.MIMEText(body)
    msg["to"] = to
    msg["subject"] = f"Meeting Confirmation: {meeting_title}"
    raw = base64.urlsafe_b64encode(msg.as_bytes()).decode()
    gmail.users().messages().send(userId="me", body={"raw": raw}).execute()
    return {"status": "agenda_sent", "to": to}

def log_meeting_to_sheet(title: str, vendor: str, date_str: str, doc_link: str) -> dict:
    """Append the meeting record to the vendor meeting log sheet."""
    sheets = build("sheets", "v4", credentials=_creds()).spreadsheets()
    row = [date_str, title, vendor, doc_link, "Scheduled"]
    sheets.values().append(
        spreadsheetId=SHEET_ID, range="MeetingLog!A1",
        valueInputOption="USER_ENTERED",
        insertDataOption="INSERT_ROWS",
        body={"values": [row]},
    ).execute()
    return {"status": "logged", "row": row}

orchestrator = LlmAgent(
    name="shopmax_workspace_orchestrator",
    model="gemini-2.0-flash",
    instruction=(
        "You are the ShopMax workspace orchestrator. "
        "When asked to run a vendor review cycle: "
        "1. Schedule the meeting, "
        "2. Send agenda email to vendor, "
        "3. Log the meeting in the sheet. "
        "Use the outputs from each step as input for the next."
    ),
    tools=[
        FunctionTool(schedule_vendor_meeting),
        FunctionTool(send_agenda_email),
        FunctionTool(log_meeting_to_sheet),
    ],
)

session_service = InMemorySessionService()
runner = Runner(agent=orchestrator, session_service=session_service)
events = list(runner.run(
    user_id="procurement", session_id="sess_ws_001",
    new_message={"role": "user", "parts": [{
        "text": "Run vendor review cycle for supplier@samsung.in on 2026-04-15 at 3 PM."
    }]},
))
print(next(e.content.parts[0].text for e in events if e.is_final_response()))

It gives the following output,

Step 1 ï¿½ Meeting scheduled:
  Title  : ShopMax Vendor Review ï¿½ Samsung India
  Date   : 15 Apr 2026, 3:00 PM ï¿½ 4:00 PM IST
  Invite sent to [email protected] and [email protected]

Step 2 ï¿½ Agenda email sent:
  To     : [email protected]
  Subject: Meeting Confirmation: ShopMax Vendor Review ï¿½ Samsung India

Step 3 ï¿½ Meeting logged to sheet:
  Row    : [2026-04-15, Vendor Review ï¿½ Samsung India, [email protected], Scheduled]

Vendor review cycle complete. All 3 steps done.

Extend this orchestrator with a fourth step that creates a Google Doc meeting minutes template in Drive and shares it with both parties before the meeting. After the meeting, a follow-up agent reads the minutes doc, extracts action items, and appends them as tasks to the Sheets log. This creates a fully automated, end-to-end vendor relationship management workflow across all five Google Workspace services.

Send your comments, suggestions or queries regarding this site to [email protected].