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.
Eduardo Rodriguez
Featured Apps
This 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 Parameters
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 Parameters
Name | Type | Default |
|---|---|---|
numberOfArticles | number | 10 |
Number of most recent articles to scrape (1-50) | ||
