Meet your AI-powered assistant in Google Sheets—a smart tool that finds the latest news based on your keywords. It's useful if you're analyzing trends in your niche, looking for news about competitors, or searching for information about potential customers.
What does News Jacker do?
You enter your keywords, and the tool pulls fresh stories from Google News, organizing them in a clean, editable spreadsheet:
- 🗝️ Keyword used for the search
- 📰 News headline
- 🔗 Clickable link to the source
- 📅 Publication date
- 🌐 News source (domain)
- ✅ Option to mark preferred articles for future content creation
- ✅ Option to create an archive of the best articles
How to Format Search Queries (Advanced Use)
Here’s how to get the most relevant results:
Simple Keyword Search. Use single words or short phrases to find matching news. Example: AI startup. Will return news about AI startups.
Exact Phrase Match. Use “quotation marks” to find news that includes the exact phrase, in that exact order. Example: "climate change". Only results where “climate change” appears as a full phrase.
Using OR Operator. Search for news related to “either one term or another” by using `OR` (must be in capital letters). Example: SpaceX OR Boeing. Finds news about either SpaceX or Boeing.
Excluding Terms. Use a minus sign (-) before a word to exclude it from results. Example: Apple -iPhone. Shows news about Apple, but filters out anything mentioning iPhone.
Combining Words (AND logic). Use the plus sign (+) to indicate both terms must be present (Google treats space as AND by default, but `+` or “AND” reinforces it). Example: web+design. Returns results that must include both “web” and “design”.
Domain-Specific Search (site:). Use site: to focus Google’s results inside one domain. Example: site:linkedin.com marketing strategy. Displays only LinkedIn pages mentioning “marketing strategy”.
Providing context-driven results — business-focused, not random noise.