Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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 ​@Gdog ,

 

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 ​@jayeshkumarbhatia ,

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 ​@Gdog,

 

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 ​@JammerS , thank you for your help. I have done the same thing all the way to Google Docs. However, in Google Docs, I pick “create document from template” in the action events. Then I have to map the data from Sheets to Docs. I set up a simple template with the fieldnames {{Product1}} {{Quantity1}} and right under {{Product2}}{{Quantity2}} thinking that I would have to create a separate fieldnames for each item. However in the fieldmap dropdown menu that comes from Sheets, I can add “PRODUCT” and “QUANTITY” which has the first row of the Sheets or “Rows Col A” and “Rows Col B” which has the two different lines in the Sheets. I have been adding both to Docs with no success. How would I enter line items separately into Docs?

Hi ​@Gdog,

 

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


Terms & Conditions