As a Google Sheets user, you've probably already used the option to download the entire spreadsheet into an Excel file or a specific sheet/tab as a CSV/TSV file (under File > Download).
To use a Google Sheet as a data source in HootVid, we require a direct download link of a CSV file.
Doing so is fairly straightforward, you need to remove the section of the URL starting from /edit and replace it with /export with some additional text.
Example Starting Google Sheet URL:
https://docs.google.com/spreadsheets/d/1Gztm9o8JEPibPWEDwH54qBG5kwj51ILDOk_dxK6uTSY/edit#gid=1330027783
- /edit#gid=1330027783
+ /export?format=csv&gid=1330027783
Downloadable Google Sheet URL (HootVid Data Source):
https://docs.google.com/spreadsheets/d/1Gztm9o8JEPibPWEDwH54qBG5kwj51ILDOk_dxK6uTSY/export?format=csv&gid=1330027783
Notice that the difference is we included &gid=1330027783 to the URL. This is basically the "Sheet ID" and as you switch sheets/tabs in Google Sheets, you'll notice this value changes and you can basically just copy that ID and append it to the URL if you want that specific sheet exported.
