Web Scraper avatar
Web Scraper
Try for free

No credit card required

View all Actors
Web Scraper

Web Scraper

apify/web-scraper
Try for free

No credit card required

Crawls arbitrary websites using the Chrome browser and extracts data from pages using a provided JavaScript code. The actor supports both recursive crawling and lists of URLs and automatically manages concurrency for maximum performance. This is Apify's basic tool for web crawling and scraping.

User avatar

Issue with uploading to Google Sheet

Closed

auzzi opened this issue
4 months ago

I'm encountering an issue while uploading data to a Google Sheet. Despite granting full access, I continue to encounter a 403 error during the upload process.

User avatar

auzzi

4 months ago

Is it possible to use a web scraper that takes input from column A in a Google Sheet and, using the same sheet, outputs data from column B?

User avatar

Hello @auzzi and thank you for your interest in this Actor!

Could you please share the run where you encountered this issue? You are using the Google Drive integration, which seems to have succeeded in the past few runs. If you want to export the data into a Google Sheets spreadsheet, consider using one of our Google Sheets integrations, e.g. Google Sheets Import & Export - we even have a tutorial on our blog about this integration.

Regarding the second question: AFAIK, we can ensure the proper functionality for our "Google sheet as a list of start URLs" feature only for Google Sheets with one column - so I'm afraid the answer to the question is no.

If you need such a feature, consider checking out the official API for Google Sheets. Alternatively, simply add the first column with URLs to the output dataset and have it exported to the output Google Sheet.

Can you please clarify in which run you are encountering this issue? Thanks!

User avatar

auzzi

4 months ago

Thank you for providing the solution of using the Google Sheets Import & Export, Unfortunately it gives the error of the app block.

User avatar

Closing due to inactivity.

Developer
Maintained by Apify
Actor metrics
  • 3.4k monthly users
  • 99.9% runs succeeded
  • 3.2 days response time
  • Created in Mar 2019
  • Modified about 2 months ago