Quick way to archive q posts offline from the gdocs spreadsheet (sorry *nix and mac only)

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