How to Send a QuickChart Graph in Gmail?

[n8nnoob]

Hi, I’m currently trying replace an app we’re paying for and using on our website. The current app basically allows people to fill out a survey on our website, we take the data and give them a score based their responses and put in a piechart.

Describe the question

Currently I have got most of this workflow working, and I’ve been able to successfully generate a Pie Chart using QuickCharts tool, but I’m having trouble emailing it.

The Pie chart comes out like this

Please share your workflow

Does anyone have any advice? Should I be exploring another way to generate the pie chart so I can send it?

Thanks

[mohamed3nan]

@n8nnoob

The Pie chart comes out like this

I think you need to convert this “Binary” to an image so that you can attach it to the email

[n8nnoob]

Hi @mohamed3nan ,

Do you have any suggestions as to how I go about doing that?

Thanks,

[mohamed3nan]

I’m not exactly sure what the ‘QuickCharts’ output binary looks like, but you can check this for inspiration:

How to handle image uploads in n8n chat? (binary data missing)

I think you have to activate this option “Include Other Input Fields” in the “Set” node to get the binary attachments from Chat node to deal with it [image] Here is a working example to upload a file from the chat to google drive:

Simply put, it converts the attachment’s binary data into a downloadable file, allowing you to perform further operations, such as uploading it to an email…

[n8nnoob]

Hi @mohamed3nan,

This is a little confusing.

To answer you question, the Output binary looks like this:

and when I click view, it looks like this

Am I converting into Base64, then back to File, so that it can be downloadable? I did notice it gives me this option after I try that.

Am I correct in assuming that I need to have this downloadable format and then I need to upload it onto Googledrive, so then I can use a Google Drive tool to attach it to the gmail?

Thanks!

[mohamed3nan]

Oh, sorry for the confusion. All I have are the screenshots…

@n8nnoob

Am I converting into Base64, then back to File, so that it can be downloadable? I did notice it gives me this option after I try that.

You do not need “Google drive” (this was an example) sorry for the confusion.

You can attach this file to the Gmail node directly

If I understand you correctly, is this what you’re trying to do?

[n8nnoob]

HI @mohamed3nan,

Yes something like that.

How do I share my workflow like you did in your previous reply?

(Sorry still quite new at this)

Thanks!

[mohamed3nan]

No problem,

You can copy and paste it inside a code block.

click on this:

or:

[n8nnoob]

Hi @mohamed3nan

Is this better?

Also, the reason as to why I’m on the newer Beta version is:

N8n Form multi-select recording Null

Hey @n8nnoob, welcome to the forum! Can you try updating to 1.84.0 that was released to beta yesterday? It should have been fixed in that version.

[mohamed3nan]

Thank you, ok i see you now set the attachments, can you tell me now what error you get or the expected output?

[n8nnoob]

Hi @mohamed3nan,

Workflow currently looks like this

The error I’m currently getting is on the Gmail App, which currently looks like this

I’m not sure what I’m supposed to put in the attachment field name actually, nothing seems to be dragable/droppable into the field.

[mohamed3nan]

Hi, can you try this

I removed the second AI Agent and directly connected Gmail to send the email with the attachment, why do you need it in your workflow!?

[n8nnoob]

Hey @mohamed3nan,

Haha Turns out I was over complicating it.

I removed the email edit fields and code lines and just used the email taken from the first part of the survey, and now it works!

Thanks you so much @mohamed3nan (Inspired me to remove stuff to get a simpler haha)

[mohamed3nan]

Thank you! You too. I actually learned a few things from this workflow as well