Send your Google Sheets data to Google BigQuery with Singer

Singer makes it easy to send standard, JSON-formatted data from taps to targets.

Learn more about the Singer spec  →

The Google Sheets tap

The Singer Google Sheets tap pulls data out of Google Sheets and delivers data in a standard, JSON-based format.

The Google BigQuery target

Google BigQuery is a popular data warehouse. The Singer Google BigQuery target consumes data from any Singer tap.

Getting started

Installing and running taps and targets is easy. Check the tap and target repositories for specific setup steps.

Google Sheets

View the Google Sheets repo  →


Google BigQuery

View the Google BigQuery repo  →
          $ pip install tap-google-sheets
          $ pip install target-google-bigquery
        

Contribute to Singer

View open pull requests for Google Sheets and Google BigQuery

View open issues for Google Sheets and Google BigQuery

Discuss working with this tap and target on the Singer Slack.

Send data from Google Sheets to Google BigQuery automatically

Stitch can run the Singer Google Sheets tap on a schedule you define. Take advantage of Stitch's automatic infrastructure scaling, error alerting, and more—no code required.

More Singer Taps

Extract data from these Taps and send it to the Google BigQuery target.