Csv to google sheets snd then only unique lines

[tomitela]

Your Workflow URL

https://connect.pabbly.com/v2/app/workflow/mapping/IjU3NjYwNTY0MDYzMDA0Mzc1MjZhNTUzYzUxMzYi_pc

Your Task History ID

https://connect.pabbly.com/task/history?filter_status=applied&filter_by_workflow_id=IjU3NjYwNTY0MDYzMDA0Mzc1MjZhNTUzYzUxMzYi_pc

Consent to Access & Modify

I authorize Pabbly Support to log in to my account and make changes to the specified workflow for troubleshooting.

Hi, i trying to use browseract through api. Now getting csv through pabbly api but can't easy to import to google sheets and if possible at the same time add only unique data. In csv i receiving.
Price,name,link
12,one,url12
15,one,url15
Next time i will receive
Price,name,link
12,one,url12
15,one,url15
11,one,url11

(original:
Price,Property_Name,Listing_URL
{##double_quotes##}€250,000{##double_quotes##},1 Bed Apartment,https://www.link.com/AAEP1846
{##double_quotes##}...............................
)
So my goal is first to add in google sheets all info by column names price, name, link.
And second goal add only unique lines as first time i received 2 unique lines and second time i received only 1 unique line.
I have issue with formatting of csv as with text formatter i do not getting normal splitting with one step. Or if i getting them in some places getting error as prices sometime gave coma inside as example 250,000$
ADED---
And as API is creating work while it is done how to add waiting time till gett work done, around 5 minutes needed to get status finished

 

[Hrishabh.pabbly]

Hi @tomitela ,

Thank you for reaching out.

To better understand your use case and see how the data is being received in the response, could you please share a few more details about your setup? Additionally, it would be helpful if you could provide the Workflow URL where you’re implementing this so that we can thoroughly review it and guide you further.

Please note that, to assist you effectively, we may need to access your Pabbly Connect account. If you’re comfortable with this, kindly confirm by replying:

“You have my permission to log into my Pabbly Connect account and edit the workflow if required. Here is the registered email address associated with it.”

Looking forward to your response.

 

[tomitela]

Hi @tomitela ,

Thank you for reaching out.

To better understand your use case and see how the data is being received in the response, could you please share a few more details about your setup? Additionally, it would be helpful if you could provide the Workflow URL where you’re implementing this so that we can thoroughly review it and guide you further.

Please note that, to assist you effectively, we may need to access your Pabbly Connect account. If you’re comfortable with this, kindly confirm by replying:



Looking forward to your response.

Hello @Hrishabh.pabbly @Hrishabh.pabbly
yes added, and updated a little question

 

[tomitela]

While waiting answer testing option with deepseek, but now facing issue as not find info how answer deepseek must to provide to requests, that it can be added to google sheets with automation. But this is secondary issue, maybe with your answer it is possible to solve this just with automation steps without ai
Price,name,link
1,1,1
2,2,2
3,3,3
4,4,4
5,5,5