Yes, it is definitely possible. For more information, you can refer to this specific answer on Stack Overflow:
Download google docs public spreadsheet to csv with python
import requests
response = requests.get('https://docs.google.com/spreadsheet/ccc?key=0ArM5yzzCw9IZdEdLWlpHT1FCcUpYQ2RjWmZYWmNwbXc&output=csv')
assert response.status_code == 200, 'Incorrect status code'
print(response.content)
Afterwards, you have the option to save the respose.content
into a file within the /tmp
directory
Cloud Functions Execution Environment
The only writable portion of the filesystem is located in the /tmp directory, which serves as a designated area for storing temporary files within a function instance. This section operates as a local disk mount point referred to as a "tmpfs" volume, where any data written onto the volume is stored in memory. It is important to note that using this feature will consume memory resources allotted for the function.
For all other purposes, the remainder of the file system remains read-only and accessible solely by the function.