dase-analytics

window.dataLayer = window.dataLayer || [];

function gtag(){dataLayer.push(arguments);}

gtag('consent', 'default', {
    functionality_storage: "denied",
    analytics_storage: "denied",
    ad_storage: "denied",
    ad_user_data: "denied",

dase-analytics

function exportBigQueryToSheet() {
  const PROJECT_ID = 'project_id';
  const SHEET_ID = 'sheet_id';
  const SHEET_NAME = 'import_to_sheet';

  const QUERY = `
    SELECT *
    FROM \`project_id.dataset_id.table_id\`
  `;

dase-analytics

function exportSheetToBigQuery() {
  /** =========================
   *  configuration
   *  ========================= */
  const CONFIG = {
  PROJECT_ID: 'project_id',
  DATASET_ID: 'dataset_id',
  TABLE_ID:   'table_id',
  SHEET_NAME: 'export_to_bq',     
  HEADER_ROW: 1,