How to Add Images from Drive and the web into Google Doc with Apps Script one click UI menu

Рет қаралды 9,331

Күн бұрын

Пікірлер: 32

@yanethhuertas6945 2 жыл бұрын

hello, I want to program an image that is uploaded from a Google form, and that is seen in a Google document spreadsheet, the URL is hosted in the spreadsheet, of form responses, how can I do it?

@LaurenceSvekisCourses 2 жыл бұрын

You can have the image on your gdrive, then select it by id and add it into the other docs as a blob

@Rookhe 2 жыл бұрын

hello, how to change the image properties before or after the text?

@LaurenceSvekisCourses 2 жыл бұрын

You can set the values in the object, which image text as they are separate elements

@RitikThakur-r6f Жыл бұрын

Hello Sir, I really appreciate your efforts and the way you teach every single bit of it . I just want to knwo can we add signature images stored in google sheets into google docs just like a automated form . Cn we do that Like an automated signature form directly

@masbromw3880 6 ай бұрын

Hello Sir, how to replace text on google docs with image from url using apps script?

@GuyRendon Жыл бұрын

Do you have an example to add an image using a placeHolder {{myImage}} in Google Docs?

@LaurenceSvekisCourses Жыл бұрын

you can link to any image, if you need a placeholder I would use a default marker and then find replace

@okonyeodumije5893 2 жыл бұрын

Thanks a lot for this awesome content Laurence. Since google sheets can grab text data from an online form, can it do so with images? For context, I have a contact form with name, email, subject. I can import this data into a spredsheet with app script. What if the form also had an image input (users uploading screenshots on the form), can I use app script to get the image into a cell, along with the other info?

@LaurenceSvekisCourses 2 жыл бұрын

Yes you can insert images in specific cells as well as the sheets document. I'm adding a new video soon on that as I have that question several times in my courses.

@rafiqrahimi6765 2 жыл бұрын

Hi sir could you help That tell me the best way to download snd install spreadsheet because whatever i tried i could not get to sny of them

@LaurenceSvekisCourses 2 жыл бұрын

Google sheets is online within the browser, you can create a local workspace if you want this is enabled in the chrome browser

@chirrispola 2 жыл бұрын

Awesome video but I have a question, how can I add an image to an specific place instead of were the cursor is at ?

@LaurenceSvekisCourses 2 жыл бұрын

You can insert it into an element index location, check out my latest video it shows how to do this,. basescripts.com/google-apps-script-images-and-files-coding-examples

@caozweefvliegen8750 2 жыл бұрын

Hi, great script. I want to make the picture upload dependend on a user variable. I have around 50 user with a userid and based on the userid I want to upload a image with a specific id. Is that possible ?

@LaurenceSvekisCourses 2 жыл бұрын

Yes, you can. You would need some time of tracking to tie the images to the users. You can use a spreadsheet which would make it easier with apps script

@YvesBartsch 2 жыл бұрын

Hey Laurence, thanks for the great Video! I am currently trying to figure out the opposite of what you did. Do you know if there's a way to automatically extract all pictures in an excel sheet and move them to specific drive folders?

@LaurenceSvekisCourses 2 жыл бұрын

Yes they are within the SpreadsheetApp Service as images within the main doc

@pintuchoyan9526 2 жыл бұрын

Sir , I watch your video regularly. Sir how I upload bulk images in doc template from g drive URL which submit by Google form . Please sir I need for school project. Thanks

@LaurenceSvekisCourses 2 жыл бұрын

I have some videos on the upload to gdrive, you can do as many images as needed. If they are from a web form, you just need the path, then copy the blob of the image which allows for reproduction.