Push data up from Sheets to BigQuery, or back down from BigQuery to Sheets.
By:
Works with:
2K+
Overview
Automates a few of the pesky challenges when getting data from Sheets up to BigQuery:

1) Creating tables: the Connector automatically reads your tab's data columns + types, and creates tables in BigQuery that will play nicely with them.

2) Scheduling upload jobs: the Connector creates timed triggers on your behalf to schedule upload jobs.  

3) Error reporting: the Connector checks with BigQuery on the status of your upload jobs, so you're never in the dark.

The Connector also allows you to pull down data from BigQuery into Sheets - useful when building spreadsheet templates (like forecasts) that depend on the data you have living in BigQuery.
Additional information
PricingNot available
Developer
Trader status unspecified
SupportNot available
Privacy policy
Terms of service
ReportFlag as inappropriate
CIFL Connector for BigQuery will ask for the permissions shown below. Learn more
CIFL Connector for BigQuery will need access to your Google account
This will allow CIFL Connector for BigQuery to :
See, edit, create, and delete all your Google Sheets spreadsheets
View and manage your data in Google BigQuery and see the email address for your Google Account
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
Send email as you
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
A User of CIFL Connector for BigQuery
April 23, 2019
I needed to be able to archive a bunch of data from Sheets to BigQuery, and the CIFL connector is a life saver! We also use Sheets as a data source for Data Studio quite a bit, and this makes it really easy to shift that over to BigQuery. Thank you CIFL!!!
Is this review helpful?
Yes
No
Profile Picture
A User of CIFL Connector for BigQuery
June 16, 2020
can't login to bigquery as app doesn't meet google new security measures and is temporarily disabled
Is this review helpful?
Yes
No
Profile Picture
Kazi Safayet
November 20, 2020
can't log in, this app is temporarily disabled for security reasons
Is this review helpful?
Yes
No
Profile Picture
A User of CIFL Connector for BigQuery
December 31, 2019
Cant get this to login to Big Query at the moment. Says its temporarily disabled.
Is this review helpful?
Yes
No
Profile Picture
Samson Assefa
December 8, 2020
Samson Assefa Gebrehiwot
Is this review helpful?
Yes
No
1-5 of 5
Search
Clear search
Close search
Google apps
Main menu