News-to-Sheet Logger
Automatically scrapes the latest articles from any news website, extracts their title, URL, and full content, and organizes it all in a Google Sheet for easy access and analysis.
By Eduardo RodriguezThis automation acts as a personal research assistant. Here's how it works:
- Navigates to Your chosen News Source: It starts by opening the news website URL you provide, just like a person would in a web browser.
- Cleans the View: The agent attempts to dismiss any cookie consent popups or subscription banners to get a clear view of the page content.
- Identifies Articles: It intelligently scans the page to find the most recent news articles, extracting their headlines and direct links.
- Deep Dives for Content: For each article it finds, the agent visits the link and carefully extracts the full body text, making sure to ignore ads, menus, and other non-essential clutter.
- Organizes in Google Sheets: Finally, it connects to your specified Google Sheet, clears any old data, and writes the freshly scraped information into neat columns:
Title,URL, andContent.
The result is a structured and up-to-date spreadsheet of news content, ready for your review or for use in other workflows.
Usage Ideas
- Create a daily digest of news from your favorite sources.
- Monitor media outlets for mentions of your brand, products, or competitors.
- Aggregate articles on a specific topic for market research or content creation.
- Build a dataset of news content for analysis or AI model training.
- Track press releases from companies in your investment portfolio.
Customization Ideas
This template is designed to be a flexible starting point. You can easily adapt it to your specific needs. For example, you can:
- Scrape any news or blog site by simply changing the input URL.
- Save data to your own Google Sheet or choose to send the results to a different service entirely.
- Adjust the number of articles you want to collect in each run.
- Change the data you save by adding, removing, or renaming the columns in your output sheet (e.g., adding a "Date Scraped" column).
- Modify the save behavior, such as having the automation add new articles to the bottom of your sheet instead of replacing the existing data.
Agent inputs
Required
| Name | Type | Default |
|---|---|---|
googleSheetUrl | string | None |
| URL of the Google Sheet where scraped articles will be saved | ||
newsSourceUrl | string | None |
| URL of the news listing page to scrape (e.g., https://www.bbc.com/news) | ||
Optional
| Name | Type | Default |
|---|---|---|
numberOfArticles | number | 10 |
| Number of most recent articles to scrape (1-50) | ||
From manual to automated in minutes
Related templates
The TikTok Listener
This automation agent searches for a specific keyword on TikTok, gathers information on recent videos, and sends a compiled HTML report to a designated email address.
Cesar SanchezExtract Insights from Fathom Video Meetings
This automation connects to your Fathom account to analyze recent meeting recordings. It uses AI to automatically classify each meeting and extract valuable, actionable insights based on your preferences, then delivers a consolidated report to your inbox.
Airtop Community
Generate Leads from New Hires
This template automates sales intelligence by identifying decision-makers who have recently started new roles at companies matching your Ideal Customer Profile (ICP), enriching their contact information, and exporting a scored, prioritized list to Google Sheets.
Airtop CommunitySee it run.
Spin up your first agent in five minutes.
