Connect a Google Sheet to Cloud Capital to keep your business metrics in sync and give your cloud cost forecasts real business context.
Business metrics let you project how your cloud costs will grow based on signals from across the company — things like customer counts, headcount, or product usage. With Google Sheets integration, you can maintain those numbers directly in a spreadsheet your team already uses, and pull them into Cloud Capital without manual re-entry.This guide walks through connecting Google Sheets, importing a metric, keeping data in sync, and disconnecting when you no longer need it.
How it works
1. Connect your Google account
Authorize Cloud Capital to see your Google Drive via OAuth. Only files you explicitly share are visible to your team.
2. Import a metric
Browse your Drive, share a sheet with your org, and map a data range to a named business metric.
3. Stay in sync
When numbers change in the sheet, any team member can refresh the metric with one click.
Step 1: Connect your Google account
1
Open Organization Settings
Navigate to Organization Settings in Cloud Capital and select the Data Connections tab.
2
Connect Google Sheets
Click Connect next to the Google Sheets option. This launches an OAuth authorization flow where you’ll grant Cloud Capital permission to access your Google Drive.
Cloud Capital only gains access to the individual files you choose to share — not your entire Drive. No one else on your team will see spreadsheets you haven’t explicitly shared with the organization. For more on how Cloud Capital handles data access and security, see the Security page.
3
Confirm the connection
Once authorized, your Google account will appear as connected under Data Connections. Any files you share will appear in the Shared Files list here, giving you a clear record of what’s accessible to Cloud Capital.
Step 2: Import a metric from Google Sheets
1
Go to Business Metrics
Navigate to Business Metrics and click New Metric. You’ll see a drop-down — select Import from Google Sheets.
2
Browse your Drive and share a file
Click Browse my Drive to see your Google Sheets files. Select the spreadsheet you want to use as a data source, then click Share one file with the org.The file is now available as an organizational data source. Other team members will be able to collaborate using this specific sheet, but won’t gain broader access to your Drive.
3
Name your metric
Give the metric a descriptive name — for example, AI Customers or Monthly Active Users. This is the name that will appear throughout Cloud Capital.
4
Configure data orientation
Tell Cloud Capital how your sheet is structured:
Setting
Choose this if…
Dates across the top
Your columns are months/dates and your rows are metrics
Dates down the side
Your rows are months/dates and your columns are metrics
Cloud Capital auto-detects orientation and data range by default. These controls are there for complex sheets with multiple metrics, or if the auto-detection doesn’t match your layout.
5
Set the data range
Specify which cells contain the data you want to import. Cloud Capital will detect a range automatically, but you can override it here if your sheet has headers, notes, or multiple datasets in the same tab.
6
Review the actuals vs. forecast split
By default, Cloud Capital treats data as follows:
Past months (including the most recently completed month) → imported as actuals
Current and future months → imported as forecasts
This matches how Cloud Capital splits time in cost projections. Adjust if your sheet uses a different convention.
7
Import the metric
Click Import Metric. The metric will appear in your Business Metrics list with data synced directly from your Google Sheet.
Step 3: Keeping data in sync
Once a metric is connected to Google Sheets, any changes made in the spreadsheet can be pulled into Cloud Capital on demand.
1
Update numbers in Google Sheets
Make changes to the data in your spreadsheet as you normally would. Any member of your team with access to the sheet can update the numbers.
2
Refresh the metric in Cloud Capital
Open the metric in Cloud Capital and click the Refresh button. The values will update to match the current state of the sheet, and the Last synced timestamp will update to confirm it.
Refresh is currently manual — click the button whenever you want to pull in the latest numbers. Automatic syncing is planned for a future release.
Any member of your team can trigger a manual refresh, not just the person who originally connected or imported the metric.
Disconnecting a metric or removing a shared file
When you no longer want a metric to be tied to a Google Sheet, or you want to remove a shared file entirely, you have a few options.
Disconnect the metric from Google Sheets (keep the metric)
Open the metric and choose Disconnect from Sheets. The metric stays in Cloud Capital as a standard manually-managed business metric — historical data is preserved, but it will no longer sync from the spreadsheet.This is useful if you want to switch to entering numbers directly in Cloud Capital going forward.
Disconnect the metric and delete it
Open the metric and choose Disconnect and delete. This removes both the Google Sheets connection and the metric itself from Cloud Capital.
Remove a shared file from the organization
Go to Organization Settings → Data Connections → Shared Files. From here, you can revoke access to any file you previously shared. This removes it as an available data source for the entire organization.
Removing a shared file will break any metrics that are currently importing data from it. Disconnect those metrics first (or note that they’ll stop syncing) before removing the file.
Frequently asked questions
Can other team members see all of my Google Drive?
No. Cloud Capital only surfaces the specific files you choose to share with your organization. Your broader Drive and any unshared spreadsheets remain private.
Can multiple team members connect their own Google accounts?
Yes. Each person who completes the OAuth flow connects their own Google account independently. This means different team members can share different sheets — useful if different business metrics are owned by different people.
Can I import more than one metric from the same spreadsheet?
Yes. Once a sheet is shared with the organization, you can import multiple metrics from it by going through the Import from Google Sheets flow and specifying different data ranges each time.
What happens if I delete or rename the spreadsheet in Google Drive?
Cloud Capital won’t be able to sync data from a file that has been deleted or had its permissions changed. The metric will remain in Cloud Capital with the last successfully synced values, but refreshing will fail. Reconnect or disconnect the metric accordingly.
Will syncing ever be automatic?
Manual sync is the current behavior. Automatic background syncing is on the roadmap and will be introduced in a future release.
Next steps
Using Business Metrics in Forecasts
Learn how to attach business metrics to your cloud cost projections to build more accurate forecasts.
Engineering Initiatives
View and manage all connected data sources for your organization.
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Cloud Capital Documentation","colors":{"primary":"#39B1CA","light":"#FDDD36","dark":"#275981"},"logo":{"light":"https://mintcdn.com/cloudcapital/IvcudIfSdItnETQn/logo/logo.png?fit=max\u0026auto=format\u0026n=IvcudIfSdItnETQn\u0026q=85\u0026s=0f0a1e67aacb7e0785e15569d8efe43a","dark":"https://mintcdn.com/cloudcapital/IvcudIfSdItnETQn/logo/logo-dark.png?fit=max\u0026auto=format\u0026n=IvcudIfSdItnETQn\u0026q=85\u0026s=d6e0b829bd771a88177c92758b36fc5f"},"favicon":{"light":"https://mintcdn.com/cloudcapital/y1SBWs9ZaRwf6Gad/favicon-16x16.svg?fit=max\u0026auto=format\u0026n=y1SBWs9ZaRwf6Gad\u0026q=85\u0026s=661dfe0c88272348de9f4555e3b262db","dark":"https://mintcdn.com/cloudcapital/y1SBWs9ZaRwf6Gad/favicon-16x16.svg?fit=max\u0026auto=format\u0026n=y1SBWs9ZaRwf6Gad\u0026q=85\u0026s=661dfe0c88272348de9f4555e3b262db"},"api":{"openapi":"api-reference/openapi.yaml","playground":{"display":"interactive"}},"navbar":{"links":[{"href":"mailto:support@cloudcapital.co","label":"Support"}],"primary":{"type":"button","label":"Dashboard","href":"https://app.cloudcapital.co"}},"footer":{"socials":{"linkedin":"https://linkedin.com/company/cloud-cap"}},"integrations":{"posthog":{"apiKey":"phc_NahBxn7JDLmqSngI3ojREwWHDy3z5jOQoSRSJvlg00Q","apiHost":"https://us.i.posthog.com"}},"styling":{"latex":false},"navigation":{"global":{"anchors":[{"anchor":"Docs Home","icon":"book-open-cover","href":"https://docs.cloudcapital.co"},{"anchor":"Insights","icon":"newspaper","href":"https://www.cloudcapital.co/insights"}]},"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"cloudcapital","hasAudioNarration":false,"actualSubdomain":"cloudcapital","customDomains":["docs.cloudcapital.co"],"gitSource":{"type":"github","owner":"cloudcapitalco","repo":"platform","deployBranch":"main","contentDirectory":"apps/app-docs","isPrivate":true,"mountPath":"","label":""},"feedback":{"issues":true},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6b02d8646d5fca11cbfae950","clientVersion":"0.0.4270","searchFilterCounts":[{"language":"default","tag":"Guides","count":54},{"language":"default","tag":"Cost Data Integrations","count":15},{"language":"default","tag":"Cost Optimization","count":14},{"language":"default","tag":"API Reference","count":8},{"language":"default","tag":"Forecasting","count":8},{"language":"default","tag":"Cost insights","count":7},{"language":"default","tag":"AI Agent \u0026 Tools","count":5},{"language":"default","tag":"Tracking \u0026 Support","count":5},{"language":"default","tag":"Getting Started","count":5},{"language":"default","tag":"How It Works","count":4}]},"assistantConfig":{},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"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":"site-roles","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":"treatment","enabled":true,"payload":{"type":"string","value":"treatment"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[]}
{"page":{"pagePath":"forecasting/business-metrics-import-googlesheets","slug":"/forecasting/business-metrics-import-googlesheets","pageMetadata":{"title":"Import Business Metrics from Google Sheets","description":"Connect a Google Sheet to Cloud Capital to keep your business metrics in sync and give your cloud cost forecasts real business context.","href":"/forecasting/business-metrics-import-googlesheets"},"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 a Google Sheet to Cloud Capital to keep your business metrics in sync and give your cloud cost forecasts real business context.\"\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`,em:`em`,hr:`hr`,li:`li`,p:`p`,strong:`strong`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,ul:`ul`,..._provideComponents(),...props.components},{Accordion,AccordionGroup,Card,CardGroup,Frame,Heading,Info,Note,OptimizedFrame,Step,Steps,Table,Tip,Warning}=_components;if(!Accordion)_missingMdxReference(`Accordion`,true);if(!AccordionGroup)_missingMdxReference(`AccordionGroup`,true);if(!Card)_missingMdxReference(`Card`,true);if(!CardGroup)_missingMdxReference(`CardGroup`,true);if(!Frame)_missingMdxReference(`Frame`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!Info)_missingMdxReference(`Info`,true);if(!Note)_missingMdxReference(`Note`,true);if(!OptimizedFrame)_missingMdxReference(`OptimizedFrame`,true);if(!Step)_missingMdxReference(`Step`,true);if(!Steps)_missingMdxReference(`Steps`,true);if(!Table)_missingMdxReference(`Table`,true);if(!Tip)_missingMdxReference(`Tip`,true);if(!Warning)_missingMdxReference(`Warning`,true);return _jsxs(_Fragment,{children:[_jsx(_components.p,{children:`Business metrics let you project how your cloud costs will grow based on signals from across the company — things like customer counts, headcount, or product usage. With Google Sheets integration, you can maintain those numbers directly in a spreadsheet your team already uses, and pull them into Cloud Capital without manual re-entry.`}),`\n`,_jsx(_components.p,{children:`This guide walks through connecting Google Sheets, importing a metric, keeping data in sync, and disconnecting when you no longer need it.`}),`\n`,_jsx(Frame,{children:_jsx(OptimizedFrame,{src:`https://www.loom.com/embed/b41a74adc0fb45e6bbe31523af17113d`,frameborder:`0`,allowfullscreen:true,style:{width:`100%`,height:`420px`}})}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`how-it-works`,children:`How it works`}),`\n`,_jsxs(CardGroup,{cols:3,children:[_jsx(Card,{title:`1. Connect your Google account`,icon:`google`,children:_jsx(_components.p,{children:`Authorize Cloud Capital to see your Google Drive via OAuth. Only files you explicitly share are visible to your team.`})}),_jsx(Card,{title:`2. Import a metric`,icon:`file-import`,children:_jsx(_components.p,{children:`Browse your Drive, share a sheet with your org, and map a data range to a named business metric.`})}),_jsx(Card,{title:`3. Stay in sync`,icon:`arrows-rotate`,children:_jsx(_components.p,{children:`When numbers change in the sheet, any team member can refresh the metric with one click.`})})]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`step-1-connect-your-google-account`,children:`Step 1: Connect your Google account`}),`\n`,_jsxs(Steps,{children:[_jsx(Step,{title:`Open Organization Settings`,children:_jsxs(_components.p,{children:[`Navigate to `,_jsx(_components.strong,{children:`Organization Settings`}),` in Cloud Capital and select the `,_jsx(_components.strong,{children:`Data Connections`}),` tab.`]})}),_jsxs(Step,{title:`Connect Google Sheets`,children:[_jsxs(_components.p,{children:[`Click `,_jsx(_components.strong,{children:`Connect`}),` next to the Google Sheets option. This launches an OAuth authorization flow where you’ll grant Cloud Capital permission to access your Google Drive.`]}),_jsx(Note,{children:_jsxs(_components.p,{children:[`Cloud Capital only gains access to the individual files you choose to share — not your entire Drive. No one else on your team will see spreadsheets you haven’t explicitly shared with the organization. For more on how Cloud Capital handles data access and security, see the `,_jsx(_components.a,{href:`/security`,children:`Security`}),` page.`]})})]}),_jsx(Step,{title:`Confirm the connection`,children:_jsxs(_components.p,{children:[`Once authorized, your Google account will appear as connected under Data Connections. Any files you share will appear in the `,_jsx(_components.strong,{children:`Shared Files`}),` list here, giving you a clear record of what’s accessible to Cloud Capital.`]})})]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`step-2-import-a-metric-from-google-sheets`,children:`Step 2: Import a metric from Google Sheets`}),`\n`,_jsxs(Steps,{children:[_jsx(Step,{title:`Go to Business Metrics`,children:_jsxs(_components.p,{children:[`Navigate to `,_jsx(_components.strong,{children:`Business Metrics`}),` and click `,_jsx(_components.strong,{children:`New Metric`}),`. You’ll see a drop-down — select `,_jsx(_components.strong,{children:`Import from Google Sheets`}),`.`]})}),_jsxs(Step,{title:`Browse your Drive and share a file`,children:[_jsxs(_components.p,{children:[`Click `,_jsx(_components.strong,{children:`Browse my Drive`}),` to see your Google Sheets files. Select the spreadsheet you want to use as a data source, then click `,_jsx(_components.strong,{children:`Share one file with the org`}),`.`]}),_jsx(_components.p,{children:`The file is now available as an organizational data source. Other team members will be able to collaborate using this specific sheet, but won’t gain broader access to your Drive.`})]}),_jsx(Step,{title:`Name your metric`,children:_jsxs(_components.p,{children:[`Give the metric a descriptive name — for example, `,_jsx(_components.em,{children:`AI Customers`}),` or `,_jsx(_components.em,{children:`Monthly Active Users`}),`. This is the name that will appear throughout Cloud Capital.`]})}),_jsxs(Step,{title:`Configure data orientation`,children:[_jsx(_components.p,{children:`Tell Cloud Capital how your sheet is structured:`}),_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Setting`}),_jsx(_components.th,{children:`Choose this if…`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Dates across the top`})}),_jsx(_components.td,{children:`Your columns are months/dates and your rows are metrics`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Dates down the side`})}),_jsx(_components.td,{children:`Your rows are months/dates and your columns are metrics`})]})]})]}),_jsx(Tip,{children:_jsx(_components.p,{children:`Cloud Capital auto-detects orientation and data range by default. These controls are there for complex sheets with multiple metrics, or if the auto-detection doesn’t match your layout.`})})]}),_jsx(Step,{title:`Set the data range`,children:_jsx(_components.p,{children:`Specify which cells contain the data you want to import. Cloud Capital will detect a range automatically, but you can override it here if your sheet has headers, notes, or multiple datasets in the same tab.`})}),_jsxs(Step,{title:`Review the actuals vs. forecast split`,children:[_jsx(_components.p,{children:`By default, Cloud Capital treats data as follows:`}),_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Past months`}),` (including the most recently completed month) → imported as `,_jsx(_components.strong,{children:`actuals`})]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Current and future months`}),` → imported as `,_jsx(_components.strong,{children:`forecasts`})]}),`\n`]}),_jsx(_components.p,{children:`This matches how Cloud Capital splits time in cost projections. Adjust if your sheet uses a different convention.`})]}),_jsx(Step,{title:`Import the metric`,children:_jsxs(_components.p,{children:[`Click `,_jsx(_components.strong,{children:`Import Metric`}),`. The metric will appear in your Business Metrics list with data synced directly from your Google Sheet.`]})})]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`step-3-keeping-data-in-sync`,children:`Step 3: Keeping data in sync`}),`\n`,_jsx(_components.p,{children:`Once a metric is connected to Google Sheets, any changes made in the spreadsheet can be pulled into Cloud Capital on demand.`}),`\n`,_jsxs(Steps,{children:[_jsx(Step,{title:`Update numbers in Google Sheets`,children:_jsx(_components.p,{children:`Make changes to the data in your spreadsheet as you normally would. Any member of your team with access to the sheet can update the numbers.`})}),_jsxs(Step,{title:`Refresh the metric in Cloud Capital`,children:[_jsxs(_components.p,{children:[`Open the metric in Cloud Capital and click the `,_jsx(_components.strong,{children:`Refresh`}),` button. The values will update to match the current state of the sheet, and the `,_jsx(_components.strong,{children:`Last synced`}),` timestamp will update to confirm it.`]}),_jsx(Note,{children:_jsx(_components.p,{children:`Refresh is currently manual — click the button whenever you want to pull in the latest numbers. Automatic syncing is planned for a future release.`})})]})]}),`\n`,_jsx(Info,{children:_jsx(_components.p,{children:`Any member of your team can trigger a manual refresh, not just the person who originally connected or imported the metric.`})}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`disconnecting-a-metric-or-removing-a-shared-file`,children:`Disconnecting a metric or removing a shared file`}),`\n`,_jsx(_components.p,{children:`When you no longer want a metric to be tied to a Google Sheet, or you want to remove a shared file entirely, you have a few options.`}),`\n`,_jsxs(AccordionGroup,{children:[_jsxs(Accordion,{title:`Disconnect the metric from Google Sheets (keep the metric)`,id:`disconnect-the-metric-from-google-sheets-keep-the-metric`,children:[_jsxs(_components.p,{children:[`Open the metric and choose `,_jsx(_components.strong,{children:`Disconnect from Sheets`}),`. The metric stays in Cloud Capital as a standard manually-managed business metric — historical data is preserved, but it will no longer sync from the spreadsheet.`]}),_jsx(_components.p,{children:`This is useful if you want to switch to entering numbers directly in Cloud Capital going forward.`})]}),_jsx(Accordion,{title:`Disconnect the metric and delete it`,id:`disconnect-the-metric-and-delete-it`,children:_jsxs(_components.p,{children:[`Open the metric and choose `,_jsx(_components.strong,{children:`Disconnect and delete`}),`. This removes both the Google Sheets connection and the metric itself from Cloud Capital.`]})}),_jsxs(Accordion,{title:`Remove a shared file from the organization`,id:`remove-a-shared-file-from-the-organization`,children:[_jsxs(_components.p,{children:[`Go to `,_jsx(_components.strong,{children:`Organization Settings`}),` → `,_jsx(_components.strong,{children:`Data Connections`}),` → `,_jsx(_components.strong,{children:`Shared Files`}),`. From here, you can revoke access to any file you previously shared. This removes it as an available data source for the entire organization.`]}),_jsx(Warning,{children:_jsx(_components.p,{children:`Removing a shared file will break any metrics that are currently importing data from it. Disconnect those metrics first (or note that they’ll stop syncing) before removing the file.`})})]})]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`frequently-asked-questions`,children:`Frequently asked questions`}),`\n`,_jsxs(AccordionGroup,{children:[_jsx(Accordion,{title:`Can other team members see all of my Google Drive?`,id:`can-other-team-members-see-all-of-my-google-drive`,children:_jsx(_components.p,{children:`No. Cloud Capital only surfaces the specific files you choose to share with your organization. Your broader Drive and any unshared spreadsheets remain private.`})}),_jsx(Accordion,{title:`Can multiple team members connect their own Google accounts?`,id:`can-multiple-team-members-connect-their-own-google-accounts`,children:_jsx(_components.p,{children:`Yes. Each person who completes the OAuth flow connects their own Google account independently. This means different team members can share different sheets — useful if different business metrics are owned by different people.`})}),_jsx(Accordion,{title:`Can I import more than one metric from the same spreadsheet?`,id:`can-i-import-more-than-one-metric-from-the-same-spreadsheet`,children:_jsxs(_components.p,{children:[`Yes. Once a sheet is shared with the organization, you can import multiple metrics from it by going through the `,_jsx(_components.strong,{children:`Import from Google Sheets`}),` flow and specifying different data ranges each time.`]})}),_jsx(Accordion,{title:`What happens if I delete or rename the spreadsheet in Google Drive?`,id:`what-happens-if-i-delete-or-rename-the-spreadsheet-in-google-drive`,children:_jsx(_components.p,{children:`Cloud Capital won’t be able to sync data from a file that has been deleted or had its permissions changed. The metric will remain in Cloud Capital with the last successfully synced values, but refreshing will fail. Reconnect or disconnect the metric accordingly.`})}),_jsx(Accordion,{title:`Will syncing ever be automatic?`,id:`will-syncing-ever-be-automatic`,children:_jsx(_components.p,{children:`Manual sync is the current behavior. Automatic background syncing is on the roadmap and will be introduced in a future release.`})})]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`next-steps`,children:`Next steps`}),`\n`,_jsxs(CardGroup,{cols:2,children:[_jsx(Card,{title:`Using Business Metrics in Forecasts`,icon:`chart-line`,href:`/forecasting/business-metrics`,children:_jsx(_components.p,{children:`Learn how to attach business metrics to your cloud cost projections to build more accurate forecasts.`})}),_jsx(Card,{title:`Engineering Initiatives`,icon:`gear`,href:`/forecasting/initiatives`,children:_jsx(_components.p,{children:`View and manage all connected data sources for your organization.`})})]})]})}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":"Import Business Metrics from Google Sheets","description":"Connect a Google Sheet to Cloud Capital to keep your business metrics in sync and give your cloud cost forecasts real business context.","href":"/forecasting/business-metrics-import-googlesheets"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"How it works","slug":"how-it-works","depth":2,"children":[]},{"title":"Step 1: Connect your Google account","slug":"step-1-connect-your-google-account","depth":2,"children":[]},{"title":"Step 2: Import a metric from Google Sheets","slug":"step-2-import-a-metric-from-google-sheets","depth":2,"children":[]},{"title":"Step 3: Keeping data in sync","slug":"step-3-keeping-data-in-sync","depth":2,"children":[]},{"title":"Disconnecting a metric or removing a shared file","slug":"disconnecting-a-metric-or-removing-a-shared-file","depth":2,"children":[]},{"title":"Frequently asked questions","slug":"frequently-asked-questions","depth":2,"children":[]},{"title":"Next steps","slug":"next-steps","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"cloudcapital","siteName":"Cloud Capital Documentation","title":"Import Business Metrics from Google Sheets - Cloud Capital Documentation","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-04-10T19:10:25.162Z","originalFileLocation":"forecasting/business-metrics-import-googlesheets.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=\"system\"}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 a Google Sheet to Cloud Capital to keep your business metrics in sync and give your cloud cost forecasts real business context.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Cloud Capital Documentation\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/cloudcapital/vJNgBIngx_tolAzu/_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=\"/mintlify-assets/_mintlify/favicons/cloudcapital/vJNgBIngx_tolAzu/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/cloudcapital/vJNgBIngx_tolAzu/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/cloudcapital/vJNgBIngx_tolAzu/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/cloudcapital/vJNgBIngx_tolAzu/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/cloudcapital/vJNgBIngx_tolAzu/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/cloudcapital/vJNgBIngx_tolAzu/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/cloudcapital/vJNgBIngx_tolAzu/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/cloudcapital/vJNgBIngx_tolAzu/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Import Business Metrics from Google Sheets - Cloud Capital Documentation\">\u003cmeta data-mint-head property=\"og:description\" content=\"Connect a Google Sheet to Cloud Capital to keep your business metrics in sync and give your cloud cost forecasts real business context.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Cloud Capital Documentation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.cloudcapital.co/forecasting/business-metrics-import-googlesheets\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://cloudcapital.mintlify.site/_mintlify/api/og/v2?division=Setup\u0026amp;title=Import+Business+Metrics+from+Google+Sheets\u0026amp;description=Connect+a+Google+Sheet+to+Cloud+Capital+to+keep+your+business+metrics+in+sync+and+give+your+cloud+cost+forecasts+real+business+context.\u0026amp;theme=a35aee8686c6564af2865143\u0026amp;signature=fc8dc2bfcd5ef64d86e5ae6f6b39558e102410cf8c70446787c77e5e3a22035f\">\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=\"Import Business Metrics from Google Sheets - Cloud Capital Documentation\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Connect a Google Sheet to Cloud Capital to keep your business metrics in sync and give your cloud cost forecasts real business context.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://cloudcapital.mintlify.site/_mintlify/api/og/v2?division=Setup\u0026amp;title=Import+Business+Metrics+from+Google+Sheets\u0026amp;description=Connect+a+Google+Sheet+to+Cloud+Capital+to+keep+your+business+metrics+in+sync+and+give+your+cloud+cost+forecasts+real+business+context.\u0026amp;theme=a35aee8686c6564af2865143\u0026amp;signature=fc8dc2bfcd5ef64d86e5ae6f6b39558e102410cf8c70446787c77e5e3a22035f\">\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=\"/mintlify-assets/_mintlify/favicons/cloudcapital/vJNgBIngx_tolAzu/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Cloud Capital Documentation\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#39B1CA\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.cloudcapital.co/forecasting/business-metrics-import-googlesheets\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/forecasting/business-metrics-import-googlesheets.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.cloudcapital.co/#organization\",\"name\":\"Cloud Capital Documentation\",\"url\":\"https://docs.cloudcapital.co\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/cloudcapital/IvcudIfSdItnETQn/logo/logo.png?fit=max\u0026auto=format\u0026n=IvcudIfSdItnETQn\u0026q=85\u0026s=0f0a1e67aacb7e0785e15569d8efe43a\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.cloudcapital.co#website\",\"name\":\"Cloud Capital Documentation\",\"url\":\"https://docs.cloudcapital.co\",\"publisher\":{\"@id\":\"https://docs.cloudcapital.co/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.cloudcapital.co/forecasting/business-metrics-import-googlesheets#webpage\",\"url\":\"https://docs.cloudcapital.co/forecasting/business-metrics-import-googlesheets\",\"name\":\"Import Business Metrics from Google Sheets\",\"description\":\"Connect a Google Sheet to Cloud Capital to keep your business metrics in sync and give your cloud cost forecasts real business context.\",\"dateModified\":\"2026-04-10T19:10:25.162Z\",\"isPartOf\":{\"@id\":\"https://docs.cloudcapital.co#website\"},\"breadcrumb\":{\"@id\":\"https://docs.cloudcapital.co/forecasting/business-metrics-import-googlesheets#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.cloudcapital.co/forecasting/business-metrics-import-googlesheets#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Forecasting\",\"item\":\"https://docs.cloudcapital.co/forecasting/overview\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Setup\",\"item\":\"https://docs.cloudcapital.co/forecasting/business-metrics\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Import Business Metrics from Google Sheets\",\"item\":\"https://docs.cloudcapital.co/forecasting/business-metrics-import-googlesheets\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.cloudcapital.co/forecasting/business-metrics-import-googlesheets#article\",\"headline\":\"Import Business Metrics from Google Sheets\",\"name\":\"Import Business Metrics from Google Sheets\",\"description\":\"Connect a Google Sheet to Cloud Capital to keep your business metrics in sync and give your cloud cost forecasts real business context.\",\"url\":\"https://docs.cloudcapital.co/forecasting/business-metrics-import-googlesheets\",\"mainEntityOfPage\":{\"@id\":\"https://docs.cloudcapital.co/forecasting/business-metrics-import-googlesheets#webpage\"},\"dateModified\":\"2026-04-10T19:10:25.162Z\",\"publisher\":{\"@id\":\"https://docs.cloudcapital.co/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.cloudcapital.co#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Cloud Capital Documentation\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Cloud Capital Documentation\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/forecasting/business-metrics-import-googlesheets.md","siteName":"Cloud Capital Documentation","nav":{"global":{"anchors":[{"anchor":"Docs Home","icon":"book-open-cover","href":"https://docs.cloudcapital.co"},{"anchor":"Insights","icon":"newspaper","href":"https://www.cloudcapital.co/insights"}]},"tabs":[{"tab":"Guides","groups":[{"group":"Overview","pages":[{"title":"What is Cloud Capital?","href":"/cloud-capital"},{"title":"Savings Assessment","href":"/optimization/savings-assessment"}]},{"group":"Quickstart","pages":[{"title":"Getting started","href":"/introduction"}]},{"group":"Cost Data Integrations","pages":[{"title":"Integrate AWS Data","href":"/get-started/aws-data-integration"},{"title":"Terraform Setup for the Forecasting Role","href":"/get-started/aws-data-integration-terraform"},{"title":"Integrate GCP Data","sidebarTitle":"Integrate GCP Data","tag":"Beta","href":"/get-started/gcp-data-integration"},{"title":"Integrate Claude API","sidebarTitle":"Integrate Claude API","tag":"Beta","href":"/get-started/claude-api-data-integration"},{"title":"Integrate Claude.ai Enterprise","sidebarTitle":"Integrate Claude.ai","tag":"Beta","href":"/get-started/claude-ai-data-integration"},{"title":"Integrate OpenAI","sidebarTitle":"Integrate OpenAI","tag":"Beta","href":"/get-started/openai-data-integration"},{"title":"Integrate LiteLLM","sidebarTitle":"Integrate LiteLLM","tag":"Beta","href":"/get-started/litellm-data-integration"},{"title":"Integrate Cloudflare","sidebarTitle":"Integrate Cloudflare","tag":"Beta","href":"/get-started/cloudflare-data-integration"},{"title":"Integrate OpenRouter","sidebarTitle":"Integrate OpenRouter","href":"/get-started/openrouter-data-integration"},{"title":"Send realtime spend","sidebarTitle":"Send realtime spend","href":"/get-started/realtime-spend-integration"},{"title":"Integrate Cursor","sidebarTitle":"Integrate Cursor","tag":"Beta","href":"/get-started/cursor-data-integration"},{"title":"Cloud Resource Mapping","href":"/get-started/map-cloud-resources"},{"title":"Auto-Mapping: Guided Cost Allocation Setup","href":"/get-started/auto-mapping"},{"title":"Request an AWS CUR backfill from AWS Support","href":"/get-started/aws-cur-backfill"},{"title":"12-Month AWS Tag Backfill","href":"/get-started/aws-tag-backfill"}]},{"group":"Cloud Capital Managed Billing","pages":[{"title":"AWS IAM Policy Check","href":"/get-started/aws-fine-grained-access-check"},{"title":"Onboarding via AWS Billing Transfer","href":"/get-started/aws-billing-transfer"},{"title":"Onboarding GCP billing to Cloud Capital","sidebarTitle":"GCP billing onboarding","href":"/get-started/gcp-billing-onboarding"}]},{"group":"Financial Onboarding","pages":[{"title":"Compliance Onboarding","href":"/optimization/onboarding"}]},{"group":"Forecasting","pages":[{"title":"Forecasting Overview","href":"/forecasting/overview"},{"group":"Setup","pages":[{"title":"Business Metrics","description":"Connect your growth data to your forecast so cloud costs move with your business plan, not just your recent history.","href":"/forecasting/business-metrics"},{"title":"Import Business Metrics from Google Sheets","href":"/forecasting/business-metrics-import-googlesheets"},{"title":"Cost Layers","description":"Manage your cost layer structure — add sub-layers, reassign services, understand inheritance, and keep your mapping current as your business evolves.","href":"/forecasting/cost-layers"}]},{"group":"Managing Your Forecast","pages":[{"title":"Exploring the Forecast","href":"/forecasting/forecast-controls"},{"title":"Engineering Initiatives","href":"/forecasting/initiatives"},{"title":"Projection Types","href":"/forecasting/projection-types"}]},{"title":"Forecasting FAQ","href":"/forecasting/forecasting-faq"}]},{"group":"Scenarios and Budgets","pages":[{"title":"Scenarios and budgets","href":"/scenarios-and-budgets/overview"}]},{"group":"Cost Insights","pages":[{"title":"Saved Reports","href":"/cost-insights/saved-reports"}]},{"group":"Cost Optimization","pages":[{"group":"Getting Started","pages":[{"title":"Commitment Optimization","sidebarTitle":"Optimization Overview","href":"/optimization/opt-process"},{"title":"Commitment Proposal \u0026 Onboarding Process","sidebarTitle":"Onboarding Process","href":"/optimization/commitment-proposal-onboarding"},{"title":"Commitment Setup","href":"/optimization/commitment-setup"},{"title":"Commitment Purchasing Authorization","href":"/optimization/cloud-provider-account"},{"title":"Terraform Setup for the Optimization Role","href":"/optimization/cloud-provider-account-terraform"}]},{"group":"How It Works","pages":[{"title":"Cloud Cost Savings Strategies","href":"/optimization/savings-strategies"},{"title":"How AWS Savings Plans and Reserved Instances Work","sidebarTitle":"Savings Plans \u0026 RIs","href":"/optimization/savings-plans-and-reserved-instances"},{"title":"Commitment Strategy","href":"/optimization/commitment-strategy"},{"title":"Guaranteed Savings Rate","href":"/optimization/guaranteed-savings-rate"}]},{"group":"Tracking \u0026 Support","pages":[{"title":"Savings Realisation","href":"/optimization/savings-realisation"},{"title":"Business Reviews (QBR / MBR)","href":"/optimization/qbr"},{"title":"Billing \u0026 Payments — Marketplace","href":"/optimization/billing-marketplace"},{"title":"Billing \u0026 Payments — Cloud Discount","href":"/optimization/billing-cloud-discount"},{"title":"Commitments FAQ","href":"/optimization/commitments-faq"}]}]},{"group":"AI Agent \u0026 Tools","pages":[{"title":"In-App Assistant","href":"/ai/chat-assistant"},{"title":"Cloud Capital Agent in Slack","href":"/ai/slack-app"},{"title":"MCP server","href":"/ai/mcp-server"},{"title":"AI agent setup instructions","href":"/ai/agent-setup"},{"title":"AWS → Cloud Capital Skill","href":"/ai/aws-to-cloud-capital-skill"}]},{"group":"Settings","pages":[{"title":"Single sign-on (SSO)","href":"/get-started/sso"}]},{"group":"Security","pages":[{"title":"Security","href":"/security"}]},{"group":"Glossary","pages":[{"title":"Glossary","sidebarTitle":"Glossary","href":"/glossary"}]}]},{"tab":"API Reference","pages":[{"title":"API Reference","href":"/api-reference/overview"}]}]},"basePath":"","title":"Import Business Metrics from Google Sheets - Cloud Capital Documentation","deploymentId":"dpl_DyXGnKeCjZyA3sUdfMJ7FjkdBefg","buildId":"dpl_DyXGnKeCjZyA3sUdfMJ7FjkdBefg","dynamics":["07c022d89b"],"chunks":["Frame-D0FT0qQs.js","DynamicMarkdown-CQM9Bhbv.js"]}