googleapis / googleapis/google-api-nodejs-client
How to access or open Spreadsheet which I have created using google sheets API ?
- 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
Assessment
This issue has not been assessed yet.