Connect Google Sheets so agents can read ranges, append rows, and build reports. OAuth tokens are injected by the gateway and never reach the agent.
Per-app Google setup is deprecated. All Google apps now share one Google OAuth client and one Redirect URI. To use your own client, follow the Google setup guide. Credentials saved for one Google app apply to all of them.
Overview
OneCLI connects AI agents to Google Sheets through Google’s OAuth flow. Agents can read spreadsheet data, write values, create new sheets, and manage formatting. The gateway injects OAuth credentials into requests to the Google Sheets API automatically.This is useful for agents that need to extract data from spreadsheets, generate reports, populate templates, or sync data between systems.
What you will set up
A Google Sheets connection through Google OAuth, in one click on OneCLI Cloud or with your own Google client
Automatic token injection on requests to the Google Sheets API
Per-agent, per-tool access, such as read-only for reporting agents
Connect on OneCLI Cloud (one click)
1
Open the app
Open the OneCLI dashboard and navigate to Settings > Apps > Google Sheets.
2
Authorize
Click Connect Google Sheets. You’ll go straight to Google: pick your account, review the permissions, and click Allow. No Google Cloud setup needed.
This is for self-hosted OneCLI, and for OneCLI Cloud when you choose Custom credentials instead of one-click. One Google client serves every Google app in OneCLI, so you set it up once. If you already did it for another Google app, skip to step 2.
1. Set up your Google client
Follow the Google setup guide. It enables the Google APIs, sets up the consent screen, creates the OAuth client, and adds the Redirect URI.You paste the client into Settings > Apps > Google Sheets > Custom credentials, under the Redirect URI the guide asks you to register:
Custom credentials for Google Sheets in OneCLI.
2. Connect Google Sheets
Open Settings > Apps > Google Sheets, select Connect Google Sheets, pick your Google account, and click Allow.
The Google Sheets connect window before a Google client is set up.
What agents can do
Read cell values from specific ranges (e.g., Sheet1!A1:D10)
Write values to individual cells or ranges
Append rows to the bottom of a sheet
Create new spreadsheets with specified titles and initial data
Add, rename, and delete sheets within a spreadsheet
Read and apply cell formatting (bold, colors, borders, number formats)
Create and manage named ranges
Read spreadsheet metadata (title, sheets, locale)
Clear cell contents in a specified range
Batch read or write multiple ranges in a single request
Controlling access
Access is per agent: grant the connection to each agent that needs it, choosing per tool what runs freely, what needs human approval, and what stays blocked — a read-only agent is a single grant. Organization rules add guardrails on top, like rate limits and blanket blocks. Everything is checked before credential injection, so a blocked request never reaches Google Sheets.
FAQ
Can I give an agent read-only access to Google Sheets?
Yes. When you grant the connection, allow the read tools and block or require approval for writes. A read-only agent is a single grant.
Does the agent see my Google OAuth token?
No. The token stays in OneCLI, and the gateway adds it to Sheets API requests at the proxy. The agent makes plain HTTP calls and never holds the credential. See How it works.
How do I switch Google accounts or reconnect Sheets?
Open Settings > Apps > Google Sheets in the dashboard and connect again with the account you want. Agents with access use the new connection automatically.
Do I need a Google Cloud project?
Not on OneCLI Cloud, where one-click connect works out of the box. Self-hosted, or to use your own client on Cloud, follow the Google setup guide once for all Google apps.
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"OneCLI","colors":{"primary":"#0b5530","light":"#93e3b4","dark":"#0b5530"},"logo":{"light":"https://mintcdn.com/onecli-sh-docs/JAdtzZwaqVLjjWOS/logo/logo-full-light.svg?fit=max\u0026auto=format\u0026n=JAdtzZwaqVLjjWOS\u0026q=85\u0026s=a7b56b71149ebb0a32928ed6ba02eb86","dark":"https://mintcdn.com/onecli-sh-docs/JAdtzZwaqVLjjWOS/logo/logo-full-dark.svg?fit=max\u0026auto=format\u0026n=JAdtzZwaqVLjjWOS\u0026q=85\u0026s=f7b8a1d875b5f3a99562759a2662ee50","href":"/"},"favicon":"https://mintcdn.com/onecli-sh-docs/GPAiKFgoDh_qYDvG/favicon.png?fit=max\u0026auto=format\u0026n=GPAiKFgoDh_qYDvG\u0026q=85\u0026s=23ea1545092b2fb0f321bbf04bc79764","appearance":{"default":"light"},"background":{"color":{"light":"#ebe6d4","dark":"#083f23"}},"navbar":{"links":[{"href":"https://github.com/onecli/onecli","label":"GitHub"},{"href":"https://onecli.sh","label":"Install"}]},"footer":{"socials":{"github":"https://github.com/onecli"}},"fonts":{"heading":{"family":"Overused Grotesk","weight":600,"source":"fonts/OverusedGroteskRoman-VF.woff2","format":"woff2"}},"contextual":{"options":["copy","view","chatgpt","claude","perplexity","mcp","cursor","vscode"],"display":"header"},"styling":{"latex":false},"navigation":{"global":{"anchors":[{"anchor":"GitHub","icon":"https://mintlify.s3.us-west-1.amazonaws.com/onecli-sh-docs/images/github.svg","href":"https://github.com/onecli"}]},"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"onecli-sh-docs","hasAudioNarration":false,"actualSubdomain":"onecli-sh-docs","customDomains":[],"gitSource":{"type":"github","owner":"onecli","repo":"onecli-docs","deployBranch":"main","contentDirectory":"","isPrivate":true,"mountPath":"","label":"","_id":"6afb23636b0360be0a1911b0"},"entitlements":{},"buildId":"6afb60e20c708e167fcc2d72","clientVersion":"0.0.4177","searchFilterCounts":[{"language":"default","tag":"API Reference","count":240},{"language":"default","tag":"Workspace","count":105},{"language":"default","tag":"Integrations","count":88},{"language":"default","tag":"All app connections","count":64},{"language":"default","tag":"Enterprise","count":57},{"language":"default","tag":"Organization","count":52},{"language":"default","tag":"Apps","count":29},{"language":"default","tag":"Channels","count":28},{"language":"default","tag":"Platform","count":21},{"language":"default","tag":"Guides","count":17}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableContextualStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"/docs","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"starter-pricing","enabled":true,"variant":{"name":"control","enabled":true,"payload":{"type":"string","value":"control"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"style.css","content":"a.nav-anchor div.mr-4.rounded-md{--tw-ring-color: transparent !important;--tw-ring-shadow: 0 0 0 0 transparent !important;--tw-ring-offset-shadow: 0 0 0 0 transparent !important;box-shadow:none!important;background:transparent!important;filter:none!important;transition:opacity 0.15s ease!important}a.nav-anchor:hover div.mr-4.rounded-md{--tw-ring-color: transparent !important;--tw-ring-shadow: 0 0 0 0 transparent !important;--tw-ring-offset-shadow: 0 0 0 0 transparent !important;box-shadow:none!important;background:transparent!important;filter:none!important;opacity:0.7!important}a.nav-anchor div.mr-4.rounded-md img{opacity:1!important;filter:none!important;background:transparent!important}a.nav-anchor:hover div.mr-4.rounded-md img{opacity:1!important;filter:none!important;background:transparent!important}.dark a.nav-anchor div.mr-4.rounded-md img,[data-theme=\"dark\"] a.nav-anchor div.mr-4.rounded-md img{filter:invert(1)!important}html:not(.dark) .card,html:not(.dark) .code-block [data-component-part=\"code-block-root\"],html:not(.dark) .callout{background-color:#f3efe1!important}html:not(.dark) .card,html:not(.dark) .code-block{border-color:#cbc3a8!important}html:not(.dark) [data-component-part=\"step-indicator\"]>div,html:not(.dark) [data-component-part=\"step-indicator\"] .bg-gray-50{background-color:#d9d2ba!important;color:#0b5530!important}#theme-preference-menu-item-system,[data-theme-preference=\"system\"]{display:none!important}"}],"page":{"pagePath":"integrations/google-sheets","slug":"/integrations/google-sheets","pageMetadata":{"title":"Let AI Agents Read and Update Google Sheets","sidebarTitle":"Google Sheets","description":"Connect Google Sheets so agents can read ranges, append rows, and build reports. OAuth tokens are injected by the gateway and never reach the agent.","canonical":"https://onecli.sh/docs/integrations/google-sheets","href":"/integrations/google-sheets"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Connect Google Sheets so agents can read ranges, append rows, and build reports. OAuth tokens are injected by the gateway and never reach the agent.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,code:`code`,li:`li`,p:`p`,strong:`strong`,ul:`ul`,..._provideComponents(),...props.components},{Accordion,AccordionGroup,Frame,Heading,Info,OptimizedImage,Step,Steps,Warning}=_components;if(!Accordion)_missingMdxReference(`Accordion`,true);if(!AccordionGroup)_missingMdxReference(`AccordionGroup`,true);if(!Frame)_missingMdxReference(`Frame`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!Info)_missingMdxReference(`Info`,true);if(!OptimizedImage)_missingMdxReference(`OptimizedImage`,true);if(!Step)_missingMdxReference(`Step`,true);if(!Steps)_missingMdxReference(`Steps`,true);if(!Warning)_missingMdxReference(`Warning`,true);return _jsxs(_Fragment,{children:[_jsx(Warning,{children:_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Per-app Google setup is deprecated.`}),` All Google apps now share one Google OAuth client and one Redirect URI. To use your own client, follow the `,_jsx(_components.a,{href:`/integrations/google`,children:`Google setup guide`}),`. Credentials saved for one Google app apply to all of them.`]})}),`\n`,_jsx(Heading,{level:`2`,id:`overview`,children:`Overview`}),`\n`,_jsx(_components.p,{children:`OneCLI connects AI agents to Google Sheets through Google’s OAuth flow. Agents can read spreadsheet data, write values, create new sheets, and manage formatting. The gateway injects OAuth credentials into requests to the Google Sheets API automatically.`}),`\n`,_jsx(_components.p,{children:`This is useful for agents that need to extract data from spreadsheets, generate reports, populate templates, or sync data between systems.`}),`\n`,_jsx(Heading,{level:`2`,id:`what-you-will-set-up`,children:`What you will set up`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsx(_components.li,{children:`A Google Sheets connection through Google OAuth, in one click on OneCLI Cloud or with your own Google client`}),`\n`,_jsx(_components.li,{children:`Automatic token injection on requests to the Google Sheets API`}),`\n`,_jsx(_components.li,{children:`Per-agent, per-tool access, such as read-only for reporting agents`}),`\n`]}),`\n`,_jsx(Heading,{level:`2`,id:`connect-on-onecli-cloud-one-click`,children:`Connect on OneCLI Cloud (one click)`}),`\n`,_jsxs(Steps,{children:[_jsx(Step,{title:`Open the app`,children:_jsxs(_components.p,{children:[`Open the OneCLI dashboard and navigate to `,_jsx(_components.strong,{children:`Settings`}),` > `,_jsx(_components.strong,{children:`Apps`}),` > `,_jsx(_components.strong,{children:`Google Sheets`}),`.`]})}),_jsx(Step,{title:`Authorize`,children:_jsxs(_components.p,{children:[`Click `,_jsx(_components.strong,{children:`Connect Google Sheets`}),`. You’ll go straight to Google: pick your account, review the permissions, and click `,_jsx(_components.strong,{children:`Allow`}),`. No Google Cloud setup needed.`]})})]}),`\n`,_jsxs(_components.p,{children:[`On self-hosted OneCLI, or to use your own Google client on Cloud, see `,_jsx(_components.a,{href:`#self-hosted`,children:`Use your own Google client`}),`.`]}),`\n`,_jsx(`a`,{id:`self-hosted`,style:{scrollMarginTop:`8rem`}}),`\n`,_jsx(Heading,{level:`2`,id:`use-your-own-google-client`,children:`Use your own Google client`}),`\n`,_jsx(Info,{children:_jsxs(_components.p,{children:[`This is for self-hosted OneCLI, and for OneCLI Cloud when you choose `,_jsx(_components.strong,{children:`Custom credentials`}),` instead of one-click. One Google client serves every Google app in OneCLI, so you set it up once. If you already did it for another Google app, skip to step 2.`]})}),`\n`,_jsxs(AccordionGroup,{children:[_jsxs(Accordion,{title:`1. Set up your Google client`,defaultOpen:true,id:`1-set-up-your-google-client`,children:[_jsxs(_components.p,{children:[`Follow the `,_jsx(_components.a,{href:`/integrations/google`,children:`Google setup guide`}),`. It enables the Google APIs, sets up the consent screen, creates the OAuth client, and adds the Redirect URI.`]}),_jsxs(_components.p,{children:[`You paste the client into `,_jsx(_components.strong,{children:`Settings`}),` > `,_jsx(_components.strong,{children:`Apps`}),` > `,_jsx(_components.strong,{children:`Google Sheets`}),` > `,_jsx(_components.strong,{children:`Custom credentials`}),`, under the Redirect URI the guide asks you to register:`]}),_jsx(Frame,{caption:`Custom credentials for Google Sheets in OneCLI.`,children:_jsx(OptimizedImage,{src:`https://mintcdn.com/onecli-sh-docs/GPAiKFgoDh_qYDvG/images/integrations/google-sheets/onecli-custom-credentials-google-sheets.png?fit=max\u0026auto=format\u0026n=GPAiKFgoDh_qYDvG\u0026q=85\u0026s=7318ba96edf1455fd420ea2ab617052f`,alt:`OneCLI Custom credentials card for Google Sheets with the setup guide link, the Redirect URI and its copy button, and the Client ID and Client Secret fields.`,\"data-og-width\":`1712`,width:`1712`,\"data-og-height\":`880`,height:`880`,\"data-path\":`images/integrations/google-sheets/onecli-custom-credentials-google-sheets.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/onecli-sh-docs/GPAiKFgoDh_qYDvG/images/integrations/google-sheets/onecli-custom-credentials-google-sheets.png?w=280\u0026fit=max\u0026auto=format\u0026n=GPAiKFgoDh_qYDvG\u0026q=85\u0026s=b8dfbc1bf8bd7d4a304082433bf89ec1 280w, https://mintcdn.com/onecli-sh-docs/GPAiKFgoDh_qYDvG/images/integrations/google-sheets/onecli-custom-credentials-google-sheets.png?w=560\u0026fit=max\u0026auto=format\u0026n=GPAiKFgoDh_qYDvG\u0026q=85\u0026s=50b7710526d58f51fe191c131edc3e28 560w, https://mintcdn.com/onecli-sh-docs/GPAiKFgoDh_qYDvG/images/integrations/google-sheets/onecli-custom-credentials-google-sheets.png?w=840\u0026fit=max\u0026auto=format\u0026n=GPAiKFgoDh_qYDvG\u0026q=85\u0026s=ee5ae355328d470ea2d556c23446e143 840w, https://mintcdn.com/onecli-sh-docs/GPAiKFgoDh_qYDvG/images/integrations/google-sheets/onecli-custom-credentials-google-sheets.png?w=1100\u0026fit=max\u0026auto=format\u0026n=GPAiKFgoDh_qYDvG\u0026q=85\u0026s=2713411a94df8b46c903789da62b805e 1100w, https://mintcdn.com/onecli-sh-docs/GPAiKFgoDh_qYDvG/images/integrations/google-sheets/onecli-custom-credentials-google-sheets.png?w=1650\u0026fit=max\u0026auto=format\u0026n=GPAiKFgoDh_qYDvG\u0026q=85\u0026s=8c279431c880e88a8490f658a705bc59 1650w, https://mintcdn.com/onecli-sh-docs/GPAiKFgoDh_qYDvG/images/integrations/google-sheets/onecli-custom-credentials-google-sheets.png?w=2500\u0026fit=max\u0026auto=format\u0026n=GPAiKFgoDh_qYDvG\u0026q=85\u0026s=d021dcf93cdc9e7aeddfb8bb4a0d795c 2500w`})})]}),_jsxs(Accordion,{title:`2. Connect Google Sheets`,id:`2-connect-google-sheets`,children:[_jsxs(_components.p,{children:[`Open `,_jsx(_components.strong,{children:`Settings`}),` > `,_jsx(_components.strong,{children:`Apps`}),` > `,_jsx(_components.strong,{children:`Google Sheets`}),`, select `,_jsx(_components.strong,{children:`Connect Google Sheets`}),`, pick your Google account, and click `,_jsx(_components.strong,{children:`Allow`}),`.`]}),_jsx(Frame,{caption:`The Google Sheets connect window before a Google client is set up.`,children:_jsx(OptimizedImage,{src:`https://mintcdn.com/onecli-sh-docs/GPAiKFgoDh_qYDvG/images/integrations/google-sheets/onecli-connect-google-sheets.png?fit=max\u0026auto=format\u0026n=GPAiKFgoDh_qYDvG\u0026q=85\u0026s=6a2d9463b04a12ef8e799b3ea8066228`,alt:`OneCLI connect window for Google Sheets showing Configuration required and the Configure credentials button.`,\"data-og-width\":`976`,width:`976`,\"data-og-height\":`1078`,height:`1078`,\"data-path\":`images/integrations/google-sheets/onecli-connect-google-sheets.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/onecli-sh-docs/GPAiKFgoDh_qYDvG/images/integrations/google-sheets/onecli-connect-google-sheets.png?w=280\u0026fit=max\u0026auto=format\u0026n=GPAiKFgoDh_qYDvG\u0026q=85\u0026s=030a80d0f6e41832c1e4e0ec583a43c6 280w, https://mintcdn.com/onecli-sh-docs/GPAiKFgoDh_qYDvG/images/integrations/google-sheets/onecli-connect-google-sheets.png?w=560\u0026fit=max\u0026auto=format\u0026n=GPAiKFgoDh_qYDvG\u0026q=85\u0026s=cac199d968ca82d568149c8e713b5a89 560w, https://mintcdn.com/onecli-sh-docs/GPAiKFgoDh_qYDvG/images/integrations/google-sheets/onecli-connect-google-sheets.png?w=840\u0026fit=max\u0026auto=format\u0026n=GPAiKFgoDh_qYDvG\u0026q=85\u0026s=20dae5be95ab6fbcec14e9506e597cca 840w, https://mintcdn.com/onecli-sh-docs/GPAiKFgoDh_qYDvG/images/integrations/google-sheets/onecli-connect-google-sheets.png?w=1100\u0026fit=max\u0026auto=format\u0026n=GPAiKFgoDh_qYDvG\u0026q=85\u0026s=aa4b9bf74d8cc9133628aeb3e160239e 1100w, https://mintcdn.com/onecli-sh-docs/GPAiKFgoDh_qYDvG/images/integrations/google-sheets/onecli-connect-google-sheets.png?w=1650\u0026fit=max\u0026auto=format\u0026n=GPAiKFgoDh_qYDvG\u0026q=85\u0026s=92dc648335f7a30b62ab1adedaa97999 1650w, https://mintcdn.com/onecli-sh-docs/GPAiKFgoDh_qYDvG/images/integrations/google-sheets/onecli-connect-google-sheets.png?w=2500\u0026fit=max\u0026auto=format\u0026n=GPAiKFgoDh_qYDvG\u0026q=85\u0026s=65fa73b415186e3d5a863b32ab33fb44 2500w`})})]})]}),`\n`,_jsx(Heading,{level:`2`,id:`what-agents-can-do`,children:`What agents can do`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[`Read cell values from specific ranges (e.g., `,_jsx(_components.code,{children:`Sheet1!A1:D10`}),`)`]}),`\n`,_jsx(_components.li,{children:`Write values to individual cells or ranges`}),`\n`,_jsx(_components.li,{children:`Append rows to the bottom of a sheet`}),`\n`,_jsx(_components.li,{children:`Create new spreadsheets with specified titles and initial data`}),`\n`,_jsx(_components.li,{children:`Add, rename, and delete sheets within a spreadsheet`}),`\n`,_jsx(_components.li,{children:`Read and apply cell formatting (bold, colors, borders, number formats)`}),`\n`,_jsx(_components.li,{children:`Create and manage named ranges`}),`\n`,_jsx(_components.li,{children:`Read spreadsheet metadata (title, sheets, locale)`}),`\n`,_jsx(_components.li,{children:`Clear cell contents in a specified range`}),`\n`,_jsx(_components.li,{children:`Batch read or write multiple ranges in a single request`}),`\n`]}),`\n`,_jsx(Heading,{level:`2`,id:`controlling-access`,children:`Controlling access`}),`\n`,_jsxs(_components.p,{children:[`Access is per agent: `,_jsx(_components.a,{href:`/guides/agent-access`,children:`grant`}),` the connection to each agent that needs it, choosing per tool what runs freely, what needs human approval, and what stays blocked — a read-only agent is a single grant. Organization `,_jsx(_components.a,{href:`/guides/rules`,children:`rules`}),` add guardrails on top, like rate limits and blanket blocks. Everything is checked before credential injection, so a blocked request never reaches Google Sheets.`]}),`\n`,_jsx(Heading,{level:`2`,id:`faq`,children:`FAQ`}),`\n`,_jsxs(AccordionGroup,{children:[_jsx(Accordion,{title:`Can I give an agent read-only access to Google Sheets?`,id:`can-i-give-an-agent-read-only-access-to-google-sheets`,children:_jsxs(_components.p,{children:[`Yes. When you `,_jsx(_components.a,{href:`/guides/agent-access`,children:`grant`}),` the connection, allow the read tools and block or require approval for writes. A read-only agent is a single grant.`]})}),_jsx(Accordion,{title:`Does the agent see my Google OAuth token?`,id:`does-the-agent-see-my-google-oauth-token`,children:_jsxs(_components.p,{children:[`No. The token stays in OneCLI, and the gateway adds it to Sheets API requests at the proxy. The agent makes plain HTTP calls and never holds the credential. See `,_jsx(_components.a,{href:`/how-it-works`,children:`How it works`}),`.`]})}),_jsx(Accordion,{title:`How do I switch Google accounts or reconnect Sheets?`,id:`how-do-i-switch-google-accounts-or-reconnect-sheets`,children:_jsxs(_components.p,{children:[`Open `,_jsx(_components.strong,{children:`Settings`}),` > `,_jsx(_components.strong,{children:`Apps`}),` > `,_jsx(_components.strong,{children:`Google Sheets`}),` in the dashboard and connect again with the account you want. Agents with access use the new connection automatically.`]})}),_jsx(Accordion,{title:`Do I need a Google Cloud project?`,id:`do-i-need-a-google-cloud-project`,children:_jsxs(_components.p,{children:[`Not on OneCLI Cloud, where one-click connect works out of the box. Self-hosted, or to use your own client on Cloud, follow the `,_jsx(_components.a,{href:`/integrations/google`,children:`Google setup guide`}),` once for all Google apps.`]})})]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Let AI Agents Read and Update Google Sheets","sidebarTitle":"Google Sheets","description":"Connect Google Sheets so agents can read ranges, append rows, and build reports. OAuth tokens are injected by the gateway and never reach the agent.","canonical":"https://onecli.sh/docs/integrations/google-sheets","href":"/integrations/google-sheets"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Overview","slug":"overview","depth":2,"children":[]},{"title":"What you will set up","slug":"what-you-will-set-up","depth":2,"children":[]},{"title":"Connect on OneCLI Cloud (one click)","slug":"connect-on-onecli-cloud-one-click","depth":2,"children":[]},{"title":"Use your own Google client","slug":"use-your-own-google-client","depth":2,"children":[]},{"title":"What agents can do","slug":"what-agents-can-do","depth":2,"children":[]},{"title":"Controlling access","slug":"controlling-access","depth":2,"children":[]},{"title":"FAQ","slug":"faq","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":["/docs/_mintlify/custom/onecli-sh-docs/e8c5fc0faf4d8de9/infra/cloudfront/docs-response-headers.js"],"subdomain":"onecli-sh-docs","siteName":"OneCLI","title":"Let AI Agents Read and Update Google Sheets - OneCLI","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-11-16T15:49:48.825Z","originalFileLocation":"integrations/google-sheets.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"light\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Connect Google Sheets so agents can read ranges, append rows, and build reports. OAuth tokens are injected by the gateway and never reach the agent.\">\u003cmeta data-mint-head name=\"application-name\" content=\"OneCLI\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/docs/mintlify-assets/_mintlify/favicons/onecli-sh-docs/JyF-6zlco6U5Y4rW/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/docs/mintlify-assets/_mintlify/favicons/onecli-sh-docs/JyF-6zlco6U5Y4rW/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/docs/mintlify-assets/_mintlify/favicons/onecli-sh-docs/JyF-6zlco6U5Y4rW/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/docs/mintlify-assets/_mintlify/favicons/onecli-sh-docs/JyF-6zlco6U5Y4rW/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/docs/mintlify-assets/_mintlify/favicons/onecli-sh-docs/JyF-6zlco6U5Y4rW/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/docs/mintlify-assets/_mintlify/favicons/onecli-sh-docs/JyF-6zlco6U5Y4rW/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/docs/mintlify-assets/_mintlify/favicons/onecli-sh-docs/JyF-6zlco6U5Y4rW/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/docs/mintlify-assets/_mintlify/favicons/onecli-sh-docs/JyF-6zlco6U5Y4rW/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/docs/mintlify-assets/_mintlify/favicons/onecli-sh-docs/JyF-6zlco6U5Y4rW/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Let AI Agents Read and Update Google Sheets - OneCLI\">\u003cmeta data-mint-head property=\"og:description\" content=\"Connect Google Sheets so agents can read ranges, append rows, and build reports. OAuth tokens are injected by the gateway and never reach the agent.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"OneCLI\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://onecli.sh/docs/integrations/google-sheets\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://onecli-sh-docs.mintlify.site/docs/_mintlify/api/og/v2?division=All+app+connections\u0026amp;title=Let+AI+Agents+Read+and+Update+Google+Sheets\u0026amp;description=Connect+Google+Sheets+so+agents+can+read+ranges%2C+append+rows%2C+and+build+reports.+OAuth+tokens+are+injected+by+the+gateway+and+never+reach+the+agent.\u0026amp;theme=21276d7bc2dc55570cc64194\u0026amp;signature=09dc4009928ba35b8567e3f4ffd9a63b3e73b585e06f39329500f0f6d29e39d8\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Let AI Agents Read and Update Google Sheets - OneCLI\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Connect Google Sheets so agents can read ranges, append rows, and build reports. OAuth tokens are injected by the gateway and never reach the agent.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://onecli-sh-docs.mintlify.site/docs/_mintlify/api/og/v2?division=All+app+connections\u0026amp;title=Let+AI+Agents+Read+and+Update+Google+Sheets\u0026amp;description=Connect+Google+Sheets+so+agents+can+read+ranges%2C+append+rows%2C+and+build+reports.+OAuth+tokens+are+injected+by+the+gateway+and+never+reach+the+agent.\u0026amp;theme=21276d7bc2dc55570cc64194\u0026amp;signature=09dc4009928ba35b8567e3f4ffd9a63b3e73b585e06f39329500f0f6d29e39d8\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/docs/mintlify-assets/_mintlify/favicons/onecli-sh-docs/JyF-6zlco6U5Y4rW/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"OneCLI\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#0b5530\">\u003clink data-mint-head rel=\"canonical\" href=\"https://onecli.sh/docs/integrations/google-sheets\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/docs/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/docs/integrations/google-sheets.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://onecli-sh-docs.mintlify.dev/#organization\",\"name\":\"OneCLI\",\"url\":\"https://onecli-sh-docs.mintlify.dev\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/onecli-sh-docs/JAdtzZwaqVLjjWOS/logo/logo-full-light.svg?fit=max\u0026auto=format\u0026n=JAdtzZwaqVLjjWOS\u0026q=85\u0026s=a7b56b71149ebb0a32928ed6ba02eb86\"}},{\"@type\":\"WebSite\",\"@id\":\"https://onecli-sh-docs.mintlify.dev/docs#website\",\"name\":\"OneCLI\",\"url\":\"https://onecli-sh-docs.mintlify.dev/docs\",\"publisher\":{\"@id\":\"https://onecli-sh-docs.mintlify.dev/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://onecli.sh/docs/integrations/google-sheets#webpage\",\"url\":\"https://onecli.sh/docs/integrations/google-sheets\",\"name\":\"Let AI Agents Read and Update Google Sheets\",\"description\":\"Connect Google Sheets so agents can read ranges, append rows, and build reports. OAuth tokens are injected by the gateway and never reach the agent.\",\"dateModified\":\"2026-11-16T15:49:48.825Z\",\"isPartOf\":{\"@id\":\"https://onecli-sh-docs.mintlify.dev/docs#website\"},\"breadcrumb\":{\"@id\":\"https://onecli.sh/docs/integrations/google-sheets#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://onecli.sh/docs/integrations/google-sheets#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"All app connections\",\"item\":\"https://onecli-sh-docs.mintlify.dev/docs/integrations/affinity\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Let AI Agents Read and Update Google Sheets\",\"item\":\"https://onecli.sh/docs/integrations/google-sheets\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://onecli.sh/docs/integrations/google-sheets#article\",\"headline\":\"Let AI Agents Read and Update Google Sheets\",\"name\":\"Let AI Agents Read and Update Google Sheets\",\"description\":\"Connect Google Sheets so agents can read ranges, append rows, and build reports. OAuth tokens are injected by the gateway and never reach the agent.\",\"url\":\"https://onecli.sh/docs/integrations/google-sheets\",\"mainEntityOfPage\":{\"@id\":\"https://onecli.sh/docs/integrations/google-sheets#webpage\"},\"dateModified\":\"2026-11-16T15:49:48.825Z\",\"publisher\":{\"@id\":\"https://onecli-sh-docs.mintlify.dev/#organization\"},\"isPartOf\":{\"@id\":\"https://onecli-sh-docs.mintlify.dev/docs#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"OneCLI\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"OneCLI\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/docs/integrations/google-sheets.md","siteName":"OneCLI","nav":{"global":{"anchors":[{"anchor":"GitHub","icon":"https://mintlify.s3.us-west-1.amazonaws.com/onecli-sh-docs/images/github.svg","href":"https://github.com/onecli"}]},"tabs":[{"tab":"Documentation","pages":[{"title":"Documentation","href":""}]},{"tab":"Integrations","groups":[{"group":"Integrations","root":{"title":"Integrations: Connect Agents to External Services","sidebarTitle":"Overview","href":"/integrations"},"pages":[{"title":"App Connections: How OAuth \u0026 API Keys Work","sidebarTitle":"App Connections","href":"/integrations/app-connections"},{"title":"Custom Connections: Connect Any API With a Key","sidebarTitle":"Custom connections","href":"/integrations/custom-connections"},{"title":"Chat With AI Agents and Approve Actions in Slack","sidebarTitle":"Slack","href":"/integrations/slack"},{"title":"Keep LLM API Keys Out of Your AI Agents","sidebarTitle":"LLMs","href":"/integrations/llms"},{"title":"External Vaults: Connect Password Managers","sidebarTitle":"External Vaults","href":"/vaults/overview"}]},{"group":"Cloud integrations","pages":[{"title":"Prospect and Enrich Leads in Apollo.io With Agents","sidebarTitle":"Apollo.io","href":"/integrations/apollo-io"},{"title":"Use AWS From AI Agents Without Exposing Keys","sidebarTitle":"AWS","href":"/integrations/aws"},{"title":"Let AI Agents Open PRs and Issues on GitHub","sidebarTitle":"GitHub","href":"/integrations/github"},{"title":"Org-Approved GitHub Repo Access for AI Agents","sidebarTitle":"GitHub App","href":"/integrations/github-app"},{"title":"Let AI Agents Query Datadog Metrics and Monitors","sidebarTitle":"Datadog","href":"/integrations/datadog"},{"title":"Let AI Agents Update HubSpot CRM Records","sidebarTitle":"HubSpot","href":"/integrations/hubspot"},{"title":"Let AI Agents Triage Sentry Errors","sidebarTitle":"Sentry","href":"/integrations/sentry"},{"title":"Let AI Agents Read and Write OneNote Notebooks","sidebarTitle":"Microsoft OneNote","href":"/integrations/microsoft-onenote"},{"title":"Connect AI Agents to Outlook Mail in Microsoft 365","sidebarTitle":"Outlook Mail","href":"/integrations/outlook-mail"},{"title":"Let AI Agents Book Meetings in Outlook Calendar","sidebarTitle":"Outlook Calendar","href":"/integrations/outlook-calendar"}]},{"group":"All app connections","pages":[{"title":"Connect AI Agents to Affinity CRM With an API Key","sidebarTitle":"Affinity","href":"/integrations/affinity"},{"title":"Let AI Agents Manage Attio CRM Records","sidebarTitle":"Attio","href":"/integrations/attio"},{"title":"Run Clay Enrichment From AI Agents","sidebarTitle":"Clay","href":"/integrations/clay"},{"title":"Query PostHog Analytics and Flags From Agents","sidebarTitle":"PostHog","href":"/integrations/posthog"},{"title":"Connect AI Agents to Salesforce With an External App","sidebarTitle":"Salesforce","href":"/integrations/salesforce"},{"title":"Turn Timeless Meetings Into Agent Follow-Ups","sidebarTitle":"Timeless","href":"/integrations/timeless"},{"title":"Let Agents Search Circleback Meeting Notes","sidebarTitle":"Circleback","href":"/integrations/circleback"},{"title":"Run HeyReach LinkedIn Campaigns From AI Agents","sidebarTitle":"HeyReach","href":"/integrations/heyreach"},{"title":"Automate Dripify LinkedIn Outreach With Agents","sidebarTitle":"Dripify","href":"/integrations/dripify"},{"title":"Let On-Call Agents Triage PagerDuty Incidents","sidebarTitle":"PagerDuty","href":"/integrations/pagerduty"},{"title":"Query Coralogix Logs and Metrics From Agents","sidebarTitle":"Coralogix","href":"/integrations/coralogix"},{"title":"Search Company Knowledge in Onyx From Agents","sidebarTitle":"Onyx","href":"/integrations/onyx"},{"title":"Scoped Cloudflare API Tokens for AI Agents","sidebarTitle":"Cloudflare","href":"/integrations/cloudflare"},{"title":"Set Up One Google OAuth Client for All Google Apps","sidebarTitle":"Google (setup)","href":"/integrations/google"},{"title":"Let AI Agents Search, Draft, and Send Gmail","sidebarTitle":"Gmail","href":"/integrations/gmail"},{"title":"Let AI Agents Schedule Meetings in Google Calendar","sidebarTitle":"Google Calendar","href":"/integrations/google-calendar"},{"title":"Give AI Agents Access to Google Drive Files","sidebarTitle":"Google Drive","href":"/integrations/google-drive"},{"title":"Let AI Agents Draft and Edit Google Docs","sidebarTitle":"Google Docs","description":"Let agents read, create, and edit Google Docs to draft reports and documentation. OAuth tokens are injected by the gateway and never reach the agent.","href":"/integrations/google-docs"},{"title":"Let AI Agents Read and Update Google Sheets","sidebarTitle":"Google Sheets","href":"/integrations/google-sheets"},{"title":"Generate Google Slides Decks With AI Agents","sidebarTitle":"Google Slides","description":"Let agents create and edit Google Slides decks, insert text and images, and update layouts. OAuth tokens are injected by the gateway, not the agent.","href":"/integrations/google-slides"},{"title":"Build Google Forms and Read Responses With Agents","sidebarTitle":"Google Forms","href":"/integrations/google-forms"},{"title":"Create Google Meet Links From AI Agents","sidebarTitle":"Google Meet","href":"/integrations/google-meet"},{"title":"Search and Organize Google Photos With AI Agents","sidebarTitle":"Google Photos","href":"/integrations/google-photos"},{"title":"Track To-Dos in Google Tasks From AI Agents","sidebarTitle":"Google Tasks","href":"/integrations/google-tasks"},{"title":"Automate Google Workspace User Admin With Agents","sidebarTitle":"Google Admin","href":"/integrations/google-admin"},{"title":"Pull GA4 Reports Into AI Agents","sidebarTitle":"Google Analytics","href":"/integrations/google-analytics"},{"title":"Let AI Agents Check Indexing in Search Console","sidebarTitle":"Google Search Console","href":"/integrations/google-search-console"},{"title":"Automate Google Classroom Coursework With Agents","sidebarTitle":"Google Classroom","href":"/integrations/google-classroom"},{"title":"Manage YouTube Playlists and Analytics With Agents","sidebarTitle":"YouTube","href":"/integrations/youtube"},{"title":"Let AI Agents Search and Update Notion Pages","sidebarTitle":"Notion","href":"/integrations/notion"},{"title":"Let AI Agents Create and Triage Jira Issues","sidebarTitle":"Jira","href":"/integrations/jira"},{"title":"Give AI Agents Search and Edit Access to Confluence","sidebarTitle":"Confluence","href":"/integrations/confluence"},{"title":"Let AI Agents Manage Your Todoist Tasks","sidebarTitle":"Todoist","href":"/integrations/todoist"},{"title":"Give AI Agents Safe Access to Your Dropbox Files","sidebarTitle":"Dropbox","href":"/integrations/dropbox"},{"title":"Deploy to Fly.io From an Agent Without Exposing Tokens","sidebarTitle":"Fly.io","href":"/integrations/flyio"},{"title":"Let AI Agents Post to LinkedIn on Your Behalf","sidebarTitle":"LinkedIn","href":"/integrations/linkedin"},{"title":"Connect AI Agents to Monday.com Boards","sidebarTitle":"Monday.com","href":"/integrations/monday"},{"title":"Administer MongoDB Atlas Clusters With Agents","sidebarTitle":"MongoDB Atlas","href":"/integrations/mongodb-atlas"},{"title":"Sync Navan Bookings and Expenses With AI Agents","sidebarTitle":"Navan","href":"/integrations/navan"},{"title":"Let AI Agents Send Email With Resend","sidebarTitle":"Resend","href":"/integrations/resend"},{"title":"Send SMS and WhatsApp From AI Agents With Twilio","sidebarTitle":"Twilio","href":"/integrations/twilio"},{"title":"Zendesk Integration: Tickets and Help Center","sidebarTitle":"Zendesk","href":"/integrations/zendesk"},{"title":"Manage Supabase Projects With AI Agents","sidebarTitle":"Supabase","href":"/integrations/supabase"},{"title":"Call Claude and Gemini on Vertex AI From Agents","sidebarTitle":"Vertex AI","href":"/integrations/vertex-ai"},{"title":"Let AI Agents Edit Webflow CMS and Publish Sites","sidebarTitle":"Webflow","href":"/integrations/webflow"},{"title":"Let AI Agents Schedule Zoom Meetings and Get Recordings","sidebarTitle":"Zoom","href":"/integrations/zoom"},{"title":"Give Agents AWS Access With an IAM Role, Not Keys","sidebarTitle":"AWS Role","href":"/integrations/aws-role"},{"title":"Bitbucket Repos, Pull Requests, and Pipelines","sidebarTitle":"Bitbucket","href":"/integrations/bitbucket"},{"title":"Manage Docker Hub Repositories From AI Agents","sidebarTitle":"Docker Hub","href":"/integrations/docker"},{"title":"Read Fathom Meeting Summaries From AI Agents","sidebarTitle":"Fathom","href":"/integrations/fathom"},{"title":"Give AI Agents Access to Fireflies Transcripts","sidebarTitle":"Fireflies","href":"/integrations/fireflies"},{"title":"Let AI Agents Work With GitLab Merge Requests","sidebarTitle":"GitLab","href":"/integrations/gitlab"},{"title":"Send Google Chat Messages From AI Agents","sidebarTitle":"Google Chat","href":"/integrations/google-chat"},{"title":"Let AI Agents Look Up and Update Google Contacts","sidebarTitle":"Google Contacts","href":"/integrations/google-contacts"},{"title":"Let AI Agents Read Your Granola Meeting Notes","sidebarTitle":"Granola","href":"/integrations/granola"},{"title":"Route Agent Package Installs Through JFrog","sidebarTitle":"JFrog Artifactory","href":"/integrations/jfrog-artifactory"},{"title":"Let AI Agents File and Update Linear Issues","sidebarTitle":"Linear","href":"/integrations/linear"},{"title":"Run Snowflake SQL From an Agent, Token Hidden","sidebarTitle":"Snowflake","href":"/integrations/snowflake"},{"title":"Use a Restricted Stripe Key With AI Agents","sidebarTitle":"Stripe","href":"/integrations/stripe"},{"title":"Let AI Agents Manage Trello Boards and Cards","sidebarTitle":"Trello","href":"/integrations/trello"},{"title":"Let AI Agents Deploy and Manage Vercel Projects","sidebarTitle":"Vercel","href":"/integrations/vercel"},{"title":"Let AI Agents Post and Read on X (Twitter)","sidebarTitle":"X","href":"/integrations/x"},{"title":"Let AI Agents Work Zoho CRM Leads and Deals","sidebarTitle":"Zoho CRM","href":"/integrations/zoho-crm"},{"title":"Let AI Agents Draft Word Docs in OneDrive","sidebarTitle":"Microsoft Word","href":"/integrations/microsoft-word"}]},{"group":"LLMs","pages":[{"title":"Connect Claude to Agents With a Token or API Key","sidebarTitle":"Anthropic","href":"/integrations/anthropic"},{"title":"Use OpenAI API Keys and Codex OAuth With AI Agents","sidebarTitle":"OpenAI","href":"/integrations/openai"}]},{"group":"External Vaults","pages":[{"title":"Bitwarden Vault: Sync Secrets to the Gateway","sidebarTitle":"Bitwarden","href":"/vaults/bitwarden"},{"title":"1Password Vault: Service Account Integration","sidebarTitle":"1Password","href":"/vaults/1password"}]}]},{"tab":"Guides","pages":[{"title":"Guides","href":"/guides"}]},{"tab":"API Reference","pages":[{"title":"API Reference","href":"/api-reference"}]},{"tab":"SDKs","pages":[{"title":"SDKs","href":"/sdks"}]}]},"basePath":"","title":"Let AI Agents Read and Update Google Sheets - OneCLI","deploymentId":"dpl_81ettUQ5G7NASN425B6JKU3FX1Rg","buildId":"dpl_81ettUQ5G7NASN425B6JKU3FX1Rg","dynamics":["07c022d89b","a74be98ba7"],"chunks":["Frame-C6xGbawq.js","DynamicMarkdown-C_R66tyH.js","zoom-image-lightbox-Cr7fyDws.js","lightbox-handle-r17bVUz3.js"]}