Download XLSX files from Gmail

Question

Hi,

I have been trying to download xlsx files from a specific label to my local computer. I use the tutorial for downloading gmail attachements from the link below:

https://community.alteryx.com/t5/Engine-Works-Blog/Download-Gmail-Attachments-with-Alteryx/ba-p/28823

However this doesn't work with xlsx files I believe. During the final step the data gets transformed into a blob (with the proper size for the test file) but the output looks like this:

"PK"

Has anyone gotten this to work? The goal is to download the gmail attachements to my local computer. I tried changing the download output to a blob and storing the file but it's unreadable after storing.

Thableaus · Accepted Answer

Hi @DanielH

The comment below on this article actually elucidates this question:

"Hi Stephen.

Just wanted to give you a heads up regarding a bug in the tool. Google uses a different base64 encoding than alteryx (see this link) so you need to replace the character '-' with '+' and '_' with '/' before you can base64 decode it, atleast for excel files.

Thank you though for saving me a lot of time with this otherwise excellent tool.

Best regards//Leif"

Maybe this could be the cause of the issue?

Cheers,