Google Sheets Release Notes

September 2024

Users can no longer select Google Sheets from the list of all available sheets. Instead, users will need to enter the Sheets identifiers or URL.
All existing Google Sheets connectors were migrated to the new version and no further action is required.

August 2024

Users can enter the requested sheet identifier they wish to ingest into Panoply instead of selecting the sheet from the list of files. In order to achieve that, select the Enter Sheet identifier and enter the identifier.

June 2024

Panoply now supports the extraction of sheets from shared drives. The list of available sheets will now include sheets from shared drives.

August 2020

As part of Panoply's efforts to improve our data sources, we are opening our updated Google Sheets beta to all users. This update includes handling for columns that do not have a header value in the header row by adding a value of column <column letter> (such as column b as well as handling of duplicate header values by modifying the second header with the column letter in the manner of <header name> column <column letter>, such as name column b.

The previous version of the Google Sheets data source is deprecated as of August 17, 2020. Users will have 90 days from then to move to the new data source. For more information, see our data source documentation.