ManualTrigger Automate

For Gong, this manual-triggered workflow automates the extraction and processing of sales call data, enhancing accuracy by integrating competitor insights and previous call summaries. It efficiently removes duplicates, generates clean transcripts, and ensures only new calls are processed, ultimately streamlining data handling and improving decision-making across departments.

7/8/2025
26 nodes
Complex
manualcomplexgongsticky noteexecuteworkflowexecuteworkflowtriggeraggregategooglesheetsnotionsplitoutcomparedatasetssplitinbatchesnoopadvanced
Categories:
Complex WorkflowManual TriggeredData Processing & AnalysisBusiness Process Automation
Integrations:
GongSticky NoteExecuteWorkflowExecuteWorkflowTriggerAggregateGoogleSheetsNotionSplitOutCompareDatasetsSplitInBatchesNoOp

Target Audience

Target Audience


- Sales Teams: Professionals looking to analyze sales calls for insights and improvements.
- Data Analysts: Individuals who need to aggregate and process data from various sources.
- Marketing Teams: Users aiming to understand competitor positioning through call analysis.
- Business Intelligence Professionals: Those interested in integrating call data with other business metrics for comprehensive reporting.

Problem Solved

Problem Solved


This workflow addresses the challenge of efficiently processing and analyzing sales calls from Gong. It automates the extraction of call data, removal of duplicates, and integration with Google Sheets and Notion, ensuring that valuable insights are not missed and that data is kept clean and actionable.

Workflow Steps

Workflow Steps


1. Manual Trigger: The workflow is initiated manually when the user clicks ‘Test workflow’.
2. Data Extraction from Gong: Calls from the last 2 days are fetched from Gong, providing relevant data for analysis.
3. Aggregation of Calls: The fetched call data is aggregated to simplify further processing.
4. Competitor Data Retrieval: Competitor information is sourced from Notion, enhancing the context of the analysis.
5. Integration Data Retrieval: Data from Google Sheets is collected to understand integrations used by the company.
6. Data Processing: The workflow processes the transcripts of the calls, preparing them for analysis.
7. Duplicate Removal: The workflow checks for previously processed calls to avoid duplication.
8. Call Analysis: Calls are looped through, and transcripts are processed to extract key insights.
9. Final Output: The workflow concludes by aggregating the processed data into a structured format for reporting.

Customization Guide

Customization Guide


- Adjust Date Range: Modify the toDateTime and fromDateTime parameters in the Gong node to change the date range for data extraction.
- Edit Sticky Notes: Customize the content of sticky notes to reflect specific insights or reminders that are relevant to your team.
- Change Workflow Triggers: Users can replace the manual trigger with other triggers like webhooks or scheduled triggers based on their needs.
- Integrate Additional Data Sources: Add more nodes to integrate with other data sources or tools that your organization uses for a more comprehensive analysis.
- Modify Output Structure: Adjust the merge and aggregation nodes to change the format of the final output as per your reporting requirements.