google-workspace-integration

Google Workspace Integration Skill

This skill enables generation of professional tax optimization reports and direct communication with accountants using Google Workspace products.

Capabilities

Authentication

Required Google Cloud APIs

- Gmail API
- Google Docs API
- Google Sheets API
- Google Drive API

OAuth 2.0 Scopes

const GOOGLE_SCOPES = [
  'https://www.googleapis.com/auth/gmail.send',
  'https://www.googleapis.com/auth/gmail.compose',
  'https://www.googleapis.com/auth/documents',
  'https://www.googleapis.com/auth/spreadsheets',
  'https://www.googleapis.com/auth/drive.file'
];

Environment Variables

GOOGLE_CLIENT_ID=your_client_id
GOOGLE_CLIENT_SECRET=your_client_secret
GOOGLE_REDIRECT_URI=http://localhost:3000/api/auth/google/callback

Report Templates

1. Tax Optimization Summary Report (Google Docs)

# Tax Optimization Report for [Business Name]
## Prepared by ATO Tax Optimization Suite
## Date: [Current Date]

---

## Executive Summary
[Auto-generated summary of findings and total potential recovery]

---

## Section 1: R&D Tax Incentive (Division 355 ITAA 1997)

### Findings
- [List of identified R&D activities]

### Potential Benefit
- Eligible expenditure: $X
- Refundable offset (43.5%): $Y

### Legislation Reference
> Division 355 of the Income Tax Assessment Act 1997
> ATO Guidance: Guide to the R&D Tax Incentive

### Action Required
☐ Review identified activities with tax advisor
☐ Prepare registration with AusIndustry
☐ Document contemporaneous records

---

## Section 2: Bad Debt Recovery (Section 25-35 ITAA 1997)

### Findings
- [List of identified bad debts]

### Potential Benefit
- Total bad debts: $X
- Income tax deduction value: $Y
- GST recovery (Division 21): $Z

### Legislation Reference
> Section 25-35 ITAA 1997 - Bad debts
> Division 21 GST Act 1999 - Bad debt adjustments
> GSTR 2000/2 - GST and bad debts

### Action Required
☐ Document write-off decisions before June 30
☐ Process credit notes in Xero
☐ Include GST adjustment in next BAS

---

## Section 3: Loss Carry-Forward Analysis

### Findings
- Accumulated losses: $X
- Similar Business Test status: [PASS/UNCERTAIN/FAIL]

### Potential Benefit
- Loss utilization value: $X × tax rate = $Y

### Legislation Reference
> Division 36 ITAA 1997 - Tax losses
> Division 165/166 ITAA 1997 - Company loss tests
> LCR 2019/1 - Similar Business Test

### Action Required
☐ Consider private ruling if losses significant
☐ Document business evolution for SiBT
☐ Coordinate with tax return lodgment

---

## Section 4: ATO Payment Negotiation

### Current Position
- Outstanding debt: $X
- Less: Recoverable amounts: $Y
- Net position: $Z

### Recommended Approach
[Auto-generated based on net position]

### Legislation Reference
> Taxation Administration Act 1953
> ATO Payment Plan Guidelines

### Action Required
☐ Lodge all outstanding returns
☐ Compile financial hardship documentation
☐ Contact ATO or engage tax advisor

---

## Appendix A: Complete Findings List
[Detailed itemized list]

## Appendix B: Xero Transaction References
[List of relevant Xero transactions]

## Appendix C: Legislation Quick Reference
[All legislation citations in one place]

---

**IMPORTANT DISCLAIMER**
This report is generated by an AI-assisted analysis tool and is provided for 
informational purposes only. All recommendations should be reviewed by a 
Registered Tax Agent or qualified accountant before implementation.

---
Generated by ATO Tax Optimization Suite
[Timestamp]

2. Financial Summary Spreadsheet (Google Sheets)

Sheet 1: Executive Summary

Sheet 2: R&D Activities

Sheet 3: Bad Debts

Sheet 4: Loss History

Sheet 5: ATO Position

3. Email Template (Gmail)

Subject: Tax Optimization Analysis - [Business Name] - Action Required

Dear [Accountant Name],

I have conducted a comprehensive tax optimization analysis using the ATO Tax 
Optimization Suite and identified several opportunities that require your 
professional review.

SUMMARY OF FINDINGS:
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

TOTAL POTENTIAL RECOVERY: $[AMOUNT]

