Save each new Google News article related to a specific topic in Google Sheets
Stay ahead effortlessly: get all new Google News articles on your chosen subject sent straight into Google Sheets, no copy-paste, zero stress.
Chasing the latest news on your topic of interest is exhausting—constantly searching Google News, sorting through irrelevant articles, and manually updating your spreadsheets is both tedious and time-consuming. Every missed update means blind spots: you risk losing that crucial bit of information just when your team or business needs to spot a trend or report a breakthrough. The cost? Hours lost every week, reduced visibility, and opportunities slipping through the cracks because the data simply isn’t there when you need it.
This Botize formula does all the heavy lifting by monitoring Google News around the clock for your chosen topic. Every time a new, relevant article appears, the automation grabs essential details—like title, link, summary, and publish date—and instantly adds them to your Google Sheet. You never need to refresh news feeds or copy-paste headlines again; your curated news dashboard grows effortlessly, updated precisely how and when you want (with fully customizable frequency and filters for your specific needs).
Ready to reclaim your time and never miss a breaking story again? Just follow the Botize step-by-step setup, or jump straight into the ready-to-use formula. Tailor it to your keywords and reporting schedule in minutes—so you stay informed, efficient, and always a step ahead.
Automate this task with 3 simple prompts
Copy and paste the following prompts into Botize's AI task editor
-
1
Access the Botize automated task editor.
-
2
Select the AI editing tool.
-
3
Begin by creating a step that will run the automation on a regular schedule.
Copy and paste this prompt into the AI editing tool.
Set up the automation to trigger automatically every hour. ⤵
Click the 'Apply this task' button to confirm.
-
4
Now, add a step to look for new news articles about the specific topic you choose from Google News.
Copy and paste this prompt into the AI editing tool.
Fetch the latest Google News articles that match the keyword 'golf' and are relevant to the selected country and language settings. ⤵
Click the 'Apply this task' button to confirm.
-
5
Finally, add a step to save the details of each new article into a Google Sheets spreadsheet.
Copy and paste this prompt into the AI editing tool.
Insert a new row in your Google Sheets file with details of the article: date published, article ID, link, title, and summary. ⤵
Click the 'Apply this task' button to confirm.
-
6
Your automation is ready to use. Click the 'Save changes' button.
Save changes
Never Miss Breaking News on Your Topic—Ever Again
Our automation keeps an eye on Google News for you. The moment a fresh article drops about your selected topic, it grabs the headline, link, summary, and date, and adds it neatly to your Google Sheet. That’s it—no more FOMO, no more manual tracking, and your time is finally yours again.
| Manual | Botize | |
|---|---|---|
| Searching Google News for updates | 10 minutes/day | 0 Minutes |
| Copying each article into your spreadsheet | 15 minutes/day | 0 Minutes |
| Organizing and sorting data by date/topic/link | 5 minutes/day | 0 Minutes |
| Total | 30 minutes/day | 0 Minutes |
Looking for a dead-simple way to track every new story about what matters to you? You’ve landed in the right place—seriously.
Track All News About 'Golf'
Suppose you manage a golf equipment store. Every piece of golf-related news is logged automatically, helping you spot trends or viral stories instantly.
Always Updated
Get real-time news as it happens, so you're always ahead.
No More Manual Labor
Forget searching and copying—let robots do the boring part.
Centralized Insights
Everything you care about, beautifully organized in your own Sheet.
Monitor Industry Announcements
A PR agency uses this to keep clients informed the second their brand (or competitors) are mentioned—no missed opportunities.
⌾︎ This is perfect if you need to monitor a topic, competitor, or trend without missing a beat.
⌾︎ Great for journalists, marketers, researchers, or anyone who says: 'I wish there was an easier way to track news.'
✕ Not useful if you never need news or don't work with Google Sheets.
✕ Doesn’t make sense if you only check the news once a month (but hey, why would you be here then?).
✓ Pick any news topic or keyword you want to track—not just 'golf'.
✓ Choose how often the news is checked: every hour, daily, or custom.
✓ Personalize which Google Sheet and what columns each article detail goes into.
This task monitors Google News and saves each new article related to a specific topic in a Google Sheets spreadsheet. Whenever a new news item that matches the selected topic appears, the automation extracts the relevant information and stores it in the spreadsheet. To use this task, you will need to customize the topic or theme of the news you want to track within the automation.
