> ## Documentation Index
> Fetch the complete documentation index at: https://beebole.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Sheets Add-on: Link Sheets to Reports

> Link Google Sheets to your saved Beebole reports and refresh time tracking, billing, and project data from a sidebar — no manual exports.

The Beebole Google Sheets add-on links sheets in your spreadsheet to your saved Beebole reports. Instead of exporting files and importing them by hand, you save a report once in Beebole, link a sheet to it, and refresh the data from the **Beebole Reports** sidebar whenever you need the latest figures.

<Info>
  The add-on loads saved reports. Build and save the report you need in Beebole first — its columns, filters, and period all come from the report configuration, not from the add-on.
</Info>

***

## How the add-on works

Each sheet links to one saved Beebole report. When you refresh, the add-on runs the report in your Beebole account, clears the linked sheet, and writes a header row followed by the report data. The links are stored in the spreadsheet, so they travel with the file when you share it.

The add-on connects with your Beebole API key — you never enter a password. The key is stored privately for your Google account and is never saved inside the spreadsheet.

***

## Installing the add-on

<Steps>
  <Step title="Open the Google Workspace Marketplace">
    In Google Sheets, click **Extensions** > **Add-ons** > **Get add-ons**.
  </Step>

  <Step title="Install the Beebole add-on">
    Search for **Beebole**, open the add-on, and click **Install**. Grant the requested permissions when prompted.
  </Step>

  <Step title="Open the sidebar">
    In the **Extensions** menu, open the Beebole add-on and click **Open Beebole Reports**. Once installed, the sidebar also opens automatically when you open the spreadsheet.
  </Step>
</Steps>

***

## Connecting with your API key

The first time you open the sidebar, the add-on asks for your Beebole API key.

<Steps>
  <Step title="Copy your API key from Beebole">
    In Beebole, click the button with your initials at the bottom of the sidebar, then **API Key**. Click **Copy**.
  </Step>

  <Step title="Paste the key into the add-on">
    In the sidebar, paste the key into the **API Key** field and click **Connect**.
  </Step>
</Steps>

<Info>
  The API key gives the add-on the same access as your Beebole account: you only see the saved reports — and the data — that your [role and authorizations](/help/documentation/roles-authorisations) allow. The **Reset** button next to your API key in Beebole revokes the current key and generates a new one.
</Info>

***

## Linking a sheet to a report

<Steps>
  <Step title="Open the add-link form">
    In the sidebar, click **+ Add link** under **Beebole reports linked**.
  </Step>

  <Step title="Pick a report">
    In the **Add Report Link** form, select one of your saved Beebole reports in the **Report** field.
  </Step>

  <Step title="Pick a sheet">
    Choose an existing sheet in the **Sheet** field, or type a name in **New sheet name** to create one.
  </Step>

  <Step title="Confirm">
    Click **Add Link**. The link appears in the **Beebole reports linked** table.
  </Step>
</Steps>

To remove a link, click the **✕** button (**Remove link**) next to it in the table. This removes the link only — the sheet and its current data stay in place.

***

## Refreshing your data

In the **Refresh** section of the sidebar:

* **Refresh This Sheet** — refreshes the sheet you are currently viewing.
* **Refresh All** — refreshes every linked sheet in the spreadsheet.

The add-on also refreshes automatically: when you open the spreadsheet, the sidebar opens and refreshes every linked sheet.

<Warning>
  Refreshing clears the linked sheet before writing the new data. Anything you typed into that sheet — formulas, notes, formatting — is removed. Keep your own calculations and charts in separate sheets that reference the linked one.
</Warning>

If a linked report no longer exists in Beebole, the add-on writes an error message to the sheet so you know the link needs updating.

***

## Updating or removing your API key

Click **Update API** at the top of the sidebar to open the key settings:

* Paste a new key into **New API Key** and click **Update API Key**. Switching to a different key clears the spreadsheet's existing report links, since they belonged to the previous account's reports.
* Click **Remove API Key** to delete your saved key. You will need to enter a key again to use the add-on.

***

## Related content

<CardGroup cols={2}>
  <Card title="Reports" icon="chart-line" href="/help/documentation/reports">
    Understand report dimensions, filters, grouping, and columns in Beebole.
  </Card>

  <Card title="Custom Reports" icon="chart-bar" href="/help/documentation/custom-reports">
    Build and save the reports your linked sheets will load.
  </Card>

  <Card title="Excel Add-in" icon="file-excel" href="/help/documentation/excel-addin">
    Link Excel worksheets to your saved Beebole reports the same way.
  </Card>

  <Card title="Data Exports" icon="download" href="/help/documentation/data-exports">
    Download one-off exports in Excel, CSV, PDF, and other formats.
  </Card>
</CardGroup>

## Frequently asked questions

<AccordionGroup>
  <Accordion title="Can I configure columns and filters inside the add-on?">
    No. The Beebole Google Sheets add-on loads saved reports exactly as they are configured in Beebole. To change the columns, filters, or period of the data in a sheet, edit the saved report in Beebole and refresh the sheet.
  </Accordion>

  <Accordion title="Can I share the spreadsheet with people who do not use Beebole?">
    Yes. The refreshed report data is ordinary cell values, so anyone you share the spreadsheet with can read it. The sheet-to-report links travel with the file, but your API key does not — to refresh the data, a person connects with their own Beebole API key, which shows only the reports their account can access.
  </Accordion>

  <Accordion title="Does refreshing overwrite my formulas?">
    Yes. A refresh clears the linked sheet completely before writing the report data. Place your own formulas, pivot tables, and charts in separate sheets that reference the linked sheet, so they survive every refresh.
  </Accordion>

  <Accordion title="Can I refresh the data automatically?">
    The Beebole add-on refreshes every linked sheet automatically when you open the spreadsheet. For anything in between, use **Refresh This Sheet** or **Refresh All** in the sidebar.
  </Accordion>
</AccordionGroup>