Hi @Patrick-Data
Yes, you can do it only you have to follow below steps -
1. Open Google sheet from which you want fetch data

2. Go to -File->Share->Publish to web- Select sheet->Select Sheet ->select .csv

4. Click on publish ->copy the URL
5. Use below code to fetch the live data
import pandas as pd
pdDF = pd.read_csv("URL which you have copied")
#Convert to spark DF
sparkDF = spark.createDataFrame(pdDF)
Ajay Kumar Pandey