How to use the IMPORTFEED formula in Google Sheets

How to use the IMPORTFEED formula in Google Sheets


hi everybody its Mitchel from Sheetgo
and today I’m going to teach you how to use the importfeed formula in Google
sheets with the importfeed formula we can import data from RSS and ATOMfeeds
into your Google sheets so for this tutorial I will use the Google News in
ATOM format to get an overview of the headers sources and introduction and I will use
the import feed formula to get a quick overview of thee 20 important topics of today so
as you can see this is ATOM format and the ATOM format is completely
different in comparison to a normal URL file so if you want to use normal URL I
would suggest you to watch the import HTML formula and I will leave a link
down below in the description with the import HTML formula and a blog post we
have made regarding the importHTML formula but in this video we will take a
look at the importfeed formula so we are going to use the ATOM format or an
RSS format if you want to so let’s use the import feed formula which is
importfeed and the only thing that we need to do is we need to put in double
accents and copy past the ATOM format so I want to copy paste this URL and put it
into my equation and as you can see the importfeed formula successfully
determined the title the source URL and the summary of my, of the important
topics of today but sometimes you just want to have a quick overview so that why
we’re using the same equation but this time I’m putting in item title as I want
to know the item title on I’m pushing on true as I want to have the important
topics of today so true corresponds to important and I put in 20, 20 as wehave 20 topics so push on enter and as you can see the importfeed formula
successfully determined the 20 most important topics of today so this is how
I use the import feed formula I want to thank you for your time if you liked the
video please leave like and goodbye

Author:

3 thoughts on “How to use the IMPORTFEED formula in Google Sheets”

  • I don't understand how to get that URL that works .. ACL formula or whatever? Idk what ur saying. I have a normal link of normal articles want to make it in the format that works with sheets and this video or the links in the description are helping me find that answer

  • This is not a "how to" video. This is "watch me do it" video. I'd like to see a video that shows the process from Start to Finish and actually shows me "how to" do it. Thanks.

Leave a Reply

Your email address will not be published. Required fields are marked *