Browse sources$ls -a sources
Logo of sheets
Google Sheets
Automate data entry and analysis with Google Sheets integration
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.
Logo of sheets
Logo of sheets
Logo of sheets
Logo of sheets
Logo of sheets
Logo of sheets
Logo of sheets
Logo of sheets
Logo of sheets
Logo of sheets
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
)
Model definition
About this source
Logo of Google Sheets
Google SheetsCloud-based spreadsheet program for data analysis and collaboration.google.com/sheets  ↗
Available resources
    Sheets
Missing a resource? We will build it for you.
Similar sources
OAuth
Need help with OAuth for Google Sheets?Handshake ↗ is a Next.js app boilerplate that handles your OAuth with Google Sheets and over 200 other APIs. Setup and deploy within minutes.
Logo of sheetsIntegrate Google Sheets using Fiber Fiber makes it easy to access third-party data from Google Sheets accounts. Get started in just a few minutes.