NOTE: We recommend to set your document locale to US and also to use YYYY-MM-DD formatting in your date column otherwise you may experience unpredictable issues during uploads.
2019-05-20: Version 11
We improved error messaging on the log sheet in case the upload failed. Previously, some users could see “success” message even though 0 rows got uploaded to BigQuery.
The errors messages now give hint of what’s likely wrong with your sheets.
2019-05-07: Version 10
We did a little change in the code which may solve a problem with incorrect status post-upload messages on the log sheet. A user reported that he was getting “Error: GoogleJsonResponseException: API call to bigquery.jobs.get failed with error: Not found: Job **some id**” message every time he tried to upload his Google Sheet to BigQuery. While the data got uploaded OK, the message returned on the log sheet would show this error.
2019-05-03: Version 9
2 updates in version 9:
We fixed edge scenarios where numbers would get converted to strings in your original Google Sheets document after upload to BigQuery was performed. The issue was not happening every time so if you are existing user, you may have not even noticed the problem.
In version 8, cells carrying formulas would sometimes get converted to pure text after the upload – this is no longer an issue and your formulas will survive untouched!