Home › Use Cases › Cannabis Dispensary Menu & Inventory API

Turn Google Sheets into a Cannabis Dispensary Menu & Inventory API API

Power your dispensary menu, strain catalog, and inventory display via Google Sheets API.

Start Free — 30 Second Setup →

The Problem

Dispensaries update menus multiple times daily as stock changes, but updating websites manually is slow and leads to customers arriving for unavailable products.

The Solution

SheetAPI converts your inventory sheet into a live API. Your website shows real-time stock, prices update automatically, and sold-out items disappear instantly.

1

Set Up Your Google Sheet

Create a spreadsheet with columns like: SKU, Product Name, Category, THC %, CBD %, Price, Quantity, Status

2

Connect to SheetAPI.pro

Sign up (takes 10 seconds), authorize Google, and paste your sheet URL. Done.

3

Start Using Your API

Get instant REST API endpoints to create, read, update, and delete your cannabis dispensary menu & inventory api data.

Code Examples

Here's how simple it is to work with your cannabis dispensary menu & inventory api data:

Fetch All Records

# Using cURL curl -H "Authorization: Bearer YOUR_API_KEY" \ https://api.sheetapi.pro/v1/YOUR_SHEET_ID
// Using JavaScript (fetch) const response = await fetch('https://api.sheetapi.pro/v1/YOUR_SHEET_ID', { headers: { 'Authorization': 'Bearer YOUR_API_KEY' } }); const data = await response.json(); console.log(data); // Your cannabis dispensary menu & inventory api records

Create a New Record

# Using cURL curl -X POST \ -H "Authorization: Bearer YOUR_API_KEY" \ -H "Content-Type: application/json" \ -d '{"SKU":"VALUE1","Product Name":"VALUE2"}' \ https://api.sheetapi.pro/v1/YOUR_SHEET_ID
// Using JavaScript (fetch) const newRecord = { 'SKU': 'Sample value', 'Product Name': 'Another value' }; const response = await fetch('https://api.sheetapi.pro/v1/YOUR_SHEET_ID', { method: 'POST', headers: { 'Authorization': 'Bearer YOUR_API_KEY', 'Content-Type': 'application/json' }, body: JSON.stringify(newRecord) });

Update a Record

// Update by row ID const response = await fetch('https://api.sheetapi.pro/v1/YOUR_SHEET_ID/ROW_ID', { method: 'PATCH', headers: { 'Authorization': 'Bearer YOUR_API_KEY', 'Content-Type': 'application/json' }, body: JSON.stringify({ 'Status': 'Updated' }) });

Key Features for Cannabis Dispensary Menu & Inventory API

⚡ Real-Time Sync

Changes in your Google Sheet reflect in the API instantly. No delays, no manual syncing.

🔔 Webhooks

Get notified instantly when data changes. Trigger automations, send emails, or update other systems.

📝 Full CRUD Operations

Create, Read, Update, and Delete records via REST API. Complete control over your data.

⚙️ Smart Caching

Lightning-fast responses with intelligent caching. Reduce API calls and improve performance.

Frequently Asked Questions

Can menus update automatically when stock changes?

Yes! Update inventory via API and your menu reflects changes instantly with a fresh cache.

How do I handle daily price changes?

Update price fields via API and all connected menus—website, digital displays, kiosks—sync automatically.

Can I filter menu by category or effect?

Absolutely! Query the API with category or tag filters to show targeted product sections.

Related Use Cases

Product Catalog & Database

Build a product catalog API from Google Sheets to manage product data, specifications, and images....

Inventory Management

Turn Google Sheets into an inventory API to track stock levels, monitor products, and automate reord...

Dynamic Price List & Catalog

Convert Google Sheets into a pricing API to power websites, apps, and quotes with real-time pricing....

Ready to Get Started?

Turn your Google Sheets into a powerful cannabis dispensary menu & inventory api API in 30 seconds.

Start Free Now →