Sheetgo now supports automatic table creation and schema evolution when using BigQuery as a destination. This means you no longer need to manually create or configure tables in Google Cloud Console before connecting — Sheetgo handles it for you.
What's new
• Automatic table creation — If the destination table does not exist in BigQuery, Sheetgo will create it automatically based on the structure of your source data.
• Replace strategy — In addition to Append, you can now choose Replace as a writing strategy. Replace fully purges the destination table and loads it with current source data on every run. Use this when you need a full refresh instead of incremental updates.
• Schema evolution — If your source data columns change, Sheetgo automatically updates the structure of the BigQuery table to match.
• Table partitioning — BigQuery destinations now support table partitioning, which helps optimize query performance and reduce costs.
Before getting started
A few things to keep in mind:
• You must have write permissions to the destination BigQuery project and dataset. Learn how to get permissions for BigQuery.
• If the table already exists, Sheetgo will use its current structure. Schema evolution applies only when source columns are added or renamed.
• The Replace strategy will delete all existing data in the table before each run. Use with caution on tables shared with other pipelines.
How to use it
1. Create a new workflow or edit an existing one.
2. Under Select source, choose your data source (Google Sheets, Excel, CSV, or any other supported format).
3. Under Select a destination, choose BigQuery. If this is your first time, you will need to connect your BigQuery account.
4. Select your project and dataset, then enter a table name. If the table does not exist, Sheetgo will create it automatically.
5. Choose your writing strategy: Append (add new rows to existing data) or Replace (full refresh on every run).
6. Click Done editing, then Finish and Save.
7. Run the automation — Sheetgo will create the table (if needed) and send your data to BigQuery.
Need more help? Send us a ticket!