Send credit note from Xero to Airtable

Hi there @mari,

I did some digging into this, and it seems like the closest trigger we have to a sales credit note is the “New Sales Invoice” trigger. Have you tried using that trigger to see if it’ll fit your desired workflow?

That said, here is how I see the Zap for the workflow that you have in mind:

1. Trigger: Xero (New Sales Invoice)
2. Action: Airtable (Create Records (With Line Item Support)

Please let me know if that helps! 😊

Hi @ken.a 

I have tried that but it doesn’t pull credit notes.

I’ve also tried adding a filter for invoice number to have CN

I have also tried to pull it as payment and the trigger doesn’t trigger.

Cheers Sam. This is going to be a problem for me. I’ve built a Sales, Stock & CRM system between Xero & Airtable based on the data coming from Xero through Zapier. I might have to now look at a different solution that doesn’t rely on zapier.

Cheers,

Sorry to hear that @mari. I’ve been doing some further looking into this and I’m wondering if you could set up a webhook directly from Xero to send information about the credit note to a Zap.

It looks like Xero has a Invoice UPDATE webhook event that you could subscribe to. So I’m thinking that when the credit note is allocated to an invoice that may be seen as an update to the invoice and the webhook would be sent to the Zap. You’d need to use a Catch Hook (Webhooks by Zapier) trigger for the Zap and use the webhook URL it provides for the “Send notifications to” field in Xero when setting up the webhook. I couldn’t see from Xero’s documentation exactly what fields would be send by the webhook but I’m hoping that if it’s sending a notification about an update to an invoice that it would include details about the update such as the credit note information that you’re after here.

Webhooks are a bit more advanced and only available on paid Zapier plans so this may not be an ideal solution here. But thought I’d mention it just in case it’s something you’d be willing to try. If that’s something you’d like to explore, you can learn more about how to trigger a Zap using a Catch Hook here: Trigger Zaps from webhooks and how to set up the webhook in Xero here: Creating a webhook 

If you do give that a try and it works, or find an alternative solution please let us know. Would love to hear how you get on!

I think I may have found a workaround

Schedule a custom report using G-Accon extension in Google Sheets 

You can then set up a trigger based off a new line in Google Sheets

Regards

Thanks for sharing this, @Mitchell Zezima! If anyone gives this a shot - we’d love to know how it works for you. 🙂

Thank you! I will give it a shot later this week and will let you know!

Hey folks,

Just circling back in here to share that we’ve recently added a New Credit Note trigger to the Xero app on Zapier! 🎉


Hope you’re able to give that new trigger a try soon!

If you experience any issues with it please do get in touch in the Community or reach out to our Support team and we’ll be happy to help. In the meantime, happy Zapping! ⚡