I can't insert an image into a Google Doc from a Google Forms response

[Alan_Daniel_Alcazar]

I’m trying to pull all the data that is filled out when submitting a Google form, and fill it out in a document with letterhead, my problem is that when I try to insert the image that is uploaded to the form, the image does not upload, only the link, I’ve been trying different ways but none have worked for me… Can you help me?

[Stoyan_Vatov]

Hey Alan,

can you share some screenshots of the scenario so far showing how the modules are setup and demonstrating the issues you are facing?

[Alan_Daniel_Alcazar]

This is one of my attempts, but I haven’t tried several ways, if you know any way to do it, I would appreciate it if you told me.

[Jonathan_Quarics]

You need to make a “Web Content Link” which can be done with the Get a Shared Link module of Google Drive, set the role as reader and the type as anyone, then map the Web Content Link to the Image URLs field in the Google Doc module

This is an example using the Watch responses form module

Integration Google Forms.blueprint.json (27.8 KB)

If you want to do it with the Watch Rows module, you’ll need to extract the ID of the image, it’s the value after the id= https://drive.google.com/open?id=1RoUqaoYAvx67lHYbYCbRGBCa0gsdxw/

This one 1RoUqaoYAvx67lHYbYCbRGBCa0gsdxw

[Alan_Daniel_Alcazar]

Do you know how to extract only that part of the URL?

[Jonathan_Quarics]

The easiest way is by using the Watch Responses form module, which includes the image fileID

Another way could be extracting the fileId from the Google Drive link on the new Google Sheets row with this function {{get(split("IMAGE LINK COLUMN HERE; "id="); 2)}}