The existing script does not write data into an already created row with a date and with each new report in Telegram, it creates a new row with a date that has already been created by the first report. Reports are sent to the Telegram group by different employees. A screenshot of the table is attached.

The principle of the script: when a message arrives in the group regarding reports, the data from it is transferred to the Google spreadsheet; at the same time, the script determines from the message which tab to send the data to and in which column. If there is data in the cell in the required column and in the row with the already created date, then new data should not be inserted there.

It needs to be fixed so that a new row is not created if a row with the date has already been created. And data should be added to the row with the already created date if the cells are empty.

The script itself:

const TOKEN = "xxxxxxxxxx";

const SPREADSHEET_ID = "xxxxxxxxxx";

/**

* Search for a row with a date or create a new one

function findOrCreateRow(sheet, dateStr) {

const [targetDay, targetMonth] = dateStr.split(".").map(Number);

// Get ALL values from column A

const lastRow = sheet.getLastRow();

if (lastRow > 0) {

const displayValues = sheet.getRange(1, 1, lastRow, 1).getDisplayValues();

for (let i = 0; i < displayValues.length; i++) {

const cellText = displayValues[i][0];

if (!cellText) continue;

const parts = cellText.split(".");

if (parts.length < 2) continue;

const day = parseInt(parts[0]);

const month = parseInt(parts[1]);

if (day === targetDay && month === targetMonth) {

Logger.log("Row found: " + (i + 1));

return i + 1;

}

// If the date is not found — create a new one

const currentYear = new Date().getFullYear();

const newDate = new Date(currentYear, targetMonth - 1, targetDay);

const newRow = sheet.getLastRow() + 1; // GET CURRENT lastRow

sheet.getRange(newRow, 1)

.setValue(newDate)

.setNumberFormat("dd.MM.yyyy");

SpreadsheetApp.flush();

Logger.log("New row created: " + newRow);

return newRow;

}

Proposals 8

Yevgeny Gordadym

600 0

Budget: 1000 UAH Deadline: 1 day

Good day, I have written many scripts for Google Spreadsheet, I work with Apps Script. I will fix the functionality. Feel free to contact me!

Vasyl Melko

18 0

Budget: 1000 UAH Deadline: 1 day

Good day, I am ready to take on the task. I will do it quickly and efficiently. I will be happy to collaborate.

Oleksandr Stinkovyi

117 0

Budget: 1000 UAH Deadline: 1 day

Hello.

I have experience with Apps Script. I am ready to take it on. Write to me, we will discuss.

Yurii Zhulinsky

8 0

Budget: 1000 UAH Deadline: 1 day

Hello, I am ready to take on your project immediately and complete it quickly and efficiently, feel free to contact me, I have experience with apps script.

Ihor Symchuk

Winning proposal

11 0

Budget: 1000 UAH Deadline: 2 days

I understand the task. Currently, the script for Apps Script creates a new row for each report submission, even if the date already exists — this leads to duplication. The logic needs to be corrected so that when the date matches, the existing row is used, and data is only written to empty columns without overwriting.

I will fix the `findOrCreateRow` function so that it correctly searches for a row by date, considering the format `dd.MM`, and does not create duplicates. I will also ensure that new data is added to the same rows if they are not yet filled in the required columns. It is important that the current year is taken into account, but the date is only specified as day and month — which means avoiding errors during comparison.

I have experience working with Google Apps Script, automating processes through Telegram bots, integrating messages into Google Sheets, and processing data without duplication. I have already implemented similar scenarios for teams where multiple users submit reports, and the system aggregates them into a single row.

The corrected script will work reliably, taking into account all conditions: searching for an existing date, preventing the creation of new rows, and correctly adding data to the appropriate columns without overwriting.

Andrey Vernidub
Zaporizhzhia, Ukraine

Projects 31
Rating 5.0
Rating 2 119

Correct the script for Apps Script

Client's review of cooperation with Ihor Symchuk

Correct the script for Apps Script

5.0

Andrey Vernidub

Freelancer's review of cooperation with Andrey Vernidub

Correct the script for Apps Script

5.0

Ihor Symchuk

Yevgeny Gordadym

Vasyl Melko

Oleksandr Stinkovyi

Yurii Zhulinsky

Ihor Symchuk

Proposals concealed

Proposals are currently absent

Current freelance projects in the category Javascript and Typescript

Creation of a website for ticket sales

Fix the calculation of Realized PnL, ROI, and Win Rate for cryptocurrency wallets.

Website on the Next.js framework (based on React)

Need a frontend developer / layout designer for a one-time improvement of a website on Magento 2.

Optimization of Core Web Vitals (OpenCart) for Google PageSpeed — Mobile and PC versions