Rajeevdaz

Automate Your Invoices with n8n and Templated.io

invoice automation

Here’s the simple N8N automation I built that pulls invoice data from Google Sheets, creates a PDF using Templated.io, emails it to the client, and updates the sheet automatically.

🔗 Useful Links

Templated.io Sign-Up (50 Free Credits): Sign up

Download Workflow JSON:

Code Node JavaScript
// Get invoice number from the Google Sheet node
const invoiceNumber = $('Loop Over Items').first().json['Invoice number'];

for (const item of items) {
  if (item.binary && item.binary.data) {
    item.binary.data.fileName = `${invoiceNumber}.pdf`;
  }
}

return items;

⚙️ Tools Used

  • n8n
  • Templated.io
  • Google Sheets
  • Gmail / SMTP

🎥 Tutorial Video

Visit Youtube Channel

Have an Automation project in mind?

Let’s discuss.

Contact Me

Latest Posts

Keep Reading
Category AI Posted on

How to Find Freelance Clients Using AI (Outseek AI Full Guide)

As a freelancer, finding clients used to be my biggest headache. Every morning, I'd open Reddit and other platforms to look for leads — because that's where people actually post when they need a service. But it was eating up so much time. One to two hours of scrolling, every single day, just to find a handful of decent leads. That's why I started looking for a way to automate the process. And recently, I found a …
Continue reading
Category AI Posted on

How to Give Your AI Agent a Real Browser for Free (BrowserAct)

Your AI agent can write code, plan projects and answer questions — but the moment you ask it to actually use a website, it hits a wall. Login pages, dynamic content, captchas — all of it breaks. BrowserAct fixes that. It's a free, open source CLI that gives any AI agent a real browser to work with. The Problem With AI Agents and the Web Most AI agents use something called web_fetch under the hood — basical…
Continue reading