skills.rest
NEXUZ-SYS
NEXUZ-SYSOFFICIAL
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/NEXUZ-SYS/nxz-tutorial-agents --skill google-sheets-nexuz-sys
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Finance & Accounting Skills→
PinpongTpPinpongTp

google-sheets

Read and write Google Sheets data with OAuth authentication.

Community
Intermediate
8GG-Git8GG-Git

reconciliation

Compare general ledger balances against subledgers and bank statements.

Community
Intermediate
rezosndrezosnd

excel-generator

Generate styled Excel workbooks with formulas, charts, and data validation.

Community
Intermediate
vpoduguvpodugu
17

startup-bookkeeper

Log financial transactions via natural language and generate reports.

Community
Intermediate