gigasheet

# Gigasheet

Gigasheet is a big data spreadsheet that allows users to analyze billions of rows of data without code. It's used by data analysts, marketers, and researchers who need to work with large datasets that exceed the limits of traditional spreadsheets.

Official docs: https://gigasheet.com/docs

## Gigasheet Overview

- **Workbooks**
  - **Columns**
  - **Filters**
  - **Sheets**
- **Views**
- **Exports**
- **Imports**
- **API Keys**

## Working with Gigasheet

This skill uses the Membrane CLI to interact with Gigasheet. Membrane handles authentication and credentials refresh automatically — so you can focus on the integration logic rather than auth plumbing.

### Install the CLI

Install the Membrane CLI so you can run `membrane` from the terminal:

```bash
npm install -g @membranehq/cli
```

### First-time setup

```bash
membrane login --tenant
```

A browser window opens for authentication.

**Headless environments:** Run the command, copy the printed URL for the user to open in a browser, then complete with `membrane login complete <code>`.

### Connecting to Gigasheet

1. **Create a new connection:**
   ```bash
   membrane search gigasheet --elementType=connector --json
   ```
   Take the connector ID from `output.items[0].element?.id`, then:
   ```bash
   membrane connect --connectorId=CONNECTOR_ID --json
   ```
   The user completes authentication in the browser. The output contains the new connection id.

### Getting list of existing connections
When you are not sure if connection already exists:
1. **Check existing connections:**
   ```bash
   membrane connection list --json
   ```
   If a Gigasheet connection exists, note its `connectionId`


### Searching for actions

When you know what you want to do but not the exact action ID:

```bash
membrane action list --intent=QUERY --connectionId=CONNECTION_ID --json
```
This will return action objects with id and inputSchema in it, so you will know how to run it.


## Popular actions

| Name | Key | Desc...