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/1-2mUcRAiBbCTVA5KcpFdEYWflLMLp9DDU3iJutvES4w/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