googleapis / googleapis/google-api-nodejs-client

How to access or open Spreadsheet which I have created using google sheets API ?

Open
#2,710 1 comment 0 reactions 0 assignees View on GitHub
type: question
Dominant language
TypeScript
Stars
12.2k
Forks
2k
Avg merge
1d 9h
Merged PRs (30d)
24

Description

I am using googleapis to create a google sheet. my working code
```
const { google } = require("googleapis");
const keys = require("./credentials.json");

var spreadsheetId = null;
var gsapi = null;
const title = "SheetExample1!";

createConnection = () => {
return new Promise((resolve, reject) => {
const client = new google.auth.JWT(
keys.client_email,
null,
keys.private_key,
["https://www.googleapis.com/auth/spreadsheets"]
);

client.authorize((err, res) => {
if (err) {
reject(err);
} else {
gsapi = google.sheets({
version: "v4",
auth: client,
});
console.log("Connection Created Successfully");
resolve(res);
}
});
});
};

createSheet = () => {
return new Promise((resolve, reject) => {
const resource = {
properties: {
title,
},
};
gsapi.spreadsheets.create(
{
resource,
fields: "spreadsheetId",
},
(err, response) => {
if (err) {
reject(err);
} else {
console.log(
"Sheet Created with spreadsheetId============",
response.data.spreadsheetId
);
resolve(response.data);
}
}
);
});
};

functionHelper = async () => {
await createConnection();
await createSheet();
};

functionHelper();

```

In response, I am getting spreadsheetId. But I have no idea where all these sheets are stored and how I can open a spreadsheet using the generated spreadsheet Id.

I checked I can't see these files inside https://docs.google.com/spreadsheets/u/0/

Any suggestion?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.