Integrate Google Sheets using Fiber

Sync your customers' dataFiber pulls data from your customers' Google Sheets accounts into your database or cloud storage. Skip months of integration work and begin syncing in minutes.

→

Fiber

→

postgres-prod

sheets_sheets

Your customers' Google Sheets accounts

Your production database

Meet your new integration toolkit: SQLReplace calls to the Google Sheets API with an interface you already use. Access the data you need straight from your database.

-- Fetch all the Sheets belonging to the Google 
-- Sheets account of a particular user. 

SELECT *
FROM fiber.sheets_sheet
WHERE account_id = '{user.sheets_id}'

-- Fetch all the Sheets belonging to the Google 
-- Sheets account of a particular user. 

SELECT *
FROM fiber.sheets_sheet
WHERE account_id = '{user.sheets_id}'

Code

CREATE TABLE fiber.sheets_sheet (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  account_id TEXT,
  title TEXT,
  sheets JSONB,
  named_ranges JSONB,
  spreadsheet_url TEXT,
  properties JSONB,
  data_sources JSONB
)

CREATE TABLE fiber.sheets_sheet (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  account_id TEXT,
  title TEXT,
  sheets JSONB,
  named_ranges JSONB,
  spreadsheet_url TEXT,
  properties JSONB,
  data_sources JSONB
)