Using data streams

Supported platforms

You can stream data to the following integrations:

  • Google Sheets

  • Microsoft Excel (via OneDrive / Microsoft 365)

  • Airtable

  • Notion

Setting up a Data Stream

1. Create a saved view

Data Streams are powered by saved views. Before setting up a stream, make sure you've saved a view in your camper or staff Datatable with the columns and filters you want to sync. For example, a view called "Session 1 - Enrolled campers" that filters by session and stage.

2. Open Data Streams

Navigate to the camper or staff Datatable and click the Data Streams icon, or use the Command Bar and search for "Data Streams".

3. Connect your account

You can't add a stream until you've connected at least one integration. If you haven't connected one yet, you'll see a Connect button for each platform (Google Sheets, Microsoft Excel, Airtable, or Notion). Follow the prompts to authorize your account. You only need to do this once per platform - after connecting, you can create more streams on that platform without re-authorizing.

4. Add a new stream

Click Add stream and choose your connected integration. For Airtable, you'll also be prompted to select your base. For Notion, you'll be prompted to select a parent page, and Campfront creates a new database inside it.

5. Link a saved view

Select the saved view you want to sync. The columns and filters from that view determine exactly what data gets pushed to the external tool.

Syncing and management

  • Automatic sync - once set up, Campfront pushes updates to your external tool approximately once per hour. No manual effort required.

  • Manual sync - trigger an immediate update at any time by clicking Sync Now from the Data Streams table.

  • Last synced - the Data Streams table shows when each stream was last synced, so you always know how fresh your data is.

  • Edit or delete - update a stream's settings or remove it entirely if you no longer need the sync.

When to use Data Streams

Data Streams are ideal for workflows that need regularly updated data without manual intervention. Some examples:

  • Sharing with vendors - keep an outside transport company up to date with a live camper list for bus manifests.

  • Board reporting - maintain a live spreadsheet for your board of directors with enrollment numbers and financial summaries.

  • Cross-department access - give teams who don't use Campfront direct access to the data they need in a tool they already use.

  • Backup and archival - maintain a running copy of key data in Google Sheets or Excel for your records.

Tips

  • If you update the saved view that a Data Stream is linked to (e.g., change columns or filters), the next sync will reflect those changes automatically.

  • You can create multiple streams from different saved views to push different data sets to different platforms.

  • Data Streams are one-way - they push data from Campfront to your external tool. Changes made in the external tool are not synced back.

Was this helpful?