Issues uploading spreadsheet from link in email body to Google Drive

[NEON_Global]

Hey All. I’m attempting to use the text parser and REGEX to match a pattern in an email body for a specific link, and then use ‘HTTP get a file’ to upload the spreadsheet from that link to Google Drive.

It seems that the REGEX pattern is correct: the URL in bundle 1 is the URL that has the spreadsheet I want downloaded. However, the file that ends up going to Google Drive is empty, containing ‘.html’ after my assigned filename.

I believe that my issue in the ‘HTTP get a file’ module. The input bundle appears to be correct to my novice eye, but I’m not so sure about the output bundle. If anyone has any ideas or solutions, I’d be very grateful.
http input bundle.txt (260 Bytes)
http output bundle.txt (7.3 KB)

[samliew]

Welcome to the Make community!

That is because the link goes to a download WEB PAGE, not an actual file.

• https://42y7l4ikac.execute-api.us-east-1.amazonaws.com/default/download?uuid=68ec9723-fdce-4335-b0f6-84c07cc034b7&expireTS=1728047071674

It then redirects you to a URL that looks like this

• https://one.ticketmaster.com/cdn/email-service-assets/download/fileDownload.html?fileName=TM1_Daily_09-04-2024_Sales-Trends_Auschwitz-Exhibition.xlsx&displayName=Daily+Report%3A+Sales+Trends±+Auschwitz+Exhibition+%28176+Events%29&targetUrl=https%3A%2F%2Fone.ticketmaster.com%2Ffilestorage%2F72cb9dd9-bf2d-4383-831b-a93d1cd152cf%2F1725455071672%2FTM1_Daily_09-04-2024_Sales-Trends_Auschwitz-Exhibition.xlsx%3Fresponse-content-type%3Dapplication%252Fvnd.openxmlformats-officedocument.spreadsheetml.sheet%26X-Amz-Algorithm%3DAWS4-HMAC-SHA256%26X-Amz-Date%3D20241001T011456Z%26X-Amz-SignedHeaders%3Dhost%26X-Amz-Expires%3D604799%26X-Amz-Credential%3DAKIA46CDME525SW3IMWQ%252F20241001%252Fus-east-1%252Fs3%252Faws4_request%26X-Amz-Signature%3Dd6e2aa2975bb433f2528855f443a522acb073180b21b2ee3259b76e742e08b4d&fileType=xlsx

The web page then uses JavaScript to download the file after a few seconds.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

[NEON_Global]

Thanks @samliew , that makes complete sense and I wish I had caught that. I’m going to do some searching and see if there’s any way to accomplish what I’m trying to do, but if you see a possible solution/route for me to go down, please let me know! Thanks again

[samliew]

Did you know, this forum has a Hire a Pro category, where you can post your request for off-site specialised help on other platforms (video call/screenshare/private messaging/etc.)? This may help you get your issue resolved faster especially if it is urgent. It is important to post your request in the Hire a Pro category, as forum members are not allowed to advertise their services elsewhere (like here).