Tag Info

Hot answers tagged

4

You can use built-in IMPORTXML function which imports data from a table or list within an HTML page. Here is the example: =IMPORTXML("http://www.google.com","//title") Some examples with similar meta tags: =IMPORTXML("http://www.google.com","//meta[@name='description']/@content") =IMPORTXML("http://www.google.com","//meta[@name='keywords']/@content")


1

My suggestion: Create a Google Spreadsheet with either ImportData (for CSV), ImportXML (for XML) or ImportFeed (for RSS/Atom). There is a trick to make it update more often than the Google default (whatever it is). Have a Google Apps script comparing the data in a particular cell to a given threshold. It can run every hour, and send an email when ...


1

The command IMPORTXML ignores the nodes with no text content: for example, taking //div[3] from the document where the body consists of <div>First</div> <div>Second</div> <div></div> <div>Fourth</div> results in "Fourth". So, when you count the <div> elements, skip over those where there is no text. ...


1

Unfortunately there doesn't seem to be a way to do that. Even when setting the Accept Header to xml, the API returns JSON: $ curl -H "Accept: application/vnd.github.v3+xml" https://api.github.com/repos/github/github-services/issues They parse the xml part of the header correctly, but still return JSON as you can see here: $ curl -I -H "Accept: ...


1

Ultimately, I can't do it with Google's functions. As a result, I decided to write a custom function. Go to Tools -> Script Editor. Click "Spreadsheet" on the left hand side to create a new document. Scroll down and paste the following code in: function getWalmartPrice(url) { var html = UrlFetchApp.fetch(url).getContentText(); //Can't create document ...


1

I have a feed setup that posts to tumblr and I've never had issues with spacing. Looking at it seems to be that the <p> and <br \> tags are respected by ifttt. Here's snippet (note, it's a vent anonymously site so I'm trying to find a safe one). This is from the <content:encoded> section of a wordpress xml feed <content:encoded> ...


1

The categorized RSS feed links might differ from site to site, CMS to CMS. For the given website, I did a quick google search for filetype:xml site:atvn.org(click it). It seems they have feed links like this - www.atvn.org/alumni/rss.xml www.atvn.org/blogs/rss.xml www.atvn.org/user/rss.xml www.atvn.org/news/2012/rss.xml etc. From the search results, ...


1

From: How to export Google search results You could try using Google AJAX Search API. For example querying the URL http://ajax.googleapis.com/ajax/services/search/web?v=1.0&q=Svick will give you results for my username in JSON. But it is deprecated http://code.google.com/apis/websearch


1

Do you have to use Google? I've read very good things about Yahoo's BOSS. And it provides the simple output (XML) you need.



Only top voted, non community-wiki answers of a minimum length are eligible