I am looking for assistance on extracting data from a post request and transferring it to Google Sheets while also confirming with the client. Any guidance or support would be highly appreciated. Thank you.
My project involves creating a web application for a check-in/check-out system where scanning a barcode automatically populates information into a Google spreadsheet.
const express = require('express');
const app = express();
const fs = require('fs');
const GoogleSpreadsheet = require('google-spreadsheet');
const creds = require('./client_secret.json');
app.use(express.static('public'));
app.get('/', function (req, res) {
const contents = fs.readFileSync('views/welcome.html').toString();
res.send(contents);
});
app.get('/info', function (req, res) {
res.send('Hello Info!');
});
app.get '/checkin', function (req, res) {
const contents = fs.readFileSync('views/no.html').toString();
res.send(contents);
console.log("checking in");
console.log(req);
});
app.get('/checkout', function (req, res) {
const contents = fs.readFileSync('views/no.html').toString();
res.send(contents);
console.log("checking out");
});
app.post('/checkin', function (req, res) {
console.log("posting check-in info");
// Extract data from POST request here
// Send data to Google Sheets
// Authenticate with Google Spreadsheets API using service account credentials
const doc = new GoogleSpreadsheet(________);
doc.useServiceAccountAuth(creds, function (err) {
doc.getInfo(function(err, info) {
console.log('Loaded doc: '+info.title+' by '+info.author.email);
const sheet = info.worksheets[0];
console.log('Sheet 1: '+sheet.title+' '+sheet.rowCount+'x'+sheet.colCount);
});
});
// Consider client confirmation here
});
app.listen(3000, function() {
console.log('Example app listening on port 3000!');
});