google_workspace_integration_skill

Overview

This skill integrates with Google Workspace to generate professional tax optimization reports in Google Docs, structured financial spreadsheets in Google Sheets, and to send those outputs via Gmail to accountants. It automates document creation, populates legislation references and action items, and stores files in Google Drive for organized access.

How this skill works

The skill uses Google Docs API to create a narrative Tax Optimization Report with sections for R&D, bad debts, loss carry-forward, ATO negotiation and appendices. It uses Google Sheets API to build multi-sheet financial summaries and calculations, then uploads both artifacts to Google Drive. Finally, it constructs a MIME email and sends it through the Gmail API to designated accountant contacts with attachments and an action-oriented cover message.

When to use it

• When you need a formal tax report with legislation citations prepared for your accountant.
• When summarizing potential tax recoveries and prioritizing action items across R&D, bad debts and loss carry-forward.
• When you want a repeatable spreadsheet of calculations and source references exported to Google Sheets.
• When you need to quickly email a consolidated package to an accountant with attachments and next steps.
• When centralizing tax documents and reports in Google Drive for audit-ready organization.

Best practices

• Authorize with OAuth scopes for Docs, Sheets, Drive and Gmail and store credentials securely in environment variables.
• Validate financial inputs and flagged items before generating the final report to avoid inaccurate claims.
• Include a clear disclaimer and request professional review from a Registered Tax Agent in every report.
• Use template sections for legislation references and action checklists so outputs are consistent and auditable.
• Keep Drive folder structure predictable (e.g., BusinessName/Year/TaxReports) for easy retrieval and sharing.

Example use cases

• Produce a Tax Optimization Report for a small business showing R&D incentives and suggested registrations.
• Generate a Finance Summary spreadsheet with detailed bad debt items and GST adjustments for accountant review.
• Send a consolidated package (Doc + Sheet) to an external tax advisor with an explicit action list and deadlines.
• Create archival copies of each report in a Drive folder tied to client and financial year for compliance records.
• Automate recurring monthly or quarterly scans to surface new write-offs or changing ATO positions for follow-up.