How to set text one by one from excel sheet to google search engine

i have some names in excel sheet and want to search in google one by one automatically


check this example
test.xaml (10.6 KB)


where should i add excel file to give input to google

Hi @raju_alakuntla

kindly refer the video

also high level approach

read the excel using read range and later use for each row to iterate each row and do your needful activities


using a read range activity


thank you


very useful video.
thanks a lot


Kindly close the topic and mark as solution so it will be benefitted to others


can you please help me to skip repeated names in web search?

Hi @raju_alakuntla

  1. Use Read Range activity to read data from excel file and will give you output as DataTable and say ‘DT’
  2. Then try this expression toremove duplicates:
             newDT = DT.DefaultView.ToTable(True,"ColumnName").CopyToDataTable
  1. And then use Write Range activity to write into exel file and pass that newDT as input to it.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.