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, https://docs.google.com/spreadsheets/d/1GA5sSQhQjB_REes8I5IKg31S-TuRcznWOPjcpNqtxmU/gviz/tq?tqx=out:csv. 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