How to load a Google Sheet in PySpark

spark_google_sheets.py

from pyspark.sql import SparkSession


# Load the package https://github.com/potix2/spark-google-spreadsheets via Maven
spark = (
    SparkSession.builder
    .appName("Testing Spark Google Sheets")
    .config("spark.jars.packages", "com.github.potix2:spark-google-spreadsheets_2.11:0.6.3")
    .getOrCreate()
)

# Before this you must create an API key and a Service Account P12 key.
# See: https://github.com/juampynr/google-spreadsheet-reader
df = (
    spark.read.format("com.github.potix2.spark.google.spreadsheets")
    .option("serviceAccountId", "xxxxxx@developer.gserviceaccount.com").
    .option("credentialPath", "/path/to/cedential.p12")
    .load("<spreadsheetId>/worksheet1")
)