Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Big Query append data daily to spreadsheets.

Hello, guys!

I have a table in BigQuery with campaign data that is updated daily at 9 am. Every day, I run a query that brings me the data I need and export it to a Google Spreadsheet. Then, I do a Ctrl+C and Ctrl+V to another spreadsheet I have on Google Drive. Thinking about automating this spreadsheet, how could I do this using Cloud Functions so that every time the data is updated, it runs and appends the new data to my spreadsheet directly?

0 0 135
0 REPLIES 0