I will create a google sheets script for parsing and updating data

A
ashokekumar
A
ashokekumar
Rajputak

Level 1

About this gig

I will write a custom Google Apps Script for your specific need. Once you give me that,

What kind of data are you working with? (e.g. names, emails, sales numbers, dates, etc.)

What do you mean by "parse or update"?

  • Parse: Are you extracting specific information from cells?
  • Update: Are you editing existing values, filling in missing ones, or calculating new data?

Where is the data located? (Which sheet, columns, or rows?)

What is the desired output/result? (Do you want new columns, modified data, conditional updates, etc.?)

Example Template Script

Just to get you started, here's a basic Google Apps Script that goes through rows in a sheet and updates a column based on a condition:


function updateSheetData() {

const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");

const dataRange = sheet.getDataRange();

const values = dataRange.getValues();

for (let i = 1; i < values.length; i++) {

if (values[i][1] === "Approved" && !values[i][0].includes(" - Verified")) {

values[i][0] = values[i][0] + " - Verified";

}

}

Let me know your case I will help you

Get to know Rajputak

Rajputak

Software development is an art

5.0(17)

Level 1

  • FromPakistan
  • Member sinceFeb 2018
  • Last delivery1 year
  • Languages

    English, Spanish, German, French
I’m an IT graduate and passionate software developer with over a decade of hands-on experience building high-quality web applications. Since 2011, I’ve been developing professional, reliable, and scalable solutions for clients worldwide. Core Expertise C#, Java, Spring Boot, C++ ASP.NET MVC, Entity Framework Database design & development Full-cycle development, software architecture, application development, bug fixing, clean code, optimized code, maintainable code, professional, detail-oriented,on-time delivery, high-performance applications.