TradingView Daily Stock Extractor

Overview

Filtering TradingView alert emails manually wastes time and risks missed signals. This template automates daily email detection, extracts stock symbols from alerts, records them in Google Sheets, and sends instant summary notifications—eliminating manual drudgery and ensuring timely, consistent data capture.

The Impact

Automate symbol extraction. No more manual scanning of alert emails.
Centralize data logging. All symbols recorded daily in Google Sheets for easy analysis.
Instant notifications. Receive timely email summaries of detected stock symbols.
Improve accuracy. Regex-based extraction reduces errors and duplicates.

Who This Is For

Quantitative Researchers aggregating daily TradingView signals for backtesting strategies.
Active Traders needing real-time alerts and recordkeeping of triggered stock signals.
Market Analysts monitoring frequently mentioned stocks for sentiment and trend spotting.
Data Analysts automating extraction and logging of financial alert data.

How It Works

Get Today Date
Calculate today and tomorrow's date strings to filter emails within the current day.

Get Today Emails
Retrieve all TradingView alert emails sent today using Gmail API with time and sender filters.

Extract Stock Symbols
For each email, extract stock symbols using multiple regex patterns, deduplicate, and count them.

Record and Notify
Append extracted data to Google Sheets and send a notification email summarizing detected symbols.

Complete
End workflow after processing all emails and logging results.

What You'll Need

Before using this template, make sure you have:

Gmail OAuth credentials configured to access your email for alert retrieval.
Google Sheets OAuth credentials to append data to your spreadsheet.
A Google Sheets spreadsheet with headers set to Date, Symbols, Symbol Count, and Original Subject.
Access to the spreadsheet ID and target range or sheet name for data entry.
An email address to receive daily notifications of extracted symbols.

How to Use

Step 1. Prepare Google Sheets

Create a Google Sheets table with columns: Date, Symbols, Symbol Count, Original Subject.

Step 2. Configure Credentials

Set up Gmail and Google Sheets OAuth credentials in the workflow.

Step 3. Set Parameters

Input SpreadsheetId, RangeName, and NotificationEmail in the start node.

Step 4. Run the Workflow

Execute to automatically fetch, extract, log, and notify based on today’s TradingView emails.

Step 5. Verify Results

Check your Google Sheets for new entries and confirm receipt of notification emails.

FAQs

How does the workflow identify which emails to process?

It filters emails sent today from noreply@tradingview.com using date boundaries generated by the "Get Today Date" node.

What stock symbol formats does it extract?

It detects symbols in formats like NASDAQ:AAPL, NYSE:TSLA, and $AAPL using regex patterns to cover common TradingView alert styles.

How are extracted symbols recorded?

Symbols and related details are appended as rows in the specified Google Sheets range, including date, symbol list, count, and original email subject.

Will I receive notifications for every email processed?

Notifications are sent only when stock symbols are detected in the emails, summarizing the findings.

Can this workflow handle multiple TradingView alert emails per day?

Yes, it processes each alert email individually in a loop, extracting and logging symbols from all emails received that day.

Updated on: Aug 21, 2026

Was This Page Helpful?