Troubleshooting Spreadsheet Duplicate Deletion Issues | Lindy Community

Troubleshooting Spreadsheet Duplicate Deletion Issues

Marvin A. I'm going to defenestrate my Lindy. I have a spreadsheet with duplicates. I just want it to find the duplicates, and then delete them. it's brilliant at loading the spreadsheet, and making a list of duplicates. But it absolutely refuses to do the delete task. It will say it did the delete task, but no actual rows get deleted. Like, it is passing this - "Comma-Separated List of Rows to Delete 42,65,6,9,12,24,14,54,55,23,81,29,30,36,39,73,74,70,52,47,58,59,60,61,62,68,57 If you need the list in a different format or with more details, let me know!" but the next bot just can't figure it out? I've spent about 3k tokens on this now, so going to stop until you give me some advice 😆

✅1

21 comments

Zac C.
·
·
this is a lie - No rows were deleted 😞
Zac C.
·
·
Marvin A.?
Marvin A.
·
·
hey zac! can you share the task URL? happy to look into whats happening here
👀1
Zac C.
·
·
https://chat.lindy.ai/duplicate-remover-681e83fe26256ddcef6671ea/tasks?task=68290c16c8c90143f26454de
Marvin A.
·
·
yeah gemini flash is definitely not smart enough to do this. But this task seems to have worked, right? https://chat.lindy.ai/duplicate-remover-681e83fe26256ddcef6671ea/tasks?task=68290640ac5c0e7b9194ed3d
Zac C.
·
·
no, it said it did, but on the actual spreadsehet it didn't
Zac C.
·
·
O3 and claude 3.7 fialed also, I threw in Gemini as a "fuck it, we ball" out of frustration 😉
Zac C.
·
·
I'll try again with O3 and see what happens
Zac C.
·
·
the first step, identifying the duplicate rows, it does just fine, in basically every model
Zac C.
·
·
is the second step, doing the actual delete, that constantly fails
Zac C.
·
·
Marvin A. I'm an idiot...it is deleting the rows, its just not removing the blank rows
Zac C.
·
·
I was looking at the total rows number
Zac C.
·
·
and expecting it to shrink
Zac C.
·
·
the total rows number is staying the same, but I didn't scroll up the sheet to see that it was deleting all the content in the selected rows
Zac C.
·
·
its deleting the content of the rows, not the rows themselves
Marvin A.
·
·
ahhh awesome! yeah looks like its doing the job well now with o3!
Zac C.
·
·
yep, thanks 😃 While I have you, I'm doing a demo of lindy to about 40 business owners next week, I wantto use the AI phone agent, I'm on the business plan, if I tell 40 of them to call it at once, can it handle that? or will it explode?
Marvin A.
·
·
it will handle it 😄 (if you are on business!)
Marvin A.
·
·
pro plans have a limit of 30 non-concurrent
Marvin A.
·
·
make sure to test everything before demoing 😄
👀1
Zac C.
·
·
cool, I tagged you farther down where I'm having trouble with it behaving inconsistently.