valenzine

// This code is based upon the one posted by @leonidas.yovan on Medium
// https://medium.com/@leonidas.yovan/connect-your-mailchimp-campaign-data-to-google-datastudio-for-free-fd7b5f2dec40
// The main difference is the split into two functions 
// and the replication of Mailchimp headers in the spreadsheet
// for broader compatibility.

var API_KEY = 'API_KEY'; // MailChimp API Keyvar
var ss = SpreadsheetApp.openById('SHEETS_ID');
var sheet = ss.getSheetByName("campaigns");

valenzine

To extract the audio stream without re-encoding:

ffmpeg -i input-video.avi -vn -acodec copy output-audio.aac

-vn is no video. -acodec copy says use the same audio stream that's already in there.

Read the output to see what codec it is, to set the right filename extension.

valenzine

Overview

FTP blows and you want to simply git push hostgator master out to your desired directory. It's pretty easy.

Assumptions

• You've gotten Hostgator to authorize you to use SSH
• The server has git
• You know that Hostgator uses port 2222 for SSH