Home » Forums » screen-scraper » screen-scraper support for licensed users

Output to Google Sheets?

I would like to schedule something in Screen Scraper Server to automatically run then auto-publish on the web. Then use Google sheets IMPORTHTML or IMPORTXML or IMPORTDATA to pull the data into a Google Sheet.

Currently, my screen-scraper sessions export to a CSV. However, Google sheets requires something be published on the web in order to pull the data automatically (for obvious reasons).

Other scraping services offer an API key to easily import into Google Sheets. Does screen-scraper have anything built-in that can be easily used? If there's a way to easily and automatically publish the scraped data to an FTP server that would work too.

If you could point me in the right direction I'd appreciate it.

‹ Does screen-scraper support IPv6? Upgrade enterprise SS from 5.5 to 7.0, export/import of sessions works first time but gone after restart ›
jeffcole on 07/10/2017 at 11:44 am

Thank you! that'll work.

Thank you! that'll work.

 jeffcole on 07/20/2017 at 10:58 am

I don't know that I've ever

I don't know that I've ever been asked to save to Google Sheets before, so I don't have that functionality yet.

I don't have a built in FTP either, but I FTP files all the time. I generally run on a Linux machine, and install LFTP. Then I can make a script to run at the end (after the files is closed), to

Runtime.getRuntime().exec(command)

 jason on 07/11/2017 at 12:06 pm