Google Sheets to HTML

Questions
, ,
1

Good afternoon community! How are you doing? Again here with my queries haha, sorry!!!
In this case I come to ask if it is possible for example from the Google Sheets node, I bring me a table and the same should as “take a screen” and place it in a body in a mail, is that possible with any node? Or should I get that info and build an html template from scratch?

Thank you very much as always for your support!
Have a nice weekend!
Regards!

Information on your n8n setup

  • **n8n version:1.25.1
  • **Database (default: SQLite):Postgress
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • **Running n8n via (Docker, npm, n8n cloud, desktop app):Kubernetes
  • Operating system:
2

I am having a little bit of a hard time understanding exactly what you’re asking help with.

I think you’re asking the best way to add a table in an email from a spreadsheet?

You can do it by first getting the google sheet with the Get Row(s) operation then use the html Convert to HTML Table operation. The html node will return an html table that you can add to your email.

Screenshot 2024-02-03 at 2.23.53 PM
Screenshot 2024-02-03 at 2.23.53 PM853×231 14.1 KB

You will likely need to customize styles, but that works. You can adjust the filters and settings in each node to dial it in.

Let me know if that’s what you were asking and if you have any follow up questions

3

Hi @liam

That is exactly what it is! I hadn’t seen that option!

Thank you so much!