Skip to main content
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.
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.

​
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

1

Open the Google Workspace Marketplace

In Google Sheets, click Extensions > Add-ons > Get add-ons.
2

Install the Beebole add-on

Search for Beebole, open the add-on, and click Install. Grant the requested permissions when prompted.
3

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.

​
Connecting with your API key

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

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.
2

Paste the key into the add-on

In the sidebar, paste the key into the API Key field and click Connect.
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 allow. The Reset button next to your API key in Beebole revokes the current key and generates a new one.

​
Linking a sheet to a report

1

Open the add-link form

In the sidebar, click + Add link under Beebole reports linked.
2

Pick a report

In the Add Report Link form, select one of your saved Beebole reports in the Report field.
3

Pick a sheet

Choose an existing sheet in the Sheet field, or type a name in New sheet name to create one.
4

Confirm

Click Add Link. The link appears in the Beebole reports linked table.
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.
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.
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

Reports

Understand report dimensions, filters, grouping, and columns in Beebole.

Custom Reports

Build and save the reports your linked sheets will load.

Excel Add-in

Link Excel worksheets to your saved Beebole reports the same way.

Data Exports

Download one-off exports in Excel, CSV, PDF, and other formats.

​
Frequently asked questions

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.
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.
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.
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.