How to auto import today's headlines into Google Sheets

Поділитися
Вставка
  • Опубліковано 5 вер 2024
  • Need a way to get the day's headlines neatly into a spreadsheet?
    -----
    ℹ️ Get 4 weekly human-written articles produced and published for you - $349/month: seo.nurturely....
    -----
    ℹ️ Sales Hack: Win 60% more sales with this incentive-based marketing plan: bit.ly/nurture...
    -----
    Need an All-In-One CRM? Get the best. Get Nurturely+: nurturely.io
    -----
    Get In Touch:
    - Twitter: / kdaxyz
    - LinkedIn: / kyle-ackerman
    - Email: hi@nurturely.io

КОМЕНТАРІ • 2

  • @mayankkumar9743
    @mayankkumar9743 3 місяці тому +1

    Please ping me that formula...😊

    • @kdaxyz
      @kdaxyz  3 місяці тому

      this is the formula for the "World" headlines:
      =ARRAYFORMULA( HYPERLINK( INDEX( IMPORTFEED( "news.google.com/rss/topics/CAAqJggKIiBDQkFTRWdvSUwyMHZNRGx1YlY4U0FtVnVHZ0pWVXlnQVAB"), 0,2), INDEX( IMPORTFEED("news.google.com/rss/topics/CAAqJggKIiBDQkFTRWdvSUwyMHZNRGx1YlY4U0FtVnVHZ0pWVXlnQVAB"), 0,1)))
      be sure to edit what comes *after* the /topics/ to whichever topic you'd like!