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
Please ping me that formula...😊
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!