Skip to main content

Import Flourish Data into Google Sheets with Flourish for Sheets

Install the Flourish for Sheets add-on, connect it with a Flourish API key, and import inventory, outbound orders, shipments and master data into Google Sheets.

Flourish for Sheets is a Google Sheets add-on that imports current Flourish data straight into your spreadsheet. Pick a facility and filters, click Import, and the data imports into its own tab, ready for formulas, pivot tables, and charts. Refresh the tab whenever you need the latest numbers.

Read-only: the add-on reads data from Flourish only. It never creates, changes, or deletes anything in Flourish.
Replacing the managed Google Sheets export: if Flourish currently pushes data to a sheet you shared with us (see Export Data to Google Workspace), you can use this add-on to pull the same data yourself, on demand.

Prerequisites

Step 1: Create an API Key

  1. In Flourish, go to Settings > Integrations > API Keys
  2. Click the pencil icon on the API Keys card.
  3. Click the + icon to create a new key.
  4. Enter a Name such as "Flourish for Sheets", a Description, and an Expiration Date.
  5. Under permissions, select MODULES and check Read only, for the data you plan to import. (outbound orders, shipments, inventory summary, items, strains, destinations, and facilities)
  6. Under Locations, select the facilities you want to import, or All Facilities.
  7. Click CREATE, copy the key.
Tip: Give each person their own key with Read permission only. If a key is ever shared by mistake, you can delete it without affecting anyone else.

Step 2: Install the Add-on

  1. Open the Flourish for Sheets install link.
  2. Click Install and choose your Google account.
  3. Review the permissions and click Allow. The add-on asks to view and manage only the spreadsheet you have open, show its sidebars, and connect to Flourish.

Step 3: Connect Your API Key

  1. Open any Google Sheet.
  2. Select Extensions > Flourish for Sheets > API Settings.
  3. Paste your key into API Key.
  4. Click Save API Key. The add-on checks the key with Flourish before saving it and shows Connected and saved when it works.
Your key is yours: the key is stored in your Google account, not in the spreadsheet. If you share the sheet, each person who wants to import or refresh data connects their own key.

Step 4: Import Data

Select Extensions > Flourish for Sheets and choose an import. Each one creates a new tab with a header row.

Import

What you get

Options

Inventory Summary

Available, non-available and sellable quantities for one facility

Facility (required), Filter by Inventory Type (Cannabis, Raw Materials, Supplies), Group By (Item Name or Lot Number), Include only inventory with available quantity

Outbound Orders

One row per order, with destination, bill-to and origin facility details

Facility (optional; leave empty for all facilities), Order Status Filter

Outbound Orders with Line Items

One row per order line, with the order details repeated on every line

Same as Outbound Orders

Shipments

Shipments for one facility

Facility (required), Shipment Status Filter

Master Data

Active Items, Strains or Destinations

Click Import Items, Import Strains or Import Destinations

Facilities

Every facility in your company

None; it imports as soon as you select it

  1. Choose your facility and filters in the sidebar.
  2. Leave the field button on Preset for a curated set of columns in a fixed order, or click it to switch to All fields.
  3. Click the import button, for example Import Outbound Orders.
Tip: if your formulas refer to columns by position, use Preset. Preset columns stay in the same order every time you refresh.

Refresh a Tab

  1. Open the tab you want to update.
  2. Open the same import from Extensions > Flourish for Sheets and set the same filters.
  3. Check Refresh current sheet instead of creating new one and click the import button.
Refresh replaces the whole tab: everything on the tab is cleared and rewritten, including anything you typed or any formulas you added. Keep your formulas, pivot tables and notes on a separate tab that refers to the imported one.

Good to Know

  • Each import brings in up to 10,000 records. If there are more, a message tells you the results were capped; narrow them with a facility or status filter.
  • IDs, license numbers, SKUs and zip codes are kept as text, so leading zeros are preserved and lookups match what you see in Flourish.
  • Large imports take longer because the add-on pulls 50 records at a time.

Troubleshooting

If you see

Do this

Flourish for Sheets isn't in the Extensions menu

Reload the sheet. If it's still missing, check Extensions > Add-ons > Manage add-ons and make sure Flourish for Sheets is installed for the Google account you're using.

No API Key found

Open API Settings, paste your key and click Save API Key. Each Google account needs its own key.

Invalid API Key

The key was mistyped, has expired, or was refreshed or deleted in Flourish. Copy the current key from Settings > Integrations (Step 1) and save it again.

Facility ID is required

Inventory Summary and Shipments need a facility. Choose one from the dropdown.

No records, or fewer than expected

Check the status filters and facility. Also check that your API key has Read permission for that data and access to that facility.

Results were capped at 10,000 records

Pick a single facility or fewer statuses, then import again.

How did we do?

Export Data to Google Workspace