+44 203 287 0899 info@solvaa.co.uk
A piece of corrugated card with the text Process Automation on it, alongside a black market pen and some wooden discs with letters printed on them. This is overlaid with text which says : Automate tasks using Zapier : 5 quick wins! Includes a small Solvaa logo in the corner.

If you use a Customer Relationship Management (CRM) app in your business, it is often a common workflow requirement to create an invoice in your accounting system once a deal or opportunity reaches a certain stage in the CRM. If an integration exists between your two apps, often the integration may not do what you need it to do or still requires manual steps.

If, for example, you use Pipedrive and Xero to manage your sales and finances, then you probably know that a great native integration exists between the two systems. It allows you to generate invoices in Xero and see invoice statuses sync between the two apps, which is very handy for visibility. Unfortunately, you won’t be able to create those invoices automatically in Xero based on certain trigger criteria in Pipedrive. Say, for example, if you wanted to create an invoice in Xero when a deal reached a certain stage in Pipedrive, the process would still require manual effort, so can be time-consuming and inefficient.

There is a solution, however! You can automate the entire process using Zapier to take out the manual steps, streamline the process and reduce errors.


Our video teaches you how to automate adding invoices to Xero when events happen in Pipedrive

Our new video shows you how easy it is to configure Zapier to connect Pipedrive and Xero to create a contact for a new customer and then add an invoice to Xero, when a deal reaches a particular stage in Pipedrive.  Zapier’s pre-built integrations mean that you don’t need to write any code, or hire a developer, to automate tasks in other apps when events happen in Pipedrive.

For our example, when a deal is updated to the ‘invoiced’ stage we can trigger a series of steps to look for an existing contact, and if it’s not found then create a new one.  The trigger step can be customised to work with other relevant triggers in Pipedrive; here is a link to the full list of Zapier trigger events with Pipedrive.  We could also have used the Create/Update Contact integration for Xero. You can check out the other Zapier integrations with Xero here.

Then we create a sales invoice for the contact, all using Zapier’s super-simple visual builder interface.  Zapier takes you through each trigger and action event, asking what data you need and testing each step as you go, to ensure it works.


The steps in Zapier which add new contacts and create an invoice

Our video is a step-by-step guide to the automation for adding new contacts and creating an invoice when a deal is updated in Pipedrive.  We explain each step in detail and explain why some of the integrations were chosen as there is often more than one way of automating a particular process.

The steps are:

  • Create a trigger event for when a deal in Pipedrive is updated to the ‘invoiced’ stage.
  • Split the person’s full name into forename and surname using the Formatter By Zapier app
  • Split the address into separate lines using Formatter By Zapier so that each can be stored in a different field in the contact record.
  • Find or create the contact in Xero by searching for the organisation and if it doesn’t exist then create a new contact using the name and address details from the previous steps.
  • Create a sales invoice in Xero, mapping the products from the Pipedrive deal into separate line items.

Watch the video and subscribe to our YouTube channel

Some handy tips

Here are a few bonus ideas to get you thinking about how you can improve this process further:

  1. You can create more visibility in your CRM by enabling the use of custom fields and adding extra steps in your workflows to pass back invoice numbers or invoice URLs, and invoice statuses.
  2. You can also create additional workflow automations to update your invoice statuses in your CRM when the status changes in Xero to “paid”.
  3. You can add additional steps in your workflow to send the invoice out automatically to your customer and mark it as “sent” in Xero. Watch another one of our videos that includes an email sending step.

Other CRM options

Although this example for adding invoices and contacts to Xero uses Pipedrive, there are many other CRMs that have pre-built integrations in Zapier, including Salesforce and Hubspot, just to name a couple. We could replicate this process in Salesforce as it has similar trigger events in Zapier, when a Lead or Opportunity changes its pipeline stage.  You can view all the Salesforce integrations here and we will be creating a video using Salesforce zaps very soon!

Use this link for a 30-day Pipedrive free trial instead of 14 days.


More about automation using Xero

If you’re a Xero user then we have some other automations you can use to connect it with your other business apps.

We also have a brilliant case study for one of our clients, One Year No Beer, who saved over £2800 by optimising their Xero setup using Zapier.


Our other resources

We also have plenty of free resources:

