Skip to main content
Question

Multi Line QBO Purchase Order to Google Sheets

  • March 6, 2026
  • 4 replies
  • 22 views

I need to export a multi line Purchase order from QBO into a Google Sheet.  I have worked on this unsuccessfully and Co-Pilot and ChatGPT both failed.  It seems that the Zapier Loop can not parse the data to output all 3 lines of the document I am working with.  Any help with this is truly appreciated.

4 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • March 7, 2026

Hi ​@Fin_VineLore 

For us to have more info, post screenshots showing how your Zap steps are outlined/configured.

 

Instead of Looping, try this Zap action: GSheet - Create Multiple Rows

This handles line items in 1 step.

 


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • March 17, 2026

Hey there ​@Fin_VineLore 👋

Just wanted to check how things went with the Create Multiple Spreadsheet Rows action Troy suggested? Did using that work out better than the previous looping approach?

Let us know how it went. Happy to lend a hand if you’re still stuck on anything 🙂


i_am_anmolg

Hey ​@Fin_VineLore , can you share how your QBO purchase order looks like and how your google sheet looks like? This can definitely be done using a code step in Zapier wherein you can write a script in Javascript/Python to transform the data from QBO purchase order to google sheet’s required format.


Forum|alt.badge.img
  • New
  • March 17, 2026

Hi ​@Fin_VineLore 

Here's the doc that might help: [link]

If you're still running into issues, I’d be happy to jump on a quick 15-minute call with you to sort this out, completely free of charge.

Just reply here with a thumbs up, and I’ll send over a link so you can schedule a time that works for you.

!-->