Shipping labels from Google Form to Google Docs

[Mithun Rao]

Your Task History ID

https://connect.pabbly.com/workflow/mapping/IjU3NjYwNTZhMDYzNzA0MzA1MjY1NTUzYzUxMzAi_pc

Workflow Link -

Pabbly

connect.pabbly.com

I am trying to send data from Google form to Google Document. I have created the " Shipping Label Template" ( link given ). The new files are getting created too and getting saved in the specified folder. Only the data in the new file is not getting updated. I am attaching the error that I get.

This is the Shipping label template - https://docs.google.com/document/d/1bKasx4fsEbkFoUZqMpgR8XuajQMVXv0BEQ6yxqmT7V4/edit?usp=sharing

2. Is there a way around where I can create multiple labels in the same document. I can create the basic template as to fit around 9 or 12 labels. And I want that any entries that come via google form should get arranged in the label format so I can just print a page and stick the labels.

Kindly Help.

 

[ArshilAhmad]

Hi @Mithun Rao,

Please test your workflow now. It should add data to your template and create a new document.

 

[Mithun Rao]

Can you please tell me what edit you did and what error I made. Thanks for your efforts.

 

[Mithun Rao]

Also can you please answer my 2nd question

2. Is there a way around where I can create multiple labels in the same document. I can create the basic template as to fit around 9 or 12 labels. And I want that any entries that come via google form should get arranged in the label format so I can just print a page and stick the labels.

 

[Preeti Paryani]

@ArshilAhmad will inform you regarding this shortly.

Can you please tell me what edit you did and what error I made. Thanks for your efforts.

In the meantime, could you please elaborate a bit more on your use case?

Specifically:

• When exactly do you want the document with labels to be created? (For example, upon form submission or at a scheduled time?)
• Secondly, where are the label details coming from—are they fields submitted via the Google Form, or are they fetched from another source?

This will help us better understand your requirements and suggest the most suitable solution.

. Is there a way around where I can create multiple labels in the same document. I can create the basic template as to fit around 9 or 12 labels. And I want that any entries that come via google form should get arranged in the label format so I can just print a page and stick the labels.

 

[ArshilAhmad]

Can you please tell me what edit you did and what error I made. Thanks for your efforts.

We simply refreshed the fields and clicked on 'Save & Send Test Request', which seems to have resolved your issue.

 

[Mithun Rao]

@ArshilAhmad will inform you regarding this shortly.


In the meantime, could you please elaborate a bit more on your use case?

Specifically:

• When exactly do you want the document with labels to be created? (For example, upon form submission or at a scheduled time?)
• Secondly, where are the label details coming from—are they fields submitted via the Google Form, or are they fetched from another source?

This will help us better understand your requirements and suggest the most suitable solution.

The main goal is to print the addresses that I receive from filling the Google Form.

The persons who fill the google form are required to give their address. I need a way to automise this in a way that all addresses are arranged in a single A4 sheet ( or multiple - if there are more entries ) so that I can print them directly on a page and dont have to manually arrange each address on a single sheet.

The above work flow is good enough and solves 50% of my problem. But is there was a way where I could shift all the address in a single document to be able to print multiple address in a single page.

Thanks

 

[ArshilAhmad]

You can try using the 'Google Docs: Append a Paragraph to a Document' action step and map the address in this step. This will allow you to capture the address from each new form submission in the same document. Each time a form is submitted, the address will be added to your document.

 

[Mithun Rao]

Do i need to create a template before hand. How will the paragraph know where to start from .?

 

[Soumya Tripathi]

Hello @Mithun Rao
You don’t need to create a detailed template beforehand. However, you do need to create a blank Google Docs document in advance, which will act as your target document.

When using the "Google Docs: Append a Paragraph to a Document" action step in Pabbly Connect, each new form submission will automatically append the address at the end of the existing content in that document. So you don’t need to define a specific position — it will always start from the bottom of the last entry.

This way, all the addresses will be compiled continuously in a single document, which you can easily format and print on an A4 sheet.

 

[Mithun Rao]

Thanks for your reply. But I think I ll have to hire an expert to get this done. because when I connect the Append a paragraph, I don't get any window/field to map the values.

And moreover, I need values in 3 different rows, not one below the other.

The aim is to print labels as the data keeps coming in. So there will be 3 rows of data, and the data should fill left to right, as in the tables. ( image attached )

I don't mind paying a fair value who does this set up for me. Anyone interested can contact me at 8331057374. Since time is money

Thanks.
Mithun

 

[Soumya Tripathi]

If you need someone to set up specific logic in your workflows, you may hire a Pabbly Connect Expert (freelancer) who can create workflows on your behalf. Their contact details are available at this link: https://forum.pabbly.com/threads/pabbly-connect-experts-and-consultants.22/.

 

[Mithun Rao]

I tried several numbers. only 1 or 2 replied and they are charging 2000 plus per hour. This is beyond my budget. if anyone charges per workflow then atleast I know what is the limit and how much I can spend.

 

[ArshilAhmad]

Thanks for your reply. But I think I ll have to hire an expert to get this done. because when I connect the Append a paragraph, I don't get any window/field to map the values.

And moreover, I need values in 3 different rows, not one below the other.

The aim is to print labels as the data keeps coming in. So there will be 3 rows of data, and the data should fill left to right, as in the tables. ( image attached )

I don't mind paying a fair value who does this set up for me. Anyone interested can contact me at 8331057374. Since time is money

Thanks.
Mithun

This particular use case you are describing doesn't appear to be possible. It’s not possible to add the data to the document in the way you are intending to.

 

[Mithun Rao]

Is it possible to enter one below the other ? I am not even able to do that

 

[Soumya Tripathi]

Hello @Mithun Rao
We already had a meeting in the morning, and you have scheduled another one for the evening as well. We will address and resolve your remaining queries during the upcoming meeting.

 

[Soumya Tripathi]

Hello @Mithun Rao
We have rescheduled the meeting for tomorrow morning and hope to resolve your issue during the session.