And finally, our founder / chief problem solver / chief automator Kelly Goss’ new book, Automate It with Zapier, is out now and is the most comprehensive Zapier guide on the market. It will get you up and running and to the stage where you can build and debug advanced automations. Buy your own copy today directly from publisher Packt using this link. Or here are links to Amazon (.co.uk) and Amazon (.com) if you prefer.

Save time and grab our pre-built Zap template

Read more about how our certified experts use Zapier workflow automations to simplify processes and increase efficiency.

Solvaa is a process and automation consultancy specialising in improving sales, operations and financial administration workflows. We help you to simplify and streamline existing processes, integrate your business tools to make data transfer more efficient and automate manual tasks to increase productivity. We are Zapier Certified Experts, Pipedrive Certified Experts and Xero Certified Advisors. 

Contact us today to discuss how Solvaa can help you simplify, improve and automate all aspects of your business with Zapier to save you time, reduce costs and keep you agile as you grow.

Related Posts

An accountant at his desk using a calculator and checking invoices, with a laptop and PC monitor in the background.

How accountants and bookkeepers can use Zapier

Running the financial aspects of businesses usually involves performing manual tasks, but if accountants and bookkeepers learn how to use Zapier then many of these can be streamlined and eliminated. We asked a few accountants and bookkeepers how they use automation to...
Close-up of a woman using a portable credit card reader, holding a receipt which is being printed.

How to automate your sales funnel and win more business

Your sales cycle is one of the most important functions in your business so it's vital that it is efficient so that you can convert more sales and win more business. We have already covered how to automate your marketing tasks so this article concentrates on pushing...
Pages from a calendar with heading of ‘Four Day Week’ and a fountain pen.

How to make a 4 day working week more productive

Many UK businesses are participating in a 6-month pilot programme for their employees to work a four-day week but get the same pay and benefits that they would if they were full-time. It might sound too good to be true but the expectation is that increasing...
Solvaa blog post title image for post "New low-code features from Zapier bring automaton power to the people."

New low-code features from Zapier bring automation power to the people

Have you ever been frustrated when a Zapier app integration doesn't have the action you need? Or perhaps you have Zaps filled with webhook steps, and only the most technical people in your team know how to update or edit them? Zapier has built low-code features App...
A draft stamp on its side with the word DRAFT with the orange Zapier logo.

New cool Zapier feature coming soon : Zap editor Drafts (in beta now!)

If you’ve ever had to tweak one of your Zaps then you’ve always had to turn it off first, which is always a worry as you may be missing vital automations which should be triggering while you work on it. So, when we received an email from Zapier inviting us to take...
Turquoise letters of the alphabet flying around randomly.

How to unlock the power of Zapier’s text formatter

If you haven’t used Zapier’s inbuilt text formatting function then you may be surprised by just how powerful it is.  Many zaps process character data in one form or another, and if the data isn’t ‘clean’ then it won’t look neat when it’s output onto invoices, used in...
: A laptop and plants on a wooden desk with grey wall, with text overlay saying ‘save contact form submissions in a spreadsheet’.

How to automatically save contact form submissions in a spreadsheet

If you use a form on your website for visitors to contact you then you will usually get their details emailed to you so that you can then respond.  Whilst this works adequately as a lead notification system, what would be more useful is to save contact form...
Decorative feature image for Solvaa blog post " Boost Your LinkedIn Sales: Streamline your sales process with Surfe and Pipedrive"

Boost Your LinkedIn Sales: Streamline your sales process with Surfe and Pipedrive

LinkedIn sales thrive on effective communication and relationship management. LinkedIn serves as a powerful tool for sales pros to engage with leads and nurture valuable connections, however, it's challenging to get your LinkedIn leads into your CRM in an automated...
The head image for the blog post showing a photo of a calendar on a yellow background. Next to the calendar is the Solvaa Automation academy & consultancy logo. Under that are the logos for the Calendly and Zapier apps.

Create a Zap for rescheduled Calendly events by adding one simple step

When you're using Zapier, it can be frustrating if the trigger or action you need doesn't exist. If you're technically minded, you may be able to build your own, but sometimes there's a simpler solution. If you're using Calendly with Zapier, you'll know that there...
Female dentist examining a patient with a mirror whilst a male dental assistant looks on and smiles.

