This template reads daily stock sentiment scores from Google Sheets, picks the top tickers, and rebalances an Alpaca account through JavaScript.
It sells positions that fell off the list, buys the names that remain, then writes order ids back to the sheet. Connect Google Sheets. Put the Alpaca API key and secret in that JavaScript node. Start with Alpaca paper trading until the orders look right.
Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.
Full pricing — how CPU seconds work →Workflow preview
The scenario starts on weekdays at the time you choose, such as 4:45 PM US Eastern.
Google Sheets returns the daily ticker scores you already write from research.
JavaScript keeps the top tickers, loads Alpaca account and positions, sells names that dropped off, and buys the rest. Put the Alpaca API key and secret in that JavaScript node.
Google Sheets records ticker, side, quantity, and Alpaca order id for the run.
Add a Google Sheets connection. Use one tab for daily sentiment scores and another tab for the order log.
In JavaScript, call the Alpaca trading API for account, open positions, sell orders, and buy orders. Store the Alpaca API key and secret in that node. Use paper trading first.
Add a schedule for weekdays at the time you want to rebalance, such as 4:45 PM US Eastern.
Read the sentiment tab, pick how many top tickers to hold, send the Alpaca orders, then append the order log. Run once by hand and confirm paper fills before you leave it on.
FAQ
More templates
This template watches a Notion database for new pages, reads the title and properties, and creates a Google Doc from that text. Use it when a database row should become a shareable document. Connect Notion and Google Docs, then point the trigger at the database you want to watch.
This template starts on a new Google Form response, then creates a Google Doc from the template you pick and replaces placeholders with the answers. Use it for intake letters, briefs, or certificates that should match each submission. Connect Google Forms and Google Docs, then point the trigger at the form and the Docs step at the template.
This template receives Kartra calendar bookings on a Latenode webhook, maps name, email, and slot time in JavaScript, and appends a row in Google Sheets. Paste the webhook URL into Kartra. If the payload is only an id, use that JavaScript node to call the Kartra API and put the Kartra API key in that node. Connect Google Sheets and point add-row at the spreadsheet that stores leads.
