Convert an image into an url button in Google Sheets Using Apps Script

Question

Peace Be Upon You,

I need some help with google app scripts.

What I want to do:

I want to add an image in google sheets
Add an app script to this image
Configure the script so that when I click the image it takes me to a url (external or internal)

What Help I need: I'm a beginner and would like to get the work done. Please help me with a sample or template code to place the url.

Why app script for this simple task: Google sheets kept no other way to point a drawing or image to a url. I've tried everything.

I’m new here. Please forgive me if asking this way is against manners. But please help me.

Thanks,

Md. Iftikhar Alam Omar

https://iftikharomar.co

Wellerman · Accepted Answer · 2021-01-15 05:08:40Z

1

Step 1: Insert the image.
Step 2: Create the following in the script.

function btnClick() {
  var html = "<script>window.open('https://google.com');google.script.host.close();</script>";
  var userInterface = HtmlService.createHtmlOutput(html); 
  SpreadsheetApp.getUi().showModalDialog(userInterface, 'Loading...');
}

Step 3: Right-click on the image, then hit the 3 dots in the upper right-hand corner. Click assign script and type btnClick in the box.

See this Google Sheet for a functional example.

answered Jan 15, 2021 at 5:08

Wellerman

8566 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert an image into an url button in Google Sheets Using Apps Script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related