Streaming data from Google Sheets to Google BigQuery

You could simply execute UrlFetchApp function for passing the required parameters to BigQuery REST Api. You could use it for functions of: Jobs, Projects, Datasets, Tables, and TableData. Simply perform the required payloads, and then pass to the correct endpoints. That's it. All can be coded from within Google Apps Script. Let me know the detail of required functions

Hi there, We can use Google Script to push the data from Google spreadsheets to Google BigQuery. Google Script can connect to the BigQuery API and of course, it can read the data from Google spreadsheets. In addition, we can make use of Google Script triggers, like perform an update when the spreadsheet is edited, or on a regular interval, like every 5 minutes. I will be happy to address any of your questions! Sincerely, Mohamed

i can work google api, scrapping data too. plz share your spreadsheet, let me check!

Hi! We've been working in data for last 3 years. It's no big task for us. Will be great pleasure to serve you. Looking forward to discuss project further Thanks