Complex Form to Google Doc Workflow

[jbph]

Hello, I have a fairly complex for with many fields and image uploads etc. I want to create a Google Doc with all of this information automatically. I have the Webhook functioning but am not clear on the workflow to best achieve this task?

I want the Google Doc to be made in a specific Google Drive Folder. I have tried to use

Google Drive : Get File or Folder by ID
and then:
Google Docs : Create a Blank Document

the first issue is that the file is created but not inside my chosen folder. The second issue is I am not sure of the best way add all my form data to the google doc? Which actions and steps would you use to best do this after the document has been created? Thanks in advance to anyone who can point me in the right direction!!!

​

 

[Himesh]

This video might be useful

If you still unable to understand it you can dm me. FYI I'm not from pabbly connect team I'm an automation freelancer who helps other pabbly users.

 

[jbph]

This video might be useful

If you still unable to understand it you can dm me. FYI I'm not from pabbly connect team I'm an automation freelancer who helps other pabbly users.

That is very useful indeed!
I have the template up and working but I have another question please.
How can I:

• Set up a rule that checks if a field is empty:
  • If the field contains data, pass the value as-is.
  • If the field is empty, replace it with "" (a blank string).

For example:

• If the {{name}} value is empty, configure Pabbly to replace {{name}} with nothing ("").

 

[ArshilAhmad]

Try using 'Text Formatter: Default Value' action step and see if it gives you the desired result.

 

[jbph]

Try using 'Text Formatter: Default Value' action step and see if it gives you the desired result.

Thanks I will definitely look into that.
I managed to change one photos in my google doc but now I updated to change many images I always get this error:

Invalid requests[0].replaceImage: No image with object ID: kix.1u9lei6fpocw

What does this mean?

 

[jbph]

This video might be useful

If you still unable to understand it you can dm me. FYI I'm not from pabbly connect team I'm an automation freelancer who helps other pabbly users.

I managed to change one photo in my google doc but now I updated to change many images I always get this error:

Invalid requests[0].replaceImage: No image with object ID: kix.1u9lei6fpocw

What does this mean?

This video might be useful

If you still unable to understand it you can dm me. FYI I'm not from pabbly connect team I'm an automation freelancer who helps other pabbly users.

I managed to change one photo in my google doc but now I updated to change many images I always get this error:
Invalid requests[0].replaceImage: No image with object ID: kix.1u9lei6fpocw
What does this mean?

 

[Preeti Paryani]

Hello @jbph,

The issue you're facing is likely because your document either does not contain any files or does not have multiple files. This is causing the error.

To resolve this, please ensure that the document contains the necessary files. Additionally, you can use filters to check for the presence of files before attempting any replacements.

 

[jbph]

Hello @jbph,

The issue you're facing is likely because your document either does not contain any files or does not have multiple files. This is causing the error.

To resolve this, please ensure that the document contains the necessary files. Additionally, you can use filters to check for the presence of files before attempting any replacements.

Thank you Preeti for your reply! My document template contains 5 images to be replaced. My Webhook shows that all 5 uploaded images are present and thos images are stored on a server for access. For some reason the image replacement fails. I have asked Pabbly Support to look into it but they do not seem to understand me.
Are you able to help me understand why i get this response from Google Docs:

Failed: The response received from the Google Docs app is shown below:

Error Code	400
Error Message	Invalid requests[0].replaceImage: The URL should not be empty.
Error Status	INVALID_ARGUMENT

 

[jbph]

Thank you Preeti for your reply! My document template contains 5 images to be replaced. My Webhook shows that all 5 uploaded images are present and thos images are stored on a server for access. For some reason the image replacement fails. I have asked Pabbly Support to look into it but they do not seem to understand me.
Are you able to help me understand why i get this response from Google Docs:

Failed: The response received from the Google Docs app is shown below:

Error Code	400
Error Message	Invalid requests[0].replaceImage: The URL should not be empty.
Error Status	INVALID_ARGUMENT

I have set up a filter to check for the presence of the files.
This filter returns a "Condition is false" message. I do not understand why as I can see the images in the webhook and if I copy and paste the image URL into a browser then I see the image.

 

[Preeti Paryani]

Hello @jbph,

Our team is currently looking into it, please allow us some time.

Thank you Preeti for your reply! My document template contains 5 images to be replaced. My Webhook shows that all 5 uploaded images are present and thos images are stored on a server for access. For some reason the image replacement fails. I have asked Pabbly Support to look into it but they do not seem to understand me.
Are you able to help me understand why i get this response from Google Docs:

Failed: The response received from the Google Docs app is shown below:

The issue might be due to the step not being properly saved. Please try saving the step again and let us know if it works as expected.

Additionally, ensure that the condition is set correctly for different keys, as having the same condition applied to the same key multiple times may cause conflicts.
I have set up a filter to check for the presence of the files.

This filter returns a "Condition is false" message. I do not understand why as I can see the images in the webhook and if I copy and paste the image URL into a browser then I see the image.

 

[jbph]

Pabbly is Down.

 

[jbph]

I created a new Workflow and new google doc

Hello @jbph,

Our team is currently looking into it, please allow us some time.


The issue might be due to the step not being properly saved. Please try saving the step again and let us know if it works as expected.

Additionally, ensure that the condition is set correctly for different keys, as having the same condition applied to the same key multiple times may cause conflicts.
I have set up a filter to check for the presence of the files.

I have written in with an update to my support email.
I created a new workflow and new google template. If I trigger the workflow from Pabbly it adds all 5 images. If I trigger the workflow by the webhook it only adds 3 images. I just don't understand why it would do only add 3 of 5 images. It makes no sense.

 

[Preeti Paryani]

Hello @jbph,

We have escalated this concern to our technical team, please allow us some time to look into it and we will get back to you as soon as we receive any updates from our team.

I created a new workflow and new google template. If I trigger the workflow from Pabbly it adds all 5 images. If I trigger the workflow by the webhook it only adds 3 images. I just don't understand why it would do only add 3 of 5 images. It makes no sense.

 

[jbph]

Hello @jbph,

We have escalated this concern to our technical team, please allow us some time to look into it and we will get back to you as soon as we receive any updates from our team.

I haven't heard back from the team. Any updates please? Can you estimate how long it will be before I receive a response from technical support?

 

[Preeti Paryani]

Hello @jbph,

The issue has now been resolved. You can enable the previously shared workflow to test the action and let us know if it works fine for you.

 

[jbph]

Hello @jbph,

The issue has now been resolved. You can enable the previously shared workflow to test the action and let us know if it works fine for you.

It still does not work. Also you created another problem. Now when parsing the variable from the Google Template you are also parsing the styling and showing it in the webhook response.
It should just read Flower Comments and not 12PTOpensSans..... that's the font size and the font style coming through so there's definitely a bug there.
This also means that the variables are no longer replaced in the Google Document so this is a new problem.
In the document I have {{ceremony_flower_comments}} this is no no longer replaced as the names don't match.

View attachment 54730

I have tried the workflow and it still does not correctly replace the images.

As before it works if you run the test in Pabbly. In the real world it fails every time....... very frustrating

 

[Preeti Paryani]

Hello @jbph,

The attachment is unavailable please attach the correct one. Also provide the workflow URL where you have faced this issue so we can better look into it.

 

[jbph]

Pabbly

connect.pabbly.com

URL:https://connect.pabbly.com/workflow/mapping/IjU3NjYwNTY5MDYzMTA0Mzc1MjY5NTUzMzUxM2Ii_pc