SEER Blog

  • http://www.evolvingseo.com Dan Shure

    Awesome Chris!!! Thank you!

    Reason I love Quora so much, is you have a whole list of people who have basically came out and “voted” on a topic they LOVE. And you know they have some interest in it because they’ve taken the time to follow the topic. Great if you’re trying to source a list of ie: DIY enthusiasts or wine lovers. And I like Quora because its a very “pure” environment (not many junk/spam profiles – you get a lot of that with follwerwonk sometimes) and I find the people to be a bit more savvy.

    Will DEF be using ALOT.

  • http://distilled.net David Sottimano

    Damn that’s nice. That’s all.

  • Chris Le

    You guys are very welcome! Enjoy!

  • http://www.digitalnino.com Cleo Kirkland

    Super nice Chris! I’ve just started getting into Quora; this will be very useful for finding relevant target.

    Also, have you or anyone else found a way to scrape Zoominfo.com. Just curious.

    Also, also, what about review sites like Yelp or Menupages? I work a lot in the travel space, and would love a scalable way to check out the “review” competition in each locality.

  • Chris Le

    @Cleo. I haven’t dug into scraping Zoominfo, Yelp, or Menupages. But I’ll keep it in mind for the next edition of the cookbook.

  • Sandeep Gulati

    WOW….thanks Chris, this is a awesome tool,I have made a massive file from the above formulas..this is amazing and rocks…thanks again for all above formula.

  • http://www.stevelarsen.co.uk Steve

    I’ve been trying to limit the importXML function to return only the first result. I haven’t been able to figure out how to do it through xPath as it seems to all be the same. Perhaps someone knows how to limit the output to only the first result OR modify the query. Here it is

    =ImportXML(“http://bit.ly/KkEXR6″,”//tr[@class='rategroup3']//span[@class='amount']“)

    This returns 3 results: 111.75,126.75,141.75
    I would only like to use 111.75

    note: the values might change or become invalid after 26 Jul 2012

  • http://www.stevelarsen.co.uk Steve

    I’ve been trying to limit the importXML function to return only the first result. I haven’t been able to figure out how to do it through xPath as it seems to all be the same. Perhaps someone knows how to limit the output to only the first result OR modify the query. Here it is

    =ImportXML(“http://bit.ly/KkFzGr″,”//tr[@class='rategroup3']//span[@class='amount']“)

    This returns 3 results: 111.75,126.75,141.75
    I would only like to use 111.75

    note: the values might change or become invalid after 26 Jul 2012

  • http://balanceddietishealthydiet.com balanced diet

    Hello! I’ve been reading your blog for a long time now and finally got the bravery to go ahead and give you a shout out from Porter Texas! Just wanted to tell you keep up the fantastic work!

  • Chris Le

    Thanks for the shout out! We really appreciate it!

  • Chris Le

    I haven’t been able to look at your query itself, but adding [1] to the xpath can sometimes yield the first result. It depends on how the HTML looks.

  • http://twitter.com/TheRastaLion MannehDF

    Tried, but frustratingly, I get an “error. Argument is blank”, even when I copied and pasted the recipe!

  • Conor Jones

    Your xpath for linkedin is very helpful for a novice like me. Next time you are doing more cookbook, can you show code for extracting ‘experience’ (title, company, dates, description). I can’t seem to get anywhere with it. Much to learn I guess.

  • Nicola Barozzi

    It does not work with Linkedin :-(

  • Nick

    Hi,

    Great article … thank you for putting it together.

    For the application I had in mind I need each importxml query to put the retrieved code into a single cell. For example when tarting a bullet list at the moment it is:

    - outputting to multiple cells horizontally (columns) when targeting ul

    - outputting to multiple cells vertically (rows) when targeting li

    Is it possible, using a gsheet formula or xpath code, to get it to out the li elements into a single cell. Ideally with a comma separator between elements? Or without a separator, as a complete text would be better than multiple cells?

    Thanks

    Nick

  • Manuel

    Superb list. Saved me hours today!