How to Generate an Excel File with Openpyxl and Email It Using Pipedream?

Help
1

This topic was automatically generated from Slack. You can find the original thread here.

Hi - I’m pretty new to Pipedream but looking to use it as an alternative to Make where I need to do more clever an complex things.
One of these is to generate an Excel file and email it to someone. I need to use openpyxl to generate the file and I can save it to the /tmp/ folder, but then I don’t believe I can access this to attach it to the Gmail action.
What’s the suggested route here? I was really getting my hopes up for Pipedream :slightly_smiling_face:
Many thanks

2

Hey , thanks for raising this issue!

For your request, I’ve created a ticket and added it to Pipedream backlog, Pipedream component dev will take a look at it soon
[FEATURE] Gmail & Gmail Developer App - Improve Send Email action to allow attachments from tmp dir · Issue #12339 · PipedreamHQ/pipedream · GitHub. Kindly subscribe to the ticket to be noticed when the new feature is available.

For any feature that you need, you can simply raise a new issue on Pipedream open source repository here

3

Thanks Leo.

4

Hi by doing a few tests I think this is already supported, you just need to pass the local path to the attachment value prop something like:

image.png
image.png1854×580 32.8 KB

5

or you can even create a Download File To /tmp step action like:

image.png
image.png2858×1430 248 KB

6

and then reference the value like:

image.png
image.png2870×1298 285 KB

7

let me know if that helps

8

I’ve tested for both Gmail and Gmail Developer App apps