SearchOps + Google Sheets and Data Studio

// Extensions > Apps Script in your Google Sheet. Then Project Settings >
// Script properties: add SEARCHOPS_API_KEY = lp_live_...
// Run setup() once (it asks for permission); weeklyPull() then runs every Monday.

const BASE = 'https://searchops.co/api/v1';
const SHEET = 'SearchOps weekly';

function api_(path) {
  const key = PropertiesService.getScriptProperties().getProperty('SEARCHOPS_API_KEY');
  const res = UrlFetchApp.fetch(BASE + path, {
    headers: { Authorization: 'Bearer ' + key },
    muteHttpExceptions: true,
  });
  const code = res.getResponseCode();
  if (code === 429) { Utilities.sleep(60000); return api_(path); } // over 120 a minute: wait
  if (code !== 200) throw new Error(path + ' -> ' + code + ' ' + res.getContentText().slice(0, 200));
  return JSON.parse(res.getContentText());
}

function allLocations_() {
  const out = [];
  for (let offset = 0; ; offset += 100) {
    const page = api_('/locations?limit=100&offset=' + offset).data;
    out.push(...page);
    if (page.length < 100) return out;
  }
}

function weeklyPull() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sh = ss.getSheetByName(SHEET) || ss.insertSheet(SHEET);
  if (sh.getLastRow() === 0) {
    sh.appendRow(['pulled_at', 'location_id', 'business_name', 'from', 'through',
      'calls', 'website_clicks', 'direction_requests', 'views',
      'calls_prev', 'website_clicks_prev', 'direction_requests_prev', 'views_prev',
      'tasks_done', 'tasks_open', 'tasks_suggested']);
  }
  const pulledAt = new Date();
  const rows = [];
  for (const loc of allLocations_()) {
    const w = api_('/locations/' + loc.id + '/week').data;
    if (!w) continue;
    const g = w.gbp; // null = no connected profile or no data yet: a blank, not zero
    rows.push([pulledAt, loc.id, loc.business_name,
      g ? g.from : '', g ? g.through : '',
      g ? g.current.calls : '', g ? g.current.website : '', g ? g.current.directions : '', g ? g.current.views : '',
      g ? g.previous.calls : '', g ? g.previous.website : '', g ? g.previous.directions : '', g ? g.previous.views : '',
      w.done.length, w.open, w.suggested]);
    Utilities.sleep(600); // stay under 120 requests a minute
  }
  if (rows.length) sh.getRange(sh.getLastRow() + 1, 1, rows.length, rows[0].length).setValues(rows);
}

function setup() {
  ScriptApp.getProjectTriggers().forEach(t => ScriptApp.deleteTrigger(t));
  ScriptApp.newTrigger('weeklyPull').timeBased().onWeekDay(ScriptApp.WeekDay.MONDAY).atHour(7).create();
  weeklyPull();
}