Log high-reach Talkwalker mentions to Google Sheets hourly

Build me a deterministic code workflow that logs every high-reach Talkwalker mention into a Google Sheet so my team can build pivots, charts, and BI reporting on top of it.

Trigger: cron, every hour.

Step 1 - Fetch mentions. Call Talkwalker's Search Project operation against my configured project and brand topic, filtered to documents published in the last hour. Page through results respecting Talkwalker's pagination caps (offset plus hits-per-page must stay under or equal to 10000, max hits-per-page is 500). Be aware that News and X results may return truncated content.

Step 2 - Filter. Keep only mentions whose reach is above a configurable threshold (default 10000) OR whose engagement is above a configurable threshold (default 500). Both thresholds should be exposed as workflow inputs.

Step 3 - Dedup. Compute a stable document_id from the mention's Talkwalker id (or url hash as fallback). Before appending, optionally read recent rows from the sheet and skip any document_id that is already logged so re-trending mentions don't get duplicated.

Step 4 - Append. Call Google Sheets' Append Values operation to add one row per qualifying mention to my configured spreadsheet and tab. Columns in this order: published_at, source (provider/network), url, author, title_or_snippet, sentiment, reach, engagement, document_id.

Inputs I want to configure on the workflow: Talkwalker project id, topic / search query, reach threshold, engagement threshold, Google Sheets spreadsheet id, and tab name.

Keep this fully deterministic with discrete steps (search, filter, dedup, append). No agent reasoning - this is a code workflow because the output feeds downstream BI.

Additional information

What does this prompt do?

Checks Talkwalker every hour for new mentions of your brand topic from the last hour.
Keeps only the mentions that crossed your reach or engagement threshold, so the sheet stays signal-heavy.
Appends one row per qualifying mention to a Google Sheet with the date, source, link, author, headline, sentiment, reach, and engagement.
Writes a stable mention ID into each row so the same story never gets logged twice.

What do I need to use this?

A Talkwalker account with a project set up for the brand or topic you want to track.
A Google account with edit access to the spreadsheet you want to log into.
A blank tab in that spreadsheet with the column headers ready for the first row.

How can I customize it?

Change how often it runs. Hourly is the default, but daily or every fifteen minutes work just as well.
Raise or lower the reach and engagement thresholds to match how noisy your topic is.
Add or remove columns. Some teams want country and language, others only need link and reach.

Frequently asked questions

Why log to a spreadsheet instead of a dashboard tool?

A Google Sheet is the simplest way to give every team in the company access to the same source of mentions. From there you can build pivots, charts, or pipe it into BI tools like Looker Studio without depending on Talkwalker exports.

Will the same mention get logged twice if it keeps trending?

No. Each row carries a stable mention ID. Before appending, the workflow can check the sheet for that ID and skip mentions that are already logged.

Can I track more than one brand or topic?

Yes. You can run the workflow once per topic and write into separate tabs, or pass a list of topics and tag each row with the topic it came from.

What counts as high-reach?

Whatever you decide. The default suggestion is reach above ten thousand or engagement above five hundred, but you set the numbers when you create the workflow.

Do I need a paid Talkwalker plan?

You need a Talkwalker plan that includes API access to your project. If you can run searches inside Talkwalker, this workflow can read the same data.