Log high-reach Talkwalker mentions to Google Sheets

Capture every mention of your brand that crosses a reach or engagement threshold into a Google Sheet you can pivot, chart, and report on.

Deterministic Code
TalkwalkerGoogle SheetsMarketingOperationsResearch & MonitoringData Sync
PromptCreate

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.

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.

FAQs

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.

Related templates

Review desk for portal forms your team still fills in by hand

Stage a batch of filings overnight, then approve each completed form from a screenshot before anything is ever submitted.

Kernel
Google Sheets
Slack Bot
App
Audit what Intercom's Fin AI actually resolved before you pay

Review every conversation Fin closed as resolved, judge which ones actually stuck, and see what the gap is worth against your bill.

Intercom
Google Sheets
Slack Bot
App
Returns and warranty claim desk that follows your policy

Work every return, damage and warranty claim in one queue, with the order, the delivery date and a policy-backed recommendation already on screen.

Kustomer
Shopify
Google Sheets
App
Turn last week's cafe sales into this week's grocery order

See exactly which ingredients next week needs based on what you actually sold, adjust anything by hand, then build a one-click grocery cart.

Instacart
Square
Google Sheets
App
Benchmark your Instagram account against rival brands

See follower growth, posting cadence, format mix and engagement rate for your brand and every competitor you track, side by side on one board.

Instagram
Google Sheets
Google Docs
App
Find the services you're underpricing in your Jobber price book

Open one screen to see how every service in your Jobber price book actually performed: how often it sold, what you charged, and where prices swing.

Jobber
Google Sheets
App

Stop exporting Talkwalker by hand every Monday.

Connect Talkwalker and Google Sheets once, and Geni keeps a clean log of every high-reach mention rolling into your spreadsheet around the clock.

Explore more promptsCreate