Scraping data automatically into Google Sheets

You can automatically save your scrape results to Google Sheets, making it possible to work with the data the instant that it's scraped. Here's how.

Privacy first: Simplescraper requests the least amount of permissions necessary which means that it cannot view, know about or access any existing files on your Google Drive. It can only access files that have been created with Simplescraper.

Connecting to Google Sheets

To connect Simplescraper to Google Sheets click on any of your recipes and then click the 'Integrations' tab. Click the 'connect' button and follow the instructions.

A new tab will open asking you to confirm Simplescraper's access. Once you confirm you will be redirected to a page asking you to re-login to Simplescraper. Once completed you can close the tab. Simplescraper is now connected to Google Drive.

Now when you run a scrape job your scrape results will automatically be saved to a sheet on your Google drive with the same name as your recipe.

Choosing to replace or append data

The first time that Simplescraper runs with the 'save to Google sheets' option selected it will create a new sheet with the same name as the recipe. When you run the recipe again, the new result data can either replace any existing data in that Google Sheet or else be appended to any data that is already there.

If you choose to append the scrape result data you can choose to identify a unique field so that Simplescraper can avoid duplicates. The unique field will depend on the data that you are scraping - a URL, title or any static value are perfect options.