How to export Dynamic scraper data to Google Sheets

You can export data scraped from the Dynamic scraper into a Google sheet.

Create new Dynamic scraper task

Pick elements to scrape

Yelp example:

https://www.yelp.com/search?find_desc=nail&find_loc=San+Francisco%2C+CA

Export > Google sheet

Under export, click Google sheet

Click on spreadsheet drop down to select sheet

You may need to sign into Google to allow access to sheets

Click Sign in
SCM will open Google sign in, in browser window
Choose Google account

You might see a Google app verification error
SCM App is currently under app verification from Google * 5/28/2024 *
Click Advanced

Click ‘Go to SEO Content Machine’

image

Click continue

Click Select all
SCM needs Google drive and Google sheets access
Click Continue

SCM App will start to pulse in your task bar
Activate SCM App

image

Click on spreadsheet dropdown
Select spreadsheet

image

Select a sheet

image

You can clear sheet of data before each run

image

If you de-select this option, SCM will keep adding new rows to your sheet

Run task

image

image

Sample

Open sheet to see new data

1 Like