Use Google Spreadsheet As Website's Time-Machine (Web Archive alternative)

This is the second and the last part of our tutorial on how to get the most out of Google Docs to get things done the clever way. In case you missed it, here's the first part: 3 Things You Didn't Know Google Spreadsheet Can Do For You (Part 1)

LICEcap Is The Best Alternative To Recordit To Screencast & Create High Quality GIFs

Web Archive is everyone's go-to place when they want to see how a specific website looks in the past. It's a wayback-machine that randomly creates snapshots of your site as reference so you can anytime check back when your site's gone awry in the future.

While Web Archive is one reliable tool to do just that, you cannot however specify how frequent a snapshot should be created. If you want to automatically create a site snapshop daily or weekly, then, Google Spreadsheet can do you a favor.

Using Google Sheet as Archive.org Alternative



Here's how:


1 Go to Screenshotmachine.com and create a FREE account. After sign up you will get an account key necessary for the API request.

2 Sign-in to your Google account and make a copy of this Google sheet (File > Make a copy).

3 Provide the required parameters as required like Account Key, URL to Capture and Capture Frequency.

4 Click Verify Now button to see if the API works or not. If it works, a new folder called Web page captures should be automatically created on your Google Drive account. This is where all screenshots will be saved.

Note: you’ll get a pop-up asking for authorization. Grant the necessary access.

5 Click Start Capturing button. You're done.

Depending on the capture frequency you specify, Google Sheet should automatically instructs Screenshotmachine.com to create a site snapshot and send it back to Google Drive.

mHotspot Is A FREE Alternative To Connectify That Turns Your Computer Into Wifi Hotspot

(3/3) Use Google Spreadsheet to Scrape Web Contents Online

One of my favorite features of Google Sheet is the importXML function which basically allows you to grab contents from another site. It's one pretty useful feature of Google Sheet as it saves you time especially if you're asked to web scrape or copy the entire contents of a site.

Watch this video below and see how web scraping can be done so easily using Google Documents Spreadsheets:



The information you get can then be imported to your website using the right apps and tools like WP All Import (if you're using WordPress as your site platform).

How To: Extract All Images Embedded In .DOC Word Documents All At Once

So next time you're asked to export the existing content of a website, then, importXML of Google Sheet is one nice function you can exploit.

Get weekly alerts delivered straight to your inbox