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

Поделиться
HTML-код
  • Опубликовано: 4 сен 2024
  • Adding images from the web and Drive to Google Docs
    UI menu item to dynamically add images like logos and others. Press the menu button and add an image. Images can be from Google Drive or from the web. Preselected images within your Doc
    Source Code basescripts.co...
    Course content web development and web design courses with coding examples and source code for the lesson content. Source Code is available within my Github account. Lessons posted are designed to help students learn more about a specific topic related to modern web development and applying code.
    Laurence Svekis is a professional top selling course author having instructed over 1 Million students both online and in person. Laurence Svekis is a Google Developer Expert specializing in Google Workspace automation using Google Apps Script Code.
    Check out my Website for more details at basescripts.com/
    Subscribe - / @laurencesvek. .
    Tags and Keywords
    #AppsScript #googlesheets #workspace #accounting #finance #automation modern web design online course #onlinecourses #modernwebdesign #tips #appsscript #coding #codingtutorial #script #scriptinghelp #google #Viral #subscribe #helping #GoogleAppsScript #Gmail #Attachments #Spreadsheet #Automation #GmailAttachments #GoogleAppsScript #EmailProductivity #Automation #SpreadsheetLogs #AttachmentDetails #TechTips #ProductivityHacks #GoogleDrive #GmailSearch #GoogleAppsScript #Spreadsheet #Email #Automation #Iteration #subscribe
    #GoogleSheets #GoogleAppsScript #CustomUIMenu #SpreadsheetTips #ProductivityTips #TechTutorial #CodingTutorial #BeginnerFriendly #StepByStepGuide

Комментарии • 32

  • @user-ct5lz7sr6m
    @user-ct5lz7sr6m 10 месяцев назад

    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
    @masbromw3880 Месяц назад

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

  • @rafiqrahimi6765
    @rafiqrahimi6765 Год назад +1

    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
      @LaurenceSvekisCourses  Год назад

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

  • @chirrispola
    @chirrispola 2 года назад +1

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

  • @okonyeodumije5893
    @okonyeodumije5893 Год назад +1

    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
      @LaurenceSvekisCourses  Год назад

      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.

  • @pintuchoyan9526
    @pintuchoyan9526 2 года назад +1

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

  • @monteabaok1621
    @monteabaok1621 2 года назад +1

    Awesome video, but how to add an image or qrcode to a cell from a google sheet in the form of a url in a doc document as a template

    • @LaurenceSvekisCourses
      @LaurenceSvekisCourses  2 года назад

      The cells can handle image paths, if it detects an image object it will show it. Although images don't work entirely like regular text in sheets

  • @Rookhe
    @Rookhe Год назад +1

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

    • @LaurenceSvekisCourses
      @LaurenceSvekisCourses  Год назад +1

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

  • @GuyRendon
    @GuyRendon Год назад +1

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

    • @LaurenceSvekisCourses
      @LaurenceSvekisCourses  Год назад

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

  • @yanethhuertas6945
    @yanethhuertas6945 Год назад +1

    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
      @LaurenceSvekisCourses  Год назад +1

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

  • @caozweefvliegen8750
    @caozweefvliegen8750 2 года назад +1

    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
      @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
    @YvesBartsch Год назад

    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
      @LaurenceSvekisCourses  Год назад +2

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

  • @pintuchoyan9526
    @pintuchoyan9526 2 года назад +1

    Sir, can I upload bulk image from gdrive folder image to doc template? Please share code

  • @sawok1975
    @sawok1975 Год назад

    How to add image into shape?😊

  • @soothingrelaxingmusic7022
    @soothingrelaxingmusic7022 2 года назад +1

    Great Work. Could you share the codes

    • @LaurenceSvekisCourses
      @LaurenceSvekisCourses  2 года назад

      I have all the source code on my website basescripts.com and on github

  • @pintuchoyan9526
    @pintuchoyan9526 2 года назад +1

    Sir insert image in doc from Google form submit ? Please share code

  • @pintuchoyan9526
    @pintuchoyan9526 2 года назад

    Sir, can I upload bulk image from gdrive folder image to doc template? Please share code

    • @LaurenceSvekisCourses
      @LaurenceSvekisCourses  2 года назад

      There is plenty of code that I have on github and my website on this topic