GoogleSpreadSheet

Search…

GoogleSpreadSheet

You can post and read data from GoogleSpreadSheet with this lib.
Demo bot
BB Google Spreadsheet Demo
Telegram
​
Getting started
1.Make new spreadsheet. 
You definitely need a table header. Make it.
2. From your Google Sheet, from the Tools menu select Script Editor
3. Paste the script from above into the script code editor and hit Save.
4.  From the Publish menu, select Deploy as web app…

5. Choose to execute the app as yourself, and allow Anyone, even anonymous to execute the script. (Note, depending on your Google Apps instance, this option may not be available. You will need to contact your Google Apps administrator, or else use a Gmail account.) Now click Deploy. You may be asked to review permissions now. Project version - always "New".
6. The URL that you get will be the webhook that you need use in this Lib. You can test this webhook in your browser first by pasting it. Note that depending on your Google Apps instance, you may need to adjust the URL to make it work. 
/setup
1
// replace with your URL, obtained in step 6
2
Libs.GoogleSpreadSheet.setUrl("https://script.google.com/macros/*******");
Copied!
​
Using
Add new row to spreadsheet.
command /add
1
let newRow = {
2
  'Country': 'Italy',
3
  'Age': '25',
4
  'Do you like Bots.Business?': 'YES'
5
}
6
​
7
let prms = {
8
  sheetName: "Users",  // sheet name
9
  row: newRow,
10
  onSuccess: "onSuccess",  // this command will be executed on Success
11
  onError: "onError"       // this command will be executed on Error
12
}
13
​
14
Libs.GoogleSpreadSheet.addRow(prms)
Copied!
onSucess command
1
// You can inspect options:
2
// Bot.sendMessage(inspect(options));
3
​
4
let rowIndex = options.rowIndex;
5
User.setProperty("rowIndex", rowIndex, "integer"); // You can set row index to options
6
​
7
Bot.sendMessage("Posted at row: " + rowIndex + 
8
    "\nInserted values: " + options.inserted);
Copied!
onError command
1
Bot.sendMessage(inspect(options));
Copied!
Edit row.
1
let newRow = {
2
  'Country': 'France',
3
  'Age': '18',
4
  'Do you like Bots.Business?': 'YES'
5
}
6
​
7
let prms = {
8
  sheetName: "Users",  // sheet name
9
  row: newRow,
10
  onSuccess: "onSuccess",  // this command will be executed on Success
11
  onError: "onError"       // this command will be executed on Error
12
}
13
​
14
​
15
prms.rowIndex = 3;  // row index for editing
16
Libs.GoogleSpreadSheet.editRow(prms);
17
​
Copied!
Get data from spreadsheet
Row can be changed on Spreadsheed.
1
var rowIndex = 3; // row index for reading
2
​
3
Libs.GoogleSpreadSheet.getRow({
4
  sheetName: "Users",
5
  rowIndex: rowIndex,
6
  onSuccess: "onSuccessRead",
7
  onError: "onError"
8
})
Copied!
onSuccessRead command
1
Bot.sendMessage(inspect(options.row));
Copied!