Google Sheets

Connect Google Sheets once, then provision a log a row action as a skill. The agent collects fields from the caller and appends a row to the tab you choose — a lead log, an order record, a callback list. Mapping is config, not code.

Connect

Google Sheets uses OAuth. Begin the connect, then finish consent in a browser.

curl -X POST https://builder.flowyte.com/api/v1/integrations/google_sheets/connect \
  -H "Authorization: Bearer flowyte_sk_…"
# → { "data": { "oauthUrl": "https://…" } }   # open this in a browser to grant access

The browser-only callback completes the connection; it cannot be finished with an API key. After consent, GET /integrations lists google_sheets as connected.

Resolve the target sheet

Before you map columns, confirm the connected account can read the spreadsheet. Pass a Sheets URL or bare id as ref and get back the title, its tabs, and each tab’s header row — so you map captured params to the real column names.

curl -G https://builder.flowyte.com/api/v1/integrations/google_sheets/spreadsheet \
  -H "Authorization: Bearer flowyte_sk_…" \
  --data-urlencode "ref=https://docs.google.com/spreadsheets/d/SHEET_ID/edit"

This read-only helper uses only the granted spreadsheet scope. A 409 integration_not_connected means Sheets isn’t connected; a 404 sheet_not_accessible means the link is wrong or the file isn’t shared with the connected account.

Provision the skill

List the actions, then provision onto an agent. The column mapping is part of the skill’s config — finish it in the dashboard if the action lands as a draft.

curl https://builder.flowyte.com/api/v1/integrations/google_sheets/actions \
  -H "Authorization: Bearer flowyte_sk_…"

curl -X POST \
  https://builder.flowyte.com/api/v1/agents/AGENT_ID/integrations/google_sheets/provision \
  -H "Authorization: Bearer flowyte_sk_…" \
  -H "Content-Type: application/json" \
  -d '{ "actions": ["append_row"] }'

await fetch(
  "https://builder.flowyte.com/api/v1/agents/AGENT_ID/integrations/google_sheets/provision",
  {
    method: "POST",
    headers: {
      Authorization: "Bearer flowyte_sk_…",
      "Content-Type": "application/json",
    },
    body: JSON.stringify({ actions: ["append_row"] }),
  },
);

import requests

requests.post(
    "https://builder.flowyte.com/api/v1/agents/AGENT_ID/integrations/google_sheets/provision",
    headers={"Authorization": "Bearer flowyte_sk_…"},
    json={"actions": ["append_row"]},
)

In the API

Action	Endpoint	Scope
Connect	`POST /integrations/google_sheets/connect`	`integrations:write`
Resolve a sheet	`GET /integrations/google_sheets/spreadsheet?ref=…`	`integrations:read`
List actions	`GET /integrations/google_sheets/actions`	`integrations:read`
Provision skills	`POST /agents/{agentId}/integrations/google_sheets/provision`	`skills:write`
Remove skills	`DELETE /agents/{agentId}/integrations/google_sheets/provision`	`skills:write`
Disconnect	`DELETE /integrations/google_sheets`	`integrations:write`

Provisioning edits the draft. Publish so live calls write rows.

Get started

Concepts

Channels

Integrations

Guides

Trust & Security

Connect

Resolve the target sheet

Provision the skill

In the API

​Connect

​Resolve the target sheet

​Provision the skill

​In the API

Connect

Resolve the target sheet

Provision the skill

In the API