Turn recent sales calls into clear insights with an automated preprocessor for Gong recordings. The flow gathers calls, cleans the transcript, adds product and competitor context, and sends everything to a child processor that returns structured JSON for sales use.

Two start options are available. You can run it by hand or let another workflow call it. It pulls the last two days of calls from Gong, collects integration names from Google Sheets, and fetches a competitor list from Notion. The flow merges these details so name checks and typos are easier to catch. A Notion check removes calls that were already handled, so the queue only includes new work. Each call then moves through a loop that builds a clean transcript and passes it to the child workflow for final parsing.

You will need access to Gong, Google Sheets, and Notion. Set credentials in n8n Cloud, point the Google Sheet and Notion databases to the right tables, and confirm the Execute Workflow node points to your transcript processor. Expect faster reviews, fewer repeats, and better accuracy in names and terms. Sales and RevOps teams can use the output for coaching, pipeline notes, and product feedback at scale.

• Pulls the last two days of call data from Gong with dynamic dates
• Aggregates all call records into one list for easier handling
• Reads integration names from Google Sheets and formats them into a clean string
• Fetches competitor names from Notion and builds a comma separated list
• Merges call, integration, and competitor data into one payload
• Checks Notion for previously processed calls and filters out duplicates
• Loops through each call to generate a clean transcript string
• Sends each transcript to a child workflow and returns structured JSON

• Reduce manual review from 2 hours to 10 minutes per call
• Eliminate duplicate processing of past calls
• Improve transcript name accuracy with product and competitor context
• Connect Gong, Google Sheets, and Notion in one flow
• Scale to handle large call queues with batch looping

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Gong, Google Sheets and Notion. See the Tools Required section above for links to create accounts with these services.
3. Open the Gong node and create a new credential in the n8n credentials manager. Choose Create new credential and follow the on screen steps to connect your Gong account.
4. Open the Get Integrations node and create a Google Sheets OAuth credential. Click Create new credential and follow the prompts. Select the spreadsheet and worksheet that hold your integration list.
5. Open both Notion nodes and create a Notion credential. Share the needed databases with your Notion integration so n8n can read and write as required.
6. In the Gong node, review the date range. It defaults to the last two days. Adjust if you want a different window.
7. In the Get list of Competitors node, select the correct Notion database and map the property that stores competitor names.
8. In the Get Previous Phone Calls node, select the Notion database that stores processed call IDs. Make sure the property used to store the call ID matches the field used in the Isolate Only Call IDs node.
9. Open the Execute Workflow node labeled Transcript Processor and select your child workflow that parses transcripts and returns structured JSON.
10. Click Test workflow to run a sample. Check the Only Process New Calls node to confirm duplicates are removed.
11. Review outputs from Process All Call Transcripts. Confirm you see structured fields such as speakers, actions, and next steps from the child workflow.
12. If no calls load, verify Gong permissions and date filters. If duplicates still pass, confirm the call ID field matches in Notion. If Google Sheets shows blank, check the sheet range and access.