Hi Pepa, thanks for the suggestion. This means that the urls would need to be already encoded in the spreadsheet, right? That does not help me much as customer just wants to fill the spreadsheet and I do not think he can encode the urls. I guess only possibility is to use google sheets actor to load the urls.
This really sounds like something that may be improved, I am definitely raise an issue for the platform team about this.
Thinking about current workaround, you may use the google sheet actor, or provide google sheet url to your implementation and use google sheets API ( https://developers.google.com/sheets/api/quickstart/nodejs#set_up_the_sample ), but that is little bit complicated since, it requires creating OAuth2 credentials from the Google API Console.
how does it work? you have registered the app that the actor use? now I need to access public spreadsheed without apify platform and it looks like I need the api key