Google Apps Script with BigQuery and gas-fakes

[Bruce Mcpherson]

Google Apps Script (GAS) has matured from a simple tool for spreadsheet macros into a serious development platform capable of enterprise-level automation. However, we often face friction due to the platform’s six-minute execution limit and a disconnected development pipeline.

Gas-fakes is a powerful emulation layer that runs Apps Script projects natively on Node.js. It solves these constraints while unlocking high-speed local debugging and execution.

The latest advancement in this ecosystem is the native integration of BigQuery into gas-fakes. This allows you to process massive datasets using familiar Apps Script syntax within a modern local development stack.

article : https://ramblings.mcpher.com/google-apps-script-with-bigquery-and-gas-fakes/