Google Sheets + Google Apps Script: Insert Image from URL
HTML-код
- Опубликовано: 22 апр 2022
- This video shows you how to use Google Apps Script to insert an image into a cell.
WANT TO SAVE MONEY USING GOOGLE WORKSPACES?
If you're interested in maximizing the capabilities of Google Workspace to help organize and run your small business, non-profit, charitable organization, or even your family, you can use my affiliate link - referworkspace.app.goo.gl/ZkK1 - along with one of my promotional codes to get 10% off of your first year!!
Business Starter Promotion LCWXMA4CWAEM6XN
Business Standard Promotion P7Y7AMGTQ64KP3V 
Наука
This is awesome. I am running an API from the NASA website to get their daily image of the day, but couldn't figure out how to turn the URL into an image and paste into GS. Perfect, simple, easy method to solve my problem. Now I am running that script on a daily trigger and have that updated in a spreadsheet so all the teachers at my school can have something fun to look at every morning prior to starting their day (assuming anyone cars about space images). Thank you!
INCREDIBLE VIDEO!! Both ChatGpt AND Google Bard could NOT figure this out. You are fantastic. It's insane to me that Bard couldn't figure it out being that it has direct access to googles own source code.
Happy to help!
GOOD JOB amigo, with yout video my macro worked
This is great! I really appreciate it if you can make a tutorial for google docs as well.
hi there. I'm working on an assignment board which display my mates pictures, i've already made a version using the funcion IMAGE and displaying it in a group of cells, one of those cells is de control cell... which manages the picture and name of my mates.
Is there any way to make the same, but with floating images?
Think this could be done by modifying your script to make a function called DYNAMICPIX("cell") which gets the cell URL in order to display it on the floating image... is this possible? So i can assign a "variable" script to the floating image.
Thanks in advance!
Hello,
Thank you for your tutorial!
I have this situation:
- one google doc template where I have a variable called {{logo}}
- one google spreadsheet with one cell where can I select a logo from a list of images (text)
- same google spreadsheet with a cell named "logo" (named range), where shows the ID of the logo previous selected (vlookup formula)
- a list of logos IDs (saved in google drive)
Question:
what lines of code sould I write in order to create a PDF from doc template with info from google docs :)
Thank you!
nice job!
Thanks @bigbrother1211
how do I add the Automation tab in my Google Sheets please?
HOW WOULD YOU IMPORT AN IMAGE FROM ONE SHEET TO ANOTHER? I ADDED AN IMAGE FROM MY GALLERY TO A CELL AND I LIKE TO IMPORT THAT IMAGE (FROM THAT CELL) IN TO ANOTHER SHEET. 😊
Is there a way to use Optical Character Recognition (OCR) technology to read the hand/type written phone number and auto-populate this into Google Sheets? Does Google Script allow us to setup a region, like the phone number area and then read that region into a cell in Google Sheets?
Hi Monique, Google Sheets does not have built in OCR, but Excel does. In my experience Excel for Mac is way better at pulling text/numbers from an image or PDF compared to the Windows version. However, there are 2 extensions that you can integrate with Google Sheets for free by going to Extensions > Add-ons > Get Add-ons and searching for OCR. I installed one to test it out and perhaps do a follow-up review video.
As far as setting up Regions, that can be done via Apps Script or with a formula. My first thought is to use =LEFT(cell, 3) to pull the area code out of a phone number and then putting that formula into either an INDEX MATCH or VLOOKUP to match it against a city or state. Let me know if that helps
@@jsphpalumbo thank you si much for commenting and telling me your insights. ☺️
looking forward to your follow up video!!!
I just can't find the proper word for me to search and it seems like OCR still do not cater hand-written texts 😅
@@moonnaalliissaa No problem. Thanks for watching my video and sending me a question. Always here to help.
@@moonnaalliissaa I downloaded Content Sense - contentsense.jivrus.com/
*How to insert an image(which is present in my google drive) to a google form(while creating a google form) using App script??*
Keep getting a bad url error when using images stored on google drive.
I am having the same problem, have you found a solution??
Very basic question, sorry for this :) How do you open emojis ? :D
This is pulling an image from a URL. But I need to import an image from a spreadsheet to a google docs file. There are some images (in cell images) in my spreadsheet. I want to take all images into my docs table. Can You help me? what is the code? Thank you.
wow... i am also looking for something similar... till now havnt found anything
@@austinjames7485If you will get it ever, please inform me. thank you :)
@@DataScience40 I tried 3 things... One is attaching a Document to the spreadsheet but then the images won't come... Then I tried using the e.namedvalues code but I dnt know why the code itself isn't working (Work still going on)... Then I tried to create a template inside the spreadsheet and linked both sheet inside it.. Response & Invoice kind.. The code runs fine.. And gives output too in pdf with image but it doesn't seem to run when the form is submitted..
No, I didn’t get the code. But I have done the work by excel VBA later instead of apps script. Excel to word doc.
This is NOT possible until now. I did a lot of research on this.
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?
Hi, I have a similar problem. I am trying to get image responses from a Google form to appear in a Google sheet.
Did you ever find a solution?
@@johnnyhaas6560 ruclips.net/video/9J3K_-0Jduw/видео.html
In the same boat right now. Did you find anything?
@@johnnyhaas6560 did you find anything?
@@okonyeodumije5893 still working on it. I've made some progress but it's not working quite yet. I'll keep you updated
sir, this is for few images only. But I want to extract 1000's of images from url to whole column at one click. Then , how will I do that. Please make a video on this topic. Please sir!!!!!!!!
Thanks for your comment, and happy to help. Can you provide more information about where these images are coming from? It depends on if the URLs for these images are being fetched from a JSON file or API, or if you want to scrape them from a website. I can make a video about either one, but would need to know which approach to take.
@@jsphpalumbo I am using google form, in which images are uploaded. Then after that I have fetched the response of that form data.
But, in response I got the url of the image, instead of getting direct image appears in the cell of the google sheet.
So, I want to see the direct image in the cell instead of seeing url of image. And, I have 1000's of responses in my sheet. So, how will I see the direct image in the cell of lakhs of records at once? That's my question.
@@miserp4557 please make a video on this topic please
@@miserp4557 I published a video today on to loop through a column in a Sheet, grab the cell value and do something with it. It sounds like you need the same thing here, but grabbing images from URLs and inserting them into either a Google Sheet, or maybe even a folder in Google Drive. Let me see if I can set something up where I can demonstrate this.
@@miserp4557 I made a video to show you how to download those images - check out ruclips.net/video/6cgMbq_t5V0/видео.html