Hi,
I am working with Google sheets, where I have an overview with all projects for 1 single customer, including the prices and the quantity. I created a Zap, and the information that is in the goolge spreadsheet is transferred to an invoice in Moneybird. The sheet however contains multiple projects, and I want to see them all on the same invoice. I only see 1 project only at the moment.
What do I need to do to include all projects (all rows with data) on the invoice?
Thanks so much!
Lindsay
Best answer by Liz_Roberts
Hi
Thanks for reaching out! I see you were working with Paul on this and were able to come up with a workaround as there is not a “Find/Update Invoice” Action at the moment.
Posting the Action workaround below in case other members have a similar question in the future. Please let us know if you have any additional question- happy to help!
The Zap only has access to a single row each time the Zap is triggered so adding in a new Google Sheets action should get us access to multiple rows at once. The below Actions can return up to 10, or 20 rows as Line Items:
The information from those rows could then be mapped the way in the exact way a single row which triggered the Zap is mapped!
+8Hi
Thanks for reaching out! I see you were working with Paul on this and were able to come up with a workaround as there is not a “Find/Update Invoice” Action at the moment.
Posting the Action workaround below in case other members have a similar question in the future. Please let us know if you have any additional question- happy to help!
The Zap only has access to a single row each time the Zap is triggered so adding in a new Google Sheets action should get us access to multiple rows at once. The below Actions can return up to 10, or 20 rows as Line Items:
The information from those rows could then be mapped the way in the exact way a single row which triggered the Zap is mapped!
Build and deploy automations from AI tools you already use. With Agentic Management, if anything breaks, the agent diagnoses the issue and proposes a fix.
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.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
