How do I load a Google Sheet into my warehouse?
ingestr reads a Google Sheet and lands it as a table in your warehouse, so spreadsheet data joins the rest of your models without manual exports.
Command
ingestr ingestDefined in
CLI
Works with
Google Sheets to any ingestr destination
What you get
Spreadsheet sourceno manual exportsscheduled loads
How it works in code
$ ingestr ingest \
--source-uri 'gsheets://?credentials_path=$GOOGLE_CREDS' \
--source-table '<spreadsheet_id>.Sheet1' \
--dest-uri $BIGQUERY_URI --dest-table 'raw.budget'Run ingestr ingest and ingestr loads the sheet into your warehouse as a table.
Related use cases
Load a specific source
Replicate a Postgres database into Snowflake
How do I replicate a Postgres database into Snowflake?
Load a specific sourceReplicate a database incrementally
How do I keep a database table in sync without full reloads (CDC-style)?
Load a specific sourceLoad Stripe data into your warehouse
How do I load Stripe data into my warehouse?
Move data with one command
Open source. Source URI in, destination URI out, incremental by default.