Questions tagged [importfeed]

For questions specifically about the Google Sheets function: ImportFeed()

Filter by
Sorted by
Tagged with
0
votes
0answers
26 views

IMPORTFEED Convert date format

I have a Google sheet that imports an RSS feed using IMPORTFEED and also the date of each entry using "items created" =IMPORTFEED("url", "items created") The date is shown as Sat, 13 Jul 2019 03:17:...
0
votes
0answers
13 views

How does one import an RSS url as a RSS formated URL?

Currenty I am currently trying to aggregate a few of these urls in order to pull html which I want to display in my Sheet. Problem But currently I am just importing RSS from a news aggregator using ...
1
vote
2answers
2k views

How to know if Google Sheets IMPORTDATA, IMPORTFEED, IMPORTHTML or IMPORTXML functions are able to get data from a resource hosted on a website?

Google Sheets has several import functions IMPORTDATA IMPORTFEED IMPORTHTML IMPORTXML Sometimes the above functions returns errors like #N/A Imported content is empty and would like to be sure that ...
0
votes
0answers
84 views

Import site URLs to Google Sheet (and add new row each time)

I am trying to make a list of site pages that will automatically update in Google Sheets, while keeping the full history rather than overwriting older rows with new ones. I see two possible ways of ...
3
votes
2answers
3k views

Auto-Update via RSS (and keep history)

I have a Google Sheets that fetches some data via RSS. The RSS feed is updated once a day, everyday. Is it possible for me to keep archive of all the new and historic data in the spreadsheet? The ...