Google Sheets Reader - add search function

The new(ish) Google Sheets Reader requires the workbook to be selected from the list, in my case the list has hundreds of entries, sorted apparently in reverse chronological order, and no ability to search within that list.
It would be nice to be able to search for words or phrases within workbook names.

My current workaround is to find the workbook on Google Drive in-browser, open it and wait for it to appear at the top of the list in the node. Not very elegant.

Hi Dimitri,
thanks for your feedback! I will check this out and forward recommendations to our development team.

hi do we have this search function yet?

Hello @gogon,

no search function yet. Ticket created and requests noted. (Internal Reference: AP-16357)

Possible workaround is to browse to the spreadsheet in browser, and supply the spreadsheet id as flow variable while hiding the actual reader away in a component.

Br,
Ivan

1 Like

I have a Google Sheet I’m accessing with Google Sheet Reader. The sheet had cells with text with hyperlinks… Is there a way to also extract the hyperlinks in addition to the text? Need both and want to then use the hyperlink info to extract data from the page to put back into the spreadsheet.

If this isn’t possible then I’d like to ask for it as a feature request. Any thoughts on work around if this isn’t possible with this node?

Hello @DemandEngineer,

have added your request to existing ticket regarding enchaining reading possibilities from Google Sheets (Internal Reference: AP-9458) as don’t think it’s currently possible. And to ask you how do you expect hyperlink column(s) to be extracted (presented) in output?

As for workarounds Python probably can do it…

Br,
Ivan

I’m open to ideas on how to show the output. The feature should have a flag to extract text only or text and hyperlinks… I have mixed feels on output… I think the cleanest approach is a new Column with the name starting with the original column name and appended with " - hyperlinks"… since the usage is like going to need a separate column as in input to another operation (i.e. GET request).

An alternative is to put the hyperlink URL in with the text and format it like markdown notation but I worry that will have issues where it is hard to tell what parts of the value are originally in the data and what parts were added to show the markdown which ends up complicating extraction which IMO is the likely next action for the urls.

If you are looking at expanding the capabilities, here is some other data that can be in the cells that seem interesting.

  • Formatting: i.e. color - this can be used in the Color Manager
  • Formulas - might use this to check logic
  • URL of embedded image - use this in other nodes… perhaps download to a folder to teach model
1 Like

Hello @DemandEngineer,

tnx for ideas. New column seems like a way to go but let’s see.

Someone will update topic once if/there is news.

Br,
Ivan