How it works
To move data from botHelp to Google Sheets automatically, use a ready-made scenario — no manual exports.
- Starts when: Schedule Trigger
- Then: FMP_Stock_Screener
- Then: Score_and_Prefilter
- Then: Write_Scan_Opportunities
- Check: loop_over_tickers
- Then: Build Summary
- Then: Send a text message
- Then: Seekingalpha Articles
- Then: Clean the news
- Check: If1
- If yes: XML
- Then: Edit Fields2
- Then: Final version of news
- Check: Merge1
- Then: First round ChatGPT
- Then: Clean Up ChatGPT
- Check: Merge
- Then: Clean Up Results from First Round
- Check: Needs Tiebreaker?
- If yes: Tide Breaker - Bull
- Then: Clean up Chatgpt 2
- Check: Merge6
- Then: TideBreaker Cleanup
- Check: Merge7
- Check: If
- If yes: Get Previous Verdict
- Then: Thesis Reversal Enricher
- Then: Alert Filter
- Check: If Alert?
- If yes: Get Price History
- Then: Consolidate price history
- Then: Get Earnings
- Then: Technical & Earnings Enricher
- Then: Risk_Manager
- Check: Above 50MA & SELL?
- If yes: Telegram Alert
- Check: Is Thesis Reversal?
- If yes: Thesis Reversal Alert
- Then: Log_Signal_Outcome
- If no: Above 50MA and BUY?
- If no: Watchlist Telegram
- Then: write_sentiment_to_sheets
- Then: Wait
- If yes: Tide Breaker - Bear
- Then: Clean up Gemini 2
- If no: No Tidebreaker
- Then: First round Gemini
- Then: Clean up Gemini
- If no: return the news
- Then: FMP - Profile
- Then: Clean Profile
- Check: Merge3
- Check: Merge2
- Check: Merge4
- Check: Merge66
- Check: Merge77
- Check: Merge88
- Check: Merge99
- Then: Clean Read Financial
- Then: FMP - Income Statement
- Then: Aggregate1
- Then: Clean Income statement
- Then: FMP - CashFlow
- Then: Aggregate2
- Then: Clean Ccashflow
- Check: Merge5
- Then: FMP- Current Price
- Then: Clean Current Price
- Then: FMP - Balance Sheet Quarter
- Then: Aggregate
- Then: Clean balance quarter sheet
- Then: FMP - Income Statement annual
- Then: Clean Income statement annual
- Then: FMP - Balance Sheet Annual
- Then: Clean balance sheet Annual
- Then: FMP - CashFlow Annual
- Then: Clean Ccashflow Annual
- Then: FMP - Key Metrics TTM
- Then: FMP - Key Metrics TTM1
You can launch this botHelp + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.