Typeform + Document Studio - is it possible to embed images that my respondents upload onto a template? | Community
Skip to main content
Answered

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

  • November 29, 2023
  • 9 replies
  • 143 views

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!

Best answer by john.desborough

@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

View original

9 replies

Grace
Community Team
Forum|alt.badge.img+5
  • Community Advocate
  • 2576 replies
  • November 29, 2023

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… 🙏


john.desborough
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5257 replies
  • November 29, 2023

@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)


mathio-tf
Typeform
Forum|alt.badge.img+5
  • Typeform
  • 888 replies
  • November 30, 2023

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
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5257 replies
  • November 30, 2023
mathio wrote:

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


Grace
Community Team
Forum|alt.badge.img+5
  • Community Advocate
  • 2576 replies
  • November 30, 2023

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


mathio-tf
Typeform
Forum|alt.badge.img+5
  • Typeform
  • 888 replies
  • December 1, 2023

@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
Forum|alt.badge.img+6
  • Certified Partner & Champion
  • 5257 replies
  • Answer
  • December 1, 2023

@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


Grace
Community Team
Forum|alt.badge.img+5
  • Community Advocate
  • 2576 replies
  • December 5, 2023

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 😊


  • Author
  • Explorer
  • 5 replies
  • December 5, 2023

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


Reply