CODEWITHSUNDEEP
htmlgoogle-apps-scriptgoogle-sheets
Weishan Ooi
Weishan Ooi

Reputation: 35

How do i change the value in a cell using google script?

im actually a beginner in google scripts, and I would like to seek some help regarding how do I change the password for an account in webapp and it would link to google sheet. So currently I'm doing a payment webapp and I'm using google sheet as my database, there's a list of username and password at google sheet. Would it that be possible for me to change the password in the webapp and it would overwrite the old ones inside google sheet?

The link to the source code: https://script.google.com/d/1mR9Cy1ylLA4CdhbD69m8uZPFN9HzPJupl3R197GR9A-7cZNnnsCH18Is/edit?usp=sharing

The link to the google sheet: https://docs.google.com/spreadsheets/d/1bM8l6JefFsPrlJnTWf56wOhnuSjdIwg3hMbY1tN1Zp8/edit?usp=sharing

Upvotes: 0

Views: 2746

Answers (1)

Cooper
Cooper

Reputation: 64032

SpreadsheetApp.getActive().getSheetByName('your sheet name').getRange('A1').setValue();

Upvotes: 1

Related Questions