Make sure the spreadsheet has one sheet and a simple structure to help the actor find the URLs.
/gviz/tq?tqx=out:csvquery 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.
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.