Connect Chartink and Google Sheets

Chartink alerts you when stocks match a scanner's conditions. FlowMattic writes each alert into a Google Sheets trading journal, with the scan name, the matching stocks, their trigger prices and the time. Traders get a record they can review after market hours and use to judge which scanners are worth keeping.

Try FlowMattic free See example workflows

7 triggers 19 actions 5 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in Chartink1 trigger

Do this in Google Sheets19 actions

1. TriggerNew Alert

2. ActionAdd New Row

When Chartink fires New Alert, FlowMattic runs Add New Row in Google Sheets with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

Chartink and Google Sheets workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

Ready-made template

Log each Chartink alert in a trading journal

Each alert adds a row with the scan, stocks, trigger prices and time, so you can look back at what fired today and compare it with how the stocks actually moved.

New AlertAdd New Row

View the template

Write one row per stock in the alert

One alert can name several stocks. Split the stock and price lists into items, loop over them and add a row for each, which makes filtering by symbol possible.

New AlertText FormatterIteratorAdd New Row

Give each scanner its own tab

A Router reads the scan name, so breakout, reversal and volume scans fill separate tabs and each strategy's hits can be reviewed on their own.

New AlertRouterAdd New Row

Count how often each stock triggers

Look the symbol up on a tally tab. Stocks already listed get their count and last trigger time updated, new ones get a row, showing which names your scanners keep flagging.

New AlertLookup Row DataRouterUpdate RowAdd New Row

Split the alert time into date and time columns

Format the trigger time into separate date and clock columns, so the journal can be filtered to the opening hour or grouped by trading day.

New AlertDate/Time FormatterAdd New Row

Set up: Chartink alerts in a journal

At the end, every alert from your Chartink scanner adds a row to your trading journal sheet.

Start the journal
Create a sheet with Date, Time, Scan, Stocks and Trigger prices columns, plus Notes for your own review.
Trigger on New Alert
Create a workflow with Chartink and New Alert, and copy the webhook URL the trigger shows.
Add the URL to your alert
In Chartink, open the alert on your scanner, paste the URL as its webhook and wait for, or create, an alert so FlowMattic captures one.
Write the row
Connect Google Sheets, add Add New Row, map scan name, stocks, prices and time to the columns, test and switch on.

Import the ready-made template Beginner, about 5 min to set up

From Chartink	To Google Sheets
Scan name	Scan
Stocks	Stocks
Trigger prices	Trigger prices
Triggered at	Time

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

An alert can list several stocks in one field. Use the one-row-per-stock example if you want to filter or count by symbol.
Alerts only arrive while your scanner's alert is active in Chartink. A quiet journal usually means the alert is paused or no stock matched.
The journal records alerts. It does not place trades; any order you place is still up to you and your broker.

Chartink

Integration page

Triggers (1)

New AlertTriggers on new alert for any specified event

Google Sheets

Integration page

Triggers (6)

New Spreadsheet RowTrigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
Update Cell DataTrigger when any cell is updated in the spreadsheet
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

Add New RowAdd a new row with mapped data
Update RowUpdate existing row in specific spreadsheet with mapped data
Delete RowDelete row by ID in specific spreadsheet
Clear Row DataClear data or row by ID in specific spreadsheet
Lookup Row DataSearch for data in specific spreadsheet
Get Cell DataGet data for particular cell in specific spreadsheet
Update Cell DataUpdate data for particular cell in specific spreadsheet
Get Row CountGet total number of rows in specific spreadsheet
Get Row DataGet rows data from the sheet based on specified range
Create Spreadsheet ColumnCreate a new column in specific spreadsheet
Create New SheetCreate a new sheet in specific spreadsheet
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
Copy SheetCopy a sheet to another or within the same spreadsheet
Get RowsRetrieve rows in JSON format for use with Iterator
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Why run this pair with FlowMattic

Chartink and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

A journal you can review later

Scrolling back through alerts in a sheet is easier than in a notification feed, and you can add notes beside each one.

Your strategy data stays private

Alerts pass through your own WordPress site on the way to the sheet, so your scanners and hits are not stored by another automation service.

Many alerts, flat cost

Runs are unlimited, so a scanner that fires dozens of times a session costs the same to log as one that fires once.

Common questions

What does a Chartink alert send to the sheet?

The alert carries the scan or alert name, the stocks that matched, their trigger prices and the time it fired. Run a test alert to see the exact fields before mapping them to columns.

Can each stock get its own row?

Yes. Split the stocks and prices into lists with Text Formatter, loop over them with Iterator and run Add New Row inside the loop, so each symbol is one row.

Can I keep alerts from different scanners apart?

Yes. Route on the scan name and send each one to its own tab, or build a separate workflow with its own webhook URL for each scanner.

Can I add my own notes to the journal?

Yes. Leave empty columns for notes or outcome in the sheet. The workflow only fills the columns you map, so your notes are never overwritten by new alerts.

Did not find your answer? You can browse the help center or ask us directly.

Start automating Chartink and Google Sheets

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

Try FlowMattic free See pricing

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 27 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Chartink integration 1.0.0, Google Sheets integration 2.2.4.