Hydra
Search
⌃K
Links

From Google Sheets

With Hydra, you can import data and run queries against Google Spreadsheets. Google Spreadsheet External Tables are implemented using gspreadsheet_fdw. To create a Google Spreadsheet External Table, create a Google Spreadsheet with some data:
  • Put column names in the first row: untitled columns will not be read
  • A blank row terminates the table (data below won't be read)
  • Put it in the first (and only) worksheet
Get the spreadsheet ID from the HTTP URL. The ID is a 44-character string matching regexp [A-Za-z0-9_]{44}. It lives between the /spreadsheets/d/ and possible trailing /edit/blah in the URL of your Google Spreadsheet.
Create a Google Service Account and enable Google Sheets API access by following this guide. Share your Google spreadsheet with the Google Service Account email that is in the format of [email protected].
Create a foreign table, replacing ... with your Google Spreadsheet ID and Google Service Account credentials in JSON format:
CREATE EXTENSION multicorn;
CREATE SERVER multicorn_gspreadsheet FOREIGN DATA WRAPPER multicorn
OPTIONS (
wrapper 'gspreadsheet_fdw.GspreadsheetFdw'
);
CREATE FOREIGN TABLE test_spreadsheet (
id character varying,
name character varying
) server multicorn_gspreadsheet options(
gskey '...',
serviceaccount '...'
);