Copy specific data from one google sheet to another

[dreamymirage]

Hi

I have one workflow that fetches data from razorpay to google sheet and I have another workflow which fetches data from facebook lead form to google sheet.

I want to copy specific columns from one google sheet to another.

what should I use - append rows, or lookup+append value or what?

Regards
Sumit

 

[Preeti Paryani]

Hello @dreamymirage

Can you please elaborate a bit more on your use case so we can assist you accordingly? Please mention on what basis you want to add the data from one Google Sheet to another.

 

[dreamymirage]

This is the first google sheet from where I wish to fetch data

and enter into this sheet

 

[Preeti Paryani]

Hello @dreamymirage

It seems you want to add details in your sheet 2's empty columns(refer to the attached screenshot) as it gets added to sheet 1. Please confirm the same and also let us know the common details between both sheets, on the basis of which we can look for the row in which data has to be added.