> For the complete documentation index, see [llms.txt](https://docs.kick.co/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.kick.co/integrations/google-sheets.md). # Google Sheets **Kick to Google Sheets™** pulls your financial reports from Kick into any spreadsheet in seconds. Add a report, turn on auto refresh, and build on top of live data — all without leaving Sheets. Install it from the [Google Workspace Marketplace](https://workspace.google.com/marketplace/app/kick/83078251972). {% hint style="success" %} **Kick reports land as live spreadsheet data, so Gemini, Claude, ChatGPT, or other AI tools can summarize trends, build forecast tabs, and run month-end review on your client's numbers - all in the same workbook** → [**Read how to use AI with Kick to Google Sheets**](broken://pages/reY9fhWAe16axyIB0mj6) {% endhint %} *** ## Common use cases Once your reports are in Sheets, you can do more than view them. Some common ways business owners use Kick to Google Sheets: * **Share live financials:** Instead of exporting a PDF every month, share a Google Sheet with your accountant, team, or investors. They always see the latest numbers. * **Build your own dashboard:** Add charts, KPIs, and commentary on top of Kick data in whatever layout works for you. * **Create a reusable template:** Set up dashboard tabs with formulas that reference your Kick report tabs, then refresh the report data each period. Your dashboard tabs stay intact. * **Cash flow forecasting:** Import historical Cash Flow Statement data on a dedicated report tab, build your forecast on a separate tab, and refresh actuals on a schedule. *** ## One-time Set up ### Install the add-on 1. Open the [Kick listing on the Google Workspace Marketplace](https://workspace.google.com/marketplace/app/kick/83078251972) 2. Click **Install** and grant the requested permissions ### Open the add-on 1. Open a Google Sheet file from your Google Drive. You can create a new spreadsheet or open an existing one. 2. Open the Kick add-on under **Extensions → Kick**, or via the **side bar menu** (look for the Kick icon) {% embed url="" %} 1. If you're not signed in yet, click **Sign in to Kick** 2. Complete the login flow that opens in a new browser tab and approve access to Kick 3. When you see the confirmation message, close the tab and return to your spreadsheet 4. The sidebar updates to show your Kick profile when sign-in is complete To disconnect, open the settings icon (gear) at the top of the sidebar and click **Sign out**. {% hint style="info" %} **Pop-up blockers:** Kick sign-in opens in a new tab. If nothing happens when you click **Sign in to Kick**, allow pop-ups for Google Sheets (`docs.google.com`) and Kick (`kick.co`). See [Troubleshooting](#troubleshooting) below. {% endhint %} *** ## Add a report The sidebar has two tabs: **Reports** for adding new reports, and **Refresh** for keeping existing ones up to date. 1. On the **Reports** tab, select your **Workspace** 2. Select your **Entity**. This is a multi-select: check individual entities, or choose **All** to include everything in the workspace. 3. Choose a **Report type**, such as Profit & Loss, Balance Sheet, or General Ledger 4. Set your **Date range** 5. Adjust the **Advanced filters** if you need them 6. Click **Add report to sheet** {% embed url="" %} The report loads in a few seconds, and the sidebar confirms **Report imported.** Add as many reports as you'd like to the same spreadsheet. ### Advanced filters The filters available are similar to those each report has in Kick: * **Columns:** how the report is broken out, for example **Total only** or **By month** * **Class:** limit the report to specific classes * **Counterparty:** limit the report to specific customers or vendors * **Compare:** add comparison columns, such as the prior year and the percentage change
Advanced filters in the Kick to Google Sheets sidebar: Columns, Counterparty, and Compare
Each report goes into its own tab named after the entity and report type. {% hint style="warning" %} For dashboards, charts, or custom formulas, use **separate tabs** that reference the report tabs. Do not add columns or formulas directly to a report tab, because refresh rewrites report tabs in full. {% endhint %} *** ## Refresh reports Open the **Refresh** tab in the sidebar to see every report you've added to the **current spreadsheet**, grouped by entity. Each report shows when it was last updated, and the top of the tab shows when the spreadsheet last synced.
The Refresh tab showing one report and the auto refresh toggle
There are 2 available options to sync live data from Kick: **1. One time refresh** * **Refresh a single, selected report:** Click the refresh icon on the report row to pull the latest data from Kick. * **Refresh all reports in the worksheet:** Click **Refresh all reports** at the bottom of the tab to update every report in the spreadsheet at once. **2. Auto refresh** Turn on the **Auto refresh** toggle to have Kick keep the reports in this spreadsheet updated for you, so the numbers are current whenever someone opens the file. **What refresh changes** Kick rewrites the full report. Any extra columns, formulas, or formatting you added to a report tab will be **overwritten**. Tabs you created yourself, such as a dashboard or summary, are **not** touched by refresh. *** ## Share a spreadsheet You can share a spreadsheet that contains your Kick data with your accountant, team, investors, or anyone else. Sharing is handled entirely by **Google**, not Kick. **How to share** 1. Open the spreadsheet in Google Sheets 2. Click **Share** in the top-right corner (or go to **File → Share → Share with others**) 3. Add people by email, or click **Copy link** to generate a shareable URL 4. Set each person's role: * **Viewer:** can see the data but not edit or refresh * **Commenter:** can view and leave comments * **Editor:** can change the spreadsheet contents 5. Click **Send** or **Copy link**, depending on how you are sharing **Who can refresh Kick data** Only a Kick user with permissions to the data can add or refresh reports. People you share the sheet with can view (or edit) the spreadsheet in Google, but they cannot pull new data from Kick unless they sign in with their own Kick account that has access to that workspace. **Limit access to people who need it** Spreadsheets you share may contain sensitive financial data. We recommend sharing with the smallest group necessary and using **Viewer** access when someone only needs to read the numbers. Kick is **not responsible for who can access a spreadsheet once you share it through Google**. Kick cannot see, manage, or revoke Google sharing permissions. You control access from the **Share** button in Google Sheets at all times. {% hint style="warning" %} Before sharing externally, review who has access under **Share** and remove anyone who no longer needs it. Treat shared links like credentials. Anyone with the link may be able to open the file, depending on your Google sharing settings. {% endhint %} *** ## Where your data is saved Kick does **not** store your spreadsheet on Kick's servers. Everything is saved in **your Google account**: * **Which file:** The report is written into whichever Google Sheet you have open when you click **Add report to sheet**. Open or create that spreadsheet first. Kick does not create a separate file for you. * **Which tab:** Kick adds the report to a **tab** inside that spreadsheet, named after the entity and report type. * **Where it lives:** The spreadsheet is stored in **Google Drive**, like any other Google Sheet you own or have access to. You can move it to a shared drive folder, rename it, or organize it however you normally manage files in Drive. If you run multiple entities in one workspace, you can use a single spreadsheet with separate tabs for each entity, or keep each entity in its own spreadsheet. *** ## Troubleshooting
Can't sign in to Kick / nothing happens when I click Sign in Kick sign-in opens a **new browser tab**. If no tab opens, a pop-up blocker is usually the cause. 1. **Allow pop-ups** for `docs.google.com` and `kick.co` (check the blocked-pop-up icon in your browser's address bar, and disable pop-up blocking in ad blockers or privacy extensions) 2. Click **Sign in to Kick** again and complete login in the new tab 3. Click **Authorize** or **Approve** on the Kick connection screen. Do not close the tab before this step. 4. Return to your spreadsheet; the sidebar should update within a few seconds If it still fails: open the settings icon (gear) → **Sign out**, try again in a private/incognito window, or confirm you are signing into the correct Kick account.
Sign-in completed but the sidebar still shows "Not signed in" 1. Close the authorization tab and return to your spreadsheet 2. Reopen the sidebar: **Extensions → Kick → Open** 3. Wait up to 2 minutes. The sidebar checks for sign-in automatically. 4. If it still shows **Not signed in**, sign out and sign in again
"Sign-in not completed. Try again." The sidebar did not detect a finished sign-in within about 2 minutes. Usually the Kick tab was blocked, closed early, or authorization was skipped. Allow pop-ups, complete the full flow (sign in → approve → see the success message), and try again.
No workspaces or no entities appear Confirm your Kick account has access to the workspace and entity you need. Sign out and back in to refresh the list. If you work with an accountant, confirm they have access to the entity in Kick.
Report does not appear after clicking Add report to sheet Make sure you have a Google Sheet open, the date range is valid, and your connection is active. Try adding the report into a blank tab. If the issue persists, sign out and sign back in.
Connection failure or a similar login error Your session with Kick has likely expired. Open the settings icon (gear) → **Sign out**, sign back in, and add the report again.
Balance Sheet or Trial Balance is empty or fails These reports require opening balances in Kick. Go to **Accounting → Balance Sheet** in Kick, complete any opening balance setup, then try again.
Refresh does not update my data Use the refresh icon on the report row in the **Refresh** tab, or **Refresh all reports** to update everything at once. For hands-off updates, turn on the **Auto refresh** toggle. Only a Kick user with access to the data can refresh. Shared viewers cannot.
Data formatting looks wrong Existing formatting on a tab can interfere. Try adding the report into a blank tab, or clear formatting on the target tab first.
I see the wrong workspace or entity data The add-on uses whichever Kick account is signed in. Sign out, sign in with the correct account, and re-select the right **Workspace** and **Entity**.
*** ## FAQs
What happens to my other tabs and formulas when I refresh? Refresh rewrites the **report tab** with the latest data from Kick. Any columns, formulas, or formatting you added to that tab will be overwritten. **Other tabs are preserved.** If you build dashboards, charts, or summary formulas on separate tabs that reference the report data, those tabs are not changed by refresh, as long as your formulas point to cells that still exist after the refresh.
Can I add reports for multiple entities? Yes. The **Entity** selector is a multi-select, so you can check several entities or choose **All**. Each report is added to its own tab, and the **Refresh** tab groups them by entity.
Is there an extra cost? No. Kick to Google Sheets is included with your Kick account.
*** Need help? [Contact Kick support](https://kick.co/support). *** *Google Sheets™, Google Drive™ and Google Account™ are trademarks of Google LLC. Kick is not endorsed by or affiliated with Google LLC.* --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.kick.co/integrations/google-sheets.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.