This functionality requires an experimental
gsheetsplugin. Read More
Frictionless supports parsing Google Sheets data as a file format.
You can read from Google Sheets using
Package/Resource, for example:
The same is actual for writing:
There is a dialect to configure how Frictionless read and write files in this format. For example: