Storm coming, Archive Q Posts offline with this bash script
Hey guys, heres a quick way to archive q posts offline from the google spreadsheet that is in the research doughs.
On any *nix with bash, a similar windows .bat file could be created.
Create a .sh file with the following content:
#!/usr/bin/env bashGSPREADSHEETS='https://docs.google.com/spreadsheets/d'ID='1Efm2AcuMJ7whuuB6T7ouOIwrE_9S-1vDJLAXIVPZU2g'FORMAT=zipCURRENT_DATE=date +%m-%d-%Ycurl $GSPREADSHEETS/$ID/export\?format\=$FORMAT\&id\=$ID "Q Posts Spreadsheet $CURRENT_DATE".$FORMAT
Add execute bit to file:
chmod +x archive-q-posts.sh
To archive:
./archive-q-posts.sh
This will create a zip file with the date in the name like this: Q Posts Spreadsheet 03-24-2020.zip