Annielytics.com

I make data sexy

  • About
  • Resources
  • Services
  • Blog
  • Contact
  • Log In

Nov 17 2012

How To Scrape The Web Using Google Docs

Scrape web pages with ImportXML, ImportHTML, and ImportFeed in Google Docs
Web scraping is like picking strawberries. (Okay, fine – not really, but they were really cute.)

Ever looked at a delicious list on a website and copied and pasted it, bit by bit, into an Excel or Google Doc? Yeah, those days are over. One thing I love to do is scrape the Web, and Google Docs makes that fairly simple with three commands (in order of complexity):

  • ImportFeed
  • ImportHTML
  • ImportXML

ImportFeed and ImportHTML are easy sneezy, but I couldn’t wrap my non-programmer brain matter around ImportXML because all the blog posts I read on it were written by web developers.

So I made it my ambition to figure it out and then explain it in simple terms that normal people can understand with analogies to things like the Duggar family and gingers who wear funky shoes.

You can watch the video here:

 

View the presentation here:

And check out the Google Doc I shared that shows tons of examples here:

 

Photo by adwriter

Written by Annie · Categorized: Google Docs · Tagged: Presentations, Web Scraping

Comments

  1. Brad_Zomick says

    August 13, 2013 at 10:22 AM

    Hi Annie, Have you tried to import Google’s “About 5,000 results” # (just below search). Any idea how to go about doing that?

    Reply
    • Annie Cushing says

      August 13, 2013 at 8:03 PM

      I’d use Scrapebox and some very good proxies. 🙂

      Reply
  2. Mina Younan says

    August 29, 2013 at 2:57 PM

    Awesome! 🙂

    Reply
  3. Yordan says

    April 30, 2014 at 7:57 AM

    Hi Annie,

    Slide 43, bullet point 5 says you’ve used it to pull GA metrics – I’ve been trying to get some Google analytics data into a spreadsheet but the ImportXML function does not work. It says imported XML content cannot be parsed. Could you share an example of how you’ve done this.

    Also, I tried accessing the google docs spreadsheet you’ve shared now requires permission.

    Thanks for sharing the tips!

    Reply
    • Annie Cushing says

      May 6, 2014 at 8:27 AM

      You can’t scrape GA metrics; you need to use the API for that. I wrote a post on how to use a free tool: http://searchengineland.com/how-to-use-the-google-analytics-api-in-plain-english-and-a-free-plugin-139867.

      I don’t share permissions for my gdocs. You can make a copy for yourself to use.

      Reply
  4. Moud Nuri says

    June 2, 2014 at 6:53 AM

    thanks

    Reply
  5. Grace says

    September 29, 2014 at 12:02 PM

    hello annie! i would like to view the google doc but it doesn’t seem to be shared publicly? it says i need to request permission just after clicking the link to view it. thanks heaps! you are amazing. 🙂

    Reply
    • Annie Cushing says

      October 2, 2014 at 4:23 PM

      Are you seeing it now? I lost all of my Google Docs when Google Sheets updated. But I think they’re all fixed now.

      Reply
  6. ALex says

    January 16, 2015 at 4:13 PM

    CONTINUE function doesn’t work anymore…any suggestions?

    Reply
  7. Pakar seo says

    July 7, 2018 at 10:08 AM

    Its works.thxs anni

    Reply
    • Annie Cushing says

      July 9, 2018 at 11:55 AM

      Great!

      Reply

Leave a Reply Cancel reply

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

CAN I HELP YOU FIND SOMETHING?

‘MAKING DATA SEXY’ IS LIVE ?

Want to learn how to create compelling, aesthetically pleasing charts in Excel? Learn how with Making Data Sexy.

Note: Also offered for Mac

STUFF I BLOG ABOUT

LEARN HOW TO USE ALL THE TOOLS

marketing strategy guide

DIY marketing strategy guide. This guide provides step-by-step instructions on how to perform 66 unique marketing tasks using 15 reputable marketing tools (both free and paid). Steal it for $295! Learn more.

LEARN TO DO A SITE AUDIT

site audit template

DIY site audit template. 20 sections, 215 checkpoints, 100+ explainer graphics, 218 pages, step-by-step instructions. Steal it for $295! Learn more.

LEARN TO DO AN ANALYTICS AUDIT

analytics audit template

DIY analytics audit template. 8 sections, 61 checkpoints, 100+ explainer graphics, 205 pages, step-by-step instructions. Steal it for $295! Learn more.

TO THIS DATA I DO THEE WED

dashboard course

Learn to build dynamic dashboards in Excel with Google Analytics data. 16 hours of video, 3 sample dashboards, 142-page workbook, practice Excel file, and more! Learn more.

FOLLOW ME ON TWITTER

SUBSCRIBE TO MY YOUTUBE CHANNEL

Privacy Policy
  • Email
  • LinkedIn
  • Twitter
  • YouTube

© 2021 annielytics.com