You need tableID. You can get it from table url. It is selected here:
Bot.sendMessage("Saving...");
var syncOptions = {
tableID: "1_NldI2**********ank1B9c",
sheetName: "Users",
// this column will be used as index for updates or reading
index: "id",
// store data
datas: [],
// this command will be runned after sync
onRun: "/onSync",
// for debug. Comment this lines
// email: "hello@bots.business",
// debug: true
}
user.balance = User.getProperty("balance");
syncOptions.datas[0] = user;
// you can add more records with index
// syncOptions.datas[1] and etc
Libs.GoogleTableSync.sync(syncOptions);
You can store any data like users, chats, products, resources and etc
Bot.sendMessage("Saving...");
var syncOptions = {
tableID: "1_NldI2**********ank1B9c",
sheetName: "Orders",
// this column will be used as index for updates or reading
index: "orderId",
datas: [],
// this command will be runned after sync
onRun: "/onSync"
}
var order = {
orderId: 10,
title: "Order - " + String(user.id),
amount: 15
}
syncOptions.datas.push(order);
Libs.GoogleTableSync.sync(syncOptions);
Read data
Bot.sendMessage("Reading...");
var syncOptions = {
tableID: "1_NldI2**********ank1B9c",
sheetName: "Users",
// this column will be used as index for updates or reading
index: "id",
// reading data
datas: [],
// this command will be runned after sync
onRun: "/onSync",
// for debug. Comment this lines
// email: "hello@bots.business",
// debug: true
}
syncOptions.datas[0] = user;
// also you can use something like:
// syncOptions.datas[0] = { id: any_user_id }
// you can add more records with index
// syncOptions.datas[1] and etc
Libs.GoogleTableSync.read(syncOptions)
Command /onSync
Bot.inspect(options)
1. Please see setup for . This lib requires GoogleApp lib.
If you have any problems with this lib - use help from .