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:

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

See more details in our documentation.

Did this answer your question?