Stock price targets and signals, into a sheet and your chat

On schedule the scenario gathers financials and news for your tickers, analyzes them with AI and delivers a price target and a buy-hold-sell signal.

  • Gathers financials and news for each ticker
  • Two AIs analyze the company and set a price target
  • A buy-hold-sell signal across the whole list
  • Results in a sheet and straight to your chat
Google SheetsAlpha Vantage
Set it up for yourselfScriptera

How it works

To move data from botHelp to Google Sheets automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Schedule Trigger
  2. Then: Read_tickers_from_Sheet
  3. Check: loop_over_tickers
  4. Then: Send a text message
  5. Then: Cache Lookup
  6. Then: Check the cache
  7. Check: Is Cache Valid?
  8. If yes: alphavantage - Balance Sheet
  9. Then: Clean balance sheet
  10. Check: Merge2
  11. Check: Merge4
  12. Then: Clean Read Financial
  13. Check: If2
  14. If yes: Update row in sheet
  15. Then: Merge New Financial
  16. Check: Merge1
  17. Then: Message a model
  18. Then: Clean Up ChatGPT
  19. Check: Merge
  20. Then: Code in JavaScript
  21. Check: If
  22. If yes: write_sentiment_to_sheets
  23. Then: Message a model1
  24. Then: Clean up Gemini
  25. If no: Insert Row
  26. If yes: alphavantage - Profile
  27. Then: Clean Profile
  28. Check: Merge3
  29. If yes: alphavantage - Income Statement
  30. Then: Clean Income statement
  31. If yes: alphavantage - CashFlow
  32. Then: Clean Ccashflow
  33. Check: Merge5
  34. If yes: alphavantage - Current Price
  35. Then: Clean Current Price
  36. If no: Get row(s) in sheet
  37. Then: Clean Old Financial
  38. Then: Seekingalpha Articles
  39. Then: Clean the news
  40. Check: If1
  41. If yes: XML
  42. Then: Edit Fields2
  43. Then: Final version of news
  44. If no: return the news

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.

Similar scenarios