submit.js
5 removals
| Words removed | 7 |
| Total words | 88 |
| Words removed (%) | 7.95 |
39 lines
6 additions
| Words added | 10 |
| Total words | 91 |
| Words added (%) | 10.99 |
39 lines
import { google } from 'googleapis';
import { google } from 'googleapis';
export default async function handler(req, res) {
export default async function handler(req, res) {
if (req.method === 'POST') {
if (req.method === 'POST') {
const { Name, Email, Message } = req.body;
const { Name, Email, Message } = req.body;
console.log(Name, Email, Message);
console.log(Name, Email, Message);
const auth = new google.auth.GoogleAuth({
const auth = new google.auth.GoogleAuth({
credentials: {
credentials: {
client_email: process.env.GOOGLE_CLIENT_EMAIL,
client_email: process.env.GOOGLE_CLIENT_EMAIL,
private_key: process.env.GOOGLE_PRIVATE_KEY?.replace(/\\n/g, '\n'),
private_key: process.env.GOOGLE_PRIVATE_KEY?.replace(/\\n/g, '\n'),
},
},
scopes: [
scopes: [
'https://www.googleapis.com/auth/drive',
'https://www.googleapis.com/auth/drive',
'https://www.googleapis.com/auth/drive.file',
'https://www.googleapis.com/auth/drive.file',
'https://www.googleapis.com/auth/spreadsheets',
'https://www.googleapis.com/auth/spreadsheets',
],
],
});
});
const sheets = google.sheets({
const sheets = google.sheets({
auth,
version: 'v4',
version: 'v4',
auth,
});
});
const response = await sheets.spreadsheets.values.append({
const response = await sheets.spreadsheets.values.append({
spreadsheetId: process.env.GOOGLE_SHEET_ID,
spreadsheetId: process.env.GOOGLE_SHEET_ID,
range: 'A1:C1',
range: 'A1:C1',
valueInputOption: 'USER_ENTERED',
valueInputOption: 'USER_ENTERED',
requestBody: {
resource: {
values: [[Name, Email, Message]],
values: [[Name, Email, Message]],
},
},
});
});
res.status(201).json({ message: 'Date entered successfully' });
res.status(201).json({ message: 'Data entered successfully' });
} else {
res.status(200).json({ message: 'Done!' });
}
}
res.status(200).json({ message: 'Done!' });
}
}