alexismp

const sheetsAPI = google.sheets({version: 'v4', auth});

alexismp

function setColumnStyle(sheetsAPI, sheetId) {
  return new Promise((resolve, reject) => {
    const setStyleParams = {
      spreadsheetId: process.env.SPREADSHEET_ID,
      resource: {
        requests: [
          {
            repeatCell: {
              range: {
                sheetId: sheetId,

alexismp

function addEmptySheet(sheetsAPI, sheetName) {
  return new Promise((resolve, reject) => {
    const emptySheetParams = {
      spreadsheetId: process.env.SPREADSHEET_ID,
      resource: {
        requests: [
          {
            addSheet: {
              properties: {
                title: sheetName,

alexismp

const auth = await google.auth.getClient({
  scopes: [
    "https://www.googleapis.com/auth/spreadsheets",
    "https://www.googleapis.com/auth/devstorage.read_only"
  ]
});

alexismp

const {google} = require("googleapis");
const {Storage} = require("@google-cloud/storage")

exports.csv2sheet = async (data, context) => {
  var fileName = data.name;
  // basic check that this is a *.csv file, etc...
  if (!fileName.endsWith(".csv")) {
    console.log("Not a .csv file, ignoring.");
    return;
  }

alexismp

{
  "name": "csv2sheet",
  "version": "0.0.42",

  "dependencies": {
    "googleapis": "^40.0.0",
    "@google-cloud/storage": "^2.5.0"
  }
}

alexismp

function readCSVContent(sheetsAPI, file, sheetName) {
  return new Promise((resolve, reject) => {
    const storage = new Storage();
    let fileContents = new Buffer('');
    let rows = [];
    storage
      .bucket(file.bucket)
      .file(file.name)
      .createReadStream()
      .on("error", function(err) {

alexismp

  const sheetId = await addEmptySheet(sheetsAPI, sheetName);
  const theData = await readCSVContent(sheetsAPI, data, sheetName);
  await populateAndStyle(sheetsAPI, theData, sheetId);

alexismp

ffmpeg -i accompagnement.mkv -ss 3 -c copy accompagnement-trimmed.mkv

alexismp

ffmpeg -i solo.mkv -i accompagnement-trimmed.mkv -filter_complex "[0:v][1:v]hstack=inputs=2[v]; [0:a][1:a]amerge[a]" -map "[v]" -map "[a]" -ac 2 valse-melanco.mkv