Google Sheets

Read Google Sheets ranges via MCP and normalize dates and currency.

Updated Mar 24, 2026

Search Tags:#integration #oauth #mcp #finance #data-extraction #google-sheets #data-normalization

Ready to run

npx skills add https://github.com/NEXUZ-SYS/nxz-tutorial-agents --skill google-sheets-nexuz-sys

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: Google Sheets
Source: https://github.com/NEXUZ-SYS/nxz-tutorial-agents/tree/main/skills/google_sheets
Command: npx skills add https://github.com/NEXUZ-SYS/nxz-tutorial-agents --skill google-sheets-nexuz-sys

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Automates secure access to financial data stored in Google Sheets via MCP, eliminating manual extraction and reducing errors in reporting.

Core Features & Use Cases

Read and ingest data: Retrieve ranges across multiple sheets from Google Sheets using MCP.
Data normalization: Normalize dates to ISO 8601 and convert monetary values to numeric formats.
Use Case: Reconcile Interbank statements and accounts payable data by importing into financial dashboards.

Quick Start

Ask the agent to fetch and normalize the latest Banco Inter statements from Google Sheets via MCP.

Frequently Asked Questions about Google Sheets

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I read specific ranges from Google Sheets via MCP?▼

To normalize dates in Google Sheets data via MCP, the system automatically converts dates to ISO 8601 format. This ensures data consistency and accuracy when importing financial records like Inter bank statements into reporting dashboards.

Can I parse currency values from Google Sheets for accounts payable?▼

Yes, you can parse currency values from Google Sheets for accounts payable. The system converts monetary values into numeric formats during data extraction, ensuring financial data is ready for validation and reconciliation tasks.

Do I need OAuth authentication to extract financial data from Google Sheets?▼

Yes, OAuth authentication is required to extract financial data from Google Sheets via MCP. It secures access to Nexuz financial spreadsheets and enables robust data validation to ensure data completeness and accuracy.

What is the best way to reconcile Inter bank statements from Google Sheets?▼

The best way to reconcile Inter bank statements from Google Sheets is to use MCP for data extraction and normalization. This automates secure access to financial data, eliminates manual extraction, and reduces reporting errors.

Does data normalization via MCP handle multiple sheets for financial dashboards?▼

Yes, data normalization via MCP handles multiple sheets for financial dashboards. It retrieves ranges across various sheets, normalizes dates to ISO 8601, and parses monetary values to ensure dashboard data completeness and accuracy.