Google Sheets Tutorial

This functionality requires an experimental gsheets plugin. Read More

Frictionless supports parsing Google Sheets data as a file format.

CLI

pip install frictionless[gsheets]

pip install 'frictionless[gsheets]' # for zsh shell

Reading Data

You can read from Google Sheets using Package/Resource, for example:

python

from pprint import pprint

from frictionless import Resource

resource = Resource(path='https://docs.google.com/spreadsheets/d/1mHIWnDvW9cALRMq9OdNfRwjAthCUFUOACPp0Lkyl7b4/edit?usp=sharing')

pprint(resource.read_rows())

[{'id': 1, 'name': 'english'}, {'id': 2, 'name': '中国人'}]

Writing Data

The same is actual for writing:

Python

from frictionless import Resource

resource = Resource(path='data/table.csv')

resource.write("https://docs.google.com/spreadsheets/d/<id>/edit", dialect={"credentials": ".google.json"})

Configuring Data

There is a dialect to configure how Frictionless read and write files in this format. For example:

Python

from frictionless import Resource

resource = Resource(path='data/table.csv')

resource.write("https://docs.google.com/spreadsheets/d/<id>/edit", dialect={"credentials": ".google.json"})

References:

• Gseets Dialect