For every response from google sheet i want to add the response to the last row of an excel sheet

Help Studio
,
4

@Sai_Prakash1 ,

Do you have to Compare all the column data from Sheet1 with all the column data of Sheet2 ?

If so, you could give a Try on the below Steps :

  1. Read the Excel Sheets 1 & 2 using Read Range Activity, and get the Output as datatables ,DT1 & DT2.

  2. Next, Merge both the Datatables (Considering the Column Name is also same) using Merge Datatables Activity where destination is set to DT1.

  3. Use Remove Duplicate Rows Activity on DT1.

  4. Now, DT1 should be the resultant data or the Updated data for Sheet2 that you would require.

Let us know if this method works for your case, If it doesn’t let us know the reason as to why it cannot work.