I would like to create a packing slip in Google Docs or Sheets after I create an invoice in Wave. I set up the trigger on Zapier for Wave new invoice. It works. I use the formatter Utilities and line itemizer to separate the two lines I have in the invoice, one for each product and quantity. It works. Then I create an action for Google Docs to create a new document from template. The text I get on the document is two product names side by side, separated by a comma and the two quantities right next to it, separated by a comma. What am I doing wrong?
Hi
This looks challenging. Can you try converting the item tables in Google Doc Templates to line items? Also can you tell us why are you using Google Doc to create invoice and not some other platform.
Hello
All I want to do is prepare a packing slip. Wave has all the information I need and I can actually get the data. The only problem I have is, I have a couple of lines in the invoice such as Product 1 and Product 2. If I use Google Docs, I can place every piece of data using Fieldnames except the line items. If I use Google Sheets, I can get the line items but I can’t design the packing slip. So I am stuck :)
Hi
Welcome to the Community.
Consider using a combination of Google Sheets and Google Docs to handle line items and create packing slips. Set up a Zap triggered by a new Wave invoice to add line items to a Google Sheet. Then, use Google Docs to create a packing slip from a template, replacing placeholders with invoice data. While line items would need to be added manually from the sheet, this workaround balances design and functionality.
I hope this helps! Let me know if you have any other questions.
Hello
Hi
Zapier’s Google Sheets integration processes rows as separate triggers, so it doesn’t natively handle mapping multiple rows into a single Google Doc template. Workarounds include using a Formatter step to join rows, using a third-party app like Airtable to manage multiple records, or adding a Code step to pull various rows. Note that the Google Docs action creates one document per Zap run, requiring separate Zaps for each document.
I hope this helps. Let me know if you have any other questions.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.