Read hyperlink from google sheet

Questions
1

I’m reading a column from a Google Sheet that contains hyperlinks, but n8n is returning the displayed text instead of the actual hyperlink. How can I extract the URL from the hyperlink along with the displayed text?

2

Hi @Karpoora_SundaraPand Welcome to n8n :n8n: community :tada:

This feature isn’t currently supported natively in the Google Sheets node, as it relies on the includeGridData parameter in the API call.

So, there are two possible approaches to solve this:

  • On the Google Sheets side: Add another column that explicitly stores the hyperlink for each cell.
  • Use a direct API call: Make a direct request to the Google Sheets API with includeGridData=true, and then parse the response to extract the hyperlink.

I’ve created an example that directly calls the Google Sheets API for a specific cell to retrieve the hyperlink — feel free to customize it to fit your use case!



If this answers your question, please mark the reply as the solution ✅🙏🏻