Google Sheets

ActionsFrom Pro

• Trigger
• Message

Google Sheets

Google Sheets · at most every 4 h

This is how the node looks on the board: inputs on the left. As an action it sits at the end of the chain.

Like a ledger, line by line: every alert becomes a new row in your Google spreadsheet, ready for your own formulas and charts.

Every alert a row in Google Sheets. Writes every alert as a row into a Google Sheets spreadsheet, as a trading journal: alert ID, time, chain, pair, timeframe, price, message, values and test. You copy a small script from the guide into the spreadsheet once and enter its address here. Google Sheets comes with the Pro plan and up. Example: with a formula you count how many alerts came each week.

What it looks like

• signal true
• alert goes out
• held back
• cooldown running

The alert comes when the trigger switches from false to true. If it stays true, no second one comes. If it switches again during the cooldown, Bellchain holds the alert back (circle); the replay counts such cases as “held back by the cooldown”.

Settings

The settings appear on the right under “Properties” once you click the node on the board. Below each field you find the same explanation as here.

Script URL

Default: empty · any text, at most 300 characters, must be filled in before activating, empty when you export a chain

The Apps Script web app’s address; it ends in /exec. The script to copy is in the guide. Anyone who knows the address can add rows; that is why it stays empty when you export the chain.

At most every … hours

Default: 4 h · from 0 to 168 h

Cooldown: after an alert the action waits at least this long before the next one. 4 hours suit most chains. 0 means an alert every time the condition turns true.

Message

Default: {{chain}}: {{values}} · any text, at most 1,000 characters, multi-line

The alert text. {{chain}} inserts the chain’s name, {{values}} the values of the nodes, {{price}} the price; there are also {{pair}}, {{coin}} and {{time}}. Use **bold**, _italic_ and `code` to highlight text. If a message template is connected to the Message input, its text is used instead.

Example

Writes every alert as a row into your Google spreadsheet, through the script from the guide (Pro plan).

How to connect the nodes:

1. Candle (Price) → RSI (Value)
2. RSI (RSI) → Compare (Value)
3. Compare (true/false) → Google Sheets (Trigger)

On the board it reads: Google Sheets · at most every 4 h

Chain as JSON

To try it, copy it and paste it in the editor under “Import”. Importing creates a new chain.

sheets.json

{
  "name": "Example: Google Sheets",
  "version": 1,
  "nodes": [
    { "id": "c1", "type": "core.candle", "position": { "x": 40, "y": 40 }, "settings": { "pair": "BTC/USDT", "timeframe": "1h" } },
    { "id": "r1", "type": "core.rsi", "position": { "x": 260, "y": 40 }, "settings": { "length": 14 } },
    { "id": "k1", "type": "core.compare", "position": { "x": 480, "y": 40 }, "settings": { "operator": "below", "value": 30 } },
    { "id": "j3", "type": "core.sheets", "position": { "x": 700, "y": 40 }, "settings": { "url": "https://script.google.com/macros/s/AKfycbExampleScriptId000000/exec" } }
  ],
  "edges": [
    { "from": "c1.close", "to": "r1.in" },
    { "from": "r1.out", "to": "k1.in" },
    { "from": "k1.out", "to": "j3.in" }
  ]
}

Inputs and outputs

Only matching types connect: number series to number series (round pin), signal to signal (square), message to message (diamond).

Direction	Pin	Type	Note
Input	Trigger	Signal (true/false)	required
Input	Message	Message	optional
Output	–	–	No outputs.

Good to know

• Search also finds it under: notification, message, alert, journal, log, spreadsheet, table, google, sheets, excel.

Technical details

POST with the webhook JSON (version 1) to the Apps Script web app; the redirect Google answers with counts as delivered. The delivery log keeps only a fingerprint of the address.

• Type in the chain: core.sheets · Version 1.0.0 · Category key act
• Settings in the chain: url (Script URL), cooldown (At most every … hours), message (Message)
• Pins in the chain: Input in, message
• Effect: writes to the trading journal in Google Sheets
• How a node is built