npm install sheetdb-node --save
You need to create a new sheetdb function, and populate it with your SheetDB API URL. You can find this URL on SheetDB Dashboard.
var sheetdb = require('sheetdb-node');
// create a config file
var config = {
address: '58f61be4dda40',
};
// Create new client
var client = sheetdb(config);for ES6
import sheetdb from 'sheetdb-node';
// create a config file
var config = {
address: '58f61be4dda40',
};
// Create new client
var client = sheetdb(config);If you have HTTP Basic Authentication turned on for your API, you should pass auth_login and auth_password here, like:
// create a config file
var config = {
address: '58f61be4dda40',
auth_login: 'BASIC_AUTH_login',
auth_password: 'BASIC_AUTH_password',
};
// Create new client
var client = sheetdb(config);SheetDB gives you the ability to use full CRUD on your Google Spreadsheet. Remember to populate the first row of every sheet with column names. You can look at example spreadsheet.
To add data to Google Spreadsheets, send an object or an array of objects.
// Adds single row
client.create({ name: "William", age: 25 }).then(function(data) {
console.log(data);
}, function(err){
console.log(err);
});
/// Adds bunch of rows
rows = [
{ name: "William", age: 25 },
{ name: "Jayden", age: 25 }
]
client.create(rows).then(function(data) {
console.log(data);
}, function(err){
console.log(err);
});By default, all writes are performed on the first sheet (worksheet). Pass name of a sheet as a 2nd param to add data to other worksheet.
// Adds single row to worksheet named "Sheet3"
client.create({ player: "William", score: 75 }, "Sheet2").then(function(data) {
console.log(data);
}, function(err){
console.log(err);
});On success returns a number of created rows.
Read the whole sheet
client.read({ limit, offset, search, sheet }).then(function(data) {
console.log(data);
}, function(err){
console.log(err);
});You can pass attributes with options
limit- limit number of resultsoffset- start from N first recordsearch- object with search params (more below)sheet- get data from named worksheet
// Get first two rows from worksheet named "Sheet2"
client.read({ limit: 2, sheet: "Sheet2" }).then(function(data) {
console.log(data);
}, function(err){
console.log(err);
});
// Get 3rd and 4th record from worksheet named "Sheet2"
client.read({ limit: 2, offset: 2, sheet: 'Sheet2' }).then(function(data) {
console.log(data);
}, function(err){
console.log(err);
});To get rows that match search criteria, pass an object with search params
// Get all rows where column 'id' is 'foo' and column 'value' is 'bar'
client.read({ search: { id: "foo", value: "bar" } }).then(function(data) {
console.log(data);
}, function(err){
console.log(err);
});
// Get all rows where column 'First name' is 'Smith' and column 'Score' is '42'
client.read({ search: { 'first name': 'Smith', 'Score': 42 } }).then(function(data) {
console.log(data);
}, function(err){
console.log(err);
});
// Get first two rows where column 'player' is 'Smith',
// column 'score' is '41' from sheet named "Sheet2"
client.read({
limit: 2,
search: { 'player': 'Smith', 'score': 41 },
sheet: 'Sheet2'
}).then(function(data) {
console.log(data);
}, function(err){
console.log(err);
});On success returns an array of objects.
To update row(s), pass column name and its value which is used to find row(s).
client.update(columnName, value, newRow, sheet).then(function(data) {
console.log(data);
}, function(err){
console.log(err);
});// Update all columns where 'name' is 'Smith' to have 'score' = 99 and 'comment' = 'Griffin'
client.update(
'name', // column name
'Smith', // value to search for
{ 'score': 99, 'comment': 'Griffin' } // object with updates
).then(function(data) {
console.log(data);
}, function(err){
console.log(err);
});To perform #update on different than the first sheet, pass sheet name as a 4th argument.
// Update all columns where 'name' is 'Smith' to have 'score' = 99 and 'comment' = 'Griffin'
// In sheet named 'Sheet2'
client.update(
'name', // column name
'Smith', // value to search for
{ 'score': 99, 'comment': 'Griffin' }, // object with updates
'Sheet2'
).then(function(data) {
console.log(data);
}, function(err){
console.log(err);
});On success returns a number of updated rows.
To delete row(s), pass column name and its value which is used to find row(s).
// Delete all rows where 'name' equals 'Smith'
client.delete(
'id', // column name
'1' // value to search for
).then(function(data) {
console.log(data);
}, function(err){
console.log(err);
});You can pass sheet name as a 3rd argument. All operations are performed on the first sheet, by default.
// Delete all rows where 'foo' equals 'bar' in sheet 'Sheet3'
client.delete(
player, // column name
'Smith', // value to search for
'Sheet2'
).then(function(data) {
console.log(data);
}, function(err){
console.log(err);
});Run all tests:
npm test
Run a nyan version test:
npm run nyan-test
Bug reports and pull requests are welcome on GitHub at https://github.com/sheetdb/sheetdb-node. This project is intended to be a safe, welcoming space for collaboration, and contributors are expected to adhere to the Contributor Covenant code of conduct.
-
Add tests! Your patch won't be accepted if it doesn't have tests.
-
Create topic branches. Please, always create a branch with meaningful name. Don't ask us to pull from your master branch.
-
One pull request per feature. If you want to do more than one thing, please send multiple pull requests.
-
Send coherent history. Make sure each individual commit in your pull request is meaningful. If you had to make multiple intermediate commits while developing, please squash them before sending them to us.
SheetDB documentation sits on GitHub. We would love your contributions! We want to make these docs accessible and easy to understand for everyone. Please send us Pull Requests or open issues on GitHub.