Skip to content

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

api-gateway

Verified

Connect to 100+ APIs (Google Workspace, Microsoft 365, Notion, Slack, Airtable, HubSpot, etc.) with managed OAuth. Use this skill when users want to interact with external services. Security: The MATON_API_KEY authenticates with Maton.ai but grants NO access to third-party services by itself. Each service requires explicit OAuth authorization by the user through Maton's connect flow. Access is strictly scoped to connections the user has authorized. Provided by Maton (https://maton.ai).

FileKindSize
LICENSE.txtmarkdown1.0 KB
SKILL.mdskill md27.5 KB
_meta.jsonconfig293 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.mdmarkdown5.1 KB
references/google-forms.mdmarkdown4.1 KB
references/google-mail.mdmarkdown3.6 KB
references/google-meet.mdmarkdown2.7 KB
references/google-merchant.mdmarkdown5.0 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.mdmarkdown5.4 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-teams.mdmarkdown5.9 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-bookings.mdmarkdown3.1 KB
references/zoho-books.mdmarkdown3.1 KB
references/zoho-calendar.mdmarkdown2.8 KB
references/zoho-crm.mdmarkdown4.0 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)
rea-analysis-optimizationmorluto/reaOptimize REA providers and shared analysis workflows for agent context, latency, CPU, and memory while preserving correctness and Evidence. Use for analysis bottlenecks and cache or query design; CI/test-suite optimization belongs to rea-ci-tests-audit.Stars: 472kUpdated Claude CodeCodexVerifiedInstall
rea-ci-tests-auditmorluto/reaAudit REA CI and test suites for correctness, fixture drift, false passes, and measured performance; use for suite or workflow investigations and efficiency changes, rather than ordinary feature testing or a single test failure.Stars: 472kUpdated Claude CodeCodexVerifiedInstall
rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics.Stars: 472kUpdated Claude CodeCodexVerifiedInstall
ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first.Stars: 194kUpdated Claude CodeCodexVerifiedInstall