Google Sheets

Every run lands in your sheet. No copying and pasting.

Connect once from a scraper's Send tab. Every run after that, by hand or on a schedule, lands in a sheet named after the scraper.

Connect once · append or replace · Simplescraper sees only the sheets it creates
app.simplescraper.io/scrapers/lumen-packs
OverviewCrawlScheduleSendAPI
Google SheetsSending after every run
AccountConnected
Spreadsheetlumen-packs
Save methodAppendReplace
Unique fieldlink
Rows whose link is already in the sheet are skipped. Simplescraper can only see sheets it created.
Runs
Yesterday 07:00 · 42 rows+3 new
Run 07:00 · Running
docs.google.com/spreadsheets
lumen-packsCreated by Simplescraper
A1fxname
ABCD
1namepriceratinglink
32Cirrus Down Jacket$219.004.8lumensupply.com/p/cirrus-down-jacket
33Tarn Fleece Hoodie$79.004.5lumensupply.com/p/tarn-fleece-hoodie
34Scree Gaiters$35.004.2lumensupply.com/p/scree-gaiters
35Bivvy Sleeping Bag$189.004.6lumensupply.com/p/bivvy-sleeping-bag
36Glacier Sunglasses$65.004.3lumensupply.com/p/glacier-sunglasses
37Harbor Dry Bag 20L$32.004.7lumensupply.com/p/harbor-dry-bag-20l
38Fellside Merino Socks$22.004.6lumensupply.com/p/fellside-merino-socks
39Pinnacle Climbing Helmet$84.004.8lumensupply.com/p/pinnacle-climbing-helmet
40Moraine Camp Chair$69.004.4lumensupply.com/p/moraine-camp-chair
41Quarry Headlamp$45.004.7lumensupply.com/p/quarry-headlamp
42Sierra Rain Pants$119.004.5lumensupply.com/p/sierra-rain-pants
43Kestrel Hip Pack$49.004.6lumensupply.com/p/kestrel-hip-pack
44Lowland Trail Runner$139.004.6lumensupply.com/p/lowland-trail-runner
45Stormline Shell 2.0$179.004.7lumensupply.com/p/stormline-shell-2-0
46Ember Titanium Mug$34.004.8lumensupply.com/p/ember-titanium-mug
47Overlook Hammock$59.004.5lumensupply.com/p/overlook-hammock
48Cairn Ultralight Tarp$99.004.4lumensupply.com/p/cairn-ultralight-tarp
49Drift Packable Pillow$28.004.3lumensupply.com/p/drift-packable-pillow
Sheet1Analysis+6 rows · 42 already in the sheet, skipped

One-time connection

Click Connect Google Sheets in a scraper's Send tab and approve access. The first run creates a sheet with the scraper's name.

Append or replace modes

Append to build a history across runs, with a unique field so rows already in the sheet are skipped. Or replace the data with fresh results each time.

Limited Drive access

Simplescraper asks Google for the smallest permission it can. It cannot see, open or change any other file in your Drive.

How to keep formulas in a scraped sheet

A run can rewrite the whole tab Simplescraper fills, which clears any formulas and formatting on it. Keep that tab as raw data and build on a second tab that copies it with =Sheet1!A:D, where D is the last column of data.

docs.google.com/spreadsheets · lumen-packs
Sheet1filled by Simplescraper
ABCD
1namepriceratinglink
2Trailhead 40L Pack$129.004.7lumensupply.com/p/trailhead-40l-pack
3Basecamp Stove$59.004.8lumensupply.com/p/basecamp-stove
4Ridge Hiker Boot$164.004.5lumensupply.com/p/ridge-hiker-boot
5Daypack 22L$89.004.6lumensupply.com/p/daypack-22l
6Summit Two Tent$219.004.9lumensupply.com/p/summit-two-tent
7Ember Titanium Mug$34.004.8lumensupply.com/p/ember-titanium-mug
Analysisyour formulas and formatting
ABCDE
1namepriceratinglinkdeal
2Trailhead 40L Pack$129.004.7lumensupply.com/p/trailhead-40l-pack
3Basecamp Stove$59.004.8lumensupply.com/p/basecamp-stoveDeal
4Ridge Hiker Boot$164.004.5lumensupply.com/p/ridge-hiker-boot
5Daypack 22L$89.004.6lumensupply.com/p/daypack-22lDeal
6Summit Two Tent$219.004.9lumensupply.com/p/summit-two-tent
7Ember Titanium Mug$34.004.8lumensupply.com/p/ember-titanium-mugDeal
Analysis copies Sheet1 with =Sheet1!A:D and marks every pack under $100 in column E.

How to send scraped data to Google Sheets

Set it up once on any scraper. Every run after that writes to the same sheet.

1

Connect Google Sheets

Open the scraper's Send tab, click Connect Google Sheets and approve access in the tab that opens.

2

Choose append or replace

Append keeps every run in one growing sheet. Pick a unique field such as a link to skip rows you already have.

3

Run or schedule the scraper

The first run creates the sheet. Each run after it lands there on its own, hourly, daily or on the days you choose.

FAQ

How do I connect Simplescraper to Google Sheets?

Click "Connect Google Sheets" in your scraper's Send tab. Authorize once, and every scrape automatically updates your spreadsheet. No manual copying needed.

Will new data replace my existing data?

You choose! Set it to append new rows (keeping old data) or replace everything for fresh data. Most users append to build historical records over time.

Can my team access the scraped data?

Yes! Share the Google Sheet with your team using normal Google permissions. Everyone with access sees the new rows as soon as each scheduled scrape lands.

Can I scrape to multiple sheets?

Absolutely! Create multiple scrapers, each connected to a different Google Sheet - or different tabs in the same Sheet. Perfect for organizing data by project, client, or data type.

Send scraped data to Google Sheets today.

Connect in a minute, schedule the scraper and start with 100 free credits.

Start free
No credit card · or read the Google Sheets guide