Predict Next 5-Day Stock Trends with Twelve Data API & Google Sheets

This n8n workflow automates the process of fetching stock data, predicting future trends, and storing the results in Google Sheets, with email notifications for successful runs.

Description

This workflow is designed to periodically retrieve stock data for a specified symbol using the Twelve Data API, process this data to predict the next 5-day trend (though the prediction logic itself is not explicitly defined in the provided JSON, it's implied by the directory name and the presence of a "Code" node), and then record the results in a Google Sheet. It also sends an email notification upon successful completion of the data processing and sheet update.

What it does

1. Schedules Execution: The workflow is triggered on a recurring schedule (defined by the Cron node).
2. Fetches Stock Data: It makes an HTTP request to the Twelve Data API to retrieve historical stock data for a specified symbol.
3. Processes Data (Code Node): A Code node is included, which is typically used for custom logic. In this context, it's expected to contain the logic for analyzing the fetched stock data and predicting the next 5-day trend.
4. Prepares Data for Google Sheets: An "Edit Fields (Set)" node likely transforms or formats the data, including the prediction, into a structure suitable for appending to a Google Sheet.
5. Records Data in Google Sheets: The processed stock data and trend prediction are appended as a new row to a designated Google Sheet.
6. Sends Email Notification: Upon successful execution, an email is sent to notify the user about the completion of the workflow, likely including details about the processed stock and its predicted trend.

Prerequisites/Requirements

• n8n Instance: A running n8n instance.
• Twelve Data API Key: An API key for the Twelve Data service to fetch stock data. This will need to be configured in the "HTTP Request" node.
• Google Account: A Google account with access to Google Sheets. You'll need to set up Google Sheets credentials in n8n.
• Google Sheet: A pre-existing Google Sheet where the stock trends will be recorded. You'll need to specify the Spreadsheet ID and Sheet Name in the "Google Sheets" node.
• SMTP Server/Email Service: Credentials for an email service (e.g., SMTP, Gmail, Outlook) to send notifications. This will need to be configured in the "Send Email" node.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button and paste the workflow JSON or upload the file.
2. Configure Credentials:
   • HTTP Request (Twelve Data): Edit the "HTTP Request" node. You will need to add your Twelve Data API Key, likely as a query parameter or header, and specify the stock symbol and other API parameters.
   • Google Sheets: Edit the "Google Sheets" node. Select or create a new Google Sheets OAuth2 credential. You will also need to specify the "Spreadsheet ID" and "Sheet Name" where the data should be written.
   • Send Email: Edit the "Send Email" node. Select or create a new credential for your email service (e.g., SMTP, Gmail, Outlook). Configure the recipient email address, subject, and body of the notification email.
3. Customize Code Node (Prediction Logic):
   • Edit the "Code" node. This is where you will implement the actual logic for predicting the 5-day stock trend based on the data received from the Twelve Data API. The current JSON does not contain specific prediction logic, so you will need to add your own JavaScript code here to analyze the json.data and output a prediction.
4. Configure Cron Schedule:
   • Edit the "Cron" node to set your desired schedule for when the workflow should run (e.g., daily, weekly).
5. Activate the Workflow:
   • Once all credentials and configurations are set, save and activate the workflow.