Creating Google Sheets Direct Download Links to a CSV File

When linking to files in Google Sheets, by default a link is created to a web page with an image on that page.

Note: This link is just an example and not a real link. 

To directly link to the image itself:

1. Got to the file in Google Sheets
2. The link will look similar to this: https://drive.google.com/file/d/2p91UaHNzqUqyBWXqQRiu9-QXbLs6ggjw/view
3. The long string of letters and numbers is the filename, copy this to a notepad somewhere.
4. In Spark copy this link https://docs.google.com/spreadsheets/d/{key}/gviz/tq?tqx=out:csv&sheet={sheet_name}
5. Replace {key} with the string from above (ex. 2p91UaHNzqUqyBWXqQRiu9-QXbLs6ggjw)
6. Repose {sheet_name} with the name of the sheet (ex. Sheet1)
7. Your link will now look like this: https://docs.google.com/spreadsheets/d/QXbLs6ggjw/gviz/tq?tqx=out:csv&sheet=Sheet1
8. Now spark should be able to pull the file from this location. 

The link can be publicly accessible or it can be private and available to anyone who has the link.

 That's it, this link will now directly download a CSV file