Key Opportunities Identified:

1. R&D Tax Incentive (Division 355 ITAA 1997)
   Potential benefit: $[X]
   ⚠️ Registration deadline: [DATE]

2. Bad Debt Deductions (Section 25-35 ITAA 1997)
   Potential benefit: $[X]
   ⚠️ Write-off deadline: June 30

3. Loss Carry-Forward (Division 36 ITAA 1997)
   Potential benefit: $[X]
   ⚠️ Similar Business Test requires review

4. ATO Payment Negotiation
   Current debt: $[X]
   Net after offsets: $[Y]

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

ATTACHMENTS:
- Tax_Optimization_Report.pdf (Full report with legislation references)
- Financial_Summary.xlsx (Detailed calculations)

ACTION REQUIRED:
Please review the attached documents and advise on:
1. Eligibility for the identified benefits
2. Any additional information required
3. Next steps for implementation
4. ATO engagement strategy (if applicable)

I would appreciate the opportunity to discuss these findings at your earliest 
convenience.

Best regards,
[Name]
[Business Name]
[Contact Details]

---
This analysis was prepared using the ATO Tax Optimization Suite.
All recommendations require professional review before implementation.

API Implementation

Google Docs Report Generation

import { google } from 'googleapis';

async function generateTaxReport(auth: any, reportData: TaxReportData) {
  const docs = google.docs({ version: 'v1', auth });
  
  // Create new document
  const createResponse = await docs.documents.create({
    requestBody: {
      title: `Tax Optimization Report - ${reportData.businessName} - ${reportData.date}`
    }
  });
  
  const documentId = createResponse.data.documentId;
  
  // Insert content using batchUpdate
  await docs.documents.batchUpdate({
    documentId,
    requestBody: {
      requests: generateReportRequests(reportData)
    }
  });
  
  return documentId;
}

Google Sheets Financial Summary

async function generateFinancialSpreadsheet(auth: any, data: FinancialData) {
  const sheets = google.sheets({ version: 'v4', auth });
  
  // Create new spreadsheet
  const createResponse = await sheets.spreadsheets.create({
    requestBody: {
      properties: {
        title: `Tax Analysis - ${data.businessName} - ${data.date}`
      },
      sheets: [
        { properties: { title: 'Executive Summary' } },
        { properties: { title: 'R&D Activities' } },
        { properties: { title: 'Bad Debts' } },
        { properties: { title: 'Loss History' } },
        { properties: { title: 'ATO Position' } }
      ]
    }
  });
  
  const spreadsheetId = createResponse.data.spreadsheetId;
  
  // Populate data
  await sheets.spreadsheets.values.batchUpdate({
    spreadsheetId,
    requestBody: {
      valueInputOption: 'USER_ENTERED',
      data: generateSheetData(data)
    }
  });
  
  return spreadsheetId;
}

Gmail Send with Attachments

async function sendToAccountant(auth: any, emailData: EmailData) {
  const gmail = google.gmail({ version: 'v1', auth });
  
  const message = createMimeMessage({
    to: emailData.accountantEmail,
    subject: `Tax Optimization Analysis - ${emailData.businessName}`,
    body: generateEmailBody(emailData),
    attachments: emailData.attachments
  });
  
  await gmail.users.messages.send({
    userId: 'me',
    requestBody: {
      raw: Buffer.from(message).toString('base64url')
    }
  });
}

Integration with Agent Fleet

Workflow Integration

The Google Workspace skill integrates with all agents:

<report_generation>
  <sources>
    <agent>rnd_tax_specialist</agent>
    <agent>bad_debt_recovery_agent</agent>
    <agent>business_transition_agent</agent>
    <agent>loss_recovery_agent</agent>
  </sources>
  <outputs>
    <google_doc>Full report with legislation</google_doc>
    <google_sheet>Financial calculations</google_sheet>
    <gmail>Direct to accountant</gmail>
  </outputs>
</report_generation>

Usage

Generate and Send Report

/send-to-accountant

This command will:

1. Compile all findings from recent analyses
2. Generate Google Doc report with legislation references
3. Generate Google Sheet with financial calculations
4. Send via Gmail to configured accountant email

Configuration

<accountant_config>
  <name>Your Accountant Name</name>
  <email>accountant@example.com</email>
  <firm>Accounting Firm Name</firm>
  <cc_emails>
    <email>your@email.com</email>
  </cc_emails>
</accountant_config>