🚀 Big News: Socket Acquires Coana to Bring Reachability Analysis to Every Appsec Team.Learn more

gsheet-object

Advanced tools

Socket logo

Install Socket

Detect and block malicious and high-risk dependencies

Install
g

gsheet-object

## Install

0.1.6
latest
72

Supply Chain Security

100

Vulnerability

83

Quality

76

Maintenance

100

License

Version published
Maintainers
1
Created
Issues
0

gsheet-object

Install

yarn add gsheet-object googleapis

Usage

You first need to set an environment variable to your sheet ID: SPREADSHEET_ID=YOUR SHEET ID

Let's use a sheet called Cities, with the following data:

CityCountry Name
ParisFrance
LondonUK
interface ICity {
  city: string;
  countryName: string;
}

async function demo() {
  const sheet = await GoogleSheet.load<ICity>("Cities");
  const cities = await sheet.getData();

  const paris = cities[0]; // { city: 'Paris', countryName: 'France', _row: 1 }

  const indexed = await sheet.getIndexed(x => x.city);
  console.log(indexed["Paris"]); // { city: 'Paris', countryName: 'France', _row: 1 }

  const pairs = await sheet.getPairs(
    x => x.city,
    x => x.countryName
  );
  console.log(pairs["Paris"]); // France

  await sheet.append({
    city: "Toulouse",
    countryName: "France",
  });

  // Update line
  await sheet.update(paris, "countryName", "USA");
  // or
  await sheet.update(0, "countryName", "USA");

  await sheet.delete(paris);
}

FAQs

Package last updated on 26 Mar 2024

Did you know?

Socket

Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.

Install

Related posts