Client Success Story : How Ascent Dental Group saved many hours of manpower by automating their dental practice

Ascent Dental Group is based in the Midlands, with 36 reception and patient-care staff plus 35 dentists across four practice locations.  They wanted to implement automations to increase productivity, reduce manual administrative tasks and improve communication with...
Image shows a pen next to a bank statement and data chart next to a calculate. Text is overlaid which says ‘How Xero automation saves time and reduces errors’.

How Xero automation saves time and reduces errors

If you’re running a business then you want your workflows to be as slick as possible, particularly the finances.  If your staff are spending hours on repetitive manual tasks such as entering data into a spreadsheet then you are wasting time and money which could be...
Blue background with electrical components arranged to look like robots with text overlay ‘Zapier Automation Project Showcase’.

Zapier Project Showcase

  We work with such a diverse range of clients, many of whom had never heard of Zapier before they connected with us.  We understand that you may be unsure what kinds of apps can be connected using Zapier so thought we’d share a showcase of some of our key...
Concept of date time with a photo of a hand overlaid with a hand drawn calendar and clock in white.

How to express dates in Zapier

Once you start to unleash the power of Zapier you will more than likely need to schedule a step to run at some point in the future.  For example, you might want to set up a cadence of sales emails to follow up leads.   You may want to automatically create project...
Jigsaw pieces which have text for the benefits of automation and a separate piece which says Automation Blueprint, as a concept of the blueprint being the missing piece of the jigsaw.

Our automation blueprint : the perfect way to learn how to use Zapier

  We often talk about the benefits of business process automation but do you find the idea of automation a bit daunting? You may be keen to improve business performance, reduce human error and get rid of all the boring mundane tasks but wonder where on earth to...
Header image for the Solvaa blog post AI-tomation: how Zapier is AI to make automation easy. Part 3 - AI apps to turbocharge your Zaps

AI-tomation: how Zapier is using AI to make automation easy

Welcome to the third instalment of our series on leveraging artificial intelligence (AI) with Zapier. In this edition, we explore different ways Zapier supports AI, like OpenAI and ChatGPT. This blog post shows how 'generative AI' and automation can increase...
Mobile phone with a ‘new message received’ message with a cursor hovering over a ‘show’ button and thumb poised to select it.

How to harness the power of automating text messages using SMS by Zapier

Automating text messages can be extremely useful in business, and using SMS by Zapier is really powerful, easy – and free! In this article we cover the following: Why is SMS such a powerful business tool? What is SMS by Zapier? What could I use SMS by Zapier for? What...
Decorative image - a header for the Solvaa blog post "Mastering Meeting Efficiency: How Automation Can Make Meetings Better"

Mastering Meeting Efficiency: How Automation Can Make Meetings Better

Meetings. A vital yet often frustrating feature in the landscape of business. Not many people look forward to meetings (there's a reason that "This could have been an email" is now a phrase so viral you can find it on mugs, t-shirts and more), and even fewer enjoy...
Yellow and orange post-it notes on a white wall, containing details of business tasks to be undertaken, representing a productivity concept. Overlaid text with ‘4 Productivity Tools That Will Change The Way You Do Business’ in black on a light blue background.

4 Productivity Tools That Will Change The Way You Do Business

As a business owner, life can get overwhelming. Between working on client assignments, running your own company, and maintaining some kind of family or social life, it’s almost impossible to do it all without a solid foundation and proper organisation. Productivity...
Mockup of a computer screen in an office with the Zapier homepage displayed on the monitor.

How to get started with Zapier

  If you’ve never used Zapier before then getting started can seem daunting.  Although the Zapier website has many examples of automations you can build, the most important thing to do before you even consider automation is to review your processes. If you’re...

How to automate thanking your customers for paying their Xero invoices

Learning how to automate sending an email using Zapier when a Xero invoice is paid is a really simple but useful workflow that saves time and provides great customer service. Xero is a cloud-based accounting system which includes a host of features to reduce...
Automate ebook

Get our free ebook

Learn about how business process automation with Zapier can help you to run your business on autopilot. The ebook is packed with real-life examples, use cases, and success stories. Whatever kind of business you have, you can use automation to help you work smarter, not harder.

Thanks! Your ebook is on the way.

Pin It on Pinterest