Documentation

1. Introduction

News2Sheet is an Google Sheets™ extension designed to fetch real-time news headlines directly from NewsAPI.org. This tool empowers users to integrate up-to-date news data into their spreadsheets, facilitating data-driven decision-making and analysis right within the familiar Google Sheets environment.

2. Getting Started

Here’s a step-by-step guide to getting your News2Sheet extension up and running:

  • Installation:

    • Visit the Google Workspace Marketplace.
    • Search for “News2Sheet” and click on the ‘Install’ button.

  • License Key Setup:

    • NewsAPI.org Key:
      • Sign up at NewsAPI.org and obtain your API license key.
    • News2Sheet Key:
      • Start with the 14-day free trial offered. Afterward, purchase a license key from our Gumroad page.
    • Input Keys:
      • Open your Google Sheets™ and navigate to Extensions > News2Sheet > Getting Started.
      • Enter your NewsAPI.org and News2Sheet license keys in their respective fields and click ‘Save’.

3. Use Cases

News2Sheet provides versatile use cases across different fields:

  • Market Analysis:

    • Use the =N2S_TOP_HEADLINES() formula to gather breaking news about specific stocks, companies, or industries, perfect for monitoring market trends or investor sentiments.

  • Academic Research:

    • Utilize =N2S_EVERYTHING() to conduct thorough searches across entire news archives for comprehensive media studies or historical data analyses.

  • Media Monitoring:

    • Track brand mentions and monitor reputational metrics with =N2S_TOP_HEADLINES().
    • Identify relevant media outlets and analyze their geographic or categorical focus with =N2S_SOURCES().

4. Using the Formulas

Leverage News2Sheet’s powerful formulas to access data seamlessly:

  • =N2S_TOP_HEADLINES(country, category, query, sources, pageSize, page): Fetches the latest headlines filtered by criteria such as country, category, or specific news sources.

  • =N2S_EVERYTHING(query, searchIn, sources, domains, excludeDomains, from, to, language, sortBy, pageSize, page): Conduct advanced searches to find articles using exhaustive filtering, ideal for keyword-based analytics.

  • =N2S_SOURCES(category, language, country): Retrieves a list of news sources, helping you identify outlets by category or region.

For detailed parameter explanations, refer to the NewsAPI.org documentation.

5. The News2Sheet Wizard

The News2Sheet Formula Wizard offers an intuitive interface for constructing API request formulas.

  • Accessing the Wizard:
    • Go to the News2Sheet menu and select “News2Sheet Formula Wizard”.
    • It guides you through parameter selection and automatically generates the formula, making it easy to input into your spreadsheet.

6. Common Issues and FAQ

Resolve frequent issues quickly:

  • What if the API key is not accepted? Double-check for any typos in your API key and ensure it has the necessary permissions set on NewsAPI.org.

  • Why is there no data returned? Ensure your parameters are correctly set and within API rate limits.

  • How do I handle API rate limits? Adjust your query frequency and consider upgrading your NewsAPI.org plan if necessary.

7. Support and Feedback

We’re here to help and value your feedback:

  • Contact Us:

    • For technical support, email us at support@news2sheet.com.
    • Suggestions and feedback are welcome to help us improve the extension further.

  • Community:

    • Join our community forum for discussions, updates, and tips from other users.

8. Disclaimer

News2Sheet is a third-party tool, independent of and not endorsed by NewsAPI.org or Google LLC. All trademarks belong to their respective owners. The use of this extension complies with the terms and conditions of NewsAPI.org, and it is the user’s responsibility to ensure adherence to these terms.