What’s the Problem here?

We often copy and paste links and the titles from varieties of webpages, and make a glory link in Google Docs / Sheets. But it soon hogs our time to repeat this process for dozens and hundreds of links. (I’m not kidding, wiki editors feel painful of it) How can we simplify it?

Our Solution

We built a small utility tool Url2Title to automate this process. It could save your time from copying and editing a link. The apps script works on both Google Sheets and Docs. Here are two demos.

Get Title Text of a Webpage in Google Sheets

  • Make a copy of the Google Sheets with Url2Title built-in.
  • Select cell A13 that contains a hyperlink
  • Click menu Add-ons > Url2Title > Convert to Title
  • The link will be converted into a =HYPERLINK formula
Demonstration of getting the page title to a link in google sheets using url2title
Demonstration of getting the page title of a link in google sheets using url2title

Get Title Text of a Webpage in Google Docs

  • Make a copy of the Google Docs with Url2Title built-in.
  • Select the link url
  • Click menu Add-ons > Url2Title > Convert to Title
  • The link will be converted into the title text of the webpage link
Demonstration of getting the page title to a link in google docs using url2title
Demonstration of getting the page title of a link in google docs using url2title

How can I use it for my existing Docs / Sheets?

There is only one piece of apps script in Url2Title, so it’s simple to replicate it on your own Docs / Sheets.

  • Copy the apps script in either the Google Docs or Sheets demo files above to your own file.
  • Refresh your Docs / Sheets, and you will see the menu.
  • Follow the demo’s steps

Scratching your head? You may take a look in this How To Add An Apps Script To Your Google Apps? tutorial for beginners.

Improvements?

This is an initial idea to ease our work. I’m sure you have more ideas of automation on Google Apps, just leave any comments below or contact us. We love to save your working time.