Skip to content

Instantly share code, notes, and snippets.

@namieluss
Created March 8, 2020 04:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save namieluss/6684fb92462b100206e5e5f253e4706d to your computer and use it in GitHub Desktop.
Save namieluss/6684fb92462b100206e5e5f253e4706d to your computer and use it in GitHub Desktop.
Firebase Cloud Functions with Google Spreadsheet
const { authorize } = require("./authorize");
const { google } = require("googleapis");
exports.handler = (req, res) => {
res.set("Access-Control-Allow-Origin", "*");
res.set("Access-Control-Allow-Methods", "GET, POST");
const spreadsheetId = String(req.query.ssid);
const sheetId = String(req.query.sheetId);
if (spreadsheetId && sheetId) {
const removeWorkSheet = auth => {
const request = {
spreadsheetId,
resource: { requests: [{ deleteSheet: { sheetId } }] }
};
const sheet = google.sheets({ version: "v4", auth });
sheet.spreadsheets.batchUpdate(request, (err, response) => {
if (err)
res.status(501).json({
msg: "remove worksheet failed",
err: err
});
else
res.status(200).json({
msg: "remove worksheet successful",
res: response
});
});
};
authorize(removeWorkSheet);
} else {
res.status(404).json({
msg: "spreadsheet id and work sheet id required"
});
}
};
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment