Hi I have set up a zap between xero and google sheets to add a new line in sheets for every new sales invoice, does anyone know how I can also pull back all historic invoice details as a one off?
Question
Pulling historic Xero data
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
FYI: Zaps are meant to work for new data going forward.
You can try Transfer by Zapier (https://transfer.zapier.com/), altho unsure if that will work with Xero for your desired use case.
[ADVANCED] Otherwise you’d have to use the Xero API: https://developer.xero.com/documentation/api/api-overview
That would require Zaps steps involving Code or Webhooks apps.
+11- Zapier Solution Partner
Hi
Hopefully, you got this sorted - but if not, here’s an article I wrote about syncing historical data in Zapier.
ZapConnect 2026 is coming
Join us September 23rd, 2026 for a free, one-day virtual event with 30+ sessions on AI automation. Get live build-alongs, playbooks, and strategies to lead AI transformation at your organization.
Log in to the Community
No account yet? Create an account
Use your Zapier credentials
Log in with ZapierEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.