Quick Overview
This workflow runs a Webz.io news search from a manual trigger and appends the returned articles as new rows in Google Sheets with key fields like title, URL, publish date, score, and excerpt.
How it works
- Starts when you run the workflow manually.
- Defines the news search query, result limit, lookback window (days), and target Google Sheet details.
- Searches Webz.io for matching news articles (with a language filter) and returns one item per article.
- Appends each article to Google Sheets, writing the query, title, URL, published date, score, and excerpt into columns.
Setup
- Install the community node
n8n-nodes-webz-news-search in your n8n instance.
- Add a Webz.io News Search API credential using your Webz.io token.
- Add a Google Sheets OAuth2 credential and ensure you have a spreadsheet and tab to append rows into.
- Update the Settings values, especially the search query, lookback days, result limit, Google Sheet ID, and sheet/tab name.