Hi everyone,
I’m new to Zapier and currently working on improving some internal processes within our finance and sales teams. I'm trying to automate a few workflows and would really appreciate your suggestions or guidance on the best approach.
Here’s what I’m working on:
-
Purchase Invoice – Payment Confirmation & Remittance Advice
When a purchase invoice is marked as "paid," I’d like to automatically send the supplier a remittance advice. Ideally, it should show all invoices paid in a particular payment batch (e.g., if 3 invoices are paid at once, the remittance should summarize them all). I also want to include a PDF copy of the paid invoice. -
Sales Invoices – Draft Email Creation & Internal CC
When a sales invoice is created and approved, I want Zapier to:-
Generate a draft email in Gmail addressed to the customer (to be reviewed before sending).
-
CC an internal department (so they stay in the loop).
-
Automatically apply a label to the email and save it to a specific folder.
-
-
Sales Invoice – Payment Confirmation Email
Once a sales invoice is marked as paid, I’d like a payment confirmation email to be drafted. It should:-
Highlight the invoice details, how it was paid (e.g., credit note, bank account), and be saved in a designated folder for review before sending.
-
-
Improve Communication Between Finance and Sales
I’m exploring ways to improve visibility and communication. For example:-
Can invoice updates (e.g. created or paid) be automatically posted in a specific Slack channel, so the sales team can review, approve, or comment?
-
Is it possible for invoices to be searchable within Slack and tagged by the sales team when there's a query or issue?
-
Can we link customer records using their unique Xero customer number—so sales or finance can quickly identify and reference the correct contact when needed?
-
If anyone has set up something similar or has advice on how best to structure these Zaps, I’d love to hear your insights!
Just to mention I've started experimenting with some workflows and was able to get a few Zaps set up. However, they only seem to work when a new event is triggered after the Zap is created. For example, nothing has happened in Slack or Gmail for existing events in Xero—only for new ones created after the Zap is set up.
Any advice on how to handle or test existing data would be appreciated!
Thanks in advance!