How to open a file sitting in a single cell uploaded to Sheets from website form?

Hi, trying to allow clients to submit a file via file upload to form on my website. The form upload is sent to a Google Sheet. It sits in a cell there. Is it possible to open the file in the cell and send its data to a new sheet?

Hi @Andy - Happy to help! Just to clarify, is the file a URL to the file or is it an actual file in the cell?

If it’s a direct URL, you could use an Enrich with API step to pull in that file. You would set the endpoint URL in the step to be {column name} and in the brackets include the name of the column that has the file that you want to pull in.