Using data streams

Data Streams let you automatically sync your Campfront data to external tools. While CSV exports are great for one-time reports, Data Streams take any saved view from your camper or staff Datatables and push that data to a supported platform on an ongoing basis.

Written By Marshall Ivler

Last updated 25 days ago

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. Add a new stream

Click Add stream and choose your integration (Google Sheets, Microsoft Excel, Airtable, or Notion). For Airtable, you'll also be prompted to select your base.

4. 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.

5. Connect your account

Follow the prompts to authorize your Google, Microsoft, Airtable, or Notion account. You only need to do this once per platform - after connecting, you can create additional streams without re-authorizing.

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.