Fix 20-line Google script for Google Sheets

The 20-line Google script below is to remove all rows in Sheet1 one that in any column substring-match any value inside column A on Sheet2. It's not working correctly. When you run the script once, the row with the value "ccc" in Sheet1 is still there even though it "c" is one of the values inside column A in Sheet2. I'm looking for a fix to the script. I have $50 for this if you can turn this around in one hour.

Below is a link to a public sheet you can copy.




function onOpen() {

const ui = [login to view URL]();

[login to view URL]('Functions')

.addItem('Unsubscribe', 'est_unsubscribe')



function est_unsubscribe() {

var ss = [login to view URL]();

var unsubscribe=[login to view URL]("Sheet2");

var sheet = [login to view URL]();

var dataRange = [login to view URL]();

var values = [login to view URL]();

var lastrow=[login to view URL]();

var findvalue="";

for(var k=1;k<=lastrow;k++){

findvalue=[login to view URL](k,1).getValue().toString();

[login to view URL](findvalue);

for (var i = 0; i < [login to view URL]; i++) {

var row = "";

for (var j = 0; j < values[i].length; j++) {

if (values[i][j].toString().includes(findvalue)) {

row = values[i][j+1];

var increment=i;

[login to view URL](++increment) // This is your row number






Beceriler: Google Sheets, Google Apps Scripts

İşveren Hakkında:
( 110 değerlendirme ) Miami Beach, United States

Proje NO: #32695633


(7 Değerlendirme)

Bu iş için 5 freelancer ortalamada $44 teklif veriyor

(23 Değerlendirme)
(15 Değerlendirme)
(6 Değerlendirme)

Hey, I can Fix your 20-line Google script for Google Sheets In how much time you want it to be completed?? Let's talk about your project Waiting for your response!!

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)