I want to generate one PDF from a Google Form submission where the applicant’s uploaded photo appears inside the form PDF

I have created a job application form in Google Forms. Applicants upload their photo and other documents in the same form. I want to generate a single PDF from that form using Pabbly Connect, where the applicant’s photo appears inside the application form PDF and the uploaded supporting documents appear below the form in the same PDF file.

Hi @SUNILPANDA,

The use case you are describing appears to be partially possible. You can capture your Google Forms response using the Google Forms trigger step in Pabbly Connect, and then use the Google Docs: Create Document from Template action step.

Once you have captured the Google Forms response, you would need to:

• Create a Google Docs template
• Insert placeholders (based on the fields in your Google Form), such as:
  
  • {{name}}
  • {{photo}}
  • {{address}}

• The uploaded image must be publicly accessible or properly shared.
• Then, use the “Create Document from Template” action step to add the form response data and the image directly into the document.

youtube.com/watch?v=AlPzBjhuHVU

the uploaded supporting documents appear below the form in the same PDF file.

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
? Pabbly.com

Hi @ArshilAhmad,
First, I used Google Forms as the trigger, then used Google Docs as the action with the “Create documents from template” event. I mapped all the fields (like {{name}}, {{father's name}}), then used the Text Formatter app to split the image file, and tried both “Insert image into document” and “Replace images in document,” but I’m getting an error. I’m attaching the screenshot of the workflow.

Hello @SUNILPANDA,

Thank you for sharing the details.

However, we are unable to find the workflow image/screenshot in your reply.

Could you please share:

• The workflow URL
• The screenshot/screencast of the workflow and the error you are receiving

You can simply edit the thread and provide the required details and access permission so we can proceed further.

Hello @SUNILPANDA,

Thank you for sharing the details.

However, we are unable to find the workflow image/screenshot in your reply.

Could you please share:

• The workflow URL
• The screenshot/screencast of the workflow and the error you are receiving

Also, kindly grant us account access permission so we can better investigate the issue from our end and assist you accordingly. If you prefer, we will not make any changes to your workflow/account — the access is only required so we can properly review the setup and understand the issue.

You can simply edit the thread and provide the required details and access permission so we can proceed further.

Hello @SUNILPANDA,

Thank you for sharing the workflow details with us.

We tested the workflow from our end. The text variables/placeholders within the Google Docs template are working correctly; however, the step where the image is being inserted into the document is returning an error.

To further investigate why this is happening, we will need access to the Google Docs template that you are using to generate the document.

Kindly share the template access with the following email addresses:

• [EMAIL][email protected][/EMAIL]
• [EMAIL][email protected][/EMAIL]

Okay, I want insert image in google docs from google spreadsheet. In google spreadsheet the image URL are available and the image URL are coming from google form to google spreadsheet. please tell me step by step I will do it.

Hello @SUNILPANDA,

Sorry, but we are not able to fully understand the exact issue from your message.

However, as per our understanding, you are using the Google Sheets trigger and have enabled both the options: "Send on Event" and "Auto Send on Schedule".

If the data is getting captured in the workflow after some delay (for example within an hour), then it is likely being captured through the "Auto Send on Schedule" option and not through the "Send on Event" option.

In such cases, if the data is being added to Google Sheets via a third-party application, you can disable the "Send on Event" option and continue using the "Auto Send on Schedule" option, as the data should still be captured in the workflow task history within an hour.

Additionally, if you want the data to be captured faster than one hour, then you can add a 1-minute Apps Script trigger in your Google Sheet (provided no other Apps Script is already configured there).

You can follow this documentation for the setup:
https://forum.pabbly.com/threads/google-sheets-1-minute-trigger.12927/

Please check and let us know if we have understood your issue correctly.