Answered

Typeform + Document Studio - is it possible to embed images that my respondents upload onto a template?

  • 29 November 2023
  • 9 replies
  • 76 views
G

Hi,

 

I have a workflow on Google Sheets that transfers my Typeform’s responses onto a PDF via a Google Docs template. I’d like to embed user image uploads on this template but so far the section remains blank.

 

I’m wondering whether this is to do with the fact that on Google Sheets, the Google Drive file URL doesn’t appear - only an api.typeform link.

 

Does anyone know whether it’s possible to transfer the image files across?

 

This is what I’ve currently got in the Docs template: {{ Embed image, photo, width=115 }} (“photo” is the tag).

 

Thanks in advance!

icon

Best answer by john.desborough 1 December 2023, 18:58

View original

9 replies

Grace
Rank
Userlevel 7
Badge +5

Hi @G Young thanks for stopping by 😊

I’m going to tag in @john.desborough as he’s a bit of a whizz kid with Document Studio so may know the answer… 🙏

If cauliflower can become pizza, you my friend can do anything
john.desborough
Userlevel 7
Badge +6

@G Young  @Grace - this isn’t so much a Document Studio/Google Sheets issue.. 

it comes down to getting the image files into a ‘place’ where you can get the fully qualified URL to the image and not the typeform default link, in the field in Google Sheet and then have that url pulled in as {{fieldname}} 

 

you’ll have to figure out the integration/upload into google drive and get the url to the file, unfortunately. I think that there are some posts by @mathio (???) elsewhere in the community that might cover that google drive url stuff.. but i may be mistaken in my memory.. 

 

(note:not a whizz kid.. way too old for that .. more of a caffeinated curmudgeon)

If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
mathio
Rank
Userlevel 7
Badge +5

Hello,

When you have Google Sheet integration, the file upload column is populated with a URL that is publicly accessible and can be displayed eg inside an <img> tag. @john.desborough is this what you are looking for?

john.desborough
Userlevel 7
Badge +6

Hello,

When you have Google Sheet integration, the file upload column is populated with a URL that is publicly accessible and can be displayed eg inside an <img> tag. @john.desborough is this what you are looking for?

@mathio -- not looking for me sir… trying to point the way to others on where to search lol..

 

des

If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
Grace
Rank
Userlevel 7
Badge +5

@G Young let us know if @mathio is on the right track or if there’s something else you are wanting to do 😊

If cauliflower can become pizza, you my friend can do anything
mathio
Rank
Userlevel 7
Badge +5

@john.desborough you mentioned that @G Young would need to move the image files into a ‘place’ where you can get the fully qualified URL to the image and not the typeform default link. I am just curious what is wrong with the default link, as it seems to be fully qualified and publicly available URL. Is there any reason to move or upload the file elsewhere?

I was reacting only to the file URL part, I have no experience with “Document Studio” and can not help there. Just trying to help with that one tiny part.

john.desborough
Userlevel 7
Badge +6

@mathio  @G Young - my comments were about being able to do the embed function… i’ve see a variety of folks with difficutly trying to embed a file in docs

 

@G Young - if you want to ‘display’ the file ie an image, using the document studio tool, then it is much simpler than using embed

here’s a shot of the spreadsheet from a sample file upload

note that it is the api.typeform url.. 

 

i do all my doc studio reporting off a separate tab in the spreadsheet so here’s what it looks like - using the arrayformula function to bring the filename across

 

here’s the google doc for the merge

 

and the result

 

 

 

using the embed inside the {{ }} for document studio is what is killing the report imho

 

des

If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
Grace
Rank
Userlevel 7
Badge +5

Hi @G Young hope you’re doing ok! Let us know if you have managed to get everything set up or if you still need help with this 😊

If cauliflower can become pizza, you my friend can do anything
G

@john.desborough This seems like the easiest fix for this, thank you!

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs