Google Looker submission script

README.md

Copy paste the script into the console of the submission flow of Google Looker. It's a Google Form, so might work for other Google Forms as well.

Enjoy!

submit.js

// Fill in these two variables for every new deployment
const deploymentId = "...";
const whatChanged = "We ...";

// Fill in these fields once 
const fields = [
  {
    name: "Connector name",
    value: "xxx",
  },
  {
    name: "Apps Script deployment ID",
    value: deploymentId,
  },
  {
    name: "Contact email",
    value: "xxx@xxx",
  },
  {
    name: "Link to the Apps Script project",
    value:
      "https://script.google.com/home/projects/xxx/edit",
  },
  {
    name: "Test configuration",
    value:
      "Use this configuration to test our connector.\n\nEnter the hostname of your website: xxx\nEnter the API key of Simple Analytics: sa_api_key_xxx\nSelect time zone you want to use in your exports: Any timezone is okay",
  },
  {
    name: "Exception for urlFetchWhitelist",
    value: "Not applicable.",
  },
  {
    name: "Additional comments",
    value: whatChanged,
  },
];

for (const field of fields) {
  const element = document.querySelector(
    `div[data-params*="${field.name}"] input, div[data-params*="${field.name}"] textarea`
  );
  if (!element) throw new Error(`Could not find input for ${field.name}!`);
  element.value = field.value;
  element.dispatchEvent(new Event("input", { bubbles: true }));
}