@emmanuel I am still in trouble here, this is what I have done:
I get an email from gmail using zapier, I save the html content of the email in a google spreadsheets, then using REGEX I extract a name, an ID , an actual contract number and a ftp link, every one of those saved in a diferent CELL, everything happens automatically, and it works as charm.
I was trying to download the file from the ftp link using zapier with dropbox, google drive, S3, even an FTP site, but with not luck, because FTP downloads and web downloads are different world. Anyway, My workaround to this was to wrote a little python script and make run every x minutes in a machine I have in paperspace.io, this script read the google spreadsheet, gets the ftp link, connects to the FTP and download the file to a dropbox folder in it, so automatically I am saving everything to dropbox ( I am thinking using also python to save the content of the email to the spreadsheet, so I can save some Zaps from Zapier, but this in the near future)
Now my problem is with blockspring, I am trying to download the data the way you told me before and get the raw data, with no luck, I am using a block called “Web Scraping - Download File from URL” (I believe the only one who does that) in the preview, using one file it works perfectly, but when I am going to use it with bubble I really do not know how to do it, I have tried to use it directly to bubble, I have also tried inside the spreadsheet , but nothing, the workflow is really diferent when you use it in the preview, where you can even see the RAW data… I really need help with this, I have been working on this since I finished the python script, some weeks ago and I am a little desesperate, and writing this here in the forum is my last resource.
I know this is a little long, but I hope you or somebody could help me out here.
Thank you so much.