All Articles
Build custom reports and dashboards in Google Sheets with Streak’s new export features

Build custom reports and dashboards in Google Sheets with Streak’s new export features

5
min read
Overview:
Overview:

We’ve rebuilt Streak’s exporter to give you greater access to raw data, making it possible to create customized reports and dashboards in Google Sheets. 

As businesses grow, teams need deeper insights to track performance, refine workflows, and scale what works. With these updates, you can now export more types of data, apply precise filters, and automate exports to keep reports up to date—without the extra manual work.

Streak CRM data exports now allow you to:

✅ Export your team’s task and interaction data to Google Sheets: task completion, call logs, and meeting notes
✅ Filter and customize exports for cleaner data and specific date ranges
✅ Schedule Google Sheets exports with automated data refreshes
✅ Join data among multiple tables with box keys
✅ Get notified as soon as your exports are ready

Keep reading to learn how these updates help you export your data into Google Sheets and create reliable reports and dashboards for your team.

Export your team’s task and interaction data into Google Sheets

In addition to exporting pipeline data like boxes, contacts, and organizations, you can now export data from your call logs and meeting notes to better understand how team interactions impact deal progress and success.

Streak New Exporter interface displaying available data fields for exporting tasks and meeting notes & call logs.

Exporting interaction data for top-performing reps helps you identify patterns, like whether a higher volume of calls and meetings leads to more closed deals or faster sales cycles. These insights can help refine sales strategies, optimize team workflows, and improve coaching efforts.

Access to task and call log data from your CRM allows you to create any number of custom reports, including:

  • Tasks marked completed by team member each week
  • Leaderboard of calls completed each week, by team member
  • Overdue tasks that each team member currently has outstanding

Set precise filters to export exactly the data you need

Streak captures a wealth of data as your team works on deals. With new filtering options, you can now set precise date ranges and choose only the data that matters—ensuring cleaner, more targeted data for your reports.

Choose your data source

Instead of exporting your entire pipeline, new data source options let you be more specific about which deals you want to see.

Streak CRM export pipeline data dialog in Gmail, displaying data source options, including selected boxes and saved views

You can now choose to export:

  • All deals in pipeline
  • Selected boxes (using the check box in pipeline view)
  • Deals included in a saved view segment

This gives you greater flexibility to analyze specific opportunities and track progress in key areas to generate more actionable insights.

Select date ranges

Select date ranges for your export to report on your data monthly, quarterly, or at other frequencies. 

 Screenshot of an "Export Pipeline Data" interface with a dropdown menu open. Options include date ranges like "Today," "Yesterday," "Last 7 days," and "Month to date," which is selected. Buttons for "Cancel" and "Start Export" are at the bottom.

This allows you to track trends over time, compare performance across different periods, and measure progress toward key goals. By aligning exports with your reporting cycles, you can generate more relevant insights and make data-driven decisions with up-to-date information.

Schedule exports and automate data refreshes [coming soon!]

Eliminate manual exports and keep your data fresh with scheduled exports. Schedule exports daily, weekly, or monthly so your KPI dashboards always reflect the latest CRM insights—no extra effort needed.

A user interface for exporting pipeline data. Options include a one-time export button and a scheduled export button labeled as "soon." There are dropdowns for selecting data boxes and exporting to a new Google sheet.

Schedule exports to Google Sheets to create reports and dashboards or use Google Sheets as a live data source for tools like Tableau and Looker Studio. This automates your data connection with fresh, accurate information for reporting and decision-making.

Once you’ve scheduled an export, you can easily manage the schedule—view, pause, delete, or track export history—for complete control over your data.

Scheduling exports is available on Pro+ and enterprise plans.

Export team activity newsfeed to Google Sheets

Previously, newsfeed data—the history of your team’s CRM activity—could only be exported as a CSV, making it difficult to keep reports up to date. Now, you can schedule newsfeed exports directly to Google Sheets and update an existing sheet with new data. This ensures your data automatically refreshes on a regular schedule.

Export Pipeline Data interface showing options to export data to a new Google Sheet or existing one. Items included are Boxes, Contacts and Orgs, Newsfeed, Tasks, and Call Logs and Meeting Notes. Buttons for cancel or start export are visible.

Schedule newsfeed exports to track real-time activity, like:

  • Updates to deal stages or other important CRM fields
  • Team interactions
  • Assignments and changes to deal ownership

With scheduled newsfeed exports, teams can analyze patterns in deal progress, measure sales rep activity, and spot bottlenecks in their pipeline. Managers get a clearer view of how deals move through the CRM, helping them identify trends, optimize workflows, and improve team performance.

Join your data tables with box keys

Now, every exported deal includes a box key, making it easy to join different tables of data for more comprehensive analysis. 

Instead of working with isolated spreadsheets, you can link deal records with interactions and pipeline activity like call logs, meeting notes, tasks, and other team activity to create a complete view of your pipeline.

Joinable data allows teams to create more powerful reports in Google Sheets, Looker Studio, or Tableau without manual data wrangling.

Get notified when your export is ready

No more waiting or checking manually—now, you'll receive a notification email as soon as your export is complete. The email includes a direct link to your Google Sheet export so you can access your updated data immediately. If you prefer, you can also download the export as a CSV file with a single click.

Fresh, actionable CRM reports – automatically

New Streak export features give you greater control over your CRM data, making it easier to track team activity, automate reports, and analyze trends over time.

Whether you’re building real-time dashboards in Google Sheets or importing your Streak data into tools like Tableau and Looker Studio, these updates help you work more efficiently with cleaner, more actionable data.

A Streak project management dashboard displays a sales pipeline. It includes stages like Lead and Contacted, with tasks assigned to various people. A menu is open showing options like Export and Integration. Several deals and their values are listed.

To start using these features, head to your Streak pipeline and explore the new export options. 

Pro+ plan users can set up scheduled exports to keep your reports up to date automatically.

Related articles

We're hiring

Come build something great with us.