[P2] Test Google Sheets add-in Data Connector deployment #1
Description
Priority: P2 (Important, Not Urgent)
Description
Test the new Data Connector feature in the Google Sheets add-in by deploying to Apps Script.
Tasks
- Deploy Code.gs to Google Apps Script
- Configure API key with Data Connector enabled account
- Test menu item "Fetch Bunker Prices (Data Connector)"
- Verify "Bunker Prices" sheet is created with correct format
- Test BUNKER_PRICE(port, fuelType) custom function
- Test BUNKER_PORT_PRICES(port) custom function
- Test error handling for accounts without Data Connector access
Acceptance Criteria
- Menu item successfully fetches and displays bunker fuel prices
- Custom functions work in cell formulas
- Sheet formatting matches specification (9 columns, green header)
- Error messages are user-friendly
Related
- Data Connector API:
/v1/prices/data-connector - Commit: 99f1cef