Google Spreadsheet loader wrapper.
npm install sheet-loader
const SheetLoader = require('sheet-loader');
const sheetLoader = new SheetLoader({
sheetKey: 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX',
keyFilePath: './xxxxxxxx-xxxxxxx.json'
});
sheetLoader.loadRecords({
sheetTitle: 'sample sheet',
columns: {
name: '名前',
message: '文章',
year: '年',
month: '月',
date: '日'
}
}).then((records) => {
records.forEach(function (row, index) {
console.log('========================');
console.log('name:\t' + row.name);
console.log('birth day:\t' + [row.year, row.month, row.date].join('.');
});
});
sheetLoader.loadRows('sample sheet').then((rows) => {
console.log(rows);
});
sheetLoader.exportRecords('./sample.json', {
sheetTitle: 'sample sheet',
columns: {
name: '名前',
message: '文章',
year: '年',
month: '月',
date: '日'
}
}).then(() => {
console.log('done.');
});
const sheetLoader = new SheetLoader({
sheetKey: 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX',
credentials: {
client_email: 'xxxxxxxxxxxxxxx@developer.gserviceaccount.com',
private_key: 'XXXXXXXXXXXXXXX'
},
});