googleapis-sheets

Reads and writes Google Sheets.

Package Information

Released: 4 mo ago
Downloads: 18 weekly / 109 monthly
Latest Version: 1.0.0
Author: kelvinzer0

Available Nodes

Documentation generating…

Googleapis Sheets icon
Googleapis Sheets
Reads and writes Google Sheets.

Documentation

@n8n-dev/n8n-nodes-googleapis-sheets

googleapis-sheets Banner

npm version
License: MIT

Stop writing googleapis-sheets API integrations by hand.

Every time you connect n8n to googleapis-sheets, you waste hours mapping endpoints, defining parameters, and debugging schemas. You copy-paste from docs, fix edge cases, and pray nothing breaks.

What if connecting n8n to googleapis-sheets took 5 minutes, not half a day?

This node gives you 1+ resources out of the box: Spreadsheets: with full CRUD operations, typed parameters, and zero manual configuration.

What You Get

  • Zero boilerplate: Resources, operations, and fields are pre-configured and ready to use
  • Full CRUD: Create, read, update, and delete support where the API allows it
  • Typed parameters: No more guessing field types
  • Built-in auth: API key authentication, ready to go
  • Declarative: Native n8n performance, no custom execute() overhead

Install

npm install @n8n-dev/n8n-nodes-googleapis-sheets

Or in n8n:

  1. Settings → Community Nodes → Install
  2. Search: @n8n-dev/n8n-nodes-googleapis-sheets
  3. Click Install

Quick Start

  1. Install the node (above)
  2. Add credentials: googleapis-sheets API → paste your API key
  3. Drag the googleapis-sheets node into your workflow
  4. Pick a resource → pick an operation → done.

That's it. No configuration files. No code. It just works.

Resources

Spreadsheets (17 operations)
  • Post Sheets Spreadsheets Create
  • Get Sheets Spreadsheets Get
  • Get Sheets Spreadsheets Developer Metadata Get
  • Post Sheets Spreadsheets Developer Metadata Search
  • Post Sheets Spreadsheets Sheets Copy To
  • Get Sheets Spreadsheets Values Get
  • Put Sheets Spreadsheets Values Update
  • Post Sheets Spreadsheets Values Append
  • Post Sheets Spreadsheets Values Clear
  • Post Sheets Spreadsheets Values Batch Clear
  • Post Sheets Spreadsheets Values Batch Clear By Data Filter
  • Get Sheets Spreadsheets Values Batch Get
  • Post Sheets Spreadsheets Values Batch Get By Data Filter
  • Post Sheets Spreadsheets Values Batch Update
  • Post Sheets Spreadsheets Values Batch Update By Data Filter
  • Post Sheets Spreadsheets Batch Update
  • Post Sheets Spreadsheets Get By Data Filter

Why This Node?

Without this node:

  • Hours of manual API integration
  • Copy-pasting from googleapis-sheets docs
  • Debugging auth, pagination, error handling
  • Maintaining your own client code

With this node:

  • Install → configure → use. 5 minutes.
  • Auto-generated from the official googleapis-sheets OpenAPI spec
  • Always up to date when the API changes
  • Native n8n performance

Auto-Generated

This node was auto-generated from the official googleapis-sheets OpenAPI specification using
@n8n-dev/n8n-openapi-node-ultimate,
then validated against the live API so you get accurate types and real parameters, not guesswork.

When the googleapis-sheets API updates, this node updates too.

Support This Project

If this node saved you hours of work, consider supporting continued development, new APIs, better error handling, and faster updates.

Keep It Moving.

License

MIT © kelvinzer0

Discussion