Skip to content

LeoYeAI/agent-master-skills / skills/api-gateway-1-0-31

api-gateway

Verified

API gateway for calling third-party APIs with managed OAuth connections, provided by Maton (https://maton.ai). Use this skill when users want to interact with external services like Slack, HubSpot, Salesforce, Google Workspace, Stripe, and more. Access is scoped to connections you explicitly authorize via OAuth - the API key alone does not grant access to any third-party service. Requires network access and valid Maton API key.

FileKindSize
LICENSE.txtmarkdown1.0 KB
SKILL.mdskill md27.1 KB
_meta.jsonconfig292 B
references/active-campaign.mdmarkdown3.2 KB
references/acuity-scheduling.mdmarkdown3.0 KB
references/airtable.mdmarkdown3.0 KB
references/apollo.mdmarkdown4.0 KB
references/asana.mdmarkdown2.7 KB
references/attio.mdmarkdown2.0 KB
references/basecamp.mdmarkdown2.8 KB
references/beehiiv.mdmarkdown2.6 KB
references/box.mdmarkdown2.8 KB
references/brevo.mdmarkdown3.7 KB
references/cal-com.mdmarkdown3.4 KB
references/calendly.mdmarkdown2.6 KB
references/callrail.mdmarkdown3.1 KB
references/chargebee.mdmarkdown5.5 KB
references/clickfunnels.mdmarkdown5.3 KB
references/clicksend.mdmarkdown2.3 KB
references/clickup.mdmarkdown2.9 KB
references/clio.mdmarkdown6.1 KB
references/clockify.mdmarkdown3.7 KB
references/coda.mdmarkdown3.6 KB
references/cognito-forms.mdmarkdown2.4 KB
references/companycam.mdmarkdown3.6 KB
references/confluence.mdmarkdown4.6 KB
references/constant-contact.mdmarkdown2.5 KB
references/dropbox-business.mdmarkdown2.7 KB
references/dropbox.mdmarkdown3.1 KB
references/elevenlabs.mdmarkdown1.8 KB
references/eventbrite.mdmarkdown4.2 KB
references/fathom.mdmarkdown1.9 KB
references/firebase.mdmarkdown3.1 KB
references/fireflies.mdmarkdown1.8 KB
references/getresponse.mdmarkdown2.8 KB
references/github.mdmarkdown2.5 KB
references/google-ads.mdmarkdown3.9 KB
references/google-analytics-admin.mdmarkdown5.7 KB
references/google-analytics-data.mdmarkdown4.2 KB
references/google-bigquery.mdmarkdown3.9 KB
references/google-calendar.mdmarkdown3.7 KB
references/google-classroom.mdmarkdown2.6 KB
references/google-contacts.mdmarkdown3.3 KB
references/google-docs.mdmarkdown2.9 KB
references/google-drive.mdmarkdown3.7 KB
references/google-forms.mdmarkdown4.1 KB
references/google-mail.mdmarkdown3.6 KB
references/google-meet.mdmarkdown2.7 KB
references/google-merchant.mdmarkdown2.7 KB
references/google-play.mdmarkdown3.8 KB
references/google-search-console.mdmarkdown3.8 KB
references/google-sheets.mdmarkdown6.0 KB
references/google-slides.mdmarkdown4.5 KB
references/google-tasks.mdmarkdown3.0 KB
references/google-workspace-admin.mdmarkdown4.6 KB
references/gumroad.mdmarkdown3.3 KB
references/hubspot.mdmarkdown9.8 KB
references/instantly.mdmarkdown3.0 KB
references/jira.mdmarkdown4.5 KB
references/jobber.mdmarkdown3.6 KB
references/jotform.mdmarkdown3.6 KB
references/keap.mdmarkdown3.1 KB
references/kit.mdmarkdown3.3 KB
references/klaviyo.mdmarkdown3.8 KB
references/lemlist.mdmarkdown2.4 KB
references/linear.mdmarkdown4.3 KB
references/linkedin.mdmarkdown6.0 KB
references/mailchimp.mdmarkdown4.1 KB
references/mailerlite.mdmarkdown4.0 KB
references/mailgun.mdmarkdown4.7 KB
references/manychat.mdmarkdown3.6 KB
references/microsoft-excel.mdmarkdown3.8 KB
references/microsoft-to-do.mdmarkdown3.6 KB
references/monday.mdmarkdown4.4 KB
references/motion.mdmarkdown2.7 KB
references/netlify.mdmarkdown3.6 KB
references/notion.mdmarkdown7.9 KB
references/one-drive.mdmarkdown2.3 KB
references/outlook.mdmarkdown4.1 KB
references/pdf-co.mdmarkdown5.0 KB
references/pipedrive.mdmarkdown3.0 KB
references/podio.mdmarkdown3.2 KB
references/quickbooks.mdmarkdown11.1 KB
references/quo.mdmarkdown2.9 KB
references/salesforce.mdmarkdown6.6 KB
references/sendgrid.mdmarkdown2.9 KB
references/signnow.mdmarkdown1.8 KB
references/slack.mdmarkdown3.8 KB
references/snapchat.mdmarkdown2.7 KB
references/squareup.mdmarkdown4.8 KB
references/stripe.mdmarkdown7.4 KB
references/systeme.mdmarkdown3.4 KB
references/tally.mdmarkdown3.0 KB
references/telegram.mdmarkdown3.3 KB
references/ticktick.mdmarkdown2.5 KB
references/todoist.mdmarkdown2.7 KB
references/toggl-track.mdmarkdown3.7 KB
references/trello.mdmarkdown3.5 KB
references/twilio.mdmarkdown3.7 KB
references/typeform.mdmarkdown5.0 KB
references/vimeo.mdmarkdown2.2 KB
references/whatsapp-business.mdmarkdown4.9 KB
references/woocommerce.mdmarkdown6.9 KB
references/wordpress.mdmarkdown3.2 KB
references/xero.mdmarkdown5.9 KB
references/youtube.mdmarkdown4.0 KB
references/zoho-bigin.mdmarkdown2.3 KB
references/zoho-books.mdmarkdown3.1 KB
references/zoho-calendar.mdmarkdown2.8 KB
references/zoho-crm.mdmarkdown2.7 KB
references/zoho-inventory.mdmarkdown5.6 KB
references/zoho-mail.mdmarkdown3.9 KB
references/zoho-people.mdmarkdown3.5 KB
references/zoho-recruit.mdmarkdown3.5 KB

references/google-sheets.md

View on GitHub
# Google Sheets Routing Reference

**App name:** `google-sheets`
**Base URL proxied:** `sheets.googleapis.com`

## API Path Pattern

```
/google-sheets/v4/spreadsheets/{spreadsheetId}/{endpoint}
```

## Common Endpoints

### Get Spreadsheet Metadata
```bash
GET /google-sheets/v4/spreadsheets/{spreadsheetId}
```

### Get Values
```bash
GET /google-sheets/v4/spreadsheets/{spreadsheetId}/values/{range}
```

Example:
```bash
GET /google-sheets/v4/spreadsheets/SHEET_ID/values/Sheet1!A1:D10
```

### Get Multiple Ranges
```bash
GET /google-sheets/v4/spreadsheets/{spreadsheetId}/values:batchGet?ranges=Sheet1!A1:B10&ranges=Sheet2!A1:C5
```

### Update Values
```bash
PUT /google-sheets/v4/spreadsheets/{spreadsheetId}/values/{range}?valueInputOption=USER_ENTERED
Content-Type: application/json

{
  "values": [
    ["A1", "B1", "C1"],
    ["A2", "B2", "C2"]
  ]
}
```

### Append Values
```bash
POST /google-sheets/v4/spreadsheets/{spreadsheetId}/values/{range}:append?valueInputOption=USER_ENTERED
Content-Type: application/json

{
  "values": [
    ["New Row 1", "Data", "More Data"],
    ["New Row 2", "Data", "More Data"]
  ]
}
```

### Batch Update Values
```bash
POST /google-sheets/v4/spreadsheets/{spreadsheetId}/values:batchUpdate
Content-Type: application/json

{
  "valueInputOption": "USER_ENTERED",
  "data": [
    {"range": "Sheet1!A1:B2", "values": [["A1", "B1"], ["A2", "B2"]]},
    {"range": "Sheet1!D1:E2", "values": [["D1", "E1"], ["D2", "E2"]]}
  ]
}
```

### Clear Values
```bash
POST /google-sheets/v4/spreadsheets/{spreadsheetId}/values/{range}:clear
```

### Create Spreadsheet
```bash
POST /google-sheets/v4/spreadsheets
Content-Type: application/json

{
  "properties": {"title": "New Spreadsheet"},
  "sheets": [{"properties": {"title": "Sheet1"}}]
}
```

### Batch Update (formatting, add sheets, etc.)
```bash
POST /google-sheets/v4/spreadsheets/{spreadsheetId}:batchUpdate
Content-Type: application/json

{
  "requests": [
    {"addSheet": {"properties": {"title": "New Sheet"}}}
  ]
}
```

## Common batchUpdate Requests

See [full list of request types](https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/request).

### Update Cells with Formatting
```json
{
  "updateCells": {
    "rows": [
      {"values": [{"userEnteredValue": {"stringValue": "Name"}}, {"userEnteredValue": {"numberValue": 100}}]}
    ],
    "fields": "userEnteredValue",
    "start": {"sheetId": 0, "rowIndex": 0, "columnIndex": 0}
  }
}
```

### Format Header Row (Bold + Background Color)
```json
{
  "repeatCell": {
    "range": {"sheetId": 0, "startRowIndex": 0, "endRowIndex": 1, "startColumnIndex": 0, "endColumnIndex": 3},
    "cell": {
      "userEnteredFormat": {
        "backgroundColor": {"red": 0.2, "green": 0.6, "blue": 0.9},
        "textFormat": {"bold": true}
      }
    },
    "fields": "userEnteredFormat(backgroundColor,textFormat)"
  }
}
```

### Auto-Resize Columns
```json
{
  "autoResizeDimensions": {
    "dimensions": {"sheetId": 0, "dimension": "COLUMNS", "startIndex": 0, "endIndex": 3}
  }
}
```

### Rename Sheet
```json
{
  "updateSheetProperties": {
    "properties": {"sheetId": 0, "title": "NewName"},
    "fields": "title"
  }
}
```

### Insert Rows/Columns
```json
{
  "insertDimension": {
    "range": {"sheetId": 0, "dimension": "ROWS", "startIndex": 1, "endIndex": 3},
    "inheritFromBefore": true
  }
}
```

### Sort Range
```json
{
  "sortRange": {
    "range": {"sheetId": 0, "startRowIndex": 1, "endRowIndex": 10, "startColumnIndex": 0, "endColumnIndex": 3},
    "sortSpecs": [{"dimensionIndex": 1, "sortOrder": "DESCENDING"}]
  }
}
```

### Add Conditional Formatting
```json
{
  "addConditionalFormatRule": {
    "rule": {
      "ranges": [{"sheetId": 0, "startRowIndex": 1, "endRowIndex": 10, "startColumnIndex": 1, "endColumnIndex": 2}],
      "booleanRule": {
        "condition": {"type": "NUMBER_GREATER_THAN_EQ", "values": [{"userEnteredValue": "90"}]},
        "format": {"backgroundColor": {"red": 0.7, "green": 1, "blue": 0.7}}
      }
    },
    "index": 0
  }
}
```

### Add Filter
```json
{
  "setBasicFilter": {
    "filter": {
      "range": {"sheetId": 0, "startRowIndex": 0, "endRowIndex": 100, "startColumnIndex": 0, "endColumnIndex": 5}
    }
  }
}
```

### Delete Sheet
```json
{
  "deleteSheet": {"sheetId": 123456789}
}
```

## Value Input Options

- `RAW` - Values are stored as-is
- `USER_ENTERED` - Values are parsed as if typed into the UI (formulas executed, numbers parsed)

## Range Notation

- `Sheet1!A1:D10` - Specific range
- `Sheet1!A:D` - Entire columns A through D
- `Sheet1!1:10` - Entire rows 1 through 10
- `Sheet1` - Entire sheet
- `A1:D10` - Range in first sheet

## Notes

- Authentication is automatic - the router injects the OAuth token
- Range in URL path must be URL-encoded (`!` → `%21`, `:` → `%3A`)
- Use `valueInputOption=USER_ENTERED` to parse formulas and numbers
- Delete spreadsheets via Google Drive API

## Resources

- [API Overview](https://developers.google.com/workspace/sheets/api/reference/rest)
- [Get Spreadsheet](https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/get)
- [Create Spreadsheet](https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/create)
- [Batch Update](https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/batchUpdate)
- [Batch Update Request Types](https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/request)
- [Get Values](https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/get)
- [Update Values](https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/update)
- [Append Values](https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/append)
- [Batch Get Values](https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/batchGet)
- [Batch Update Values](https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/batchUpdate)
- [Clear Values](https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/clear)
reverse-engineer-anythingmorluto/reaReverse engineer native, managed, Electron/JavaScript, packaged, firmware, and browser targets with REA, and build agent environments (AgentEnv bundles) of web applications from a live instance or a capture, and of Linux desktop apps with a task from a request. Use shipped-artifact or requested runtime evidence to explain features, compare versions, decompile code, or guide a reconstruction. Skip REA for ordinary source-repository architecture analysis.Stars: 472kUpdated Claude CodeCodexVerifiedInstall
diagnosing-superpowersobra/superpowersUse when a superpowers session went wrong and your human partner wants to know why — repeated work, ignored plans, stumbles, poor results, a skill that didn't fire, "it took too long", "why is it so expensive", "what is it doing" — or wants to build a bug report for the superpowers maintainers, for the current session or a past one identified by id or path, on any harness.Stars: 322kUpdated Claude CodeCodexVerifiedInstall
dispatching-parallel-agentsobra/superpowersUse when facing 2+ independent tasks that can be worked on without shared state or sequential dependenciesStars: 322kUpdated Claude CodeCodexVerifiedInstall
executing-plansobra/superpowersUse when executing an implementation plan in the current session as the implementer yourself — your human partner chose inline execution, or no subagent tool is availableStars: 322kUpdated Claude CodeCodexVerifiedInstall