Create Kitchen Prep Sheet from Square invoice line items

Hi ​@tnelson, sorry to see you haven’t gotten a reply here yet. Not sure if you’ve already got this sorted?

If not, I had a quick look and it doesn’t look like the New Invoice trigger for Square would output the individual order line items can’t see that sort of workflow being an issue. So you might need to use a Find Order search action to get the line items for the order relating to that customer’s invoice. From there you could use a Create Multiple Spreadsheet Rows action to add the line item data to the spreadsheet.

If you wanted to have a different spreadsheet created for each event you’d want to use a Create Spreadsheet action first to make a new spreadsheet, then in the Create Multiple Spreadsheet Rows action you’d use the Custom value option to select the spreadsheet’s ID (from the Create Spreadsheet action). That should ensure the Zap adds the rows to the new spreadsheet that was created.

You’d use a similar approach for if you wanted the details added to a Google Doc instead but use a Create Document From Text to create a new document, or use a Append Text to Document action to add the info to an existing doc. That said, you’d likely need to convert the line items to text using a Formatter step first since I don’t think the Google Docs app supports line items.

Hope that helps. Keep us posted on how you’re getting on though, want to make sure you’re all set!

Thanks. I’ll give this a try!

​Hey ​@tnelson​, just checking in! Did that approach do the trick?

I’m happy to assist further if you’re still stuck at all - just let me know! 🙂

Thanks for letting me know ​@tnelson and sorry for the delay in my reply. I’m so glad you were able to get an alternative solution in place. Feel free to reach back out if you decide to revisit this in the future. In the meantime, happy Zapping! ⚡