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.
Prerequisites
- A Google account with access to Google Sheets.
- A Flourish user role with Update access to Integrations, or someone in your company who has it, to create the API key. See Flourish Software External API Key Management.
Step 1: Create an API Key
- In Flourish, go to Settings > Integrations > API Keys
- Click the pencil icon on the API Keys card.
- Click the + icon to create a new key.
- Enter a Name such as "Flourish for Sheets", a Description, and an Expiration Date.
- 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)
- Under Locations, select the facilities you want to import, or All Facilities.
- Click CREATE, copy the key.
Step 2: Install the Add-on
- Open the Flourish for Sheets install link.
- Click Install and choose your Google account.
- 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
- Open any Google Sheet.
- Select Extensions > Flourish for Sheets > API Settings.
- Paste your key into API Key.
- Click Save API Key. The add-on checks the key with Flourish before saving it and shows Connected and saved when it works.
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 |
- Choose your facility and filters in the sidebar.
- Leave the field button on Preset for a curated set of columns in a fixed order, or click it to switch to All fields.
- Click the import button, for example Import Outbound Orders.
Refresh a Tab
- Open the tab you want to update.
- Open the same import from Extensions > Flourish for Sheets and set the same filters.
- Check Refresh current sheet instead of creating new one and click the import button.
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