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!
+14
Hi
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
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.
+14
Can you please provide screenshots of how your Zap step is currently configured? Thanks.
Hey 
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
+11
Hi
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.
+14
Hi
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 [link_label].
Article: https://support.google.com/docs/answer/3093313?hl=en
+11
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).
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
