- Create a new Google Sheet at sheets.google.com and copy its ID from the URL.
- Go to script.google.com → New project → paste the contents of
asset-tracking-bridge.gs.
- Fill in
API_KEY (any secret string) and SHEET_ID in the script config.
- Click Run → setupSheet() once to create the column structure.
- Click Deploy → New deployment → Web App.
Set "Execute as: Me" and "Who has access: Anyone". Copy the URL.
- Paste the URL and your API Key here, then click Save & Connect.
Once connected, all asset data syncs to Google Sheets automatically every 2 minutes and on every save — accessible from any device, any browser.