Vendor API Integrations

Overview

LoopString integrates with external services to automate data flows beyond your IoT dashboard. Send alerts to Zapier for custom workflows, export sensor data to Google Sheets for analysis, or sync energy costs to QuickBooks for accounting.

Manage integrations at Settings > Integrations (/settings/integrations).

Zapier Webhooks

Zapier integration sends event data to a webhook URL whenever specific events occur in your LoopString system.

Setup

1. Go to Settings > Integrations.
2. Click Add under Zapier.
3. Paste your Zapier webhook URL.
4. Select which events trigger the webhook:
   • Alert triggered — When a sensor breaches its threshold.
   • Alert resolved — When a breached sensor returns to normal.
   • Sensor reading — Periodic sensor data pushes.
   • Actuator toggled — When an actuator state changes.
   • Recipe stage changed — When a recipe advances to the next stage.
5. Optionally set a batch interval (in minutes) to group events and reduce webhook calls.
6. Click Save.

Testing

Click the Test button to send a sample payload to your webhook URL. The test verifies the URL is reachable and shows the HTTP response status.

Webhook Payload Format

Each webhook sends a JSON payload with:

• type — The event type (e.g., alert_triggered).
• timestamp — ISO 8601 timestamp.
• deviceId and deviceName — The source device.
• data — Event-specific details (sensor values, alert info, etc.).

Google Sheets Export

Export sensor data directly to a Google Sheets spreadsheet for analysis, charting, or sharing with team members who don't use LoopString.

Setup

1. Click Add under Google Sheets.
2. Click Connect to authorize LoopString's access to your Google account.
3. Select which sensors to export and the export interval (every 5, 15, or 60 minutes, or daily).

Note: Full Google OAuth integration is coming in a follow-up release. The connect button is currently a placeholder.

QuickBooks Expense Sync

Sync energy costs from your devices as expenses in QuickBooks for automated bookkeeping.

Setup

1. Click Add under QuickBooks.
2. Click Connect to authorize access.
3. Map actuators to QuickBooks expense categories.
4. Set sync frequency (monthly).

Note: Full QuickBooks OAuth integration is coming in a follow-up release. The connect button is currently a placeholder.

Managing Integrations

• Toggle active/inactive — Use the switch to temporarily disable an integration without deleting its configuration.
• Delete — Remove an integration permanently.

Related Documentation

• Alarm Thresholds — Alert configuration that triggers webhooks
• Energy Cost Tracking — Energy data that feeds QuickBooks sync
• Analytics and History — Sensor data that feeds Sheets export