https://sheets.googleapis.com/v4/spreadsheets/<ID_ТАБЛИЦЫ>/values/<ИМЯ_ЛИСТА>
curl \
'https://sheets.googleapis.com/v4/spreadsheets/193Dbro4_sHjRMy_tqbIkGK8AaUjfsBwHVS5MwNqqvmM/values/%D0%9E%20%D0%A2%D0%B0%D0%B1%D0%BB%D0%B8%D1%86%D0%B5' \
--header 'Authorization: Bearer [YOUR_ACCESS_TOKEN]' \
--header 'Accept: application/json' \
--compressed
{
"values": [[]]
}
const nameTo = ss.getSheetByName(name) ? `${name}_${new Date().getTime()}` : name;
sheetTemp.setName(nameTo);
if(ss.getSheetByName(name)) {
ss.deleteSheet(name);
}
if(!ss.getSheetByName(name)) {
sheetTemp.setName(name);
}
=IF(F5<>1;;"Завершено")
=TRANSPOSE(WRAPCOLS(A3:A11;B1;""))
=WRAPROWS(A3:A11;B1;"")