Skip to main content

Scraping a list of URLs from a Google Sheets document

You can export URLs from Google Sheets such as this one directly into an actor's Start URLs field.

  1. Make sure the spreadsheet has one sheet and a simple structure to help the actor find the URLs.

  2. Add the /gviz/tq?tqx=out:csv query parameter to the Google Sheet URL base, right after the long document identifier part. For example, This automatically exports the spreadsheet to CSV format.

  3. In the actor's input, click Link remote text file and paste the URL there:

List of URLs

IMPORTANT: Make sure anyone with the link can view the document. Otherwise, the actor will not be able to access it.

Link sharing