Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I’m having trouble creating a Zap for what seems like a really simple function in Google Sheets.  If a URL is added to a row in an existing spreadsheet, I want the Zap to convert the URL into its relevant ACTUAL post title. 

For example, if https://keviniscooking.com/greek-grilled-chicken/ is inserted into the spreadsheet, I want the URL converted so it has anchor text that says Greek Grilled Chicken (or whatever the meta post title actually is.

Hoping someone can help!

Hi @Bec-SSE 

Try adding the HYPERLINK formula into the desired field of the GSheets Zap step.

=HYPERLINK(url, link_label])

Article: https://support.google.com/docs/answer/3093313?hl=en

Hi @Bec-SSE 

Try adding the HYPERLINK formula into the desired field of the GSheets Zap step.

=HYPERLINK(url, ,link_label])

Article: https://support.google.com/docs/answer/3093313?hl=en

Thanks, Troy. I must still be missing something because it’s not working. Not a huge deal, I was just trying to save time by not having to edit the URL anchor link text manually.

@Bec-SSE 

Can you please provide screenshots of how your Zap step is currently configured? Thanks.

Hey @Troy Tessalone , so here’s what I’ve got. Hopefully you can see this :laughing:

 

 

The trigger is when column C of the spreadsheet is updated (I had to white out names for confidentiality reasons)

 

When I add a URL into column C of the spreadsheet, I want that same URL to be replaced with hyperlinked anchor text 

When I try to test the action, this the error I’m getting

 

Hi @Bec-SSE!

I actually found a way to do this (which I wasn’t aware that Google Sheets could do), but with the example website you gave it doesn’t quite work as you’d want it to. It’s based on the metadata for the website, I imagine.

You can use this formula: =IMPORTXML("http://www.google.com","//title")

This is what happens:

Notice all of the social network names that show up under the cell where I entered the formula. 

In your Zap, you would type out the formula and then map the website URL, as I’ve done here:

Then when the Zap runs…

… you can see that even zapier.com ends up pulling in that extra “Microsoft Logo” text. So it may not be a perfect solution. That’s the only way I know of to pull in the title automatically based on having the website address.

Hi @Bec-SSE 

In the Zap step, you’ll need to dynamically replace url with a dynamic data point that is enclosed in double quotes “” and same for the olink_label].

Article: https://support.google.com/docs/answer/3093313?hl=en

 

@Troy Tessalone I think the issue with that was that you’d need to know ahead of time what to insert as the label, as opposed to pulling it from the website’s meta data. Otherwise, definitely one way to go.

But if someone wants to provide a URL and then retrieve the title of the site, I don’t think HYPERLINK will work (I’m happy to be proven wrong, since I’m not super familiar with that function).

Terms & Conditions